X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.main.git;a=blobdiff_plain;f=yarrg%2Fupdate-master-info;h=adad34c81f42fbd29dbc2d0f9b24a7a392bda272;hp=3515bff78fbf4ae16a250248801cc08acc2239de;hb=27d9c020c52e2ad3d6e8ae5c4b113f062ec01251;hpb=03e5036282e2fc11ca05928c383c3c3c5b2d6355

diff --git a/yarrg/update-master-info b/yarrg/update-master-info
index 3515bff..adad34c 100755
--- a/yarrg/update-master-info
+++ b/yarrg/update-master-info
@@ -1,8 +1,62 @@
 #!/usr/bin/perl -w
+#
+# MAIN ADMINISTRATIVE DATABASE UPDATE TOOL
+#
+#  Usage:
+#     ./update-master-info [-d RSYNCDESTDIR] [-O OCEAN ... | -a]
+#
+#  Usual usages:
+#
+#    After editing source-info.txt to add commodities, or
+#    changing db-idempotent-update (eg to change the schema):
+#         ./update-master-info -d ~ftp/users/ijackson/yarrg/
+#    This will update everything except the ocean topologies.
+#
+#    To take account of new islands, or to fix a mistake in
+#    assigning island(s) to archipelago(es), or to add support
+#    for a new ocean:
+#         ./update-master-info -d ~ftp/users/ijackson/yarrg/ -O Midnight
+#
+#    After a fix to a mistake on a YPPedia chart page, correcting
+#    only inter-island-distances:
+#         ./update-master-info -O Midnight
+#
+#    After changing the algorithms for topology determination
+#    or YPPedia scraping:
+#         ./update-master-info -a
+#    and check that nothing unexpected changes.
+#
+#    To just make backups of the databases into the rsync directory:
+#         ./update-master-info -b -d ~ftp/users/ijackson/yarrg/ -a
+#         ./update-master-info -b -d ~ftp/users/ijackson/yarrg/ -O ...
+
+# This is part of the YARRG website.  YARRG is a tool and website
+# for assisting players of Yohoho Puzzle Pirates.
+#
+# Copyright (C) 2009 Ian Jackson <ijackson@chiark.greenend.org.uk>
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+# Yohoho and Puzzle Pirates are probably trademarks of Three Rings and
+# are used without permission.  This program is not endorsed or
+# sponsored by Three Rings.
 
 use strict (qw(vars));
 use DBI;
 use Commods;
+use CommodsDatabase;
+use File::Copy;
 
 $ENV{'LC_CTYPE'}= 'en_GB.UTF-8';
 
@@ -11,6 +65,7 @@ sub full ($) {
     quick($ocean);
     print "## updating topology of $ocean\n";
     system('./yppedia-chart-parser',$ocean); die "$ocean $?" if $?;
+    print "\n";
 }
 
 sub quick ($) {
@@ -39,7 +94,8 @@ sub process_some_info ($$$) {
 	if ($v<2) {
 	    next if $h =~ m/^nocommods/;
 	}
-	next if $sfn =~ m/source-info/ && $h =~ m/^ocean/;
+	next if $sfn =~ m/source-info/ && $h =~ m/^ocean\b/;
+	next if $h =~ m/^client|^vessels|^shot\b|^commodclasses/;
 
 	print $df $_, "\n" or die $!;
     }
@@ -68,6 +124,7 @@ sub update_master_info () {
 
 my @specoceans;
 my $alloceans;
+my $backup;
 
 sub optarg () {
     return $_ if length;
@@ -79,19 +136,44 @@ while (@ARGV && $ARGV[0] =~ m/^-/) {
     $_= shift @ARGV;
     last if m/^--?$/;
     while (m/^-./) {
-	if (s/^-d//) { $rsyncdir= optarg(); }
-	elsif (s/^-O//) { push @specoceans, optarg(); }
-	elsif (s/^-a//) { $alloceans=1; }
-	else { die "$_ ?"; }
+	if (s/^-d//) {
+	    die if defined $rsyncdir;
+	    $rsyncdir= optarg();
+	} elsif (s/^-O//) {
+	    push @specoceans, optarg();
+	} elsif (s/^-b/-/) {
+	    die if $backup;
+	    $backup=1;
+	} elsif (s/^-a/-/) {
+	    die if $alloceans;
+	    $alloceans=1;
+	} else {
+	    die "$_ ?";
+	}
     }
 }
 die if @ARGV;
 
 die if @specoceans && $alloceans;
+die if $backup && !$alloceans && !@specoceans;
 
 parse_info_serverside();
 
-if (@specoceans) {
+if ($backup) {
+    my @oceans= $alloceans ? (sort keys %oceans) : @specoceans;
+    foreach my $ocean (@oceans) {
+	print "## database backup for $ocean\n";
+	db_setocean($ocean);
+	db_writer();
+	db_connect();
+	$dbh->selectall_arrayref("SELECT * FROM commods WHERE commodid=1");
+	my $src= db_filename();
+	my $dst= $src; $dst =~ s,.*/,,; $dst= "$rsyncdir/$dst";
+	copy($src,"$dst.tmp") or die "$src -> $dst.tmp $!";
+	rename("$dst.tmp",$dst) or die "$dst.tmp -> $dst $!";
+	$dbh->rollback();
+    }
+} elsif (@specoceans) {
     print "### full update of specified oceans ...\n";
     foreach my $ocean (@specoceans) {
 	die "$ocean ?" unless defined $oceans{$ocean};
@@ -109,7 +191,7 @@ if (@specoceans) {
     }
 }
 
-if (defined $rsyncdir) {
+if (defined $rsyncdir and !$backup) {
     print "### master-info update ...\n";
     update_master_info();
 }