garten
diff 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 |
line diff
1.1 --- a/db.h Wed Jul 23 11:40:45 2008 +0200 1.2 +++ b/db.h Wed Jul 23 11:41:38 2008 +0200 1.3 @@ -2,39 +2,51 @@ 1.4 * data for the database connection 1.5 */ 1.6 1.7 -char* server = "localhost"; 1.8 -char* user = "garten"; 1.9 -char* password = "gras"; 1.10 -char* database = "garten"; 1.11 +#include <sqlite3.h> 1.12 1.13 -MYSQL* conn; 1.14 -MYSQL_RES* result; 1.15 -MYSQL_ROW row; 1.16 +char* database; 1.17 +char query[1024]; 1.18 +sqlite3* db; 1.19 +sqlite3_stmt* stmt; 1.20 + 1.21 1.22 1.23 void db_connect() { 1.24 - conn = mysql_init(NULL); 1.25 - 1.26 - /* Connect to database */ 1.27 - if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) { 1.28 - fprintf(stderr, "%s\n", mysql_error(conn)); 1.29 + if (sqlite3_open(database, &db) != SQLITE_OK) { 1.30 + fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db)); 1.31 + sqlite3_close(db); 1.32 exit(1); 1.33 } 1.34 } 1.35 1.36 1.37 void db_close() { 1.38 - /* close connection */ 1.39 - mysql_close(conn); 1.40 + sqlite3_close(db); 1.41 } 1.42 1.43 1.44 +/* 1.45 +static int callback(void* NotUsed, int argc, char* argv[], char* azColName[]){ 1.46 + NotUsed = NULL; 1.47 + int i; 1.48 + for (i = 0; i < argc; i++) { 1.49 + printf("%s = %s\n", azColName[i], argv[i] ? argv[i]: "NULL"); 1.50 + } 1.51 + printf("\n"); 1.52 + return 0; 1.53 +} 1.54 + 1.55 +int rc; 1.56 +char* zErrMsg = 0; 1.57 +rc = sqlite3_exec(db, query, callback, 0, &zErrMsg); 1.58 +*/ 1.59 + 1.60 + 1.61 void db_query(char* query) { 1.62 int error; 1.63 - /* send SQL query */ 1.64 - error = mysql_query(conn, query); 1.65 - /*printf("query: %s\nerror: %d / %d\n", query, error, mysql_errno(conn));*/ 1.66 - if (error != 0) { 1.67 - fprintf(stderr, "E: %s\n", mysql_error(conn)); 1.68 + 1.69 + error = sqlite3_prepare(db, query, -1, &stmt, NULL); 1.70 + if (error) { 1.71 + fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db)); 1.72 } 1.73 }