Lines Matching refs:db
17 size_t CountSQLItemsOfType(sql::Connection* db, const char* type) {
19 sql::Statement s(db->GetUniqueStatement(kTypeSQL));
26 bool GetPageSize(sql::Connection* db, int* page_size) {
27 sql::Statement s(db->GetUniqueStatement("PRAGMA page_size"));
35 bool GetRootPage(sql::Connection* db, const char* name, int* page_number) {
37 sql::Statement s(db->GetUniqueStatement(kPageSql));
115 sql::Connection db;
116 if (!db.Open(db_path))
120 if (!GetPageSize(&db, &page_size))
124 if (!GetRootPage(&db, tree_name, &page_number))
146 if (!db.Execute(update_sql))
148 if (db.GetLastChangeCount() == 0)
152 db.Close();
176 size_t CountSQLTables(sql::Connection* db) {
177 return CountSQLItemsOfType(db, "table");
180 size_t CountSQLIndices(sql::Connection* db) {
181 return CountSQLItemsOfType(db, "index");
184 size_t CountTableColumns(sql::Connection* db, const char* table) {
189 sql::Statement s(db->GetUniqueStatement(kQuoteSQL));
196 sql::Statement s(db->GetUniqueStatement(sql.c_str()));
205 bool CountTableRows(sql::Connection* db, const char* table, size_t* count) {
211 sql::Statement s(db->GetUniqueStatement(sql.c_str()));
228 sql::Connection db;
229 if (!db.Open(db_path))
236 ignore_result(db.Execute("PRAGMA auto_vacuum = 0"));
238 return db.Execute(sql.c_str());
241 std::string IntegrityCheck(sql::Connection* db) {
242 sql::Statement statement(db->GetUniqueStatement("PRAGMA integrity_check"));
