46     sqlite::database db = sqlite::database::in_memory();  in ATF_TEST_CASE_BODY()  local
47     create_test_table(raw(db));  in ATF_TEST_CASE_BODY()
48     verify_test_table(raw(db));  in ATF_TEST_CASE_BODY()
58         ::sqlite3* db;  in ATF_TEST_CASE_BODY()
59         ATF_REQUIRE_EQ(SQLITE_OK, ::sqlite3_open_v2("test.db", &db,  in ATF_TEST_CASE_BODY()
61         create_test_table(db);  in ATF_TEST_CASE_BODY()
62         ::sqlite3_close(db);  in ATF_TEST_CASE_BODY()
65         sqlite::database db = sqlite::database::open(fs::path("test.db"),  in ATF_TEST_CASE_BODY()  local
67         verify_test_table(raw(db));  in ATF_TEST_CASE_BODY()
85         sqlite::database db = sqlite::database::open(fs::path("test.db"),  in ATF_TEST_CASE_BODY()  local
88         create_test_table(raw(db));  in ATF_TEST_CASE_BODY()
91         ::sqlite3* db;  in ATF_TEST_CASE_BODY()
92         ATF_REQUIRE_EQ(SQLITE_OK, ::sqlite3_open_v2("test.db", &db,  in ATF_TEST_CASE_BODY()
94         verify_test_table(db);  in ATF_TEST_CASE_BODY()
95         ::sqlite3_close(db);  in ATF_TEST_CASE_BODY()
122     sqlite::database db = sqlite::database::temporary();  in ATF_TEST_CASE_BODY()  local
123     create_test_table(raw(db));  in ATF_TEST_CASE_BODY()
124     verify_test_table(raw(db));  in ATF_TEST_CASE_BODY()
131     sqlite::database db = sqlite::database::in_memory();  in ATF_TEST_CASE_BODY()  local
132     db.close();  in ATF_TEST_CASE_BODY()
157     sqlite::database db = sqlite::database::in_memory();  in ATF_TEST_CASE_BODY()  local
158     db.exec(create_test_table_sql);  in ATF_TEST_CASE_BODY()
159     verify_test_table(raw(db));  in ATF_TEST_CASE_BODY()
166     sqlite::database db = sqlite::database::in_memory();  in ATF_TEST_CASE_BODY()  local
168                       db.exec("SELECT * FROM test"));  in ATF_TEST_CASE_BODY()
170                       db.exec("CREATE TABLE test (col INTEGER PRIMARY KEY);"  in ATF_TEST_CASE_BODY()
172     db.exec("SELECT * FROM test");  in ATF_TEST_CASE_BODY()
179     sqlite::database db = sqlite::database::in_memory();  in ATF_TEST_CASE_BODY()  local
180     sqlite::statement stmt = db.create_statement("SELECT 3");  in ATF_TEST_CASE_BODY()
189     sqlite::database db = sqlite::database::in_memory();  in ATF_TEST_CASE_BODY()  local
190     sqlite::transaction stmt = db.begin_transaction();  in ATF_TEST_CASE_BODY()
199     sqlite::database db = sqlite::database::in_memory();  in ATF_TEST_CASE_BODY()  local
201                       db.create_statement("SELECT * FROM missing"));  in ATF_TEST_CASE_BODY()
208     sqlite::database db = sqlite::database::in_memory();  in ATF_TEST_CASE_BODY()  local
209     db.exec("CREATE TABLE test (a INTEGER PRIMARY KEY, b INTEGER)");  in ATF_TEST_CASE_BODY()
210     db.exec("INSERT INTO test VALUES (723, 5)");  in ATF_TEST_CASE_BODY()
211     ATF_REQUIRE_EQ(723, db.last_insert_rowid());  in ATF_TEST_CASE_BODY()
212     db.exec("INSERT INTO test VALUES (145, 20)");  in ATF_TEST_CASE_BODY()
213     ATF_REQUIRE_EQ(145, db.last_insert_rowid());  in ATF_TEST_CASE_BODY()