X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?a=blobdiff_plain;f=yarrg%2Fdb-idempotent-populate;h=43a2f0d62cc22d75d920c728f63476339bfa3720;hb=208ca9059b4d502497799a627c7b4541de1a4101;hp=143e2ef9d518e2e733d221365c372971b3ad29e0;hpb=1478fddc005bdaa1fa3ab731a0bd59613502e90d;p=ypp-sc-tools.db-live.git

diff --git a/yarrg/db-idempotent-populate b/yarrg/db-idempotent-populate
index 143e2ef..43a2f0d 100755
--- a/yarrg/db-idempotent-populate
+++ b/yarrg/db-idempotent-populate
@@ -102,6 +102,13 @@ db_doall(<<END)
 	dist		INTEGER			NOT NULL,
 	PRIMARY KEY (aiid, biid)
  );
+ CREATE TABLE IF NOT EXISTS vessels (
+	name		TEXT			NOT NULL,
+	mass		INTEGER			NOT NULL,
+	volume		INTEGER			NOT NULL,
+	shot		INTEGER			NOT NULL,
+	PRIMARY KEY (name)
+ );
 END
     ;
 
@@ -136,6 +143,24 @@ END
     $dbh->commit;
 }
 
+#---------- vessel types ----------
+{
+    my $idempotent= $dbh->prepare(<<'END')
+ INSERT OR REPLACE INTO vessels (name, shot, mass, volume)
+                         VALUES (?,?,?,?)
+END
+    ;
+    foreach my $name (sort keys %vessels) {
+	my $v= $vessels{$name};
+	my $shotdamage= $shotname2damage{$v->{Shot}};
+	die "no shot damage for shot $v->{Shot} for vessel $name"
+	    unless defined $shotdamage;
+	my @qa= ($name, $shotdamage, map { $v->{$_} } qw(Mass Volume));
+	$idempotent->execute(@qa);
+    }
+    $dbh->commit;
+}
+
 #---------- island list ----------
 #---------- routes ----------
 # now done by yppedia-chart-parser