Move migration code out of WebDatabase and into table-specific classes.

chrome/browser/webdata/keyword_table.cc

 // Copyright (c) 2011 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 "chrome/browser/webdata/keyword_table.h"
 
 #include "app/sql/statement.h"
 #include "base/logging.h"
 #include "base/string_split.h"
 #include "base/string_util.h"
@@ skipping 208 matching lines @@
 
 bool KeywordTable::SetBuitinKeywordVersion(int version) {
   return meta_table_->SetValue(kBuiltinKeywordVersion, version);
 }
 
 int KeywordTable::GetBuitinKeywordVersion() {
   int version = 0;
   meta_table_->GetValue(kBuiltinKeywordVersion, &version);
   return version;
 }
+
+bool KeywordTable::MigrateToVersion21AutoGenerateKeywordColumn() {
+  return db_->Execute("ALTER TABLE keywords ADD COLUMN autogenerate_keyword "
+                      "INTEGER DEFAULT 0");
+}
+
+bool KeywordTable::MigrateToVersion25AddLogoIDColumn() {
+  return db_->Execute(
+      "ALTER TABLE keywords ADD COLUMN logo_id INTEGER DEFAULT 0");
+}
+
+bool KeywordTable::MigrateToVersion26AddCreatedByPolicyColumn() {
+  return db_->Execute("ALTER TABLE keywords ADD COLUMN created_by_policy "
+                      "INTEGER DEFAULT 0");
+}
+
+bool KeywordTable::MigrateToVersion28SupportsInstantColumn() {
+  return db_->Execute("ALTER TABLE keywords ADD COLUMN supports_instant "
+                      "INTEGER DEFAULT 0");
+}
+
+bool KeywordTable::MigrateToVersion29InstantUrlToSupportsInstant() {
+  if (!db_->Execute("ALTER TABLE keywords ADD COLUMN instant_url VARCHAR"))
+    return false;
+
+  if (!db_->Execute("CREATE TABLE keywords_temp ("
+                    "id INTEGER PRIMARY KEY,"
+                    "short_name VARCHAR NOT NULL,"
+                    "keyword VARCHAR NOT NULL,"
+                    "favicon_url VARCHAR NOT NULL,"
+                    "url VARCHAR NOT NULL,"
+                    "show_in_default_list INTEGER,"
+                    "safe_for_autoreplace INTEGER,"
+                    "originating_url VARCHAR,"
+                    "date_created INTEGER DEFAULT 0,"
+                    "usage_count INTEGER DEFAULT 0,"
+                    "input_encodings VARCHAR,"
+                    "suggest_url VARCHAR,"
+                    "prepopulate_id INTEGER DEFAULT 0,"
+                    "autogenerate_keyword INTEGER DEFAULT 0,"
+                    "logo_id INTEGER DEFAULT 0,"
+                    "created_by_policy INTEGER DEFAULT 0,"
+                    "instant_url VARCHAR)")) {
+    return false;
+  }
+
+  if (!db_->Execute(
+      "INSERT INTO keywords_temp "
+      "SELECT id, short_name, keyword, favicon_url, url, "
+      "show_in_default_list, safe_for_autoreplace, originating_url, "
+      "date_created, usage_count, input_encodings, suggest_url, "
+      "prepopulate_id, autogenerate_keyword, logo_id, created_by_policy, "
+      "instant_url FROM keywords")) {
+    return false;
+  }
+
+  if (!db_->Execute("DROP TABLE keywords"))
+    return false;
+
+  if (!db_->Execute("ALTER TABLE keywords_temp RENAME TO keywords"))
+    return false;
+
+  return true;
+}