X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=futatabi%2Fdb.cpp;h=1ad17cbfece33368742f5e08da29e8072156edb7;hb=4a9e97065dade428e373a83618bc973cd93cbe52;hp=fb6694be3a2f2c729edefedcd3d923a9a4ca2209;hpb=5150998b6b97fb01eb393f1c76db073cc4fe8505;p=nageru diff --git a/futatabi/db.cpp b/futatabi/db.cpp index fb6694b..1ad17cb 100644 --- a/futatabi/db.cpp +++ b/futatabi/db.cpp @@ -17,19 +17,23 @@ DB::DB(const string &filename) sqlite3_exec(db, R"( CREATE TABLE IF NOT EXISTS state (state BLOB); - )", nullptr, nullptr, nullptr); // Ignore errors. + )", + nullptr, nullptr, nullptr); // Ignore errors. sqlite3_exec(db, R"( CREATE TABLE IF NOT EXISTS settings (settings BLOB); - )", nullptr, nullptr, nullptr); // Ignore errors. + )", + nullptr, nullptr, nullptr); // Ignore errors. sqlite3_exec(db, R"( DROP TABLE file; - )", nullptr, nullptr, nullptr); // Ignore errors. + )", + nullptr, nullptr, nullptr); // Ignore errors. sqlite3_exec(db, R"( DROP TABLE frame; - )", nullptr, nullptr, nullptr); // Ignore errors. + )", + nullptr, nullptr, nullptr); // Ignore errors. sqlite3_exec(db, R"( CREATE TABLE IF NOT EXISTS filev2 ( @@ -38,7 +42,8 @@ DB::DB(const string &filename) size BIGINT NOT NULL, frames BLOB NOT NULL ); - )", nullptr, nullptr, nullptr); // Ignore errors. + )", + nullptr, nullptr, nullptr); // Ignore errors. sqlite3_exec(db, "PRAGMA journal_mode=WAL", nullptr, nullptr, nullptr); // Ignore errors. sqlite3_exec(db, "PRAGMA synchronous=NORMAL", nullptr, nullptr, nullptr); // Ignore errors. @@ -342,7 +347,8 @@ void DB::clean_unused_frame_files(const vector &used_filenames) ret = sqlite3_exec(db, R"( CREATE TEMPORARY TABLE used_filenames ( filename VARCHAR NOT NULL PRIMARY KEY ) - )", nullptr, nullptr, nullptr); + )", + nullptr, nullptr, nullptr); if (ret != SQLITE_OK) { fprintf(stderr, "CREATE TEMPORARY TABLE: %s\n", sqlite3_errmsg(db)); @@ -381,7 +387,8 @@ void DB::clean_unused_frame_files(const vector &used_filenames) ret = sqlite3_exec(db, R"( DELETE FROM filev2 WHERE filename NOT IN ( SELECT filename FROM used_filenames ) - )", nullptr, nullptr, nullptr); + )", + nullptr, nullptr, nullptr); if (ret != SQLITE_OK) { fprintf(stderr, "DELETE: %s\n", sqlite3_errmsg(db)); @@ -390,7 +397,8 @@ void DB::clean_unused_frame_files(const vector &used_filenames) ret = sqlite3_exec(db, R"( DROP TABLE used_filenames - )", nullptr, nullptr, nullptr); + )", + nullptr, nullptr, nullptr); if (ret != SQLITE_OK) { fprintf(stderr, "DROP TABLE: %s\n", sqlite3_errmsg(db));