1926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)/* 2926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * Copyright (C) 2007, 2013 Apple Inc. All rights reserved. 3926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * 4926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * Redistribution and use in source and binary forms, with or without 5926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * modification, are permitted provided that the following conditions 6926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * are met: 7926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * 8926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * 1. Redistributions of source code must retain the above copyright 9926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * notice, this list of conditions and the following disclaimer. 10926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * 2. Redistributions in binary form must reproduce the above copyright 11926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * notice, this list of conditions and the following disclaimer in the 12926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * documentation and/or other materials provided with the distribution. 13926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * 3. Neither the name of Apple Computer, Inc. ("Apple") nor the names of 14926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * its contributors may be used to endorse or promote products derived 15926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * from this software without specific prior written permission. 16926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * 17926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * THIS SOFTWARE IS PROVIDED BY APPLE AND ITS CONTRIBUTORS "AS IS" AND ANY 18926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED 19926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE 20926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * DISCLAIMED. IN NO EVENT SHALL APPLE OR ITS CONTRIBUTORS BE LIABLE FOR ANY 21926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES 22926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; 23926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 24926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 25926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF 26926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) * THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 27926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) */ 28926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)#include "config.h" 2953e740f4a82e17f3ae59772501622dc354e42336Torne (Richard Coles)#include "modules/webdatabase/SQLStatementBackend.h" 30926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 317242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano Tucci#include "modules/webdatabase/Database.h" 327242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano Tucci#include "modules/webdatabase/SQLError.h" 337242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano Tucci#include "modules/webdatabase/SQLStatement.h" 341e202183a5dc46166763171984b285173f8585e5Torne (Richard Coles)#include "modules/webdatabase/sqlite/SQLiteDatabase.h" 351e202183a5dc46166763171984b285173f8585e5Torne (Richard Coles)#include "modules/webdatabase/sqlite/SQLiteStatement.h" 367242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano Tucci#include "platform/Logging.h" 3753e740f4a82e17f3ae59772501622dc354e42336Torne (Richard Coles)#include "wtf/text/CString.h" 38926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 39926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 4002772c6a72f1ee0b226341a4f4439970c29fc861Ben Murdoch// The Life-Cycle of a SQLStatement i.e. Who's keeping the SQLStatement alive? 41926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// ========================================================================== 42926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// The RefPtr chain goes something like this: 43926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// 44926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// At birth (in SQLTransactionBackend::executeSQL()): 45926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// ================================================= 46926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// SQLTransactionBackend // Deque<RefPtr<SQLStatementBackend> > m_statementQueue points to ... 47926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// --> SQLStatementBackend // OwnPtr<SQLStatement> m_frontend points to ... 48926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// --> SQLStatement 49926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// 50926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// After grabbing the statement for execution (in SQLTransactionBackend::getNextStatement()): 51926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// ========================================================================================= 52926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// SQLTransactionBackend // RefPtr<SQLStatementBackend> m_currentStatementBackend points to ... 53926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// --> SQLStatementBackend // OwnPtr<SQLStatement> m_frontend points to ... 54926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// --> SQLStatement 55926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// 56926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// Then we execute the statement in SQLTransactionBackend::runCurrentStatementAndGetNextState(). 57926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// And we callback to the script in SQLTransaction::deliverStatementCallback() if 58926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// necessary. 59926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// - Inside SQLTransaction::deliverStatementCallback(), we operate on a raw SQLStatement*. 60926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// This pointer is valid because it is owned by SQLTransactionBackend's 61926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// SQLTransactionBackend::m_currentStatementBackend. 62926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// 63926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// After we're done executing the statement (in SQLTransactionBackend::getNextStatement()): 64926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// ======================================================================================= 65926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// When we're done executing, we'll grab the next statement. But before we 66926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// do that, getNextStatement() nullify SQLTransactionBackend::m_currentStatementBackend. 67926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// This will trigger the deletion of the SQLStatementBackend and SQLStatement. 68926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// 69926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// Note: unlike with SQLTransaction, there is no JS representation of SQLStatement. 70926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)// Hence, there is no GC dependency at play here. 71926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 72c1847b1379d12d0e05df27436bf19a9b1bf12deaTorne (Richard Coles)namespace blink { 73926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 747242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano TucciPassRefPtrWillBeRawPtr<SQLStatementBackend> SQLStatementBackend::create(PassOwnPtrWillBeRawPtr<SQLStatement> frontend, 75926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) const String& statement, const Vector<SQLValue>& arguments, int permissions) 76926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 7743e7502580f146aa5b3db8267ba6dbb5c733a489Torne (Richard Coles) return adoptRefWillBeNoop(new SQLStatementBackend(frontend, statement, arguments, permissions)); 78926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 79926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 807242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano TucciSQLStatementBackend::SQLStatementBackend(PassOwnPtrWillBeRawPtr<SQLStatement> frontend, 81926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) const String& statement, const Vector<SQLValue>& arguments, int permissions) 82926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) : m_frontend(frontend) 83926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) , m_statement(statement.isolatedCopy()) 84926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) , m_arguments(arguments) 85926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) , m_hasCallback(m_frontend->hasCallback()) 86926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) , m_hasErrorCallback(m_frontend->hasErrorCallback()) 8707a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch , m_resultSet(SQLResultSet::create()) 88926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) , m_permissions(permissions) 89926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 90926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) m_frontend->setBackend(this); 91926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 92926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 9307a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdochvoid SQLStatementBackend::trace(Visitor* visitor) 9443e7502580f146aa5b3db8267ba6dbb5c733a489Torne (Richard Coles){ 95f6b7aed3f7ce69aca0d7a032d144cbd088b04393Torne (Richard Coles) visitor->trace(m_frontend); 9607a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch visitor->trace(m_resultSet); 9743e7502580f146aa5b3db8267ba6dbb5c733a489Torne (Richard Coles)} 9843e7502580f146aa5b3db8267ba6dbb5c733a489Torne (Richard Coles) 997242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano TucciSQLStatement* SQLStatementBackend::frontend() 100926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 101926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return m_frontend.get(); 102926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 103926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 10407a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben MurdochSQLErrorData* SQLStatementBackend::sqlError() const 105926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 10607a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch return m_error.get(); 107926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 108926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 10907a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben MurdochSQLResultSet* SQLStatementBackend::sqlResultSet() const 110926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 11107a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch return m_resultSet->isValid() ? m_resultSet.get() : 0; 112926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 113926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 1147242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano Tuccibool SQLStatementBackend::execute(Database* db) 115926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 11607a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch ASSERT(!m_resultSet->isValid()); 117926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 118926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // If we're re-running this statement after a quota violation, we need to clear that error now 119926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) clearFailureDueToQuota(); 120926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 121926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // This transaction might have been marked bad while it was being set up on the main thread, 122926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // so if there is still an error, return false. 123926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (m_error) 124926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return false; 125926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 126926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) db->setAuthorizerPermissions(m_permissions); 127926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 128926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) SQLiteDatabase* database = &db->sqliteDatabase(); 129926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 130926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) SQLiteStatement statement(*database, m_statement); 131926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) int result = statement.prepare(); 132926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 133926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (result != SQLResultOk) { 134a854de003a23bf3c7f95ec0f8154ada64092ff5cTorne (Richard Coles) WTF_LOG(StorageAPI, "Unable to verify correctness of statement %s - error %i (%s)", m_statement.ascii().data(), result, database->lastErrorMsg()); 135926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (result == SQLResultInterrupt) 13607a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_error = SQLErrorData::create(SQLError::DATABASE_ERR, "could not prepare statement", result, "interrupted"); 137926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) else 13807a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_error = SQLErrorData::create(SQLError::SYNTAX_ERR, "could not prepare statement", result, database->lastErrorMsg()); 139926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) db->reportExecuteStatementResult(1, m_error->code(), result); 140926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return false; 141926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } 142926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 143926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // FIXME: If the statement uses the ?### syntax supported by sqlite, the bind parameter count is very likely off from the number of question marks. 144926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // If this is the case, they might be trying to do something fishy or malicious 145926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (statement.bindParameterCount() != m_arguments.size()) { 146a854de003a23bf3c7f95ec0f8154ada64092ff5cTorne (Richard Coles) WTF_LOG(StorageAPI, "Bind parameter count doesn't match number of question marks"); 1477242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano Tucci m_error = SQLErrorData::create(SQLError::SYNTAX_ERR, "number of '?'s in statement string does not match argument count"); 148926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) db->reportExecuteStatementResult(2, m_error->code(), 0); 149926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return false; 150926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } 151926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 152926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) for (unsigned i = 0; i < m_arguments.size(); ++i) { 153926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) result = statement.bindValue(i + 1, m_arguments[i]); 154926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (result == SQLResultFull) { 155926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) setFailureDueToQuota(db); 156926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return false; 157926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } 158926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 159926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (result != SQLResultOk) { 160a854de003a23bf3c7f95ec0f8154ada64092ff5cTorne (Richard Coles) WTF_LOG(StorageAPI, "Failed to bind value index %i to statement for query '%s'", i + 1, m_statement.ascii().data()); 161926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) db->reportExecuteStatementResult(3, SQLError::DATABASE_ERR, result); 16207a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_error = SQLErrorData::create(SQLError::DATABASE_ERR, "could not bind value", result, database->lastErrorMsg()); 163926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return false; 164926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } 165926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } 166926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 167926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // Step so we can fetch the column names. 168926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) result = statement.step(); 169926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (result == SQLResultRow) { 170926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) int columnCount = statement.columnCount(); 17107a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch SQLResultSetRowList* rows = m_resultSet->rows(); 172926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 173926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) for (int i = 0; i < columnCount; i++) 174926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) rows->addColumn(statement.getColumnName(i)); 175926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 176926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) do { 177926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) for (int i = 0; i < columnCount; i++) 178926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) rows->addResult(statement.getColumnValue(i)); 179926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 180926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) result = statement.step(); 181926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } while (result == SQLResultRow); 182926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 183926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (result != SQLResultDone) { 184926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) db->reportExecuteStatementResult(4, SQLError::DATABASE_ERR, result); 18507a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_error = SQLErrorData::create(SQLError::DATABASE_ERR, "could not iterate results", result, database->lastErrorMsg()); 186926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return false; 187926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } 188926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } else if (result == SQLResultDone) { 189926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // Didn't find anything, or was an insert 190926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (db->lastActionWasInsert()) 19107a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_resultSet->setInsertId(database->lastInsertRowID()); 192926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } else if (result == SQLResultFull) { 193926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // Return the Quota error - the delegate will be asked for more space and this statement might be re-run 194926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) setFailureDueToQuota(db); 195926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return false; 196926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } else if (result == SQLResultConstraint) { 197926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) db->reportExecuteStatementResult(6, SQLError::CONSTRAINT_ERR, result); 19807a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_error = SQLErrorData::create(SQLError::CONSTRAINT_ERR, "could not execute statement due to a constaint failure", result, database->lastErrorMsg()); 199926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return false; 200926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } else { 201926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) db->reportExecuteStatementResult(5, SQLError::DATABASE_ERR, result); 20207a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_error = SQLErrorData::create(SQLError::DATABASE_ERR, "could not execute statement", result, database->lastErrorMsg()); 203926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return false; 204926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) } 205926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 206926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // FIXME: If the spec allows triggers, and we want to be "accurate" in a different way, we'd use 207926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // sqlite3_total_changes() here instead of sqlite3_changed, because that includes rows modified from within a trigger 208926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) // For now, this seems sufficient 20907a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_resultSet->setRowsAffected(database->lastChanges()); 210926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 211926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) db->reportExecuteStatementResult(0, -1, 0); // OK 212926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return true; 213926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 214926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 2157242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano Tuccivoid SQLStatementBackend::setVersionMismatchedError(Database* database) 216926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 21707a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch ASSERT(!m_error && !m_resultSet->isValid()); 218926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) database->reportExecuteStatementResult(7, SQLError::VERSION_ERR, 0); 21907a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_error = SQLErrorData::create(SQLError::VERSION_ERR, "current version of the database and `oldVersion` argument do not match"); 220926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 221926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 2227242dc3dbeb210b5e876a3c42d1ec1a667fc621aPrimiano Tuccivoid SQLStatementBackend::setFailureDueToQuota(Database* database) 223926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 22407a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch ASSERT(!m_error && !m_resultSet->isValid()); 225926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) database->reportExecuteStatementResult(8, SQLError::QUOTA_ERR, 0); 22607a852d8c1953036774d8f3b65d18dcfea3bb4a2Ben Murdoch m_error = SQLErrorData::create(SQLError::QUOTA_ERR, "there was not enough remaining storage space, or the storage quota was reached and the user declined to allow more space"); 227926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 228926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 229926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)void SQLStatementBackend::clearFailureDueToQuota() 230926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 231926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) if (lastExecutionFailedDueToQuota()) 232d5428f32f5d1719f774f62e19147104ca245a3abTorne (Richard Coles) m_error = nullptr; 233926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 234926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 235926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)bool SQLStatementBackend::lastExecutionFailedDueToQuota() const 236926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles){ 237926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) return m_error && m_error->code() == SQLError::QUOTA_ERR; 238926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles)} 239926b001d589ce2f10facb93dd4b87578ea35a855Torne (Richard Coles) 240c1847b1379d12d0e05df27436bf19a9b1bf12deaTorne (Richard Coles)} // namespace blink 241