Lines Matching full:foo

51         "CREATE TABLE foo (a INTEGER PRIMARY KEY)");  in ATF_TEST_CASE_BODY()
52 ATF_REQUIRE_THROW(sqlite::error, db.exec("SELECT * FROM foo")); in ATF_TEST_CASE_BODY()
54 db.exec("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
76 "CREATE TABLE foo (a INTEGER PRIMARY KEY)"); in ATF_TEST_CASE_BODY()
87 "CREATE TABLE foo (a INTEGER PRIMARY KEY)"); in ATF_TEST_CASE_BODY()
88 ATF_REQUIRE_THROW(sqlite::error, db.exec("SELECT * FROM foo")); in ATF_TEST_CASE_BODY()
90 db.exec("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
98 db.exec("CREATE TABLE foo (a INTEGER PRIMARY KEY)"); in ATF_TEST_CASE_BODY()
99 db.exec("INSERT INTO foo VALUES (3)"); in ATF_TEST_CASE_BODY()
101 "INSERT INTO foo VALUES (3)"); in ATF_TEST_CASE_BODY()
110 db.exec("CREATE TABLE foo (a INTEGER PRIMARY KEY, b INTEGER, c TEXT);" in ATF_TEST_CASE_BODY()
111 "INSERT INTO foo VALUES (5, 3, 'foo');"); in ATF_TEST_CASE_BODY()
112 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
123 db.exec("CREATE TABLE foo (first INTEGER PRIMARY KEY, second TEXT);" in ATF_TEST_CASE_BODY()
124 "INSERT INTO foo VALUES (5, 'foo');"); in ATF_TEST_CASE_BODY()
125 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
137 db.exec("CREATE TABLE foo (first INTEGER PRIMARY KEY);" in ATF_TEST_CASE_BODY()
138 "INSERT INTO foo VALUES (5);"); in ATF_TEST_CASE_BODY()
139 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
151 db.exec("CREATE TABLE foo (a_blob BLOB," in ATF_TEST_CASE_BODY()
156 "INSERT INTO foo VALUES (x'0102', 0.3, 5, NULL, 'foo bar');" in ATF_TEST_CASE_BODY()
157 "INSERT INTO foo VALUES (NULL, NULL, NULL, NULL, NULL);"); in ATF_TEST_CASE_BODY()
158 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
176 db.exec("CREATE TABLE foo (a INTEGER PRIMARY KEY);" in ATF_TEST_CASE_BODY()
177 "INSERT INTO foo VALUES (1);"); in ATF_TEST_CASE_BODY()
178 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
191 db.exec("CREATE TABLE foo (bar INTEGER PRIMARY KEY, " in ATF_TEST_CASE_BODY()
193 "INSERT INTO foo VALUES (1, 2);"); in ATF_TEST_CASE_BODY()
194 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
208 db.exec("CREATE TABLE foo (bar INTEGER PRIMARY KEY, " in ATF_TEST_CASE_BODY()
210 "INSERT INTO foo VALUES (1, 2);"); in ATF_TEST_CASE_BODY()
211 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
228 db.exec("CREATE TABLE foo (a INTEGER, b BLOB, c INTEGER);" in ATF_TEST_CASE_BODY()
229 "INSERT INTO foo VALUES (NULL, x'cafe', NULL);"); in ATF_TEST_CASE_BODY()
230 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
243 db.exec("CREATE TABLE foo (a INTEGER, b DOUBLE, c INTEGER);" in ATF_TEST_CASE_BODY()
244 "INSERT INTO foo VALUES (NULL, 0.5, NULL);"); in ATF_TEST_CASE_BODY()
245 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
256 db.exec("CREATE TABLE foo (a TEXT, b INTEGER, c TEXT);" in ATF_TEST_CASE_BODY()
257 "INSERT INTO foo VALUES (NULL, 987, NULL);"); in ATF_TEST_CASE_BODY()
258 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
269 db.exec("CREATE TABLE foo (a TEXT, b INTEGER, c TEXT);" in ATF_TEST_CASE_BODY()
270 "INSERT INTO foo VALUES (NULL, 4294967419, NULL);"); in ATF_TEST_CASE_BODY()
271 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
282 db.exec("CREATE TABLE foo (a TEXT, b INTEGER, c TEXT);" in ATF_TEST_CASE_BODY()
283 "INSERT INTO foo VALUES (NULL, 4294967419, NULL);"); in ATF_TEST_CASE_BODY()
284 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
295 db.exec("CREATE TABLE foo (a INTEGER, b TEXT, c INTEGER);" in ATF_TEST_CASE_BODY()
296 "INSERT INTO foo VALUES (NULL, 'foo bar', NULL);"); in ATF_TEST_CASE_BODY()
297 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
299 ATF_REQUIRE_EQ("foo bar", stmt.column_text(1)); in ATF_TEST_CASE_BODY()
308 db.exec("CREATE TABLE foo (a BLOB);" in ATF_TEST_CASE_BODY()
309 "INSERT INTO foo VALUES (x'12345678');"); in ATF_TEST_CASE_BODY()
310 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
321 db.exec("CREATE TABLE foo (a TEXT);" in ATF_TEST_CASE_BODY()
322 "INSERT INTO foo VALUES ('foo bar');"); in ATF_TEST_CASE_BODY()
323 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
334 db.exec("CREATE TABLE foo (a INTEGER, b BLOB, c INTEGER);" in ATF_TEST_CASE_BODY()
335 "INSERT INTO foo VALUES (NULL, x'cafe', NULL);"); in ATF_TEST_CASE_BODY()
336 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
349 db.exec("CREATE TABLE foo (a INTEGER);" in ATF_TEST_CASE_BODY()
350 "INSERT INTO foo VALUES (123);"); in ATF_TEST_CASE_BODY()
351 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
365 db.exec("CREATE TABLE foo (a INTEGER, b DOUBLE, c INTEGER);" in ATF_TEST_CASE_BODY()
366 "INSERT INTO foo VALUES (NULL, 0.5, NULL);"); in ATF_TEST_CASE_BODY()
367 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
378 db.exec("CREATE TABLE foo (a INTEGER);" in ATF_TEST_CASE_BODY()
379 "INSERT INTO foo VALUES (NULL);"); in ATF_TEST_CASE_BODY()
380 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
394 db.exec("CREATE TABLE foo (a TEXT, b INTEGER, c TEXT);" in ATF_TEST_CASE_BODY()
395 "INSERT INTO foo VALUES (NULL, 987, NULL);"); in ATF_TEST_CASE_BODY()
396 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
407 db.exec("CREATE TABLE foo (a TEXT);" in ATF_TEST_CASE_BODY()
408 "INSERT INTO foo VALUES ('def');"); in ATF_TEST_CASE_BODY()
409 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
423 db.exec("CREATE TABLE foo (a TEXT, b INTEGER, c TEXT);" in ATF_TEST_CASE_BODY()
424 "INSERT INTO foo VALUES (NULL, 4294967419, NULL);"); in ATF_TEST_CASE_BODY()
425 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
436 db.exec("CREATE TABLE foo (a TEXT);" in ATF_TEST_CASE_BODY()
437 "INSERT INTO foo VALUES ('abc');"); in ATF_TEST_CASE_BODY()
438 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
452 db.exec("CREATE TABLE foo (a INTEGER, b TEXT, c INTEGER);" in ATF_TEST_CASE_BODY()
453 "INSERT INTO foo VALUES (NULL, 'foo bar', NULL);"); in ATF_TEST_CASE_BODY()
454 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
456 ATF_REQUIRE_EQ("foo bar", stmt.safe_column_text("b")); in ATF_TEST_CASE_BODY()
465 db.exec("CREATE TABLE foo (a INTEGER);" in ATF_TEST_CASE_BODY()
466 "INSERT INTO foo VALUES (NULL);"); in ATF_TEST_CASE_BODY()
467 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
481 db.exec("CREATE TABLE foo (a BLOB);" in ATF_TEST_CASE_BODY()
482 "INSERT INTO foo VALUES (x'12345678');"); in ATF_TEST_CASE_BODY()
483 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
494 db.exec("CREATE TABLE foo (a TEXT);" in ATF_TEST_CASE_BODY()
495 "INSERT INTO foo VALUES ('foo bar');"); in ATF_TEST_CASE_BODY()
496 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
507 db.exec("CREATE TABLE foo (a TEXT);" in ATF_TEST_CASE_BODY()
508 "INSERT INTO foo VALUES (NULL);"); in ATF_TEST_CASE_BODY()
509 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
523 db.exec("CREATE TABLE foo (a TEXT);" in ATF_TEST_CASE_BODY()
524 "INSERT INTO foo VALUES ('foo bar');"); in ATF_TEST_CASE_BODY()
525 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
637 sqlite::statement stmt = db.create_statement("SELECT 3, :foo"); in ATF_TEST_CASE_BODY()
641 stmt.bind(":foo", str); in ATF_TEST_CASE_BODY()
657 sqlite::statement stmt = db.create_statement("SELECT 3, :foo"); in ATF_TEST_CASE_BODY()
660 stmt.bind(":foo", str); in ATF_TEST_CASE_BODY()
683 sqlite::statement stmt = db.create_statement("SELECT 3, :foo, ?, :bar"); in ATF_TEST_CASE_BODY()
684 ATF_REQUIRE_EQ(1, stmt.bind_parameter_index(":foo")); in ATF_TEST_CASE_BODY()
693 sqlite::statement stmt = db.create_statement("SELECT 3, :foo, ?, :bar"); in ATF_TEST_CASE_BODY()
694 ATF_REQUIRE_EQ(":foo", stmt.bind_parameter_name(1)); in ATF_TEST_CASE_BODY()