Lines Matching refs:db
23 int SqliteMasterCount(sql::Connection* db) {
25 sql::Statement s(db->GetUniqueStatement(kMasterCount));
56 void ErrorCallbackSetHelper(sql::Connection* db,
62 db->set_error_callback(base::Bind(&IgnoreErrorCallback));
66 void ErrorCallbackResetHelper(sql::Connection* db,
72 db->reset_error_callback();
95 db_path_ = temp_dir_.path().AppendASCII("SQLConnectionTest.db");
103 sql::Connection& db() { return db_; }
120 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
121 EXPECT_EQ(SQLITE_OK, db().GetErrorCode());
125 db().ExecuteAndReturnErrorCode("CREATE TAB foo (a, b"));
126 EXPECT_EQ(SQLITE_ERROR, db().GetErrorCode());
131 db().ExecuteAndReturnErrorCode("CREATE TABLE foo (a, b)"));
133 db().ExecuteAndReturnErrorCode("CREATE TABLE TABLE"));
135 db().ExecuteAndReturnErrorCode(
142 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
143 ASSERT_TRUE(db().Execute("INSERT INTO foo(a, b) VALUES (12, 13)"));
147 sql::Statement s(db().GetCachedStatement(id1, "SELECT a FROM foo"));
155 EXPECT_TRUE(db().HasCachedStatement(id1));
160 sql::Statement s(db().GetCachedStatement(id1, "something invalid("));
168 EXPECT_FALSE(db().HasCachedStatement(SQL_FROM_HERE));
172 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
173 ASSERT_TRUE(db().IsSQLValid("SELECT a FROM foo"));
174 ASSERT_FALSE(db().IsSQLValid("SELECT no_exist FROM foo"));
179 EXPECT_FALSE(db().DoesTableExist("foo"));
180 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
181 EXPECT_TRUE(db().DoesTableExist("foo"));
184 EXPECT_FALSE(db().DoesTableExist("FOO"));
187 EXPECT_FALSE(db().DoesColumnExist("foo", "bar"));
188 EXPECT_TRUE(db().DoesColumnExist("foo", "a"));
191 EXPECT_FALSE(db().DoesColumnExist("bar", "b"));
195 ASSERT_TRUE(db().Execute("CREATE TABLE foo (id INTEGER PRIMARY KEY, value)"));
197 ASSERT_TRUE(db().Execute("INSERT INTO foo (value) VALUES (12)"));
200 int64 row = db().GetLastInsertRowId();
204 sql::Statement s(db().GetUniqueStatement("SELECT value FROM foo WHERE id=?"));
211 ASSERT_TRUE(db().BeginTransaction());
212 ASSERT_TRUE(db().BeginTransaction());
213 EXPECT_EQ(2, db().transaction_nesting());
214 db().RollbackTransaction();
215 EXPECT_FALSE(db().CommitTransaction());
216 EXPECT_TRUE(db().BeginTransaction());
223 ASSERT_TRUE(db().Execute(kCreateSql));
224 ASSERT_TRUE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
228 ASSERT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
234 ASSERT_TRUE(db().Execute(kCreateSql));
235 ASSERT_TRUE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
240 &db(), base::Bind(&sql::CaptureErrorCallback, &error));
241 EXPECT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
250 ASSERT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
267 &db(), base::Bind(&ErrorCallbackSetHelper,
268 &db(), &count, RefCounter(&count)));
270 EXPECT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
277 &db(), base::Bind(&ErrorCallbackResetHelper,
278 &db(), &count, RefCounter(&count)));
280 EXPECT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
288 ASSERT_TRUE(db().Execute(kCreateSql));
289 ASSERT_TRUE(db().Execute("INSERT INTO foo (value) VALUES (12)"));
293 sql::Statement s(db().GetUniqueStatement("PRAGMA auto_vacuum"));
303 sql::Statement s(db().GetUniqueStatement("PRAGMA page_count"));
309 sql::Statement s(db().GetUniqueStatement("SELECT * FROM sqlite_master"));
319 ASSERT_TRUE(db().Raze());
322 sql::Statement s(db().GetUniqueStatement("PRAGMA page_count"));
327 ASSERT_EQ(0, SqliteMasterCount(&db()));
330 sql::Statement s(db().GetUniqueStatement("PRAGMA auto_vacuum"));
343 sql::Statement s(db().GetUniqueStatement("PRAGMA page_size"));
351 db().Close();
352 db().set_page_size(kPageSize);
353 ASSERT_TRUE(db().Open(db_path()));
356 sql::Statement s(db().GetUniqueStatement("PRAGMA page_size"));
361 ASSERT_TRUE(db().Raze());
370 ASSERT_TRUE(db().Execute(kCreateSql));
378 ASSERT_TRUE(db().Raze());
386 ASSERT_TRUE(db().Execute(kCreateSql));
397 ASSERT_FALSE(db().Raze());
401 ASSERT_TRUE(db().Raze());
404 ASSERT_TRUE(db().Execute(kCreateSql));
405 ASSERT_TRUE(db().Execute(kInsertSql));
412 ASSERT_FALSE(db().Raze());
416 ASSERT_TRUE(db().Raze());
423 ASSERT_TRUE(db().Execute(kCreateSql));
424 db().Close();
433 ASSERT_TRUE(db().Open(db_path()));
434 ASSERT_TRUE(db().Raze());
435 EXPECT_EQ(0, SqliteMasterCount(&db()));
440 db().Close();
459 EXPECT_TRUE(db().Open(db_path()));
462 EXPECT_TRUE(db().Raze());
463 db().Close();
466 EXPECT_TRUE(db().Open(db_path()));
467 EXPECT_EQ(0, SqliteMasterCount(&db()));
473 ASSERT_TRUE(db().Execute(kCreateSql));
474 ASSERT_EQ(1, SqliteMasterCount(&db()));
475 db().Close();
492 EXPECT_TRUE(db().Open(db_path()));
495 EXPECT_TRUE(db().Raze());
496 db().Close();
499 EXPECT_TRUE(db().Open(db_path()));
500 EXPECT_EQ(0, SqliteMasterCount(&db()));
509 db().Execute(kCreateSql));
510 ASSERT_EQ(1, SqliteMasterCount(&db()));
511 db().Close();
521 ASSERT_TRUE(db().Open(db_path()));
522 ASSERT_FALSE(db().Execute("PRAGMA auto_vacuum"));
523 db().Close();
527 db().set_error_callback(base::Bind(&SQLConnectionTest::RazeErrorCallback,
535 ASSERT_TRUE(db().Open(db_path()));
536 ASSERT_TRUE(db().Execute("PRAGMA auto_vacuum"));
537 EXPECT_EQ(0, SqliteMasterCount(&db()));
547 ASSERT_TRUE(db().Execute(kCreateSql));
548 ASSERT_TRUE(db().Execute(kPopulateSql));
549 ASSERT_TRUE(db().RazeAndClose());
550 ASSERT_FALSE(db().is_open());
551 db().Close();
552 ASSERT_TRUE(db().Open(db_path()));
553 ASSERT_EQ(0, SqliteMasterCount(&db()));
556 ASSERT_TRUE(db().Execute(kCreateSql));
557 ASSERT_TRUE(db().Execute(kPopulateSql));
558 ASSERT_TRUE(db().BeginTransaction());
559 ASSERT_TRUE(db().RazeAndClose());
560 ASSERT_FALSE(db().is_open());
561 ASSERT_FALSE(db().CommitTransaction());
562 db().Close();
563 ASSERT_TRUE(db().Open(db_path()));
564 ASSERT_EQ(0, SqliteMasterCount(&db()));
574 ASSERT_TRUE(db().Execute(kCreateSql));
575 ASSERT_TRUE(db().Execute(kPopulateSql));
578 db().Preload();
579 ASSERT_TRUE(db().DoesTableExist("foo"));
580 ASSERT_TRUE(db().IsSQLValid(kSimpleSql));
581 ASSERT_EQ(SQLITE_OK, db().ExecuteAndReturnErrorCode(kSimpleSql));
582 ASSERT_TRUE(db().Execute(kSimpleSql));
583 ASSERT_TRUE(db().is_open());
585 sql::Statement s(db().GetUniqueStatement(kSimpleSql));
589 sql::Statement s(db().GetCachedStatement(SQL_FROM_HERE, kSimpleSql));
592 ASSERT_TRUE(db().BeginTransaction());
593 ASSERT_TRUE(db().CommitTransaction());
594 ASSERT_TRUE(db().BeginTransaction());
595 db().RollbackTransaction();
597 ASSERT_TRUE(db().RazeAndClose());
600 db().Preload();
601 ASSERT_FALSE(db().DoesTableExist("foo"));
602 ASSERT_FALSE(db().IsSQLValid(kSimpleSql));
603 ASSERT_EQ(SQLITE_ERROR, db().ExecuteAndReturnErrorCode(kSimpleSql));
604 ASSERT_FALSE(db().Execute(kSimpleSql));
605 ASSERT_FALSE(db().is_open());
607 sql::Statement s(db().GetUniqueStatement(kSimpleSql));
611 sql::Statement s(db().GetCachedStatement(SQL_FROM_HERE, kSimpleSql));
614 ASSERT_FALSE(db().BeginTransaction());
615 ASSERT_FALSE(db().CommitTransaction());
616 ASSERT_FALSE(db().BeginTransaction());
617 db().RollbackTransaction();
620 db().Close();
629 db().IsSQLValid(kSimpleSql);
630 }, "Illegal use of connection without a db");
648 ASSERT_TRUE(meta_table.Init(&db(), 4, 4));
653 EXPECT_TRUE(db().Execute("CREATE TABLE x (x)"));
654 db().Close();
675 db().Close();
679 ASSERT_TRUE(db().Open(db_path()));
684 EXPECT_TRUE(db().Execute("CREATE TABLE x (x)"));
702 db().Close();
703 db().set_restrict_to_user();
704 ASSERT_TRUE(db().Open(db_path()));
715 db().Close();
717 ASSERT_TRUE(db().Open(db_path()));
725 EXPECT_TRUE(db().Execute("CREATE TABLE x (x)"));
735 EXPECT_TRUE(db().Execute("CREATE TABLE x (x)"));
738 EXPECT_TRUE(db().IsSQLValid("INSERT INTO x VALUES ('x')"));
739 EXPECT_TRUE(db().Execute("INSERT INTO x VALUES ('x')"));
741 sql::Statement s(db().GetUniqueStatement("SELECT COUNT(*) FROM x"));
748 db().GetUniqueStatement("SELECT COUNT(*) FROM sqlite_master"));
753 db().Poison();
756 EXPECT_FALSE(db().IsSQLValid("INSERT INTO x VALUES ('x')"));
757 EXPECT_FALSE(db().Execute("INSERT INTO x VALUES ('x')"));
759 sql::Statement s(db().GetUniqueStatement("SELECT COUNT(*) FROM x"));
771 EXPECT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
775 db_path().DirName().AppendASCII("SQLConnectionAttach.db");
785 EXPECT_FALSE(db().IsSQLValid("SELECT count(*) from other.bar"));
788 EXPECT_TRUE(db().BeginTransaction());
792 EXPECT_FALSE(db().AttachDatabase(attach_path, kAttachmentPoint));
797 db().RollbackTransaction();
798 EXPECT_TRUE(db().AttachDatabase(attach_path, kAttachmentPoint));
799 EXPECT_TRUE(db().IsSQLValid("SELECT count(*) from other.bar"));
802 EXPECT_TRUE(db().Execute("INSERT INTO foo SELECT a, b FROM other.bar"));
804 sql::Statement s(db().GetUniqueStatement("SELECT COUNT(*) FROM foo"));
810 EXPECT_TRUE(db().BeginTransaction());
814 EXPECT_FALSE(db().DetachDatabase(kAttachmentPoint));
815 EXPECT_TRUE(db().IsSQLValid("SELECT count(*) from other.bar"));
820 db().RollbackTransaction();
821 EXPECT_TRUE(db().DetachDatabase(kAttachmentPoint));
823 EXPECT_FALSE(db().IsSQLValid("SELECT count(*) from other.bar"));
828 ASSERT_TRUE(db().Execute(kCreateSql));
829 EXPECT_TRUE(db().QuickIntegrityCheck());
830 db().Close();
837 ASSERT_TRUE(db().Open(db_path()));
838 EXPECT_FALSE(db().QuickIntegrityCheck());
848 ASSERT_TRUE(db().Execute(kCreateSql));
849 EXPECT_TRUE(db().FullIntegrityCheck(&messages));
852 db().Close();
859 ASSERT_TRUE(db().Open(db_path()));
860 EXPECT_TRUE(db().FullIntegrityCheck(&messages));
