#ifndef BOKF_DB_H
#define BOKF_DB_H

#include <sqlite3.h>
#include <stddef.h>
#include <stdint.h>

#define BOKF_SCHEMA_VERSION 11

int db_open(const char *path, sqlite3 **out, char **err);
int db_migrate(sqlite3 *db, char **err);
int db_exec(sqlite3 *db, const char *sql, char **err);
int db_create_user(sqlite3 *db, const char *username, const char *display_name,
                   const char *password, int is_admin, int64_t *out_id,
                   char **err);
char *db_membership_role(sqlite3 *db, int64_t org_id, int64_t user_id);
char *db_setting(sqlite3 *db, int64_t org_id, const char *key);
void db_setting_copy(sqlite3 *db, int64_t org_id, const char *key,
                     const char *def, char *out, size_t n);
int64_t db_count(sqlite3 *db, const char *sql);
int64_t db_last_id(sqlite3 *db);

#endif