garten
diff db.h @ 12:8db6497d6065
merged everything to only one program
author | meillo@marmaro.de |
---|---|
date | Wed, 23 Jul 2008 15:19:45 +0200 |
parents | 176ee28e7464 |
children | 5e6c9260913a |
line diff
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);