Lines Matching refs:db
21 int SqliteMasterCount(sql::Connection* db) {
23 sql::Statement s(db->GetUniqueStatement(kMasterCount));
54 void ErrorCallbackSetHelper(sql::Connection* db,
60 db->set_error_callback(base::Bind(&IgnoreErrorCallback));
64 void ErrorCallbackResetHelper(sql::Connection* db,
70 db->reset_error_callback();
102 sql::Connection& db() { return db_; }
105 return temp_dir_.path().AppendASCII("SQLConnectionTest.db");
121 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
122 EXPECT_EQ(SQLITE_OK, db().GetErrorCode());
126 db().ExecuteAndReturnErrorCode("CREATE TAB foo (a, b"));
127 EXPECT_EQ(SQLITE_ERROR, db().GetErrorCode());
132 db().ExecuteAndReturnErrorCode("CREATE TABLE foo (a, b)"));
134 db().ExecuteAndReturnErrorCode("CREATE TABLE TABLE"));
136 db().ExecuteAndReturnErrorCode(
143 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
144 ASSERT_TRUE(db().Execute("INSERT INTO foo(a, b) VALUES (12, 13)"));
148 sql::Statement s(db().GetCachedStatement(id1, "SELECT a FROM foo"));
156 EXPECT_TRUE(db().HasCachedStatement(id1));
161 sql::Statement s(db().GetCachedStatement(id1, "something invalid("));
169 EXPECT_FALSE(db().HasCachedStatement(SQL_FROM_HERE));
173 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
174 ASSERT_TRUE(db().IsSQLValid("SELECT a FROM foo"));
175 ASSERT_FALSE(db().IsSQLValid("SELECT no_exist FROM foo"));
180 EXPECT_FALSE(db().DoesTableExist("foo"));
181 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
182 EXPECT_TRUE(db().DoesTableExist("foo"));
185 EXPECT_FALSE(db().DoesTableExist("FOO"));
188 EXPECT_FALSE(db().DoesColumnExist("foo", "bar"));
189 EXPECT_TRUE(db().DoesColumnExist("foo", "a"));
192 EXPECT_FALSE(db().DoesColumnExist("bar", "b"));
196 ASSERT_TRUE(db().Execute("CREATE TABLE foo (id INTEGER PRIMARY KEY, value)"));
198 ASSERT_TRUE(db().Execute("INSERT INTO foo (value) VALUES (12)"));
201 int64 row = db().GetLastInsertRowId();
205 sql::Statement s(db().GetUniqueStatement("SELECT value FROM foo WHERE id=?"));
212 ASSERT_TRUE(db().BeginTransaction());
213 ASSERT_TRUE(db().BeginTransaction());
214 EXPECT_EQ(2, db().transaction_nesting());
215 db().RollbackTransaction();
216 EXPECT_FALSE(db().CommitTransaction());
217 EXPECT_TRUE(db().BeginTransaction());
224 ASSERT_TRUE(db().Execute(kCreateSql));
225 ASSERT_TRUE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
229 ASSERT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
235 ASSERT_TRUE(db().Execute(kCreateSql));
236 ASSERT_TRUE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
241 &db(), base::Bind(&sql::CaptureErrorCallback, &error));
242 EXPECT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
251 ASSERT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
268 &db(), base::Bind(&ErrorCallbackSetHelper,
269 &db(), &count, RefCounter(&count)));
271 EXPECT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
278 &db(), base::Bind(&ErrorCallbackResetHelper,
279 &db(), &count, RefCounter(&count)));
281 EXPECT_FALSE(db().Execute("INSERT INTO foo (id) VALUES (12)"));
289 ASSERT_TRUE(db().Execute(kCreateSql));
290 ASSERT_TRUE(db().Execute("INSERT INTO foo (value) VALUES (12)"));
294 sql::Statement s(db().GetUniqueStatement("PRAGMA auto_vacuum"));
304 sql::Statement s(db().GetUniqueStatement("PRAGMA page_count"));
310 sql::Statement s(db().GetUniqueStatement("SELECT * FROM sqlite_master"));
320 ASSERT_TRUE(db().Raze());
323 sql::Statement s(db().GetUniqueStatement("PRAGMA page_count"));
328 ASSERT_EQ(0, SqliteMasterCount(&db()));
331 sql::Statement s(db().GetUniqueStatement("PRAGMA auto_vacuum"));
344 sql::Statement s(db().GetUniqueStatement("PRAGMA page_size"));
352 db().Close();
353 db().set_page_size(kPageSize);
354 ASSERT_TRUE(db().Open(db_path()));
357 sql::Statement s(db().GetUniqueStatement("PRAGMA page_size"));
362 ASSERT_TRUE(db().Raze());
371 ASSERT_TRUE(db().Execute(kCreateSql));
379 ASSERT_TRUE(db().Raze());
387 ASSERT_TRUE(db().Execute(kCreateSql));
398 ASSERT_FALSE(db().Raze());
402 ASSERT_TRUE(db().Raze());
405 ASSERT_TRUE(db().Execute(kCreateSql));
406 ASSERT_TRUE(db().Execute(kInsertSql));
413 ASSERT_FALSE(db().Raze());
417 ASSERT_TRUE(db().Raze());
424 ASSERT_TRUE(db().Execute(kCreateSql));
425 db().Close();
434 ASSERT_TRUE(db().Open(db_path()));
435 ASSERT_TRUE(db().Raze());
436 EXPECT_EQ(0, SqliteMasterCount(&db()));
441 db().Close();
460 EXPECT_TRUE(db().Open(db_path()));
463 EXPECT_TRUE(db().Raze());
464 db().Close();
467 EXPECT_TRUE(db().Open(db_path()));
468 EXPECT_EQ(0, SqliteMasterCount(&db()));
474 ASSERT_TRUE(db().Execute(kCreateSql));
475 ASSERT_EQ(1, SqliteMasterCount(&db()));
476 db().Close();
493 EXPECT_TRUE(db().Open(db_path()));
496 EXPECT_TRUE(db().Raze());
497 db().Close();
500 EXPECT_TRUE(db().Open(db_path()));
501 EXPECT_EQ(0, SqliteMasterCount(&db()));
517 ASSERT_TRUE(db().Execute(kCreateSql));
518 ASSERT_EQ(1, SqliteMasterCount(&db()));
521 sql::Statement s(db().GetUniqueStatement("PRAGMA page_size"));
525 db().Close();
540 ASSERT_TRUE(db().Open(db_path()));
541 ASSERT_FALSE(db().Execute("PRAGMA auto_vacuum"));
542 db().Close();
546 db().set_error_callback(base::Bind(&SQLConnectionTest::RazeErrorCallback,
554 ASSERT_TRUE(db().Open(db_path()));
555 ASSERT_TRUE(db().Execute("PRAGMA auto_vacuum"));
556 EXPECT_EQ(0, SqliteMasterCount(&db()));
566 ASSERT_TRUE(db().Execute(kCreateSql));
567 ASSERT_TRUE(db().Execute(kPopulateSql));
568 ASSERT_TRUE(db().RazeAndClose());
569 ASSERT_FALSE(db().is_open());
570 db().Close();
571 ASSERT_TRUE(db().Open(db_path()));
572 ASSERT_EQ(0, SqliteMasterCount(&db()));
575 ASSERT_TRUE(db().Execute(kCreateSql));
576 ASSERT_TRUE(db().Execute(kPopulateSql));
577 ASSERT_TRUE(db().BeginTransaction());
578 ASSERT_TRUE(db().RazeAndClose());
579 ASSERT_FALSE(db().is_open());
580 ASSERT_FALSE(db().CommitTransaction());
581 db().Close();
582 ASSERT_TRUE(db().Open(db_path()));
583 ASSERT_EQ(0, SqliteMasterCount(&db()));
593 ASSERT_TRUE(db().Execute(kCreateSql));
594 ASSERT_TRUE(db().Execute(kPopulateSql));
597 db().Preload();
598 ASSERT_TRUE(db().DoesTableExist("foo"));
599 ASSERT_TRUE(db().IsSQLValid(kSimpleSql));
600 ASSERT_EQ(SQLITE_OK, db().ExecuteAndReturnErrorCode(kSimpleSql));
601 ASSERT_TRUE(db().Execute(kSimpleSql));
602 ASSERT_TRUE(db().is_open());
604 sql::Statement s(db().GetUniqueStatement(kSimpleSql));
608 sql::Statement s(db().GetCachedStatement(SQL_FROM_HERE, kSimpleSql));
611 ASSERT_TRUE(db().BeginTransaction());
612 ASSERT_TRUE(db().CommitTransaction());
613 ASSERT_TRUE(db().BeginTransaction());
614 db().RollbackTransaction();
616 ASSERT_TRUE(db().RazeAndClose());
619 db().Preload();
620 ASSERT_FALSE(db().DoesTableExist("foo"));
621 ASSERT_FALSE(db().IsSQLValid(kSimpleSql));
622 ASSERT_EQ(SQLITE_ERROR, db().ExecuteAndReturnErrorCode(kSimpleSql));
623 ASSERT_FALSE(db().Execute(kSimpleSql));
624 ASSERT_FALSE(db().is_open());
626 sql::Statement s(db().GetUniqueStatement(kSimpleSql));
630 sql::Statement s(db().GetCachedStatement(SQL_FROM_HERE, kSimpleSql));
633 ASSERT_FALSE(db().BeginTransaction());
634 ASSERT_FALSE(db().CommitTransaction());
635 ASSERT_FALSE(db().BeginTransaction());
636 db().RollbackTransaction();
639 db().Close();
648 db().IsSQLValid(kSimpleSql);
649 }, "Illegal use of connection without a db");
667 ASSERT_TRUE(meta_table.Init(&db(), 4, 4));
672 EXPECT_TRUE(db().Execute("CREATE TABLE x (x)"));
673 db().Close();
694 db().Close();
698 ASSERT_TRUE(db().Open(db_path()));
703 EXPECT_TRUE(db().Execute("CREATE TABLE x (x)"));
721 db().Close();
722 db().set_restrict_to_user();
723 ASSERT_TRUE(db().Open(db_path()));
734 db().Close();
736 ASSERT_TRUE(db().Open(db_path()));
744 EXPECT_TRUE(db().Execute("CREATE TABLE x (x)"));
754 EXPECT_TRUE(db().Execute("CREATE TABLE x (x)"));
757 EXPECT_TRUE(db().IsSQLValid("INSERT INTO x VALUES ('x')"));
758 EXPECT_TRUE(db().Execute("INSERT INTO x VALUES ('x')"));
760 sql::Statement s(db().GetUniqueStatement("SELECT COUNT(*) FROM x"));
767 db().GetUniqueStatement("SELECT COUNT(*) FROM sqlite_master"));
772 db().Poison();
775 EXPECT_FALSE(db().IsSQLValid("INSERT INTO x VALUES ('x')"));
776 EXPECT_FALSE(db().Execute("INSERT INTO x VALUES ('x')"));
778 sql::Statement s(db().GetUniqueStatement("SELECT COUNT(*) FROM x"));
790 EXPECT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
794 db_path().DirName().AppendASCII("SQLConnectionAttach.db");
804 EXPECT_FALSE(db().IsSQLValid("SELECT count(*) from other.bar"));
807 EXPECT_TRUE(db().BeginTransaction());
811 EXPECT_FALSE(db().AttachDatabase(attach_path, kAttachmentPoint));
816 db().RollbackTransaction();
817 EXPECT_TRUE(db().AttachDatabase(attach_path, kAttachmentPoint));
818 EXPECT_TRUE(db().IsSQLValid("SELECT count(*) from other.bar"));
821 EXPECT_TRUE(db().Execute("INSERT INTO foo SELECT a, b FROM other.bar"));
823 sql::Statement s(db().GetUniqueStatement("SELECT COUNT(*) FROM foo"));
829 EXPECT_TRUE(db().BeginTransaction());
833 EXPECT_FALSE(db().DetachDatabase(kAttachmentPoint));
834 EXPECT_TRUE(db().IsSQLValid("SELECT count(*) from other.bar"));
839 db().RollbackTransaction();
840 EXPECT_TRUE(db().DetachDatabase(kAttachmentPoint));
842 EXPECT_FALSE(db().IsSQLValid("SELECT count(*) from other.bar"));
