db.h


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

#include <sqlite3.h>

sqlite3 *db;

struct att{
	int id;
	int post;
	int bytes;	/* Size of data. */
	char *name;
	char *desc;
	char *mime;
	char *data;
};

struct post{
	int id;
	int parent;
	int user;
	int created;
	int edited;
	char *subject;
	char *text;
};

struct user{
	int id;
	int created;
	char *name;
	char *full;
	char *hash;
};

int addatt(struct att *);
int adduser(struct user *);
struct att *getatt(sqlite3_stmt *);
struct post *getpost(sqlite3_stmt *);
struct user *getuser(sqlite3_stmt *);
struct att *nextatt(sqlite3_stmt *);
struct post *nextpost(sqlite3_stmt *);
struct user *nextuser(sqlite3_stmt *);
sqlite3_stmt *selectbyint(char *, char *, int);