Lines Matching refs:statement
16 #include "sql/statement.h"
63 void URLDatabase::FillURLRow(sql::Statement& s, history::URLRow* i) {
79 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
81 statement.BindInt64(0, url_id);
83 if (statement.Step()) {
84 FillURLRow(statement, info);
91 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
94 while (statement.Step()) {
96 FillURLRow(statement, &info);
103 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
106 statement.BindString(0, url_string);
108 if (!statement.Step())
112 FillURLRow(statement, info);
113 return statement.ColumnInt64(0);
118 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
122 statement.BindString16(0, info.title());
123 statement.BindInt(1, info.visit_count());
124 statement.BindInt(2, info.typed_count());
125 statement.BindInt64(3, info.last_visit().ToInternalValue());
126 statement.BindInt(4, info.hidden() ? 1 : 0);
127 statement.BindInt64(5, url_id);
129 return statement.Run() && GetDB().GetLastChangeCount() > 0;
153 sql::Statement statement(GetDB().GetCachedStatement(
155 statement.BindString(0, GURLToDatabaseURL(info.url()));
156 statement.BindString16(1, info.title());
157 statement.BindInt(2, info.visit_count());
158 statement.BindInt(3, info.typed_count());
159 statement.BindInt64(4, info.last_visit().ToInternalValue());
160 statement.BindInt(5, info.hidden() ? 1 : 0);
162 if (!statement.Run()) {
183 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
188 statement.BindInt64(0, info.id());
189 statement.BindString(1, GURLToDatabaseURL(info.url()));
190 statement.BindString16(2, info.title());
191 statement.BindInt(3, info.visit_count());
192 statement.BindInt(4, info.typed_count());
193 statement.BindInt64(5, info.last_visit().ToInternalValue());
194 statement.BindInt(6, info.hidden() ? 1 : 0);
196 return statement.Run();
200 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
202 statement.BindInt64(0, id);
204 if (!statement.Run())
285 sql::Statement statement(
295 statement.BindString(0, prefix);
296 statement.BindString(1, end_query);
297 statement.BindInt(2, static_cast<int>(max_results));
299 while (statement.Step()) {
301 FillURLRow(statement, &info);
343 sql::Statement statement(GetDB().GetUniqueStatement(sql.c_str()));
344 statement.BindString(0, base);
345 statement.BindString(1, url); // :end
346 statement.BindInt(2, min_visits);
347 statement.BindInt(3, min_typed);
349 if (!statement.Step())
353 FillURLRow(statement, info);
363 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
366 while (statement.Step()) {
368 base::string16 url = base::i18n::ToLower(statement.ColumnString16(1));
380 base::string16 title = base::i18n::ToLower(statement.ColumnString16(2));
385 FillURLRow(statement, &info);
440 sql::Statement exist_statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
452 sql::Statement statement
455 statement.BindInt64(0, keyword_id);
456 statement.BindInt64(1, url_id);
457 statement.BindString16(2, base::i18n::ToLower(term));
458 statement.BindString16(3, term);
459 return statement.Run();
465 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
467 statement.BindInt64(0, url_id);
469 if (!statement.Step())
474 row->keyword_id = statement.ColumnInt64(0);
475 row->term = statement.ColumnString16(1);
483 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
485 statement.BindString16(0, term);
487 if (!statement.is_valid())
490 while (statement.Step()) {
492 row.url_id = statement.ColumnInt64(1);
493 row.keyword_id = statement.ColumnInt64(0);
503 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
505 statement.BindInt64(0, keyword_id);
507 statement.Run();
522 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
535 statement.BindInt64(0, keyword_id);
536 statement.BindString16(1, lower_prefix);
537 statement.BindString16(2, next_prefix);
538 statement.BindInt(3, max_count);
541 while (statement.Step()) {
542 visit.term = statement.ColumnString16(0);
543 visit.visits = statement.ColumnInt(1);
544 visit.time = base::Time::FromInternalValue(statement.ColumnInt64(2));
550 sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
552 statement.BindString16(0, term);
554 return statement.Run();
558 sql::Statement statement(GetDB().GetCachedStatement(
560 statement.BindInt64(0, url_id);
561 return statement.Run();
