Lines Matching refs:zFilename
200 const char *zFilename = (char*)pArg;
203 int t = atoi(zFilename);
210 printf("%s: START\n", zFilename);
213 db = sqlite_open(&zFilename[2], 0, &azErr);
215 fprintf(stdout,"%s: can't open\n", zFilename);
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);
225 db_check(zFilename, "tX size", az, "100", 0);
226 az = db_query(db, zFilename, "SELECT avg(b) FROM t%d", t);
227 db_check(zFilename, "tX avg", az, "101", 0);
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);
230 db_check(zFilename, "tX avg2", az, "51", 0);
233 az = db_query(db, zFilename, "SELECT b, c FROM t%d WHERE a=%d", t, i);
236 db_check(zFilename, "readback", az, z1, z2, 0);
238 db_execute(db, zFilename, "DROP TABLE t%d;", t);
241 printf("%s: END\n", zFilename);
242 /* unlink(zFilename); */