X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=bayeswf.cpp;h=eee6882e4e18f59dcc9c2b8f37f950e22b3d6e13;hb=9d67bf4c0aca09d014072713f5143a313d482941;hp=c7aad7dbe349d3dc0ee3ccf07266dd5552d12f2b;hpb=47707d117b1fe767d916217042bf22c006e4ea5e;p=wloh diff --git a/bayeswf.cpp b/bayeswf.cpp index c7aad7d..eee6882 100644 --- a/bayeswf.cpp +++ b/bayeswf.cpp @@ -422,6 +422,23 @@ int main(int argc, char **argv) pqxx::work txn(conn); txn.exec("SET client_min_messages TO WARNING"); + // Dump aux_params. + { + txn.exec("TRUNCATE aux_params"); + pqxx::tablewriter writer(txn, "aux_params"); + for (map, float>::const_iterator it = aux_params.begin(); it != aux_params.end(); ++it) { + char str[128]; + snprintf(str, 128, "%f", it->second); + + vector tuple; + tuple.push_back(it->first.first); // locale + tuple.push_back(it->first.second); // parameter name + tuple.push_back(str); + writer.push_back(tuple); + } + writer.complete(); + } + // Dump ratings. { txn.exec("TRUNCATE ratings"); @@ -464,23 +481,6 @@ int main(int argc, char **argv) txn.exec("ALTER TABLE new_covariance ADD PRIMARY KEY ( player1, player2 );"); txn.exec("DROP TABLE IF EXISTS covariance"); txn.exec("ALTER TABLE new_covariance RENAME TO covariance"); - - // Dump aux_params. - { - txn.exec("TRUNCATE aux_params"); - pqxx::tablewriter writer(txn, "aux_params"); - for (map, float>::const_iterator it = aux_params.begin(); it != aux_params.end(); ++it) { - char str[128]; - snprintf(str, 128, "%f", it->second); - - vector tuple; - tuple.push_back(it->first.first); // locale - tuple.push_back(it->first.second); // parameter name - tuple.push_back(str); - writer.push_back(tuple); - } - writer.complete(); - } #else //fprintf(stderr, "Optimal sigma: %f (two-player: %f)\n", sigma[0], sigma[0] * sqrt(2.0f)); for (map, float>::const_iterator it = aux_params.begin(); it != aux_params.end(); ++it) {