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  }