From d8a994340871009feca58ade3414fe4f7c80bb92 Mon Sep 17 00:00:00 2001 From: "andybons@chromium.org" Date: Tue, 5 Apr 2011 15:48:34 +0000 Subject: Move migration code out of WebDatabase and into table-specific classes. - Currently this only affects AutofillTable and KeywordTable. - Delete autofill_util as those functions can go back into an anonymous namespace within autofill_table.cc - Add helper functions for the migration code to reduce code duplication. - This is the final refactor CL for WebDatabase. R=dhollowa@chromium.org BUG=none TEST=anything WebDatabase/Migration/Table related. Review URL: http://codereview.chromium.org/6677124 git-svn-id: svn://svn.chromium.org/chrome/trunk/src@80460 0039d316-1c4b-4281-b951-d872f2087c98 --- chrome/browser/webdata/keyword_table.cc | 64 +++++++++++++++++++++++++++++++++ 1 file changed, 64 insertions(+) (limited to 'chrome/browser/webdata/keyword_table.cc') diff --git a/chrome/browser/webdata/keyword_table.cc b/chrome/browser/webdata/keyword_table.cc index 35edb56..fd812e5 100644 --- a/chrome/browser/webdata/keyword_table.cc +++ b/chrome/browser/webdata/keyword_table.cc @@ -226,3 +226,67 @@ int KeywordTable::GetBuitinKeywordVersion() { 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; +} -- cgit v1.1