Autofill database migration to clean up bogus profiles.

chrome/browser/webdata/web_database.h

 // Copyright (c) 2011 The Chromium Authors. All rights reserved.
 // Use of this source code is governed by a BSD-style license that can be
 // found in the LICENSE file.
 
 #ifndef CHROME_BROWSER_WEBDATA_WEB_DATABASE_H_
 #define CHROME_BROWSER_WEBDATA_WEB_DATABASE_H_
 #pragma once
 
 #include <vector>
 
@@ skipping 243 matching lines @@
   // Retrieves all credit cards in the database.  Caller owns the returned
   // credit cards.
   virtual bool GetCreditCards(std::vector<CreditCard*>* credit_cards);
 
   // Removes rows from autofill_profiles and credit_cards if they were created
   // on or after |delete_begin| and strictly before |delete_end|.
   bool RemoveAutofillProfilesAndCreditCardsModifiedBetween(
       base::Time delete_begin,
       base::Time delete_end);
 
+  // Retrieves all profiles in the database that have been deleted since last
+  // "empty" of the trash.
+  bool GetAutofillProfilesInTrash(std::vector<std::string>* guids);
+
+  // Empties the Autofill profiles "trash can".
+  bool EmptyAutofillProfilesTrash();
+
   //////////////////////////////////////////////////////////////////////////////
   //
   // Web Apps
   //
   //////////////////////////////////////////////////////////////////////////////
 
   bool SetWebAppImage(const GURL& url, const SkBitmap& image);
   bool GetWebAppImages(const GURL& url, std::vector<SkBitmap>* images);
 
   bool SetWebAppHasAllImages(const GURL& url, bool has_all_images);
@@ skipping 30 matching lines @@
   FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest,
                            Autofill_GetAllAutofillEntries_TwoDistinct);
   FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest,
                            Autofill_GetAllAutofillEntries_TwoSame);
   FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest, Autofill_UpdateDontReplace);
   FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest, Autofill_AddFormFieldValues);
   FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest, AutofillProfile);
   FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest, CreditCard);
   FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest, UpdateAutofillProfile);
   FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest, UpdateCreditCard);
+  FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest, AutofillProfileTrash);
+  FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest, AutofillProfileTrashInteraction);
   FRIEND_TEST_ALL_PREFIXES(WebDatabaseTest,
                            RemoveAutofillProfilesAndCreditCardsModifiedBetween);
 
   // Methods for adding autofill entries at a specified time.  For
   // testing only.
   bool AddFormFieldValuesTime(
       const std::vector<webkit_glue::FormField>& elements,
       std::vector<AutofillChange>* changes,
       base::Time time);
   bool AddFormFieldValueTime(const webkit_glue::FormField& element,
                              std::vector<AutofillChange>* changes,
                              base::Time time);
 
   // Removes empty values for autofill that were incorrectly stored in the DB
   // (see bug http://crbug.com/6111).
   // TODO(jcampan): http://crbug.com/7564 remove when we think all users have
   //                run this code.
   bool ClearAutofillEmptyValueElements();
 
   // Insert a single AutofillEntry into the autofill/autofill_dates tables.
   bool InsertAutofillEntry(const AutofillEntry& entry);
 
+  // Retrieves all profiles in the database that have been deleted since last
+  // "empty" of the trash.
+  bool AddAutofillGUIDToTrash(const std::string& guid);
+
+  // Checks if the guid is in the trash.
+  bool IsAutofillGUIDInTrash(const std::string& guid);
+
+  // Clear all profiles.
+  bool ClearAutofillProfiles();
+
   bool InitKeywordsTable();
   bool InitLoginsTable();
   bool InitAutofillTable();
   bool InitAutofillDatesTable();
   bool InitAutofillProfilesTable();
   bool InitAutofillProfileNamesTable();
   bool InitAutofillProfileEmailsTable();
   bool InitAutofillProfilePhonesTable();
+  bool InitAutofillProfileTrashTable();
   bool InitCreditCardsTable();
   bool InitTokenServiceTable();
   bool InitWebAppIconsTable();
   bool InitWebAppsTable();
 
   // Used by |Init()| to migration database schema from older versions to
   // current version.
   sql::InitStatus MigrateOldVersionsAsNeeded();
 
   sql::Connection db_;
   sql::MetaTable meta_table_;
 
   scoped_ptr<NotificationService> notification_service_;
 
   DISALLOW_COPY_AND_ASSIGN(WebDatabase);
 };
 
 #endif  // CHROME_BROWSER_WEBDATA_WEB_DATABASE_H_