| Index: webkit/browser/database/databases_table.cc
|
| diff --git a/webkit/browser/database/databases_table.cc b/webkit/browser/database/databases_table.cc
|
| deleted file mode 100644
|
| index c5e239b496329cfb4ddf8adaffe8c36d3803fc25..0000000000000000000000000000000000000000
|
| --- a/webkit/browser/database/databases_table.cc
|
| +++ /dev/null
|
| @@ -1,150 +0,0 @@
|
| -// Copyright (c) 2012 The Chromium Authors. All rights reserved.
|
| -// Use of this source code is governed by a BSD-style license that can be
|
| -// found in the LICENSE file.
|
| -
|
| -#include "webkit/browser/database/databases_table.h"
|
| -
|
| -#include "base/logging.h"
|
| -#include "base/strings/utf_string_conversions.h"
|
| -#include "sql/statement.h"
|
| -
|
| -namespace storage {
|
| -
|
| -DatabaseDetails::DatabaseDetails() : estimated_size(0) { }
|
| -
|
| -DatabaseDetails::~DatabaseDetails() {}
|
| -
|
| -bool DatabasesTable::Init() {
|
| - // 'Databases' schema:
|
| - // id A unique ID assigned to each database
|
| - // origin The originto which the database belongs. This is a
|
| - // string that can be used as part of a file name
|
| - // (http_webkit.org_0, for example).
|
| - // name The database name.
|
| - // description A short description of the database.
|
| - // estimated_size The estimated size of the database.
|
| - return db_->DoesTableExist("Databases") ||
|
| - (db_->Execute(
|
| - "CREATE TABLE Databases ("
|
| - "id INTEGER PRIMARY KEY AUTOINCREMENT, "
|
| - "origin TEXT NOT NULL, "
|
| - "name TEXT NOT NULL, "
|
| - "description TEXT NOT NULL, "
|
| - "estimated_size INTEGER NOT NULL)") &&
|
| - db_->Execute(
|
| - "CREATE INDEX origin_index ON Databases (origin)") &&
|
| - db_->Execute(
|
| - "CREATE UNIQUE INDEX unique_index ON Databases (origin, name)"));
|
| -}
|
| -
|
| -int64 DatabasesTable::GetDatabaseID(const std::string& origin_identifier,
|
| - const base::string16& database_name) {
|
| - sql::Statement select_statement(db_->GetCachedStatement(
|
| - SQL_FROM_HERE, "SELECT id FROM Databases WHERE origin = ? AND name = ?"));
|
| - select_statement.BindString(0, origin_identifier);
|
| - select_statement.BindString16(1, database_name);
|
| -
|
| - if (select_statement.Step()) {
|
| - return select_statement.ColumnInt64(0);
|
| - }
|
| -
|
| - return -1;
|
| -}
|
| -
|
| -bool DatabasesTable::GetDatabaseDetails(const std::string& origin_identifier,
|
| - const base::string16& database_name,
|
| - DatabaseDetails* details) {
|
| - DCHECK(details);
|
| - sql::Statement select_statement(db_->GetCachedStatement(
|
| - SQL_FROM_HERE, "SELECT description, estimated_size FROM Databases "
|
| - "WHERE origin = ? AND name = ?"));
|
| - select_statement.BindString(0, origin_identifier);
|
| - select_statement.BindString16(1, database_name);
|
| -
|
| - if (select_statement.Step()) {
|
| - details->origin_identifier = origin_identifier;
|
| - details->database_name = database_name;
|
| - details->description = select_statement.ColumnString16(0);
|
| - details->estimated_size = select_statement.ColumnInt64(1);
|
| - return true;
|
| - }
|
| -
|
| - return false;
|
| -}
|
| -
|
| -bool DatabasesTable::InsertDatabaseDetails(const DatabaseDetails& details) {
|
| - sql::Statement insert_statement(db_->GetCachedStatement(
|
| - SQL_FROM_HERE, "INSERT INTO Databases (origin, name, description, "
|
| - "estimated_size) VALUES (?, ?, ?, ?)"));
|
| - insert_statement.BindString(0, details.origin_identifier);
|
| - insert_statement.BindString16(1, details.database_name);
|
| - insert_statement.BindString16(2, details.description);
|
| - insert_statement.BindInt64(3, details.estimated_size);
|
| -
|
| - return insert_statement.Run();
|
| -}
|
| -
|
| -bool DatabasesTable::UpdateDatabaseDetails(const DatabaseDetails& details) {
|
| - sql::Statement update_statement(db_->GetCachedStatement(
|
| - SQL_FROM_HERE, "UPDATE Databases SET description = ?, "
|
| - "estimated_size = ? WHERE origin = ? AND name = ?"));
|
| - update_statement.BindString16(0, details.description);
|
| - update_statement.BindInt64(1, details.estimated_size);
|
| - update_statement.BindString(2, details.origin_identifier);
|
| - update_statement.BindString16(3, details.database_name);
|
| -
|
| - return (update_statement.Run() && db_->GetLastChangeCount());
|
| -}
|
| -
|
| -bool DatabasesTable::DeleteDatabaseDetails(
|
| - const std::string& origin_identifier,
|
| - const base::string16& database_name) {
|
| - sql::Statement delete_statement(db_->GetCachedStatement(
|
| - SQL_FROM_HERE, "DELETE FROM Databases WHERE origin = ? AND name = ?"));
|
| - delete_statement.BindString(0, origin_identifier);
|
| - delete_statement.BindString16(1, database_name);
|
| -
|
| - return (delete_statement.Run() && db_->GetLastChangeCount());
|
| -}
|
| -
|
| -bool DatabasesTable::GetAllOriginIdentifiers(
|
| - std::vector<std::string>* origin_identifiers) {
|
| - sql::Statement statement(db_->GetCachedStatement(
|
| - SQL_FROM_HERE, "SELECT DISTINCT origin FROM Databases ORDER BY origin"));
|
| -
|
| - while (statement.Step())
|
| - origin_identifiers->push_back(statement.ColumnString(0));
|
| -
|
| - return statement.Succeeded();
|
| -}
|
| -
|
| -bool DatabasesTable::GetAllDatabaseDetailsForOriginIdentifier(
|
| - const std::string& origin_identifier,
|
| - std::vector<DatabaseDetails>* details_vector) {
|
| - sql::Statement statement(db_->GetCachedStatement(
|
| - SQL_FROM_HERE, "SELECT name, description, estimated_size "
|
| - "FROM Databases WHERE origin = ? ORDER BY name"));
|
| - statement.BindString(0, origin_identifier);
|
| -
|
| - while (statement.Step()) {
|
| - DatabaseDetails details;
|
| - details.origin_identifier = origin_identifier;
|
| - details.database_name = statement.ColumnString16(0);
|
| - details.description = statement.ColumnString16(1);
|
| - details.estimated_size = statement.ColumnInt64(2);
|
| - details_vector->push_back(details);
|
| - }
|
| -
|
| - return statement.Succeeded();
|
| -}
|
| -
|
| -bool DatabasesTable::DeleteOriginIdentifier(
|
| - const std::string& origin_identifier) {
|
| - sql::Statement delete_statement(db_->GetCachedStatement(
|
| - SQL_FROM_HERE, "DELETE FROM Databases WHERE origin = ?"));
|
| - delete_statement.BindString(0, origin_identifier);
|
| -
|
| - return (delete_statement.Run() && db_->GetLastChangeCount());
|
| -}
|
| -
|
| -} // namespace storage
|
|
|