Lines Matching refs:query
106 SQLiteStatement query(sqliteDatabase, "SELECT value FROM MetaData WHERE name = 'version'");
107 if (query.prepare() != SQLResultOk || query.step() != SQLResultRow)
110 *databaseVersion = query.getColumnInt(0);
111 return query.finalize() == SQLResultOk;
225 SQLiteStatement query(m_db, sql);
226 if (query.prepare() != SQLResultOk) {
231 query.bindText(1, name);
232 query.bindText(2, version);
234 query.bindInt64(3, rowId);
236 if (query.step() != SQLResultDone)
247 SQLiteStatement query(m_db, "SELECT id, name, keyPath, doAutoIncrement FROM ObjectStores WHERE databaseId = ?");
248 bool ok = query.prepare() == SQLResultOk;
256 query.bindInt64(1, databaseId);
258 while (query.step() == SQLResultRow) {
259 foundIds.append(query.getColumnInt64(0));
260 foundNames.append(query.getColumnText(1));
261 foundKeyPaths.append(query.getColumnText(2));
262 foundAutoIncrementFlags.append(!!query.getColumnInt(3));
268 SQLiteStatement query(m_db, "INSERT INTO ObjectStores (name, keyPath, doAutoIncrement, databaseId) VALUES (?, ?, ?, ?)");
269 if (query.prepare() != SQLResultOk)
272 query.bindText(1, name);
273 query.bindText(2, keyPath);
274 query.bindInt(3, static_cast<int>(autoIncrement));
275 query.bindInt64(4, databaseId);
277 if (query.step() != SQLResultDone)
340 static int bindKeyToQuery(SQLiteStatement& query, int column, const IDBKey& key)
344 query.bindText(column, key.string());
347 query.bindDouble(column, key.date());
350 query.bindDouble(column, key.number());
398 SQLiteStatement query(m_db, "SELECT keyString, keyDate, keyNumber, value FROM ObjectStoreData WHERE objectStoreId = ? AND " + whereSyntaxForKey(key));
399 bool ok = query.prepare() == SQLResultOk;
402 query.bindInt64(1, objectStoreId);
403 bindKeyToQuery(query, 2, key);
404 if (query.step() != SQLResultRow)
407 ASSERT((key.type() == IDBKey::StringType) != query.isColumnNull(0));
408 ASSERT((key.type() == IDBKey::DateType) != query.isColumnNull(1));
409 ASSERT((key.type() == IDBKey::NumberType) != query.isColumnNull(2));
411 String record = query.getColumnBlobAsString(3);
412 ASSERT(query.step() != SQLResultRow);
417 static void bindKeyToQueryWithNulls(SQLiteStatement& query, int baseColumn, const IDBKey& key)
421 query.bindText(baseColumn + 0, key.string());
422 query.bindNull(baseColumn + 1);
423 query.bindNull(baseColumn + 2);
426 query.bindNull(baseColumn + 0);
427 query.bindDouble(baseColumn + 1, key.date());
428 query.bindNull(baseColumn + 2);
431 query.bindNull(baseColumn + 0);
432 query.bindNull(baseColumn + 1);
433 query.bindDouble(baseColumn + 2, key.number());
436 query.bindNull(baseColumn + 0);
437 query.bindNull(baseColumn + 1);
438 query.bindNull(baseColumn + 2);
451 SQLiteStatement query(m_db, sql);
452 if (query.prepare() != SQLResultOk)
455 bindKeyToQueryWithNulls(query, 1, key);
456 query.bindBlob(4, value);
458 query.bindInt64(5, sqliteRecordIdentifier->id());
460 query.bindInt64(5, objectStoreId);
462 if (query.step() != SQLResultDone)
494 SQLiteStatement query(m_db, "SELECT max(keyNumber) + 1 FROM ObjectStoreData WHERE objectStoreId = ? AND keyString IS NULL AND keyDate IS NULL");
495 bool ok = query.prepare() == SQLResultOk;
498 query.bindInt64(1, objectStoreId);
500 if (query.step() != SQLResultRow || query.isColumnNull(0))
503 return query.getColumnDouble(0);
511 SQLiteStatement query(m_db, sql);
512 bool ok = query.prepare() == SQLResultOk;
515 query.bindInt64(1, objectStoreId);
516 bindKeyToQuery(query, 2, key);
518 if (query.step() != SQLResultRow)
521 sqliteRecordIdentifier->setId(query.getColumnInt64(0));
527 SQLiteStatement query(m_db, "SELECT id, value FROM ObjectStoreData WHERE objectStoreId = ?");
528 if (query.prepare() != SQLResultOk)
531 query.bindInt64(1, objectStoreId);
533 while (query.step() == SQLResultRow) {
534 int64_t objectStoreDataId = query.getColumnInt64(0);
535 String value = query.getColumnBlobAsString(1);
546 SQLiteStatement query(m_db, "SELECT id, name, keyPath, isUnique FROM Indexes WHERE objectStoreId = ?");
547 bool ok = query.prepare() == SQLResultOk;
555 query.bindInt64(1, objectStoreId);
557 while (query.step() == SQLResultRow) {
558 foundIds.append(query.getColumnInt64(0));
559 foundNames.append(query.getColumnText(1));
560 foundKeyPaths.append(query.getColumnText(2));
561 foundUniqueFlags.append(!!query.getColumnInt(3));
567 SQLiteStatement query(m_db, "INSERT INTO Indexes (objectStoreId, name, keyPath, isUnique) VALUES (?, ?, ?, ?)");
568 if (query.prepare() != SQLResultOk)
571 query.bindInt64(1, objectStoreId);
572 query.bindText(2, name);
573 query.bindText(3, keyPath);
574 query.bindInt(4, static_cast<int>(isUnique));
576 if (query.step() != SQLResultDone)
593 SQLiteStatement query(m_db, "INSERT INTO IndexData (keyString, keyDate, keyNumber, indexId, objectStoreDataId) VALUES (?, ?, ?, ?, ?)");
594 if (query.prepare() != SQLResultOk)
597 bindKeyToQueryWithNulls(query, 1, key);
598 query.bindInt64(4, indexId);
599 query.bindInt64(5, sqliteRecordIdentifier->id());
601 return query.step() == SQLResultDone;
608 SQLiteStatement query(m_db, "DELETE FROM IndexData WHERE objectStoreDataId = ? AND indexId = ?");
609 if (query.prepare() != SQLResultOk)
612 query.bindInt64(1, sqliteRecordIdentifier->id());
613 query.bindInt64(2, indexId);
614 return query.step() == SQLResultDone;
624 SQLiteStatement query(m_db, sql);
625 bool ok = query.prepare() == SQLResultOk;
628 query.bindInt64(1, indexId);
629 bindKeyToQuery(query, 2, key);
631 if (query.step() != SQLResultRow)
634 String foundValue = query.getColumnBlobAsString(0);
635 ASSERT(query.step() != SQLResultRow);
639 static PassRefPtr<IDBKey> keyFromQuery(SQLiteStatement& query, int baseColumn)
641 if (query.columnCount() <= baseColumn)
644 if (!query.isColumnNull(baseColumn))
645 return IDBKey::createString(query.getColumnText(baseColumn));
647 if (!query.isColumnNull(baseColumn + 1))
648 return IDBKey::createDate(query.getColumnDouble(baseColumn + 1));
650 if (!query.isColumnNull(baseColumn + 2))
651 return IDBKey::createNumber(query.getColumnDouble(baseColumn + 2));
663 SQLiteStatement query(m_db, sql);
664 bool ok = query.prepare() == SQLResultOk;
667 query.bindInt64(1, indexId);
668 bindKeyToQuery(query, 2, key);
670 if (query.step() != SQLResultRow)
673 RefPtr<IDBKey> foundKey = keyFromQuery(query, 0);
674 ASSERT(query.step() != SQLResultRow);
681 SQLiteStatement query(m_db, sql);
682 bool ok = query.prepare() == SQLResultOk;
685 query.bindInt64(1, indexId);
686 bindKeyToQuery(query, 2, key);
688 return query.step() == SQLResultRow;
695 CursorImplCommon(SQLiteDatabase& sqliteDatabase, String query, bool uniquenessConstraint, bool iterateForward)
696 : m_query(sqliteDatabase, query)
761 ObjectStoreCursorImpl(SQLiteDatabase& sqliteDatabase, String query, bool uniquenessConstraint, bool iterateForward)
762 : CursorImplCommon(sqliteDatabase, query, uniquenessConstraint, iterateForward)
798 IndexKeyCursorImpl(SQLiteDatabase& sqliteDatabase, String query, bool uniquenessConstraint, bool iterateForward)
799 : CursorImplCommon(sqliteDatabase, query, uniquenessConstraint, iterateForward)
836 IndexCursorImpl(SQLiteDatabase& sqliteDatabase, String query, bool uniquenessConstraint, bool iterateForward)
837 : CursorImplCommon(sqliteDatabase, query, uniquenessConstraint, iterateForward)