Subversion Repositories MLServ

Rev

Rev 1 | Rev 7 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
1 nishi 1 
/* $Id: db.c 5 2024-09-25 00:19:35Z nishi $ */
5 nishi 2 
 
3 
#include "cm_db.h"
4 
 
5 
#include <sqlite3.h>
6 
 
7 
#include <stddef.h>
8 
 
9 
sqlite3* cm_db_init(void) {
10 
	int ret;
11 
	sqlite3* sql;
12 
	ret = sqlite3_open(DB_PATH, &sql);
13 
	if(ret != SQLITE_OK) {
14 
		return NULL;
15 
	}
16 
	ret = sqlite3_exec(sql, "create table if not exists lists(name text, description text)", NULL, NULL, NULL);
17 
	if(ret != SQLITE_OK) {
18 
		sqlite3_close(sql);
19 
		return NULL;
20 
	}
21 
	ret = sqlite3_exec(sql, "create table if not exists users(email text, password text)", NULL, NULL, NULL);
22 
	if(ret != SQLITE_OK) {
23 
		sqlite3_close(sql);
24 
		return NULL;
25 
	}
26 
	ret = sqlite3_exec(sql, "create table if not exists tokens(list text, email text, token text, expire numeric)", NULL, NULL, NULL);
27 
	if(ret != SQLITE_OK) {
28 
		sqlite3_close(sql);
29 
		return NULL;
30 
	}
31 
	return sql;
32 
}