Lines Matching refs:sqlite
43 namespace sqlite = utils::sqlite;
49 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
50 sqlite::statement stmt = db.create_statement( in ATF_TEST_CASE_BODY()
52 ATF_REQUIRE_THROW(sqlite::error, db.exec("SELECT * FROM foo")); in ATF_TEST_CASE_BODY()
61 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
63 sqlite::statement stmt = db.create_statement( in ATF_TEST_CASE_BODY()
74 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
75 sqlite::statement stmt = db.create_statement( in ATF_TEST_CASE_BODY()
85 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
86 sqlite::statement stmt = db.create_statement( in ATF_TEST_CASE_BODY()
88 ATF_REQUIRE_THROW(sqlite::error, db.exec("SELECT * FROM foo")); in ATF_TEST_CASE_BODY()
97 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
100 sqlite::statement stmt = db.create_statement( in ATF_TEST_CASE_BODY()
109 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
112 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
122 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
125 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
136 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
139 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
150 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
158 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
160 ATF_REQUIRE(sqlite::type_blob == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
161 ATF_REQUIRE(sqlite::type_float == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
162 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(2)); in ATF_TEST_CASE_BODY()
163 ATF_REQUIRE(sqlite::type_null == stmt.column_type(3)); in ATF_TEST_CASE_BODY()
164 ATF_REQUIRE(sqlite::type_text == stmt.column_type(4)); in ATF_TEST_CASE_BODY()
167 ATF_REQUIRE(sqlite::type_null == stmt.column_type(i)); in ATF_TEST_CASE_BODY()
175 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
178 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
180 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
181 ATF_REQUIRE(sqlite::type_null == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
182 ATF_REQUIRE(sqlite::type_null == stmt.column_type(512)); in ATF_TEST_CASE_BODY()
190 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
194 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
207 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
211 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
217 } catch (const sqlite::invalid_column_error& e) { in ATF_TEST_CASE_BODY()
227 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
230 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
232 const sqlite::blob blob = stmt.column_blob(1); in ATF_TEST_CASE_BODY()
242 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
245 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
255 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
258 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
268 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
271 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
281 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
284 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
294 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
297 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
307 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
310 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
320 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
323 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
333 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
336 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
338 const sqlite::blob blob = stmt.safe_column_blob("b"); in ATF_TEST_CASE_BODY()
348 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
351 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
353 ATF_REQUIRE_THROW(sqlite::invalid_column_error, in ATF_TEST_CASE_BODY()
355 ATF_REQUIRE_THROW_RE(sqlite::error, "not a blob", in ATF_TEST_CASE_BODY()
364 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
367 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
377 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
380 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
382 ATF_REQUIRE_THROW(sqlite::invalid_column_error, in ATF_TEST_CASE_BODY()
384 ATF_REQUIRE_THROW_RE(sqlite::error, "not a float", in ATF_TEST_CASE_BODY()
393 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
396 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
406 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
409 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
411 ATF_REQUIRE_THROW(sqlite::invalid_column_error, in ATF_TEST_CASE_BODY()
413 ATF_REQUIRE_THROW_RE(sqlite::error, "not an integer", in ATF_TEST_CASE_BODY()
422 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
425 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
435 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
438 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
440 ATF_REQUIRE_THROW(sqlite::invalid_column_error, in ATF_TEST_CASE_BODY()
442 ATF_REQUIRE_THROW_RE(sqlite::error, "not an integer", in ATF_TEST_CASE_BODY()
451 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
454 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
464 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
467 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
469 ATF_REQUIRE_THROW(sqlite::invalid_column_error, in ATF_TEST_CASE_BODY()
471 ATF_REQUIRE_THROW_RE(sqlite::error, "not a string", in ATF_TEST_CASE_BODY()
480 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
483 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
493 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
496 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
506 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
509 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
511 ATF_REQUIRE_THROW(sqlite::invalid_column_error, in ATF_TEST_CASE_BODY()
513 ATF_REQUIRE_THROW_RE(sqlite::error, "not a blob or a string", in ATF_TEST_CASE_BODY()
522 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
525 sqlite::statement stmt = db.create_statement("SELECT * FROM foo"); in ATF_TEST_CASE_BODY()
537 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
538 sqlite::statement stmt = db.create_statement("SELECT 3, ?"); in ATF_TEST_CASE_BODY()
541 stmt.bind(1, sqlite::blob(static_cast< const void* >(blob), 2)); in ATF_TEST_CASE_BODY()
543 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
545 ATF_REQUIRE(sqlite::type_blob == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
556 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
557 sqlite::statement stmt = db.create_statement("SELECT 3, ?"); in ATF_TEST_CASE_BODY()
561 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
563 ATF_REQUIRE(sqlite::type_float == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
572 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
573 sqlite::statement stmt = db.create_statement("SELECT 3, ?"); in ATF_TEST_CASE_BODY()
577 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
579 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
588 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
589 sqlite::statement stmt = db.create_statement("SELECT 3, ?"); in ATF_TEST_CASE_BODY()
593 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
595 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
604 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
605 sqlite::statement stmt = db.create_statement("SELECT 3, ?"); in ATF_TEST_CASE_BODY()
607 stmt.bind(1, sqlite::null()); in ATF_TEST_CASE_BODY()
609 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
611 ATF_REQUIRE(sqlite::type_null == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
619 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
620 sqlite::statement stmt = db.create_statement("SELECT 3, ?"); in ATF_TEST_CASE_BODY()
625 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
627 ATF_REQUIRE(sqlite::type_text == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
636 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
637 sqlite::statement stmt = db.create_statement("SELECT 3, :foo"); in ATF_TEST_CASE_BODY()
645 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
647 ATF_REQUIRE(sqlite::type_text == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
656 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
657 sqlite::statement stmt = db.create_statement("SELECT 3, :foo"); in ATF_TEST_CASE_BODY()
662 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
664 ATF_REQUIRE(sqlite::type_text == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
673 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
674 sqlite::statement stmt = db.create_statement("SELECT 3, ?, ?"); in ATF_TEST_CASE_BODY()
682 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
683 sqlite::statement stmt = db.create_statement("SELECT 3, :foo, ?, :bar"); in ATF_TEST_CASE_BODY()
692 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
693 sqlite::statement stmt = db.create_statement("SELECT 3, :foo, ?, :bar"); in ATF_TEST_CASE_BODY()
702 sqlite::database db = sqlite::database::in_memory(); in ATF_TEST_CASE_BODY()
703 sqlite::statement stmt = db.create_statement("SELECT 3, ?"); in ATF_TEST_CASE_BODY()
707 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
709 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(1)); in ATF_TEST_CASE_BODY()
715 ATF_REQUIRE(sqlite::type_integer == stmt.column_type(0)); in ATF_TEST_CASE_BODY()
717 ATF_REQUIRE(sqlite::type_null == stmt.column_type(1)); in ATF_TEST_CASE_BODY()