1 /*

2 * data for the database connection

3 */

4

5 #include <sqlite3.h>

6

7 char* database;

8 char query[1024];

9 sqlite3* db;

10 sqlite3_stmt* stmt;

11

12

13

14 void db_connect() {

15 if (sqlite3_open(database, &db) != SQLITE_OK) {

16 fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));

17 sqlite3_close(db);

18 exit(1);

19 }

20 }

21

22

23 void db_close() {

24 sqlite3_close(db);

25 }

26

27

28 /*

29 static int callback(void* NotUsed, int argc, char* argv[], char* azColName[]){

30 NotUsed = NULL;

31 int i;

32 for (i = 0; i < argc; i++) {

33 printf("%s = %s\n", azColName[i], argv[i] ? argv[i]: "NULL");

34 }

35 printf("\n");

36 return 0;

37 }

38

39 int rc;

40 char* zErrMsg = 0;

41 rc = sqlite3_exec(db, query, callback, 0, &zErrMsg);

42 */

43

44

45 void db_query(char* query) {

46 int error;

47

48 error = sqlite3_prepare(db, query, -1, &stmt, NULL);

49 if (error) {

50 fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));

51 }

52 }