third_party/WebKit/Source/modules/webdatabase/sqlite/SQLiteStatement.cpp

/*
 * Copyright (C) 2006, 2007, 2008 Apple Inc. All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions
 * are met:
 * 1. Redistributions of source code must retain the above copyright
 *    notice, this list of conditions and the following disclaimer.
 * 2. Redistributions in binary form must reproduce the above copyright
 *    notice, this list of conditions and the following disclaimer in the
 *    documentation and/or other materials provided with the distribution.
 *
 * THIS SOFTWARE IS PROVIDED BY APPLE COMPUTER, INC. ``AS IS'' AND ANY
 * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
 * PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL APPLE COMPUTER, INC. OR
 * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
 * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
 * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
 * OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */

#include "modules/webdatabase/sqlite/SQLiteStatement.h"

#include "modules/webdatabase/sqlite/SQLLog.h"
#include "modules/webdatabase/sqlite/SQLValue.h"
#include "platform/heap/SafePoint.h"
#include "third_party/sqlite/sqlite3.h"
#include "wtf/Assertions.h"
#include "wtf/PtrUtil.h"
#include "wtf/text/CString.h"
#include <memory>

// SQLite 3.6.16 makes sqlite3_prepare_v2 automatically retry preparing the
// statement once if the database scheme has changed. We rely on this behavior.
#if SQLITE_VERSION_NUMBER < 3006016
#error SQLite version 3.6.16 or newer is required
#endif

namespace {

// Only return error codes consistent with 3.7.6.3.
int restrictError(int error) {
  switch (error) {
    case SQLITE_IOERR_READ:
    case SQLITE_IOERR_SHORT_READ:
    case SQLITE_IOERR_WRITE:
    case SQLITE_IOERR_FSYNC:
    case SQLITE_IOERR_DIR_FSYNC:
    case SQLITE_IOERR_TRUNCATE:
    case SQLITE_IOERR_FSTAT:
    case SQLITE_IOERR_UNLOCK:
    case SQLITE_IOERR_RDLOCK:
    case SQLITE_IOERR_DELETE:
    case SQLITE_IOERR_BLOCKED:
    case SQLITE_IOERR_NOMEM:
    case SQLITE_IOERR_ACCESS:
    case SQLITE_IOERR_CHECKRESERVEDLOCK:
    case SQLITE_IOERR_LOCK:
    case SQLITE_IOERR_CLOSE:
    case SQLITE_IOERR_DIR_CLOSE:
    case SQLITE_IOERR_SHMOPEN:
    case SQLITE_IOERR_SHMSIZE:
    case SQLITE_IOERR_SHMLOCK:
    case SQLITE_LOCKED_SHAREDCACHE:
    case SQLITE_BUSY_RECOVERY:
    case SQLITE_CANTOPEN_NOTEMPDIR:
      return error;
    default:
      return (error & 0xff);
  }
}

}  // namespace

namespace blink {

SQLiteStatement::SQLiteStatement(SQLiteDatabase& db, const String& sql)
    : m_database(db),
      m_query(sql),
      m_statement(0)
#if ENABLE(ASSERT)
      ,
      m_isPrepared(false)
#endif
{
}

SQLiteStatement::~SQLiteStatement() {
  finalize();
}

int SQLiteStatement::prepare() {
  ASSERT(!m_isPrepared);

  CString query = m_query.stripWhiteSpace().utf8();

  // Need to pass non-stack |const char*| and |sqlite3_stmt*| to avoid race
  // with Oilpan stack scanning.
  std::unique_ptr<const char*> tail = wrapUnique(new const char*);
  std::unique_ptr<sqlite3_stmt*> statement = wrapUnique(new sqlite3_stmt*);
  *tail = nullptr;
  *statement = nullptr;
  int error;
  {
    SafePointScope scope(BlinkGC::HeapPointersOnStack);

    SQL_DVLOG(1) << "SQL - prepare - " << query.data();

    // Pass the length of the string including the null character to
    // sqlite3_prepare_v2; this lets SQLite avoid an extra string copy.
    size_t lengthIncludingNullCharacter = query.length() + 1;

    error = sqlite3_prepare_v2(m_database.sqlite3Handle(), query.data(),
                               lengthIncludingNullCharacter, statement.get(),
                               tail.get());
  }
  m_statement = *statement;

  if (error != SQLITE_OK)
    SQL_DVLOG(1) << "sqlite3_prepare16 failed (" << error << ")\n"
                 << query.data() << "\n"
                 << sqlite3_errmsg(m_database.sqlite3Handle());
  else if (*tail && **tail)
    error = SQLITE_ERROR;

#if ENABLE(ASSERT)
  m_isPrepared = error == SQLITE_OK;
#endif
  return restrictError(error);
}

int SQLiteStatement::step() {
  SafePointScope scope(BlinkGC::HeapPointersOnStack);
  // ASSERT(m_isPrepared);

  if (!m_statement)
    return SQLITE_OK;

  // The database needs to update its last changes count before each statement
  // in order to compute properly the lastChanges() return value.
  m_database.updateLastChangesCount();

  SQL_DVLOG(1) << "SQL - step - " << m_query;
  int error = sqlite3_step(m_statement);
  if (error != SQLITE_DONE && error != SQLITE_ROW) {
    SQL_DVLOG(1) << "sqlite3_step failed (" << error << " )\nQuery - "
                 << m_query << "\nError - "
                 << sqlite3_errmsg(m_database.sqlite3Handle());
  }

  return restrictError(error);
}

int SQLiteStatement::finalize() {
#if ENABLE(ASSERT)
  m_isPrepared = false;
#endif
  if (!m_statement)
    return SQLITE_OK;
  SQL_DVLOG(1) << "SQL - finalize - " << m_query;
  int result = sqlite3_finalize(m_statement);
  m_statement = 0;
  return restrictError(result);
}

bool SQLiteStatement::executeCommand() {
  if (!m_statement && prepare() != SQLITE_OK)
    return false;
  ASSERT(m_isPrepared);
  if (step() != SQLITE_DONE) {
    finalize();
    return false;
  }
  finalize();
  return true;
}

int SQLiteStatement::bindText(int index, const String& text) {
  ASSERT(m_isPrepared);
  ASSERT(index > 0);
  ASSERT(static_cast<unsigned>(index) <= bindParameterCount());

  String text16(text);
  text16.ensure16Bit();
  return restrictError(
      sqlite3_bind_text16(m_statement, index, text16.characters16(),
                          sizeof(UChar) * text16.length(), SQLITE_TRANSIENT));
}

int SQLiteStatement::bindDouble(int index, double number) {
  ASSERT(m_isPrepared);
  ASSERT(index > 0);
  ASSERT(static_cast<unsigned>(index) <= bindParameterCount());

  return restrictError(sqlite3_bind_double(m_statement, index, number));
}

int SQLiteStatement::bindNull(int index) {
  ASSERT(m_isPrepared);
  ASSERT(index > 0);
  ASSERT(static_cast<unsigned>(index) <= bindParameterCount());

  return restrictError(sqlite3_bind_null(m_statement, index));
}

int SQLiteStatement::bindValue(int index, const SQLValue& value) {
  switch (value.getType()) {
    case SQLValue::StringValue:
      return bindText(index, value.string());
    case SQLValue::NumberValue:
      return bindDouble(index, value.number());
    case SQLValue::NullValue:
      return bindNull(index);
  }

  ASSERT_NOT_REACHED();
  return SQLITE_ERROR;
}

unsigned SQLiteStatement::bindParameterCount() const {
  ASSERT(m_isPrepared);
  if (!m_statement)
    return 0;
  return sqlite3_bind_parameter_count(m_statement);
}

int SQLiteStatement::columnCount() {
  ASSERT(m_isPrepared);
  if (!m_statement)
    return 0;
  return sqlite3_data_count(m_statement);
}

String SQLiteStatement::getColumnName(int col) {
  ASSERT(col >= 0);
  if (!m_statement)
    if (prepareAndStep() != SQLITE_ROW)
      return String();
  if (columnCount() <= col)
    return String();
  return String(
      reinterpret_cast<const UChar*>(sqlite3_column_name16(m_statement, col)));
}

SQLValue SQLiteStatement::getColumnValue(int col) {
  ASSERT(col >= 0);
  if (!m_statement)
    if (prepareAndStep() != SQLITE_ROW)
      return SQLValue();
  if (columnCount() <= col)
    return SQLValue();

  // SQLite is typed per value. optional column types are
  // "(mostly) ignored"
  sqlite3_value* value = sqlite3_column_value(m_statement, col);
  switch (sqlite3_value_type(value)) {
    case SQLITE_INTEGER:  // SQLValue and JS don't represent integers, so use
                          // FLOAT -case
    case SQLITE_FLOAT:
      return SQLValue(sqlite3_value_double(value));
    case SQLITE_BLOB:  // SQLValue and JS don't represent blobs, so use TEXT
                       // -case
    case SQLITE_TEXT: {
      const UChar* string =
          reinterpret_cast<const UChar*>(sqlite3_value_text16(value));
      unsigned length = sqlite3_value_bytes16(value) / sizeof(UChar);
      return SQLValue(StringImpl::create8BitIfPossible(string, length));
    }
    case SQLITE_NULL:
      return SQLValue();
    default:
      break;
  }
  ASSERT_NOT_REACHED();
  return SQLValue();
}

String SQLiteStatement::getColumnText(int col) {
  ASSERT(col >= 0);
  if (!m_statement)
    if (prepareAndStep() != SQLITE_ROW)
      return String();
  if (columnCount() <= col)
    return String();
  const UChar* string =
      reinterpret_cast<const UChar*>(sqlite3_column_text16(m_statement, col));
  return StringImpl::create8BitIfPossible(
      string, sqlite3_column_bytes16(m_statement, col) / sizeof(UChar));
}

int SQLiteStatement::getColumnInt(int col) {
  ASSERT(col >= 0);
  if (!m_statement)
    if (prepareAndStep() != SQLITE_ROW)
      return 0;
  if (columnCount() <= col)
    return 0;
  return sqlite3_column_int(m_statement, col);
}

int64_t SQLiteStatement::getColumnInt64(int col) {
  ASSERT(col >= 0);
  if (!m_statement)
    if (prepareAndStep() != SQLITE_ROW)
      return 0;
  if (columnCount() <= col)
    return 0;
  return sqlite3_column_int64(m_statement, col);
}

}  // namespace blink