Lines Matching full:select
143 "SELECT id FROM segments WHERE name = ?"));
167 "SELECT url_id FROM segments WHERE id = ?"));
196 sql::Statement select(GetDB().GetCachedStatement(SQL_FROM_HERE,
197 "SELECT id, visit_count FROM segment_usage "
199 if (!select)
202 select.BindInt64(0, t.ToInternalValue());
203 select.BindInt64(1, segment_id);
204 if (select.Step()) {
210 update.BindInt64(0, select.ColumnInt64(1) + static_cast<int64>(amount));
211 update.BindInt64(1, select.ColumnInt64(0));
242 "SELECT segment_id, time_slot, visit_count "
301 "SELECT urls.url, urls.title FROM urls "
346 sql::Statement select(GetDB().GetCachedStatement(SQL_FROM_HERE,
347 "SELECT id FROM segments WHERE url_id = ?"));
348 if (!select)
362 select.BindInt64(0, url_id);
365 while (select.Step()) {
366 SegmentID segment_id = select.ColumnInt64(0);
