Lines Matching defs:db
105 char **db_query(sqlite *db, const char *zFile, const char *zFormat, ...){
117 rc = sqlite_exec(db, zSql, db_query_callback, &sResult, &zErrMsg);
120 rc = sqlite_exec(db, zSql, db_query_callback, &sResult, &zErrMsg);
140 void db_execute(sqlite *db, const char *zFile, const char *zFormat, ...){
149 rc = sqlite_exec(db, zSql, 0, 0, &zErrMsg);
152 rc = sqlite_exec(db, zSql, 0, 0, &zErrMsg);
205 sqlite *db;
213 db = sqlite_open(&zFilename[2], 0, &azErr);
214 if( db==0 ){
218 sqlite_busy_handler(db, db_is_locked, zFilename);
219 db_execute(db, zFilename, "CREATE TABLE t%d(a,b,c);", t);
221 db_execute(db, zFilename, "INSERT INTO t%d VALUES(%d,%d,%d);",
224 az = db_query(db, zFilename, "SELECT count(*) FROM t%d", t);
226 az = db_query(db, zFilename, "SELECT avg(b) FROM t%d", t);
228 db_execute(db, zFilename, "DELETE FROM t%d WHERE a>50", t);
229 az = db_query(db, zFilename, "SELECT avg(b) FROM t%d", t);
233 az = db_query(db, zFilename, "SELECT b, c FROM t%d WHERE a=%d", t, i);
238 db_execute(db, zFilename, "DROP TABLE t%d;", t);
239 sqlite_close(db);