1 files changed, 11 insertions, 0 deletions

diff --git a/db.c b/db.c
index 98b35a0..0ec4e31 100644
--- a/db.c
+++ b/db.c
@@ -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;
 }