X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=main.cpp;h=e233c08c30f7a305c00f752455a6e7e7be457cfd;hb=eacc9e44fb6c07405ca07080deaa23bb89c99b00;hp=bda85588e02cd167f9e7d73f7ecba257c00e5f35;hpb=605df45786d9848550f3559cea85a24edb4dcb63;p=pkanalytics diff --git a/main.cpp b/main.cpp index bda8558..e233c08 100644 --- a/main.cpp +++ b/main.cpp @@ -33,7 +33,7 @@ sqlite3 *open_db(const char *filename) )", nullptr, nullptr, nullptr); // Ignore errors. sqlite3_exec(db, R"( - CREATE TABLE IF NOT EXISTS match (match INTEGER PRIMARY KEY, description VARCHAR, video_filename VARCHAR); + CREATE TABLE IF NOT EXISTS match (match INTEGER PRIMARY KEY, description VARCHAR, video_filename VARCHAR, gender_rule_a BOOLEAN DEFAULT false, gender_pull_rule BOOLEAN DEFAULT false); )", nullptr, nullptr, nullptr); // Ignore errors. sqlite3_exec(db, R"( @@ -118,7 +118,7 @@ int get_match_id(sqlite3 *db, QWidget *parent, int requested_match) } // Insert the new row into the database. - ret = sqlite3_prepare_v2(db, "INSERT INTO match (description) VALUES (?)", -1, &stmt, 0); + ret = sqlite3_prepare_v2(db, "INSERT INTO match (description, gender_rule_a, gender_pull_rule) VALUES (?, COALESCE((SELECT gender_rule_a FROM match ORDER BY match DESC LIMIT 1),false), COALESCE((SELECT gender_pull_rule FROM match ORDER BY match DESC LIMIT 1),false))", -1, &stmt, 0); if (ret != SQLITE_OK) { fprintf(stderr, "INSERT prepare: %s\n", sqlite3_errmsg(db)); abort();