diff options
author | Trumeet <yuuta@yuuta.moe> | 2023-03-19 15:00:05 -0700 |
---|---|---|
committer | Trumeet <yuuta@yuuta.moe> | 2023-03-19 15:00:05 -0700 |
commit | 9f86b3bbe7d5d892620f1973ca069da67e90b568 (patch) | |
tree | f6c30c33785e8d6e28b9c1d1eee2780bd5a8df0f /db.c | |
parent | e1a3e886bf36da6fc49b52ed5f24e8b193dadc4d (diff) | |
download | ksyxbot-9f86b3bbe7d5d892620f1973ca069da67e90b568.tar ksyxbot-9f86b3bbe7d5d892620f1973ca069da67e90b568.tar.gz ksyxbot-9f86b3bbe7d5d892620f1973ca069da67e90b568.tar.bz2 ksyxbot-9f86b3bbe7d5d892620f1973ca069da67e90b568.zip |
Share stmt_global_stat
Diffstat (limited to 'db.c')
-rw-r--r-- | db.c | 11 |
1 files changed, 11 insertions, 0 deletions
@@ -28,6 +28,8 @@ static const char *sql_upgrades[] = { sqlite3 *db = NULL; +sqlite3_stmt *stmt_global_stat = NULL; + void db_init(void) { int r; r = sqlite3_open(cmd.db_path, &db); @@ -68,11 +70,20 @@ void db_init(void) { goto sql_err; } } + + /* Prepare statements */ + if ((r = sqlite3_prepare_v2(db, "SELECT * FROM stats_global;", -1, &stmt_global_stat, NULL))) { + goto sql_err; + } } void db_close(void) { if (db == NULL) return; + if (stmt_global_stat) { + sqlite3_finalize(stmt_global_stat); + stmt_global_stat = NULL; + } sqlite3_close(db); db = NULL; } |