[sql] Static helper to delete database and all associated files.

sql/connection_unittest.cc

 // Copyright (c) 2012 The Chromium Authors. All rights reserved.
 // Use of this source code is governed by a BSD-style license that can be
 // found in the LICENSE file.
 
 #include "base/file_util.h"
 #include "base/files/scoped_temp_dir.h"
 #include "base/logging.h"
 #include "sql/connection.h"
 #include "sql/meta_table.h"
 #include "sql/statement.h"
@@ skipping 379 matching lines @@
 
   sql::MetaTable meta_table;
   // Below call needs a temporary directory in sqlite3
   // On Android, it can pass only when the temporary directory is set.
   // Otherwise, sqlite3 doesn't find the correct directory to store
   // temporary files and will report the error 'unable to open
   // database file'.
   ASSERT_TRUE(meta_table.Init(&db(), 4, 4));
 }
 #endif
+
+TEST_F(SQLConnectionTest, Delete) {
+  EXPECT_TRUE(db().Execute("CREATE TABLE x (x)"));
+  db().Close();
+
+  // Should have both a main database file and a journal file because
+  // of journal_mode PERSIST.
+  base::FilePath journal(db_path().value() + FILE_PATH_LITERAL("-journal"));
+  ASSERT_TRUE(file_util::PathExists(db_path()));
+  ASSERT_TRUE(file_util::PathExists(journal));
+
+  sql::Connection::Delete(db_path());
+  EXPECT_FALSE(file_util::PathExists(db_path()));
+  EXPECT_FALSE(file_util::PathExists(journal));
+}