X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.db-test.git;a=blobdiff_plain;f=yarrg%2Fupdate-master-info;h=e2b0973db453b093e9b6f261b60c5f2969701e8b;hp=893b3677974aa924143a20360dd085341de3175c;hb=8cbcdefaf39ea525ea12957a115b8d78d88566c4;hpb=59bee7afb77216585b904bd20f17e71005e9778c

diff --git a/yarrg/update-master-info b/yarrg/update-master-info
index 893b367..e2b0973 100755
--- a/yarrg/update-master-info
+++ b/yarrg/update-master-info
@@ -26,6 +26,9 @@
 #         ./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 ypp-sc-tools, a set of third-party tools for assisting
 # players of Yohoho Puzzle Pirates.
@@ -52,6 +55,8 @@
 use strict (qw(vars));
 use DBI;
 use Commods;
+use CommodsDatabase;
+use File::Copy;
 
 $ENV{'LC_CTYPE'}= 'en_GB.UTF-8';
 
@@ -90,7 +95,7 @@ sub process_some_info ($$$) {
 	    next if $h =~ m/^nocommods/;
 	}
 	next if $sfn =~ m/source-info/ && $h =~ m/^ocean\b/;
-	next if $h =~ m/^client\b/;
+	next if $h =~ m/^client|^vessels|^shot\b/;
 
 	print $df $_, "\n" or die $!;
     }
@@ -119,6 +124,7 @@ sub update_master_info () {
 
 my @specoceans;
 my $alloceans;
+my $backup;
 
 sub optarg () {
     return $_ if length;
@@ -135,7 +141,10 @@ while (@ARGV && $ARGV[0] =~ m/^-/) {
 	    $rsyncdir= optarg();
 	} elsif (s/^-O//) {
 	    push @specoceans, optarg();
-	} elsif (s/^-a//) {
+	} elsif (s/^-b/-/) {
+	    die if $backup;
+	    $backup=1;
+	} elsif (s/^-a/-/) {
 	    die if $alloceans;
 	    $alloceans=1;
 	} else {
@@ -146,10 +155,25 @@ while (@ARGV && $ARGV[0] =~ m/^-/) {
 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};
@@ -167,7 +191,7 @@ if (@specoceans) {
     }
 }
 
-if (defined $rsyncdir) {
+if (defined $rsyncdir and !$backup) {
     print "### master-info update ...\n";
     update_master_info();
 }