annotate db.h @ 11:176ee28e7464
switched from mysql to sqlite; (+ some cleanups)
author |
meillo@marmaro.de |
date |
Wed, 23 Jul 2008 11:41:38 +0200 |
parents |
32c4212f05d9 |
children |
8db6497d6065 |
rev |
line source |
meillo@0
|
1 /*
|
meillo@0
|
2 * data for the database connection
|
meillo@0
|
3 */
|
meillo@0
|
4
|
meillo@11
|
5 #include <sqlite3.h>
|
meillo@0
|
6
|
meillo@11
|
7 char* database;
|
meillo@11
|
8 char query[1024];
|
meillo@11
|
9 sqlite3* db;
|
meillo@11
|
10 sqlite3_stmt* stmt;
|
meillo@11
|
11
|
meillo@0
|
12
|
meillo@0
|
13
|
meillo@0
|
14 void db_connect() {
|
meillo@11
|
15 if (sqlite3_open(database, &db) != SQLITE_OK) {
|
meillo@11
|
16 fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
|
meillo@11
|
17 sqlite3_close(db);
|
meillo@0
|
18 exit(1);
|
meillo@0
|
19 }
|
meillo@0
|
20 }
|
meillo@0
|
21
|
meillo@0
|
22
|
meillo@0
|
23 void db_close() {
|
meillo@11
|
24 sqlite3_close(db);
|
meillo@0
|
25 }
|
meillo@0
|
26
|
meillo@0
|
27
|
meillo@11
|
28 /*
|
meillo@11
|
29 static int callback(void* NotUsed, int argc, char* argv[], char* azColName[]){
|
meillo@11
|
30 NotUsed = NULL;
|
meillo@11
|
31 int i;
|
meillo@11
|
32 for (i = 0; i < argc; i++) {
|
meillo@11
|
33 printf("%s = %s\n", azColName[i], argv[i] ? argv[i]: "NULL");
|
meillo@11
|
34 }
|
meillo@11
|
35 printf("\n");
|
meillo@11
|
36 return 0;
|
meillo@11
|
37 }
|
meillo@11
|
38
|
meillo@11
|
39 int rc;
|
meillo@11
|
40 char* zErrMsg = 0;
|
meillo@11
|
41 rc = sqlite3_exec(db, query, callback, 0, &zErrMsg);
|
meillo@11
|
42 */
|
meillo@11
|
43
|
meillo@11
|
44
|
meillo@0
|
45 void db_query(char* query) {
|
meillo@0
|
46 int error;
|
meillo@11
|
47
|
meillo@11
|
48 error = sqlite3_prepare(db, query, -1, &stmt, NULL);
|
meillo@11
|
49 if (error) {
|
meillo@11
|
50 fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));
|
meillo@0
|
51 }
|
meillo@0
|
52 }
|