Lines Matching refs:statement
88 sql::Statement statement(db_->GetCachedStatement(
94 if (!statement) {
102 while (statement.Step()) {
105 GURL gurl(statement.ColumnString(0));
107 url.title = statement.ColumnString16(2);
108 std::string redirects = statement.ColumnString(4);
113 statement.ColumnBlobAsVector(3, &data);
116 thumbnail.thumbnail_score.boring_score = statement.ColumnDouble(5);
117 thumbnail.thumbnail_score.good_clipping = statement.ColumnBool(6);
118 thumbnail.thumbnail_score.at_top = statement.ColumnBool(7);
120 base::Time::FromInternalValue(statement.ColumnInt64(8));
162 sql::Statement statement(db_->GetCachedStatement(
168 if (!statement)
171 statement.BindString16(0, url.title);
173 statement.BindBlob(1, thumbnail.thumbnail->front(),
176 statement.BindString(2, GetRedirects(url));
178 statement.BindDouble(3, score.boring_score);
179 statement.BindBool(4, score.good_clipping);
180 statement.BindBool(5, score.at_top);
181 statement.BindInt64(6, score.time_at_snapshot.ToInternalValue());
182 statement.BindString(7, url.url.spec());
183 if (!statement.Run())
192 sql::Statement statement(db_->GetCachedStatement(
198 if (!statement)
201 statement.BindString(0, url.url.spec());
202 statement.BindInt(1, count); // Make it the last url.
203 statement.BindString16(2, url.title);
205 statement.BindBlob(3, thumbnail.thumbnail->front(),
208 statement.BindString(4, GetRedirects(url));
210 statement.BindDouble(5, score.boring_score);
211 statement.BindBool(6, score.good_clipping);
212 statement.BindBool(7, score.at_top);
213 statement.BindInt64(8, score.time_at_snapshot.ToInternalValue());
214 if (!statement.Run())
240 sql::Statement shift_statement(db_->GetCachedStatement(
251 sql::Statement shift_statement(db_->GetCachedStatement(
263 sql::Statement set_statement(db_->GetCachedStatement(
276 sql::Statement statement(db_->GetCachedStatement(
281 if (!statement) {
286 statement.BindString(0, url.spec());
287 if (!statement.Step())
291 statement.ColumnBlobAsVector(0, &data);
293 thumbnail->thumbnail_score.boring_score = statement.ColumnDouble(1);
294 thumbnail->thumbnail_score.good_clipping = statement.ColumnBool(2);
295 thumbnail->thumbnail_score.at_top = statement.ColumnBool(3);
297 base::Time::FromInternalValue(statement.ColumnInt64(4));
303 sql::Statement select_statement(db_->GetCachedStatement(
319 sql::Statement select_statement(db_->GetCachedStatement(
344 sql::Statement shift_statement(db_->GetCachedStatement(
354 sql::Statement delete_statement(