Mercurial > garten

comparison db.h @ 11:176ee28e7464

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
switched from mysql to sqlite; (+ some cleanups)
author meillo@marmaro.de
date Wed, 23 Jul 2008 11:41:38 +0200
parents 32c4212f05d9
children 8db6497d6065
comparison
equal deleted inserted replaced
10:13c6828bd4a5 11:176ee28e7464
1 /* 1 /*
2 * data for the database connection 2 * data for the database connection
3 */ 3 */
4 4
5 char* server = "localhost"; 5 #include <sqlite3.h>
6 char* user = "garten";
7 char* password = "gras";
8 char* database = "garten";
9 6
10 MYSQL* conn; 7 char* database;
11 MYSQL_RES* result; 8 char query[1024];
12 MYSQL_ROW row; 9 sqlite3* db;
10 sqlite3_stmt* stmt;
11
13 12
14 13
15 void db_connect() { 14 void db_connect() {
16 conn = mysql_init(NULL); 15 if (sqlite3_open(database, &db) != SQLITE_OK) {
17 16 fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
18 /* Connect to database */ 17 sqlite3_close(db);
19 if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
20 fprintf(stderr, "%s\n", mysql_error(conn));
21 exit(1); 18 exit(1);
22 } 19 }
23 } 20 }
24 21
25 22
26 void db_close() { 23 void db_close() {
27 /* close connection */ 24 sqlite3_close(db);
28 mysql_close(conn);
29 } 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 */
30 43
31 44
32 void db_query(char* query) { 45 void db_query(char* query) {
33 int error; 46 int error;
34 /* send SQL query */ 47
35 error = mysql_query(conn, query); 48 error = sqlite3_prepare(db, query, -1, &stmt, NULL);
36 /*printf("query: %s\nerror: %d / %d\n", query, error, mysql_errno(conn));*/ 49 if (error) {
37 if (error != 0) { 50 fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));
38 fprintf(stderr, "E: %s\n", mysql_error(conn));
39 } 51 }
40 } 52 }