Lines Matching refs:statement
10 #include "app/sql/statement.h"
30 static void FillIconMapping(const sql::Statement& statement,
33 icon_mapping->mapping_id = statement.ColumnInt64(0);
34 icon_mapping->icon_id = statement.ColumnInt64(1);
36 static_cast<history::IconType>(statement.ColumnInt(2));
256 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
260 if (!statement)
276 statement.BindInt64(0, id);
277 statement.BindDouble(1, score.boring_score);
278 statement.BindBool(2, score.good_clipping);
279 statement.BindBool(3, score.at_top);
280 statement.BindInt64(4, score.time_at_snapshot.ToTimeT());
281 statement.BindBlob(5, &jpeg_data[0],
283 if (!statement.Run())
305 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
307 if (!statement)
310 statement.BindInt64(0, id);
311 if (!statement.Step())
314 statement.ColumnBlobAsVector(0, data);
323 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
325 if (!statement)
328 statement.BindInt64(0, id);
329 return statement.Run();
345 NOTREACHED() << "Couldn't build select statement!";
368 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
370 if (!statement)
373 statement.BindBlob(0, icon_data->front(),
375 statement.BindInt64(1, time.ToTimeT());
376 statement.BindInt64(2, icon_id);
377 return statement.Run();
379 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
381 if (!statement)
384 statement.BindInt64(0, time.ToTimeT());
385 statement.BindInt64(1, icon_id);
386 return statement.Run();
392 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
394 if (!statement)
397 statement.BindInt64(0, time.ToTimeT());
398 statement.BindInt64(1, icon_id);
399 return statement.Run();
405 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
408 if (!statement)
411 statement.BindString(0, URLDatabase::GURLToDatabaseURL(icon_url));
412 statement.BindInt(1, required_icon_type);
413 if (!statement.Step())
417 *icon_type = static_cast<IconType>(statement.ColumnInt(1));
418 return statement.ColumnInt64(0);
428 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
430 if (!statement)
433 statement.BindInt64(0, icon_id);
435 if (!statement.Step())
438 *last_updated = base::Time::FromTimeT(statement.ColumnInt64(0));
439 if (statement.ColumnByteLength(1) > 0)
440 statement.ColumnBlobAsVector(1, png_icon_data);
442 *icon_url = GURL(statement.ColumnString(2));
450 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
452 if (!statement)
455 statement.BindString(0, URLDatabase::GURLToDatabaseURL(icon_url));
456 statement.BindInt(1, icon_type);
457 if (!statement.Run())
463 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
465 if (!statement)
468 statement.BindInt64(0, id);
469 return statement.Run();
494 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
501 if (!statement)
504 statement.BindString(0, URLDatabase::GURLToDatabaseURL(page_url));
507 while (statement.Step()) {
513 FillIconMapping(statement, page_url, &icon_mapping);
526 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
528 if (!statement)
531 statement.BindInt64(0, icon_id);
532 statement.BindInt64(1, mapping_id);
533 return statement.Run();
537 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
539 if (!statement)
542 statement.BindString(0, URLDatabase::GURLToDatabaseURL(page_url));
543 return statement.Run();
547 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
550 if (!statement)
553 statement.BindInt64(0, id);
554 return statement.Step();
592 sql::Statement statement(db_.GetCachedStatement(SQL_FROM_HERE,
596 if (!statement)
598 statement.BindInt64(0, source);
599 if (!statement.Run())
645 // This block is needed because otherwise the attach statement is
735 sql::Statement statement(
737 if (!statement)
740 statement.BindString(0, URLDatabase::GURLToDatabaseURL(page_url));
741 statement.BindInt64(1, icon_id);
743 if (!statement.Run())