/*
 * Created by yuuta on 11/28/21.
 */

#ifndef _DB_H
#define _DB_H

#include <sqlite3.h>
#include <stdio.h>
#include <math.h>
#include <stdlib.h>

#define ULEN(X) (X == 0 ? 1 : (int)floor(log10(X)) + 1)
#define LLEN(X) ((int)floor(log10(llabs(X))) + 1 + ((X < 0) ? 1 : 0))

extern sqlite3_stmt *stmt_global_stat;

extern sqlite3_stmt *stmt_personal_stat;

extern sqlite3_stmt *stmt_random;

extern sqlite3_stmt *stmt_search;

extern sqlite3 *db;

void db_init(void);

void db_close(void);

#endif /* _DB_H */