Lines Matching refs:sql
12 #include "app/sql/statement.h"
74 void URLDatabase::FillURLRow(sql::Statement& s, history::URLRow* i) {
90 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
104 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
118 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
135 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
172 sql::Statement statement(GetDB().GetCachedStatement(
173 sql::StatementID(statement_name), statement_sql));
195 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
208 sql::Statement del_keyword_visit(GetDB().GetCachedStatement(SQL_FROM_HERE,
249 std::string sql("SELECT ");
250 sql.append(kURLRowFields);
251 sql.append(" FROM urls");
252 enumerator->statement_.Assign(GetDB().GetUniqueStatement(sql.c_str()));
263 std::string sql("SELECT ");
264 sql.append(kURLRowFields);
265 sql.append(" FROM urls WHERE last_visit_time >= ? OR visit_count > ? OR "
267 enumerator->statement_.Assign(GetDB().GetUniqueStatement(sql.c_str()));
301 const char* sql;
304 sql = "SELECT" HISTORY_URL_ROW_FIELDS "FROM urls "
310 sql = "SELECT" HISTORY_URL_ROW_FIELDS "FROM urls "
316 sql::Statement statement(
317 GetDB().GetCachedStatement(sql::StatementID(__FILE__, line), sql));
352 std::string sql("SELECT ");
353 sql.append(kURLRowFields);
354 sql.append(" FROM urls WHERE url ");
355 sql.append(allow_base ? ">=" : ">");
356 sql.append(" ? AND url < :end AND url = substr(:end, 1, length(url)) "
359 sql::Statement statement(GetDB().GetUniqueStatement(sql.c_str()));
411 sql::Statement exist_statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
421 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
437 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
457 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
478 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
537 std::string sql;
538 sql.append("CREATE TABLE ");
539 sql.append(name);
540 sql.append("("
550 return GetDB().Execute(sql.c_str());