Lines Matching refs:statement
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,
92 if (!statement)
95 statement.BindInt64(0, url_id);
96 if (statement.Step()) {
97 FillURLRow(statement, info);
104 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
106 if (!statement)
109 while (statement.Step()) {
111 FillURLRow(statement, &info);
118 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
120 if (!statement)
124 statement.BindString(0, url_string);
125 if (!statement.Step())
129 FillURLRow(statement, info);
130 return statement.ColumnInt64(0);
135 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
139 if (!statement)
142 statement.BindString16(0, info.title());
143 statement.BindInt(1, info.visit_count());
144 statement.BindInt(2, info.typed_count());
145 statement.BindInt64(3, info.last_visit().ToInternalValue());
146 statement.BindInt(4, info.hidden() ? 1 : 0);
147 statement.BindInt64(5, url_id);
148 return statement.Run();
172 sql::Statement statement(GetDB().GetCachedStatement(
174 if (!statement) {
179 statement.BindString(0, GURLToDatabaseURL(info.url()));
180 statement.BindString16(1, info.title());
181 statement.BindInt(2, info.visit_count());
182 statement.BindInt(3, info.typed_count());
183 statement.BindInt64(4, info.last_visit().ToInternalValue());
184 statement.BindInt(5, info.hidden() ? 1 : 0);
186 if (!statement.Run()) {
195 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
197 if (!statement)
200 statement.BindInt64(0, id);
201 if (!statement.Run())
208 sql::Statement del_keyword_visit(GetDB().GetCachedStatement(SQL_FROM_HERE,
316 sql::Statement statement(
318 if (!statement)
329 statement.BindString(0, prefix_utf8);
330 statement.BindString(1, end_query);
331 statement.BindInt(2, static_cast<int>(max_results));
333 while (statement.Step()) {
335 FillURLRow(statement, &info);
359 sql::Statement statement(GetDB().GetUniqueStatement(sql.c_str()));
360 if (!statement) {
365 statement.BindString(0, base);
366 statement.BindString(1, url); // :end
367 statement.BindInt(2, min_visits);
368 statement.BindInt(3, min_typed);
370 if (!statement.Step())
374 FillURLRow(statement, info);
411 sql::Statement exist_statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
421 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
424 if (!statement)
427 statement.BindInt64(0, keyword_id);
428 statement.BindInt64(1, url_id);
429 statement.BindString16(2, l10n_util::ToLower(term));
430 statement.BindString16(3, term);
431 return statement.Run();
437 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
439 if (!statement)
442 statement.BindInt64(0, url_id);
443 if (!statement.Step())
448 row->keyword_id = statement.ColumnInt64(0);
449 row->term = statement.ColumnString16(1);
457 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
459 if (!statement)
462 statement.BindInt64(0, keyword_id);
463 statement.Run();
478 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
484 if (!statement)
493 statement.BindInt64(0, keyword_id);
494 statement.BindString16(1, lower_prefix);
495 statement.BindString16(2, next_prefix);
496 statement.BindInt(3, max_count);
499 while (statement.Step()) {
500 visit.term = statement.ColumnString16(0);
501 visit.time = base::Time::FromInternalValue(statement.ColumnInt64(1));
