web_database_migration_unittest.cc revision 90dce4d38c5ff5333bea97d859d4e484e27edf0c
15821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Copyright (c) 2012 The Chromium Authors. All rights reserved. 25821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Use of this source code is governed by a BSD-style license that can be 35821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// found in the LICENSE file. 45821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 55821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include <string> 65821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 75821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/file_util.h" 82a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)#include "base/files/scoped_temp_dir.h" 95821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/guid.h" 105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/message_loop.h" 115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/stl_util.h" 125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/string16.h" 132a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)#include "base/strings/string_number_conversions.h" 145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/time.h" 155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/utf_string_conversions.h" 165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/values.h" 175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/browser/webdata/keyword_table.h" 182a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)#include "chrome/browser/webdata/logins_table.h" 192a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)#include "chrome/browser/webdata/token_service_table.h" 202a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)#include "chrome/browser/webdata/web_apps_table.h" 215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/browser/webdata/web_intents_table.h" 225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/test/base/ui_test_utils.h" 23c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)#include "components/autofill/browser/autofill_country.h" 242a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)#include "components/autofill/browser/autofill_profile.h" 252a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)#include "components/autofill/browser/autofill_type.h" 262a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)#include "components/autofill/browser/credit_card.h" 27c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)#include "components/autofill/browser/webdata/autofill_change.h" 28c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)#include "components/autofill/browser/webdata/autofill_entry.h" 29c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)#include "components/autofill/browser/webdata/autofill_table.h" 30c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)#include "components/webdata/common/web_database.h" 315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "sql/statement.h" 325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "testing/gtest/include/gtest/gtest.h" 335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 34c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)using autofill::AutofillProfile; 35c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)using autofill::AutofillTable; 36c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)using autofill::CreditCard; 375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using base::Time; 385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)namespace { 405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)void AutofillProfile31FromStatement(const sql::Statement& s, 425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) AutofillProfile* profile, 43c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) base::string16* label, 445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int* unique_id, 455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64* date_modified) { 465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(profile); 475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(label); 485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(unique_id); 495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(date_modified); 505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) *label = s.ColumnString16(0); 515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) *unique_id = s.ColumnInt(1); 52c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::NAME_FIRST, s.ColumnString16(2)); 53c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::NAME_MIDDLE, s.ColumnString16(3)); 54c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::NAME_LAST, s.ColumnString16(4)); 55c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::EMAIL_ADDRESS, s.ColumnString16(5)); 56c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::COMPANY_NAME, s.ColumnString16(6)); 57c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_LINE1, s.ColumnString16(7)); 58c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_LINE2, s.ColumnString16(8)); 59c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_CITY, s.ColumnString16(9)); 60c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_STATE, s.ColumnString16(10)); 61c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_ZIP, s.ColumnString16(11)); 62c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetInfo( 63c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) autofill::ADDRESS_HOME_COUNTRY, s.ColumnString16(12), "en-US"); 64c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::PHONE_HOME_WHOLE_NUMBER, s.ColumnString16(13)); 655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) *date_modified = s.ColumnInt64(15); 665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) profile->set_guid(s.ColumnString(16)); 675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(base::IsValidGUID(profile->guid())); 685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)void AutofillProfile33FromStatement(const sql::Statement& s, 715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) AutofillProfile* profile, 725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64* date_modified) { 735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(profile); 745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(date_modified); 755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) profile->set_guid(s.ColumnString(0)); 765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(base::IsValidGUID(profile->guid())); 77c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::COMPANY_NAME, s.ColumnString16(1)); 78c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_LINE1, s.ColumnString16(2)); 79c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_LINE2, s.ColumnString16(3)); 80c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_CITY, s.ColumnString16(4)); 81c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_STATE, s.ColumnString16(5)); 82c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetRawInfo(autofill::ADDRESS_HOME_ZIP, s.ColumnString16(6)); 83c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile->SetInfo( 84c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) autofill::ADDRESS_HOME_COUNTRY, s.ColumnString16(7), "en-US"); 855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) *date_modified = s.ColumnInt64(8); 865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)void CreditCard31FromStatement(const sql::Statement& s, 895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) CreditCard* credit_card, 90c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) base::string16* label, 915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int* unique_id, 925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string* encrypted_number, 935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64* date_modified) { 945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(credit_card); 955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(label); 965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(unique_id); 975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(encrypted_number); 985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(date_modified); 995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) *label = s.ColumnString16(0); 1005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) *unique_id = s.ColumnInt(1); 101c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) credit_card->SetRawInfo(autofill::CREDIT_CARD_NAME, s.ColumnString16(2)); 102c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) credit_card->SetRawInfo(autofill::CREDIT_CARD_TYPE, s.ColumnString16(3)); 103c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) credit_card->SetRawInfo(autofill::CREDIT_CARD_EXP_MONTH, s.ColumnString16(5)); 104c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) credit_card->SetRawInfo( 105c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) autofill::CREDIT_CARD_EXP_4_DIGIT_YEAR, s.ColumnString16(6)); 1065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int encrypted_number_len = s.ColumnByteLength(10); 1075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) if (encrypted_number_len) { 1085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) encrypted_number->resize(encrypted_number_len); 1095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) memcpy(&(*encrypted_number)[0], s.ColumnBlob(10), encrypted_number_len); 1105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 1115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) *date_modified = s.ColumnInt64(12); 1125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) credit_card->set_guid(s.ColumnString(13)); 1135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(base::IsValidGUID(credit_card->guid())); 1145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 1155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)void CreditCard32FromStatement(const sql::Statement& s, 1175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) CreditCard* credit_card, 1185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string* encrypted_number, 1195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64* date_modified) { 1205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(credit_card); 1215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(encrypted_number); 1225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DCHECK(date_modified); 1235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) credit_card->set_guid(s.ColumnString(0)); 1245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(base::IsValidGUID(credit_card->guid())); 125c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) credit_card->SetRawInfo(autofill::CREDIT_CARD_NAME, s.ColumnString16(1)); 126c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) credit_card->SetRawInfo(autofill::CREDIT_CARD_EXP_MONTH, s.ColumnString16(2)); 127c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) credit_card->SetRawInfo( 128c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) autofill::CREDIT_CARD_EXP_4_DIGIT_YEAR, s.ColumnString16(3)); 1295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int encrypted_number_len = s.ColumnByteLength(4); 1305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) if (encrypted_number_len) { 1315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) encrypted_number->resize(encrypted_number_len); 1325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) memcpy(&(*encrypted_number)[0], s.ColumnBlob(4), encrypted_number_len); 1335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 1345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) *date_modified = s.ColumnInt64(5); 1355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 1365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1372a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)void CheckHasBackupData(sql::MetaTable* meta_table) { 1382a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) std::string value; 1392a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_TRUE(meta_table->GetValue( 1402a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) "Default Search Provider ID Backup", &value)); 1412a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_TRUE(meta_table->GetValue( 1422a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) "Default Search Provider ID Backup Signature", &value)); 1432a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)} 1442a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 1452a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)void CheckNoBackupData(const sql::Connection& connection, 1462a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) sql::MetaTable* meta_table) { 1472a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) std::string value; 1482a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_FALSE(meta_table->GetValue( 1492a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) "Default Search Provider ID Backup", &value)); 1502a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_FALSE(meta_table->GetValue( 1512a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) "Default Search Provider ID Backup Signature", &value)); 1522a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("keywords_backup")); 1532a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)} 1542a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 1555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} // anonymous namespace 1565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// The WebDatabaseMigrationTest encapsulates testing of database migrations. 1585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Specifically, these tests are intended to exercise any schema changes in 1595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// the WebDatabase and data migrations that occur in 1605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// |WebDatabase::MigrateOldVersionsAsNeeded()|. 1615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)class WebDatabaseMigrationTest : public testing::Test { 1625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) public: 163c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) WebDatabaseMigrationTest() {} 1645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) virtual ~WebDatabaseMigrationTest() {} 1655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) virtual void SetUp() { 1675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(temp_dir_.CreateUniqueTempDir()); 1685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 1695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1702a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // Load the database via the WebDatabase class and migrate the database to 1712a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // the current version. 1722a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) void DoMigration() { 1732a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // TODO(joi): This whole unit test file needs to stay in //chrome 1742a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // for now, as it needs to know about all the different table 1752a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // types. Once all webdata datatypes have been componentized, this 1762a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // could move to components_unittests. 177c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) AutofillTable autofill_table("en-US"); 1782a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) KeywordTable keyword_table; 1792a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) LoginsTable logins_table; 1802a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) TokenServiceTable token_service_table; 1812a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) WebAppsTable web_apps_table; 1822a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) WebIntentsTable web_intents_table; 1832a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 1842a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) WebDatabase db; 1852a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) db.AddTable(&autofill_table); 1862a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) db.AddTable(&keyword_table); 1872a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) db.AddTable(&logins_table); 1882a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) db.AddTable(&token_service_table); 1892a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) db.AddTable(&web_apps_table); 1902a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) db.AddTable(&web_intents_table); 1912a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 1922a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // This causes the migration to occur. 193c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) ASSERT_EQ(sql::INIT_OK, db.Init(GetDatabasePath())); 1942a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) } 1952a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 1965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) protected: 1975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Current tested version number. When adding a migration in 1985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |WebDatabase::MigrateOldVersionsAsNeeded()| and changing the version number 1995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |kCurrentVersionNumber| this value should change to reflect the new version 2005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // number and a new migration test added below. 2015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) static const int kCurrentTestedVersionNumber; 2025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2032a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) base::FilePath GetDatabasePath() { 2042a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) const base::FilePath::CharType kWebDatabaseFilename[] = 2055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) FILE_PATH_LITERAL("TestWebDatabase.sqlite3"); 2062a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) return temp_dir_.path().Append(base::FilePath(kWebDatabaseFilename)); 2075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 2085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // The textual contents of |file| are read from 2105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // "chrome/test/data/web_database" and returned in the string |contents|. 2115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns true if the file exists and is read successfully, false otherwise. 2122a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) bool GetWebDatabaseData(const base::FilePath& file, std::string* contents) { 2132a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) base::FilePath path = ui_test_utils::GetTestFilePath( 2142a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) base::FilePath(FILE_PATH_LITERAL("web_database")), file); 2155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) return file_util::PathExists(path) && 2165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) file_util::ReadFileToString(path, contents); 2175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 2185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) static int VersionFromConnection(sql::Connection* connection) { 2205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Get version. 2215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s(connection->GetUniqueStatement( 2225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT value FROM meta WHERE key='version'")); 2235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) if (!s.Step()) 2245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) return 0; 2255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) return s.ColumnInt(0); 2265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 2275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // The sql files located in "chrome/test/data/web_database" were generated by 2295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // launching the Chromium application prior to schema change, then using the 2305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // sqlite3 command-line application to dump the contents of the "Web Data" 2315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 2325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Like this: 2335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // > .output version_nn.sql 2345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // > .dump 2352a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) void LoadDatabase(const base::FilePath::StringType& file); 2365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) private: 2382a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) base::ScopedTempDir temp_dir_; 2395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DISALLOW_COPY_AND_ASSIGN(WebDatabaseMigrationTest); 2415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)}; 2425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 24390dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)const int WebDatabaseMigrationTest::kCurrentTestedVersionNumber = 51; 2445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2452a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)void WebDatabaseMigrationTest::LoadDatabase( 2462a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) const base::FilePath::StringType& file) { 2475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string contents; 2482a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_TRUE(GetWebDatabaseData(base::FilePath(file), &contents)); 2495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 2515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 2525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Execute(contents.data())); 2535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 2545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the all migrations from an empty database succeed. 2565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateEmptyToCurrent) { 2572a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 2585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 2605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 2615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 2625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 2635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 2645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 2665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 2675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that expected tables are present. 2695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("autofill")); 2705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("autofill_dates")); 2715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("autofill_profiles")); 2725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("credit_cards")); 2735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("keywords")); 2745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // The logins table is obsolete. (We used to store saved passwords here.) 2755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("logins")); 2765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("meta")); 2775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("token_service")); 2785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("web_app_icons")); 2795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("web_apps")); 2805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("web_intents")); 2815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("web_intents_defaults")); 2825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 2835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 2845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the |credit_card| table gets added to the schema for a version 22 2865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// database. 2875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion22ToCurrent) { 2885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This schema is taken from a build prior to the addition of the 2895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |credit_card| table. Version 22 of the schema. Contrast this with the 2905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // corrupt version below. 2915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_22.sql"))); 2925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. 2945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 2955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 2965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 2975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 2985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // No |credit_card| table prior to version 23. 2995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("credit_cards", "guid")); 3005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE( 3015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.DoesColumnExist("credit_cards", "card_number_encrypted")); 3025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 3035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3042a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 3055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 3075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 3085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 3095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 3105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 3115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 3135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 3145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |credit_card| table now exists. 3165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "guid")); 3175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE( 3185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.DoesColumnExist("credit_cards", "card_number_encrypted")); 3195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 3205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 3215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the |credit_card| table gets added to the schema for a corrupt 3235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// version 22 database. The corruption is that the |credit_cards| table exists 3245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// but the schema version number was not set correctly to 23 or later. This 3255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// test exercises code introduced to fix bug http://crbug.com/50699 that 3265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// resulted from the corruption. 3275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion22CorruptedToCurrent) { 3285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This schema is taken from a build after the addition of the |credit_card| 3295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // table. Due to a bug in the migration logic the version is set incorrectly 3305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // to 22 (it should have been updated to 23 at least). 3315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE( 3325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) LoadDatabase(FILE_PATH_LITERAL("version_22_corrupt.sql"))); 3335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for corrupt version 22 of 3355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // the database. 3365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 3375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 3385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 3395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Columns existing and not existing before current version. 3415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("credit_cards", "unique_id")); 3425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE( 3435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.DoesColumnExist("credit_cards", "card_number_encrypted")); 3445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("keywords", "id")); 3455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 3465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3472a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 3485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 3505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 3515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 3525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 3535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 3545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 3565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 3575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Columns existing and not existing before version 25. 3605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", "unique_id")); 3615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "guid")); 3625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE( 3635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.DoesColumnExist("credit_cards", "card_number_encrypted")); 3645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "id")); 3655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 3665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 3675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the |keywords| |created_by_policy| column gets added to the schema 3695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// for a version 25 database. 3705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion25ToCurrent) { 3715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This schema is taken from a build prior to the addition of the |keywords| 3725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |created_by_policy| column. 3735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_25.sql"))); 3745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 25 of the 3765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 3775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 3785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 3795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 3805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 3815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3822a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 3835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 3855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 3865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 3875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 3885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 3895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 3915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 3925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |keywords| |created_by_policy| column should have been added. 3945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "id")); 3955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "created_by_policy")); 3965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 3975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 3985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 3995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the credit_cards.billing_address column is changed from a string 4005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// to an int whilst preserving the associated billing address. This version of 4015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// the test makes sure a stored label is converted to an ID. 4025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion26ToCurrentStringLabels) { 4035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This schema is taken from a build prior to the change of column type for 4045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // credit_cards.billing_address from string to int. 4055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_26.sql"))); 4065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 26 of the 4085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 4095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 4105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 4115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 4125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Columns existing and not existing before current version. 4145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "billing_address")); 4155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string stmt = "INSERT INTO autofill_profiles" 4175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "(label, unique_id, first_name, middle_name, last_name, email," 4185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) " company_name, address_line_1, address_line_2, city, state, zipcode," 4195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) " country, phone, fax)" 4205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "VALUES ('Home',1,'','','','','','','','','','','','','')"; 4215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s(connection.GetUniqueStatement(stmt.c_str())); 4225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Run()); 4235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Insert a CC linked to an existing address. 4255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string stmt2 = "INSERT INTO credit_cards" 4265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "(label, unique_id, name_on_card, type, card_number," 4275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) " expiration_month, expiration_year, verification_code, billing_address," 4285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) " shipping_address, card_number_encrypted, verification_code_encrypted)" 4295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "VALUES ('label',2,'Jack','Visa','1234',2,2012,'','Home','','','')"; 4305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s2(connection.GetUniqueStatement(stmt2.c_str())); 4315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Run()); 4325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |billing_address| is a string. 4345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string stmt3 = "SELECT billing_address FROM credit_cards"; 4355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s3(connection.GetUniqueStatement(stmt3.c_str())); 4365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s3.Step()); 4375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(s3.ColumnType(0), sql::COLUMN_TYPE_TEXT); 4385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 4395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4402a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 4415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 4435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 4445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 4455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 4465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 4475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 4495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 4505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", "billing_address")); 4515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify the credit card data is converted. 4535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s(connection.GetUniqueStatement( 4545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT guid, name_on_card, expiration_month, expiration_year, " 4555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "card_number_encrypted, date_modified " 4565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM credit_cards")); 4575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Step()); 4585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("Jack", s.ColumnString(1)); 4595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(2, s.ColumnInt(2)); 4605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(2012, s.ColumnInt(3)); 4615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Column 5 is encrypted number blob. 4625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Column 6 is date_modified. 4635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 4645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 4655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the credit_cards.billing_address column is changed from a string 4675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// to an int whilst preserving the associated billing address. This version of 4685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// the test makes sure a stored string ID is converted to an integer ID. 4695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion26ToCurrentStringIDs) { 4705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This schema is taken from a build prior to the change of column type for 4715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // credit_cards.billing_address from string to int. 4725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_26.sql"))); 4735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 26 of the 4755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 4765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 4775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 4785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 4795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "billing_address")); 4805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string stmt = "INSERT INTO autofill_profiles" 4825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "(label, unique_id, first_name, middle_name, last_name, email," 4835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) " company_name, address_line_1, address_line_2, city, state, zipcode," 4845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) " country, phone, fax)" 4855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "VALUES ('Home',1,'','','','','','','','','','','','','')"; 4865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s(connection.GetUniqueStatement(stmt.c_str())); 4875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Run()); 4885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Insert a CC linked to an existing address. 4905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string stmt2 = "INSERT INTO credit_cards" 4915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "(label, unique_id, name_on_card, type, card_number," 4925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) " expiration_month, expiration_year, verification_code, billing_address," 4935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) " shipping_address, card_number_encrypted, verification_code_encrypted)" 4945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "VALUES ('label',2,'Jack','Visa','1234',2,2012,'','1','','','')"; 4955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s2(connection.GetUniqueStatement(stmt2.c_str())); 4965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Run()); 4975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 4985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |billing_address| is a string. 4995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string stmt3 = "SELECT billing_address FROM credit_cards"; 5005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s3(connection.GetUniqueStatement(stmt3.c_str())); 5015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s3.Step()); 5025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(s3.ColumnType(0), sql::COLUMN_TYPE_TEXT); 5035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 5045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5052a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 5065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 5085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 5095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 5105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 5115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 5125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 5145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 5155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |keywords| |created_by_policy| column should have been added. 5175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "id")); 5185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "created_by_policy")); 5195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", "billing_address")); 5205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify the credit card data is converted. 5225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s(connection.GetUniqueStatement( 5235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT guid, name_on_card, expiration_month, expiration_year, " 5245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "card_number_encrypted, date_modified " 5255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM credit_cards")); 5265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Step()); 5275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("Jack", s.ColumnString(1)); 5285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(2, s.ColumnInt(2)); 5295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(2012, s.ColumnInt(3)); 5305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Column 5 is encrypted credit card number blo b. 5315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Column 6 is date_modified. 5325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 5335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 5345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Makes sure instant_url is added correctly to keywords. 5365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion27ToCurrent) { 5375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Initialize the database. 5385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_27.sql"))); 5395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 27 of the 5415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 5425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 5435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 5445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 5455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("keywords", "instant_url")); 5475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 5485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5492a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 5505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 5525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 5535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 5545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 5555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 5565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 5585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 5595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Make sure supports_instant (added in Version 28) was ultimately dropped 5615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // again and instant_url was added. 5625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("keywords", "supports_instant")); 5635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "instant_url")); 5645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that instant_url is empty. 5665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string stmt = "SELECT instant_url FROM keywords"; 5675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s(connection.GetUniqueStatement(stmt.c_str())); 5685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Step()); 5695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(std::string(), s.ColumnString(0)); 5705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify the data made it over. 5725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) stmt = "SELECT " + KeywordTable::GetKeywordColumns() + " FROM keywords"; 5735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s2(connection.GetUniqueStatement(stmt.c_str())); 5745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 5755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(2, s2.ColumnInt(0)); 5765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("Google", s2.ColumnString(1)); 5775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("google.com", s2.ColumnString(2)); 5785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("http://www.google.com/favicon.ico", s2.ColumnString(3)); 5795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("{google:baseURL}search?{google:RLZ}{google:acceptedSuggestion}"\ 5805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "{google:originalQueryForSuggestion}sourceid=chrome&ie={inputEncoding}"\ 5815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "&q={searchTerms}", 5825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) s2.ColumnString(4)); 5835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(s2.ColumnBool(5)); 5845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(std::string(), s2.ColumnString(6)); 5855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(0, s2.ColumnInt(7)); 5865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(0, s2.ColumnInt(8)); 5875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(std::string("UTF-8"), s2.ColumnString(9)); 5885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(s2.ColumnBool(10)); 5895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(std::string("{google:baseSuggestURL}search?client=chrome&hl=" 5905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "{language}&q={searchTerms}"), s2.ColumnString(11)); 5915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(1, s2.ColumnInt(12)); 5925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) //EXPECT_EQ(false, s2.ColumnBool(13)); 5935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(std::string(), s2.ColumnString(14)); 5945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(0, s2.ColumnInt(15)); 5955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(std::string(), s2.ColumnString(16)); 5965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 5975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 5985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 5995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Makes sure date_modified is added correctly to autofill_profiles and 6005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// credit_cards. 6015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion29ToCurrent) { 6025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Initialize the database. 6035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_29.sql"))); 6045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 29 of the 6065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 6075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 6085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 6095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 6105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", 6125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "date_modified")); 6135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", 6145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "date_modified")); 6155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 6165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) Time pre_creation_time = Time::Now(); 6182a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 6195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) Time post_creation_time = Time::Now(); 6205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 6225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 6235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 6245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 6255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 6265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 6285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 6295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that the columns were created. 6315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 6325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "date_modified")); 6335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", 6345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "date_modified")); 6355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s_profiles(connection.GetUniqueStatement( 6375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT date_modified FROM autofill_profiles ")); 6385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s_profiles.is_valid()); 6395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) while (s_profiles.Step()) { 6405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_GE(s_profiles.ColumnInt64(0), 6415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) pre_creation_time.ToTimeT()); 6425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_LE(s_profiles.ColumnInt64(0), 6435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) post_creation_time.ToTimeT()); 6445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 6455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(s_profiles.Succeeded()); 6465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s_credit_cards(connection.GetUniqueStatement( 6485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT date_modified FROM credit_cards ")); 6495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s_credit_cards.is_valid()); 6505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) while (s_credit_cards.Step()) { 6515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_GE(s_credit_cards.ColumnInt64(0), 6525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) pre_creation_time.ToTimeT()); 6535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_LE(s_credit_cards.ColumnInt64(0), 6545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) post_creation_time.ToTimeT()); 6555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 6565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(s_credit_cards.Succeeded()); 6575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 6585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 6595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Makes sure guids are added to autofill_profiles and credit_cards tables. 6615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion30ToCurrent) { 6625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Initialize the database. 6635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_30.sql"))); 6645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 29 of the 6665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 6675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 6685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 6695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 6705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", "guid")); 6725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", "guid")); 6735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 6745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6752a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 6765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 6785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 6795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 6805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 6815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 6825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 6845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 6855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("autofill_profiles", "guid")); 6875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("credit_cards", "guid")); 6885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that guids are non-null, non-empty, conforms to guid format, and 6905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // are different. 6915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s( 6925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement("SELECT guid FROM autofill_profiles")); 6935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Step()); 6955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string guid1 = s.ColumnString(0); 6965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(base::IsValidGUID(guid1)); 6975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 6985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Step()); 6995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string guid2 = s.ColumnString(0); 7005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(base::IsValidGUID(guid2)); 7015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NE(guid1, guid2); 7035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 7045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 7055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Removes unique IDs and make GUIDs the primary key. Also removes unused 7075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// columns. 7085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion31ToCurrent) { 7095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Initialize the database. 7105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_31.sql"))); 7115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 30 of the 7135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 7145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) AutofillProfile profile; 715c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) base::string16 profile_label; 7165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int profile_unique_id = 0; 7175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 profile_date_modified = 0; 7185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) CreditCard credit_card; 719c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) base::string16 cc_label; 7205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int cc_unique_id = 0; 7215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string cc_number_encrypted; 7225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 cc_date_modified = 0; 7235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 7245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 7255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 7265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify existence of columns we'll be changing. 7285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "guid")); 7295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "unique_id")); 7305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "guid")); 7315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "unique_id")); 7325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "type")); 7335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "card_number")); 7345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", 7355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "verification_code")); 7365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "billing_address")); 7375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "shipping_address")); 7385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", 7395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "verification_code_encrypted")); 7405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Fetch data in the database prior to migration. 7425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s1( 7435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement( 7445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT label, unique_id, first_name, middle_name, last_name, " 7455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "email, company_name, address_line_1, address_line_2, city, state, " 7465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "zipcode, country, phone, fax, date_modified, guid " 7475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM autofill_profiles")); 7485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s1.Step()); 7495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NO_FATAL_FAILURE(AutofillProfile31FromStatement( 7505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) s1, &profile, &profile_label, &profile_unique_id, 7515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &profile_date_modified)); 7525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s2( 7545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement( 7555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT label, unique_id, name_on_card, type, card_number, " 7565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "expiration_month, expiration_year, verification_code, " 7575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "billing_address, shipping_address, card_number_encrypted, " 7585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "verification_code_encrypted, date_modified, guid " 7595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM credit_cards")); 7605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 7615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CreditCard31FromStatement(s2, 7625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &credit_card, 7635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &cc_label, 7645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &cc_unique_id, 7655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &cc_number_encrypted, 7665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &cc_date_modified)); 7675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NE(profile_unique_id, cc_unique_id); 7695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NE(profile.guid(), credit_card.guid()); 7705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 7715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7722a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 7735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 7755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 7765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 7775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 7785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 7795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 7815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 7825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify existence of columns we'll be changing. 7845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "guid")); 7855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", "unique_id")); 7865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "guid")); 7875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", "unique_id")); 7885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", "type")); 7895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", "card_number")); 7905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", 7915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "verification_code")); 7925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", "billing_address")); 7935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", 7945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "shipping_address")); 7955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", 7965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "verification_code_encrypted")); 7975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 7985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify data in the database after the migration. 7995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s1( 8005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement( 8015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT guid, company_name, address_line_1, address_line_2, " 8025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "city, state, zipcode, country, date_modified " 8035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM autofill_profiles")); 8045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s1.Step()); 8055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) AutofillProfile profile_a; 8075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 profile_date_modified_a = 0; 8085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NO_FATAL_FAILURE(AutofillProfile33FromStatement( 8095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) s1, &profile_a, &profile_date_modified_a)); 8105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(profile.guid(), profile_a.guid()); 811c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(profile.GetRawInfo(autofill::COMPANY_NAME), 812c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile_a.GetRawInfo(autofill::COMPANY_NAME)); 813c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(profile.GetRawInfo(autofill::ADDRESS_HOME_LINE1), 814c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile_a.GetRawInfo(autofill::ADDRESS_HOME_LINE1)); 815c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(profile.GetRawInfo(autofill::ADDRESS_HOME_LINE2), 816c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile_a.GetRawInfo(autofill::ADDRESS_HOME_LINE2)); 817c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(profile.GetRawInfo(autofill::ADDRESS_HOME_CITY), 818c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile_a.GetRawInfo(autofill::ADDRESS_HOME_CITY)); 819c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(profile.GetRawInfo(autofill::ADDRESS_HOME_STATE), 820c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile_a.GetRawInfo(autofill::ADDRESS_HOME_STATE)); 821c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(profile.GetRawInfo(autofill::ADDRESS_HOME_ZIP), 822c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile_a.GetRawInfo(autofill::ADDRESS_HOME_ZIP)); 823c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(profile.GetRawInfo(autofill::ADDRESS_HOME_COUNTRY), 824c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) profile_a.GetRawInfo(autofill::ADDRESS_HOME_COUNTRY)); 8255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(profile_date_modified, profile_date_modified_a); 8265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s2( 8285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement( 8295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT guid, name_on_card, expiration_month, " 8305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "expiration_year, card_number_encrypted, date_modified " 8315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM credit_cards")); 8325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 8335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) CreditCard credit_card_a; 835c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) base::string16 cc_label_a; 8365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string cc_number_encrypted_a; 8375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 cc_date_modified_a = 0; 8385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CreditCard32FromStatement(s2, 8395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &credit_card_a, 8405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &cc_number_encrypted_a, 8415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &cc_date_modified_a)); 8425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(credit_card, credit_card_a); 8435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(cc_label, cc_label_a); 8445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(cc_number_encrypted, cc_number_encrypted_a); 8455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(cc_date_modified, cc_date_modified_a); 8465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 8475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 8485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Factor |autofill_profiles| address information separately from name, email, 8505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// and phone. 8515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion32ToCurrent) { 8525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Initialize the database. 8535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_32.sql"))); 8545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 32 of the 8565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 8575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 8585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 8595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 8605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify existence of columns we'll be changing. 8625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "guid")); 8635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "label")); 8645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "first_name")); 8655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "middle_name")); 8665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "last_name")); 8675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "email")); 8685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 8695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "company_name")); 8705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 8715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "address_line_1")); 8725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 8735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "address_line_2")); 8745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "city")); 8755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "state")); 8765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "zipcode")); 8775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "country")); 8785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "phone")); 8795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "fax")); 8805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 8815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "date_modified")); 8825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("autofill_profile_names")); 8845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("autofill_profile_emails")); 8855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("autofill_profile_phones")); 8865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "label")); 8885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 8895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8902a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 8915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 8935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 8945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 8955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 8965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 8975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 8985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 8995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 9005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify changes to columns. 9025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "guid")); 9035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", "label")); 9045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", "first_name")); 9055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", 9065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "middle_name")); 9075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", "last_name")); 9085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", "email")); 9095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 9105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "company_name")); 9115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 9125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "address_line_1")); 9135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 9145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "address_line_2")); 9155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "city")); 9165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "state")); 9175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "zipcode")); 9185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "country")); 9195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", "phone")); 9205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", "fax")); 9215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 9225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "date_modified")); 9235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // New "names" table. 9255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profile_names", "guid")); 9265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profile_names", 9275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "first_name")); 9285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profile_names", 9295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "middle_name")); 9305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profile_names", 9315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "last_name")); 9325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // New "emails" table. 9345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profile_emails", "guid")); 9355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profile_emails", "email")); 9365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // New "phones" table. 9385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profile_phones", "guid")); 9395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profile_phones", "type")); 9405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profile_phones", 9415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "number")); 9425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("credit_cards", "label")); 9445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify data in the database after the migration. 9465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s1( 9475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement( 9485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT guid, company_name, address_line_1, address_line_2, " 9495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "city, state, zipcode, country, date_modified " 9505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM autofill_profiles")); 9515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John Doe. 9535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s1.Step()); 9545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00580526-FF81-EE2A-0546-1AC593A32E2F", s1.ColumnString(0)); 9555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Doe Enterprises"), s1.ColumnString16(1)); 9565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("1 Main St"), s1.ColumnString16(2)); 9575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Apt 1"), s1.ColumnString16(3)); 9585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Los Altos"), s1.ColumnString16(4)); 9595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("CA"), s1.ColumnString16(5)); 9605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("94022"), s1.ColumnString16(6)); 9615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("United States"), s1.ColumnString16(7)); 9625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(1297882100L, s1.ColumnInt64(8)); 9635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John P. Doe. 9655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets merged during migration from 35 to 37 due to multi-valued fields. 9665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Dave Smith. 9685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s1.Step()); 9695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("4C74A9D8-7EEE-423E-F9C2-E7FA70ED1396", s1.ColumnString(0)); 970c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s1.ColumnString16(1)); 9715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("2 Main Street"), s1.ColumnString16(2)); 972c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s1.ColumnString16(3)); 9735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Los Altos"), s1.ColumnString16(4)); 9745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("CA"), s1.ColumnString16(5)); 9755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("94022"), s1.ColumnString16(6)); 9765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("United States"), s1.ColumnString16(7)); 9775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(1297882100L, s1.ColumnInt64(8)); 9785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Dave Smith (Part 2). 9805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s1.Step()); 9815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("722DF5C4-F74A-294A-46F0-31FFDED0D635", s1.ColumnString(0)); 982c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s1.ColumnString16(1)); 9835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("2 Main St"), s1.ColumnString16(2)); 984c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s1.ColumnString16(3)); 9855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Los Altos"), s1.ColumnString16(4)); 9865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("CA"), s1.ColumnString16(5)); 9875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("94022"), s1.ColumnString16(6)); 9885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("United States"), s1.ColumnString16(7)); 9895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(1297882100L, s1.ColumnInt64(8)); 9905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Alfred E Newman. 9925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled during migration from 35 to 36 due to incomplete address. 9935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 9945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 3 Main St. 9955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s1.Step()); 9965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("9E5FE298-62C7-83DF-6293-381BC589183F", s1.ColumnString(0)); 997c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s1.ColumnString16(1)); 9985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("3 Main St"), s1.ColumnString16(2)); 999c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s1.ColumnString16(3)); 10005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Los Altos"), s1.ColumnString16(4)); 10015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("CA"), s1.ColumnString16(5)); 10025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("94022"), s1.ColumnString16(6)); 10035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("United States"), s1.ColumnString16(7)); 10045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(1297882100L, s1.ColumnInt64(8)); 10055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // That should be all. 10075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(s1.Step()); 10085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s2( 10105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement( 10115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT guid, first_name, middle_name, last_name " 10125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM autofill_profile_names")); 10135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John Doe. 10155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 10165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00580526-FF81-EE2A-0546-1AC593A32E2F", s2.ColumnString(0)); 10175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("John"), s2.ColumnString16(1)); 1018c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s2.ColumnString16(2)); 10195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Doe"), s2.ColumnString16(3)); 10205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John P. Doe. Note same guid as above due to merging of multi-valued 10225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // fields. 10235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 10245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00580526-FF81-EE2A-0546-1AC593A32E2F", s2.ColumnString(0)); 10255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("John"), s2.ColumnString16(1)); 10265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("P."), s2.ColumnString16(2)); 10275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Doe"), s2.ColumnString16(3)); 10285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Dave Smith. 10305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 10315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("4C74A9D8-7EEE-423E-F9C2-E7FA70ED1396", s2.ColumnString(0)); 10325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Dave"), s2.ColumnString16(1)); 1033c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s2.ColumnString16(2)); 10345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Smith"), s2.ColumnString16(3)); 10355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Dave Smith (Part 2). 10375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 10385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("722DF5C4-F74A-294A-46F0-31FFDED0D635", s2.ColumnString(0)); 10395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Dave"), s2.ColumnString16(1)); 1040c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s2.ColumnString16(2)); 10415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Smith"), s2.ColumnString16(3)); 10425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Alfred E Newman. 10445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled during migration from 35 to 36 due to incomplete address. 10455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 3 Main St. 10475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 10485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("9E5FE298-62C7-83DF-6293-381BC589183F", s2.ColumnString(0)); 1049c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s2.ColumnString16(1)); 1050c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s2.ColumnString16(2)); 1051c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s2.ColumnString16(3)); 10525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Should be all. 10545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(s2.Step()); 10555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s3( 10575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement( 10585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT guid, email " 10595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM autofill_profile_emails")); 10605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John Doe. 10625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s3.Step()); 10635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00580526-FF81-EE2A-0546-1AC593A32E2F", s3.ColumnString(0)); 10645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("john@doe.com"), s3.ColumnString16(1)); 10655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John P. Doe. 10675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled during migration from 35 to 37 due to merging of John Doe and 10685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John P. Doe addresses. 10695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 2 Main Street. 10715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s3.Step()); 10725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("4C74A9D8-7EEE-423E-F9C2-E7FA70ED1396", s3.ColumnString(0)); 1073c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s3.ColumnString16(1)); 10745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 2 Main St. 10765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s3.Step()); 10775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("722DF5C4-F74A-294A-46F0-31FFDED0D635", s3.ColumnString(0)); 1078c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s3.ColumnString16(1)); 10795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Alfred E Newman. 10815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled during migration from 35 to 36 due to incomplete address. 10825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 3 Main St. 10845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s3.Step()); 10855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("9E5FE298-62C7-83DF-6293-381BC589183F", s3.ColumnString(0)); 1086c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s3.ColumnString16(1)); 10875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Should be all. 10895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(s3.Step()); 10905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s4( 10925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement( 10935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT guid, type, number " 10945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM autofill_profile_phones")); 10955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 10965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John Doe phone. 10975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s4.Step()); 10985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00580526-FF81-EE2A-0546-1AC593A32E2F", s4.ColumnString(0)); 10995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(0, s4.ColumnInt(1)); // 0 means phone. 11005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("4151112222"), s4.ColumnString16(2)); 11015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John Doe fax. 11035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled after fax type removed. 11045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John P. Doe phone. 11065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled during migration from 35 to 37 due to merging of John Doe and 11075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John P. Doe addresses. 11085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John P. Doe fax. 11105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled during migration from 35 to 37 due to merging of John Doe and 11115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John P. Doe addresses. 11125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 2 Main Street phone. 11145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s4.Step()); 11155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("4C74A9D8-7EEE-423E-F9C2-E7FA70ED1396", s4.ColumnString(0)); 11165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(0, s4.ColumnInt(1)); // 0 means phone. 1117c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s4.ColumnString16(2)); 11185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 2 Main Street fax. 11205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled after fax type removed. 11215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 2 Main St phone. 11235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s4.Step()); 11245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("722DF5C4-F74A-294A-46F0-31FFDED0D635", s4.ColumnString(0)); 11255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(0, s4.ColumnInt(1)); // 0 means phone. 1126c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s4.ColumnString16(2)); 11275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 2 Main St fax. 11295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled after fax type removed. 11305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Note no phone or fax for Alfred E Newman. 11325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 3 Main St phone. 11345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s4.Step()); 11355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("9E5FE298-62C7-83DF-6293-381BC589183F", s4.ColumnString(0)); 11365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(0, s4.ColumnInt(1)); // 0 means phone. 1137c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(base::string16(), s4.ColumnString16(2)); 11385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 2 Main St fax. 11405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Gets culled after fax type removed. 11415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Should be all. 11435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(s4.Step()); 11445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 11455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 11465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Adds a column for the autofill profile's country code. 11485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion33ToCurrent) { 11495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Initialize the database. 11505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_33.sql"))); 11515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 33 of the 11535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 11545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 11555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 11565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 11575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("autofill_profiles", 11595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "country_code")); 11605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that the country value is the one we expect. 11625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s( 11635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement("SELECT country FROM autofill_profiles")); 11645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Step()); 11665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string country = s.ColumnString(0); 11675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("United States", country); 11685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 11695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11702a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 11715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 11735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 11745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 11755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 11765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 11775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 11795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 11805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("autofill_profiles", 11825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "country_code")); 11835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that the country code is properly converted. 11855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s(connection.GetUniqueStatement( 11865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT country_code FROM autofill_profiles")); 11875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Step()); 11895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string country_code = s.ColumnString(0); 11905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("US", country_code); 11915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 11925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 11935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Cleans up bad country code "UK" in favor of good country code "GB". 11955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion34ToCurrent) { 11965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Initialize the database. 11975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_34.sql"))); 11985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 11995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 34 of the 12005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 12015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 12025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 12035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 12045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", 12065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "country_code")); 12075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that the country_code value is the one we expect. 12095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s( 12105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement("SELECT country_code " 12115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM autofill_profiles")); 12125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Step()); 12145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string country_code = s.ColumnString(0); 12155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("UK", country_code); 12165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Should have only one. 12185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(s.Step()); 12195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 12205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12212a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 12225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 12245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 12255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 12265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 12275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 12285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 12305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 12315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("autofill_profiles", 12335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "country_code")); 12345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that the country_code code is properly converted. 12365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s(connection.GetUniqueStatement( 12375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT country_code FROM autofill_profiles")); 12385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s.Step()); 12405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string country_code = s.ColumnString(0); 12415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("GB", country_code); 12425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Should have only one. 12445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(s.Step()); 12455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 12465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 12475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Cleans up invalid profiles based on more agressive merging. Filters out 12495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// profiles that are subsets of other profiles, and profiles with invalid email, 12505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// state, and incomplete address. 12515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion35ToCurrent) { 12525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Initialize the database. 12535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_35.sql"))); 12545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 34 of the 12565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 12575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 12585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 12595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 12605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("autofill_profiles_trash")); 12625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("autofill_profiles", "guid")); 12635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that there are 6 profiles prior to merge. 12655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s( 12665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement("SELECT guid FROM autofill_profiles")); 12675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int i = 0; 12685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) while (s.Step()) 12695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ++i; 12705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(6, i); 12715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 12725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12732a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 12745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 12765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 12775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 12785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 12795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 12805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 12825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 12835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesTableExist("autofill_profiles_trash")); 12855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("autofill_profiles_trash", "guid")); 12865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("autofill_profiles", "guid")); 12875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify data in the database after the migration. 12895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s1( 12905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement( 12915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "SELECT guid, company_name, address_line_1, address_line_2, " 12925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "city, state, zipcode, country, date_modified " 12935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM autofill_profiles")); 12945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 12955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // John Doe. 12965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s1.Step()); 12975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00000000-0000-0000-0000-000000000001", s1.ColumnString(0)); 12985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Acme Inc."), s1.ColumnString16(1)); 12995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("1 Main Street"), s1.ColumnString16(2)); 13005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Apt 2"), s1.ColumnString16(3)); 13015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("San Francisco"), s1.ColumnString16(4)); 13025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("CA"), s1.ColumnString16(5)); 13035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("94102"), s1.ColumnString16(6)); 13045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("United States"), s1.ColumnString16(7)); 13055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(1300131704, s1.ColumnInt64(8)); 13065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // That should be it. 13085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(s1.Step()); 13095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check that there 5 trashed profile after the merge. 13115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s2( 13125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement("SELECT guid " 13135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "FROM autofill_profiles_trash")); 13145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 13155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00000000-0000-0000-0000-000000000002", s2.ColumnString(0)); 13165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 13185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00000000-0000-0000-0000-000000000003", s2.ColumnString(0)); 13195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 13215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00000000-0000-0000-0000-000000000004", s2.ColumnString(0)); 13225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 13245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00000000-0000-0000-0000-000000000005", s2.ColumnString(0)); 13255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 13275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("00000000-0000-0000-0000-000000000006", s2.ColumnString(0)); 13285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // That should be it. 13305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(s2.Step()); 13315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 13325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 13335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the |keywords| |last_modified| column gets added to the schema for 13355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// a version 37 database. 13365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion37ToCurrent) { 13375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This schema is taken from a build prior to the addition of the |keywords| 13385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |last_modified| column. 13395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_37.sql"))); 13405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 37 of the 13425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 13435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 13445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 13455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 13465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Columns existing and not existing before current version. 13485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("keywords", "id")); 13495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("keywords", "last_modified")); 13505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 13515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13522a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 13535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 13555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 13565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 13575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 13585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 13595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 13615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 13625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |keywords| |last_modified| column should have been added. 13645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "id")); 13655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "last_modified")); 13665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 13675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 13685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the |keywords| |sync_guid| column gets added to the schema for 13705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// a version 38 database. 13715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion38ToCurrent) { 13725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This schema is taken from a build prior to the addition of the |keywords| 13735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |sync_guid| column. 13745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_38.sql"))); 13755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 38 of the 13775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 13785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 13795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 13805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 13815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Columns existing and not existing before current version. 13835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("keywords", "id")); 13845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("keywords", "sync_guid")); 13855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 13865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13872a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 13885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 13905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 13915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 13925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 13935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 13945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 13965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 13975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 13985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |keywords| |sync_guid| column should have been added. 13995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "id")); 14005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "sync_guid")); 14015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 14025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 14035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14042a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)// Tests that no backup data is added to a version 39 database. 14055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion39ToCurrent) { 14065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This schema is taken from a build prior to the addition of the default 14075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // search provider backup field to the meta table. 14085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_39.sql"))); 14095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 39 of the 14115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 14125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 14135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 14145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 14155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 14165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 14185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 39, 39)); 14195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 14215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 14225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 14235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14242a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckNoBackupData(connection, &meta_table)); 14255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 14265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14272a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 14285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 14305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 14315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 14325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 14335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 14345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 14355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 14375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 14385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 14405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, kCurrentTestedVersionNumber, 14415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber)); 14425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 14445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 14455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 14462a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NE(0, default_search_provider_id); 14475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14482a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckNoBackupData(connection, &meta_table)); 14495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 14505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 14515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14522a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)// Tests that the backup data is removed from the database. 14535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion40ToCurrent) { 14545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_40.sql"))); 14555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 40 of the 14575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 14585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 14595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 14605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 14615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 14625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 14645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 40, 40)); 14655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 14675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 14685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 14695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14702a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckHasBackupData(&meta_table)); 14715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 14725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14732a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 14745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 14765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 14775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 14785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 14795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 14805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 14815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 14835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 14845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 14865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, kCurrentTestedVersionNumber, 14875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber)); 14885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 14905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 14915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 14925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NE(0, default_search_provider_id); 14935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14942a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckNoBackupData(connection, &meta_table)); 14955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 14965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 14975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 14982a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)// Tests that the backup data is removed from the database. 14995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion41ToCurrent) { 15005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_41.sql"))); 15015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 41 of the 15035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 15045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 15055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 15065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 15075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 15085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 15105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 41, 41)); 15115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 15135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 15145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 15155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15162a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckHasBackupData(&meta_table)); 15175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 15185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15192a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 15205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 15225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 15235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 15245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 15255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 15265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 15275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 15295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 15305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 15325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, kCurrentTestedVersionNumber, 15335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber)); 15345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 15365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 15375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 15385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NE(0, default_search_provider_id); 15395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15402a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckNoBackupData(connection, &meta_table)); 15415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 15425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 15435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15442a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)// Tests that the backup data is removed from the database. 15455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion42ToCurrent) { 15465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_42.sql"))); 15475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 42 of the 15495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 15505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 15515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 15525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 15535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 15545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 15565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 42, 42)); 15575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 15595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 15605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 15615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15622a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckHasBackupData(&meta_table)); 15635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("keywords_backup")); 15655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 15665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15672a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 15685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 15705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 15715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 15725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 15735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 15745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 15755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 15775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 15785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 15805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, kCurrentTestedVersionNumber, 15815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber)); 15825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 15845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 15855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 15865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NE(0, default_search_provider_id); 15875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15882a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckNoBackupData(connection, &meta_table)); 15895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 15905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 15915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15922a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)// Tests that the backup data is removed from the database. 15935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion43ToCurrent) { 15945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_43.sql"))); 15955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 previous_default_search_provider_id; 15975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 15985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 43 of the 15995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 16005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 16015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 16025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 16035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 16045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 16065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 43, 43)); 16075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 16095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 16105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 16115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_NE(default_search_provider_id, 0); 16125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) previous_default_search_provider_id = default_search_provider_id; 16135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16142a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckHasBackupData(&meta_table)); 16152a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("keywords_backup")); 16165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 16175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16182a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 16195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 16215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 16225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 16235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 16245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 16255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 16265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 16285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 16295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 16315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init( 16325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &connection, 16335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber, 16345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber)); 16355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int64 default_search_provider_id = 0; 16375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 16385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_id)); 16395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Default search provider ID should not change. 16405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(previous_default_search_provider_id, default_search_provider_id); 16415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16422a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckNoBackupData(connection, &meta_table)); 16435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 16445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 16455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the |autogenerate_keyword| and |logo_id| columns get removed from 16475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// the keyword table schema for a version 45 database. 16485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion44ToCurrent) { 16495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_44.sql"))); 16505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 44 of the 16525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 16535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 16545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 16555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 16565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 16575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 16595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 44, 44)); 16605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("keywords", "autogenerate_keyword")); 16625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.DoesColumnExist("keywords", "logo_id")); 16635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 16645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16652a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 16665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 16685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 16695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 16705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 16715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 16725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 16735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 16755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 16765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 16785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, kCurrentTestedVersionNumber, 16795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber)); 16805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // We should have removed this obsolete key. 16825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::string default_search_provider_backup; 16835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(meta_table.GetValue("Default Search Provider Backup", 16845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &default_search_provider_backup)); 16855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Two columns should have been removed. 16875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("keywords", 16885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "autogenerate_keyword")); 16895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesColumnExist("keywords", "logo_id")); 16905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16912a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // Backup data should have been removed. 16922a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckNoBackupData(connection, &meta_table)); 16935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 16945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 16955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 16965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the web_intents and web_intents_defaults tables are 16975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// modified to include "scheme" columns. 16985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion45ToCurrent) { 16995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_45.sql"))); 17005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 45 of the 17025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 17035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 17045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 17055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 17065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 17075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 17095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 45, 45)); 17105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("scheme", "web_intents")); 17125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist( 17135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "scheme", "web_intents_defaults")); 17145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 17155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17162a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 17175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 17195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 17205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 17215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 17225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 17235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 17245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 17265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 17275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 17295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init( 17305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &connection, 17315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber, 17325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber)); 17335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // A new "scheme" column should have been added to each web_intents table. 17355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("web_intents", "scheme")); 17365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("web_intents_defaults", "scheme")); 17375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify existing user data was copied. 17395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s1( 17405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement("SELECT * FROM web_intents")); 17415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s1.Step()); 17435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("http://poodles.com/fuzzer", s1.ColumnString(0)); 17445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("fuzz"), s1.ColumnString16(1)); 17455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("poodle/*"), s1.ColumnString16(2)); 17465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("Poodle Fuzzer"), s1.ColumnString16(3)); 17475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("window"), s1.ColumnString16(4)); 17485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16(""), s1.ColumnString16(5)); 17495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(s1.Step()); 17505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Now we want to verify existing user data was copied 17525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s2( 17535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement("SELECT * FROM web_intents_defaults")); 17545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(s2.Step()); 17565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ("fuzz", s2.ColumnString(0)); 17575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("poodle/*"), s2.ColumnString16(1)); 17585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16(""), s2.ColumnString16(2)); 17595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(0, s2.ColumnInt(3)); 17605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(0, s2.ColumnInt(4)); 17615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16("http://poodles.com/fuzzer"), s2.ColumnString16(5)); 17625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(ASCIIToUTF16(""), s2.ColumnString16(6)); 17635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(s2.Step()); 17645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // finally ensure the migration code cleaned up after itself 17665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("old_web_intents")); 17675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("old_web_intents_defaults")); 17685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 17695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 17705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the web_intents and web_intents_defaults tables are 17725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// modified to include "scheme" columns. 17735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion45InvalidToCurrent) { 17745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE( 17755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) LoadDatabase(FILE_PATH_LITERAL("version_45_invalid.sql"))); 17765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 45 of the 17785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 17795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 17805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 17815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 17825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 17835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 17855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 45, 45)); 17865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("scheme", "web_intents")); 17885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist( 17895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "scheme", "web_intents_defaults")); 17905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 17915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17922a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 17935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 17945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 17955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 17965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 17975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 17985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 17995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 18005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 18025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 18035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 18055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init( 18065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) &connection, 18075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber, 18085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) kCurrentTestedVersionNumber)); 18095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // A new "scheme" column should have been added to each web_intents table. 18115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("web_intents", "scheme")); 18125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("web_intents_defaults", "scheme")); 18135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify existing user data was copied. 18155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s1( 18165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement("SELECT * FROM web_intents")); 18175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(s1.Step()); // Basically should be empty at this point. 18195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Now we want to verify existing user data was copied 18215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Statement s2( 18225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) connection.GetUniqueStatement("SELECT * FROM web_intents_defaults")); 18235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // We were able to create the new tables, but unable to copy any data 18255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Given the initial bad state of the tables. 18265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(s2.Step()); 18275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Finally ensure the migration code cleaned up after itself. 18295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("old_web_intents")); 18305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_FALSE(connection.DoesTableExist("old_web_intents_defaults")); 18315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 18325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 18335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Check that current version is forced to compatible version before migration, 18355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// if the former is smaller. 18365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion45CompatibleToCurrent) { 18375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE( 18385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) LoadDatabase(FILE_PATH_LITERAL("version_45_compatible.sql"))); 18395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 45 of the 18415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 18425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 18435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 18445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 18455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 18465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 18485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Database is actually version 45 but the version field states 40. 18495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 40, 45)); 18505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 18515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18522a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 18535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 18555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 18565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 18575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 18585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 18595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 18605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 18625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 18635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_LE(45, VersionFromConnection(&connection)); 18645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 18655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 18665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Tests that the |alternate_urls| column is added to the keyword table schema 18685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// for a version 47 database. 18695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion46ToCurrent) { 18705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_NO_FATAL_FAILURE( 18715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) LoadDatabase(FILE_PATH_LITERAL("version_46.sql"))); 18725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify pre-conditions. These are expectations for version 46 of the 18745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 18755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 18765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 18775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 18785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 18795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 18815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 46, 46)); 18825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("keywords", "alternate_urls")); 18845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("keywords_backup", 18855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) "alternate_urls")); 18865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 18875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18882a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 18895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 18915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 18925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 18935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 18945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 18955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 18965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 18975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 18985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 18995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 19005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // A new column should have been created. 19015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", "alternate_urls")); 19025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 19035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 19045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 19052a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)// Tests that the backup data is removed from the database. 19062a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion47ToCurrent) { 19072a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_47.sql"))); 19082a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19092a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // Verify pre-conditions. These are expectations for version 47 of the 19105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 19115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 19125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 19135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 19145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 19155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 19165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::MetaTable meta_table; 19172a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 47, 47)); 19185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 19192a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) int64 default_search_provider_id = 0; 19202a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 19212a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) &default_search_provider_id)); 19222a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NE(0, default_search_provider_id); 19232a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19242a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckHasBackupData(&meta_table)); 19252a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_TRUE(connection.DoesTableExist("keywords_backup")); 19265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 19275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 19282a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 19292a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19302a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 19312a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // database. 19325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 19332a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) sql::Connection connection; 19342a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 19352a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 19362a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19372a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // Check version. 19382a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 19392a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19402a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) sql::MetaTable meta_table; 19412a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, kCurrentTestedVersionNumber, 19422a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) kCurrentTestedVersionNumber)); 19432a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19442a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) int64 default_search_provider_id = 0; 19452a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_TRUE(meta_table.GetValue(KeywordTable::kDefaultSearchProviderKey, 19462a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) &default_search_provider_id)); 19472a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NE(0, default_search_provider_id); 19482a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19492a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_NO_FATAL_FAILURE(CheckNoBackupData(connection, &meta_table)); 19505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 19512a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)} 19522a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19532a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)// Tests that the |search_terms_replacement_key| column is added to the keyword 19542a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)// table schema for a version 49 database. 19552a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion48ToCurrent) { 19562a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_NO_FATAL_FAILURE( 19572a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) LoadDatabase(FILE_PATH_LITERAL("version_48.sql"))); 19582a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19592a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // Verify pre-conditions. These are expectations for version 48 of the 19602a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // database. 19612a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) { 19622a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) sql::Connection connection; 19632a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 19642a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 19652a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19662a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) sql::MetaTable meta_table; 19672a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_TRUE(meta_table.Init(&connection, 48, 48)); 19682a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19692a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("keywords", 19702a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) "search_terms_replacement_key")); 19712a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) } 19722a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) 19732a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) DoMigration(); 19745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 19755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 19765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // database. 19775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) { 19785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) sql::Connection connection; 19795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 19805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 19815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 19825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Check version. 19835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 19845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 19855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // A new column should have been created. 19862a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("keywords", 19872a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) "search_terms_replacement_key")); 19885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 19895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)} 1990c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) 1991c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)// Tests that the |origin| column is added to the autofill_profiles and 1992c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)// credit_cards table schemas for a version 50 database. 1993c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)TEST_F(WebDatabaseMigrationTest, MigrateVersion49ToCurrent) { 1994c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) ASSERT_NO_FATAL_FAILURE(LoadDatabase(FILE_PATH_LITERAL("version_49.sql"))); 1995c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) 1996c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) // Verify pre-conditions. These are expectations for version 49 of the 1997c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) // database. 1998c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) { 1999c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) sql::Connection connection; 2000c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 2001c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) 2002c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("autofill_profiles", "origin")); 2003c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) ASSERT_FALSE(connection.DoesColumnExist("credit_cards", "origin")); 2004c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) } 2005c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) 2006c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) DoMigration(); 2007c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) 2008c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) // Verify post-conditions. These are expectations for current version of the 2009c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) // database. 2010c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) { 2011c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) sql::Connection connection; 2012c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) ASSERT_TRUE(connection.Open(GetDatabasePath())); 2013c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) ASSERT_TRUE(sql::MetaTable::DoesTableExist(&connection)); 2014c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) 2015c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) // Check version. 2016c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_EQ(kCurrentTestedVersionNumber, VersionFromConnection(&connection)); 2017c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) 2018c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) // A new column should have been created in both tables. 2019c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("autofill_profiles", "origin")); 2020c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) EXPECT_TRUE(connection.DoesColumnExist("credit_cards", "origin")); 2021c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles) } 2022c2e0dbddbe15c98d52c4786dac06cb8952a8ae6dTorne (Richard Coles)} 2023