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