summaryrefslogtreecommitdiff
path: root/src/db.h
blob: 38fc6dc8419bddfe970d89de0abd97715075e8dc (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
#ifndef BOKF_DB_H
#define BOKF_DB_H

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

#define BOKF_SCHEMA_VERSION 9

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);
int64_t db_count(sqlite3 *db, const char *sql);
int64_t db_last_id(sqlite3 *db);

#endif