1.1 --- a/db.h	Wed Jul 23 11:41:38 2008 +0200
     1.2 +++ b/db.h	Wed Jul 23 15:19:45 2008 +0200
     1.3 @@ -1,7 +1,3 @@
     1.4 -/*
     1.5 - * data for the database connection
     1.6 - */
     1.7 -
     1.8  #include <sqlite3.h>
     1.9  
    1.10  char* database;
    1.11 @@ -10,43 +6,7 @@
    1.12  sqlite3_stmt* stmt;
    1.13  
    1.14  
    1.15 -
    1.16 -void db_connect() {
    1.17 -	if (sqlite3_open(database, &db) != SQLITE_OK) {
    1.18 -		fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
    1.19 -		sqlite3_close(db);
    1.20 -		exit(1);
    1.21 -	}
    1.22 -}
    1.23 -
    1.24 -
    1.25 -void db_close() {
    1.26 -	sqlite3_close(db);
    1.27 -}
    1.28 -
    1.29 -
    1.30 -/*
    1.31 -static int callback(void* NotUsed, int argc, char* argv[], char* azColName[]){
    1.32 -	NotUsed = NULL;
    1.33 -	int i;
    1.34 -	for (i = 0; i < argc; i++) {
    1.35 -		printf("%s = %s\n", azColName[i], argv[i] ? argv[i]: "NULL");
    1.36 -	}
    1.37 -	printf("\n");
    1.38 -	return 0;
    1.39 -}
    1.40 -
    1.41 -int rc;
    1.42 -char* zErrMsg = 0;
    1.43 -rc = sqlite3_exec(db, query, callback, 0, &zErrMsg);
    1.44 -*/
    1.45 -
    1.46 -
    1.47 -void db_query(char* query) {
    1.48 -	int error;
    1.49 -
    1.50 -	error = sqlite3_prepare(db, query, -1, &stmt, NULL);
    1.51 -	if (error) {
    1.52 -		fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));
    1.53 -	}
    1.54 -}
    1.55 +void db_connect();
    1.56 +void db_close();
    1.57 +sqlite3_stmt* db_query(char* query);
    1.58 +int db_update(char* query);