Mercurial > garten

comparison db.c @ 17:5e6c9260913a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
lots of cleanups and small fixes
author meillo@marmaro.de
date Wed, 23 Jul 2008 17:14:38 +0200
parents 3c104b5f5158
children 5937504619f2
comparison
equal deleted inserted replaced
16:3c104b5f5158 17:5e6c9260913a
43 } 43 }
44 return 1; 44 return 1;
45 } 45 }
46 46
47 47
48 int db_rows(sqlite3_stmt* stmt) {
49 int i = 0;
50
51 sqlite3_reset(stmt);
52 while (sqlite3_step(stmt) == SQLITE_ROW) {
53 i++;
54 }
55 sqlite3_reset(stmt);
56 return i;
57 }
58
59
48 int read_time() { 60 int read_time() {
49 sprintf(query, "select time from game;"); 61 sprintf(query, "select time from game;");
50 stmt = db_query(query); 62 stmt = db_query(query);
51 if (sqlite3_step(stmt) != SQLITE_ROW) { 63 if (sqlite3_step(stmt) != SQLITE_ROW) {
52 printf("error: %s\n", sqlite3_errmsg(db)); 64 printf("error: %s\n", sqlite3_errmsg(db));
55 gametime = sqlite3_column_int(stmt, 0); 67 gametime = sqlite3_column_int(stmt, 0);
56 sqlite3_finalize(stmt); 68 sqlite3_finalize(stmt);
57 return gametime; 69 return gametime;
58 } 70 }
59 71
72
73 void db_error(char* info) {
74 fprintf(stderr, "%s%sSQL error: %s\n", (info) ? info : "", (info) ? ": " : "", sqlite3_errmsg(db));
75 }