Load the covariance table before doing anything else, since that process can happen...

diff --git a/train.pl b/train.pl
index f104b7016191129fb7ba567fde5e00b38f29cbc0..084f84b91c14f60029fe98f0b3e9dfcdb845f92f 100755 (executable)
--- a/train.pl
+++ b/train.pl
@@ -96,6 +96,14 @@ my @aux_params = ();
 train_model($tmpnam, \@ratings, \@covariances, \@aux_params);
 unlink($tmpnam);
 
+$dbh->do('CREATE TABLE new_covariance ( player1 smallint NOT NULL, player2 smallint NOT NULL, cov float NOT NULL )');
+$dbh->do('COPY new_covariance ( player1, player2, cov ) FROM STDIN');
+$dbh->pg_putcopydata(join("\n", @covariances));
+$dbh->pg_putcopyend();
+$dbh->do('ALTER TABLE new_covariance ADD PRIMARY KEY ( player1, player2 );');
+$dbh->do('DROP TABLE IF EXISTS covariance');
+$dbh->do('ALTER TABLE new_covariance RENAME TO covariance');
+
 $dbh->do('TRUNCATE aux_params');
 $dbh->do('COPY aux_params ( kultur, id, value ) FROM STDIN');
 $dbh->pg_putcopydata(join("\n", @aux_params));
@@ -106,12 +114,4 @@ $dbh->do('COPY ratings ( id, rating, rating_stddev ) FROM STDIN');
 $dbh->pg_putcopydata(join("\n", @ratings));
 $dbh->pg_putcopyend();
 
-$dbh->do('CREATE TABLE new_covariance ( player1 smallint NOT NULL, player2 smallint NOT NULL, cov float NOT NULL )');
-$dbh->do('COPY new_covariance ( player1, player2, cov ) FROM STDIN');
-$dbh->pg_putcopydata(join("\n", @covariances));
-$dbh->pg_putcopyend();
-$dbh->do('ALTER TABLE new_covariance ADD PRIMARY KEY ( player1, player2 );');
-$dbh->do('DROP TABLE IF EXISTS covariance');
-$dbh->do('ALTER TABLE new_covariance RENAME TO covariance');
-
 $dbh->commit;