Added MediaGalleryDatabase

content/browser/media_gallery/media_gallery_database_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 <string>
+
+#include "base/file_path.h"
+#include "base/scoped_temp_dir.h"
+#include "content/browser/media_gallery/media_gallery_database.h"
+#include "content/browser/media_gallery/media_gallery_types.h"
+#include "sql/connection.h"
+#include "testing/gtest/include/gtest/gtest.h"
+
+namespace media_gallery {
+
+class MediaGalleryDatabaseTest : public testing::Test,
+                                 public MediaGalleryDatabase {
+ public:
+  MediaGalleryDatabaseTest() { }
+
+ protected:
+  virtual sql::Connection& GetDB() {
+    return db_;
+  }
+
+ private:
+  // Test setup.
+  void SetUp() {
+    ASSERT_TRUE(temp_dir_.CreateUniqueTempDir());
+    FilePath db_file = temp_dir_.path().AppendASCII("MediaGalleryTest.db");
+
+    ASSERT_TRUE(db_.Open(db_file));
+
+    // Initialize the tables for this test.
+    ASSERT_EQ(sql::INIT_OK, InitInternal(&db_));
+  }
+
+  void TearDown() {
+    db_.Close();
+  }
+
+  ScopedTempDir temp_dir_;
+  sql::Connection db_;
+};
+
+TEST_F(MediaGalleryDatabaseTest, Init) {
+  EXPECT_TRUE(DoesCollectionsTableExist(&GetDB()));
+}
+
+TEST_F(MediaGalleryDatabaseTest, AddCollection) {
+  CollectionRow row1(FilePath(FILE_PATH_LITERAL("path1")),
+                     base::Time::FromDoubleT(12345),
+                     123,
+                     false);
+  CollectionId rowid = CreateCollectionRow(&row1);
+  EXPECT_TRUE(rowid);
+  EXPECT_EQ(rowid, row1.id);
+
+  CollectionRow row2;
+  EXPECT_TRUE(GetCollectionRow(rowid, &row2));
+  EXPECT_TRUE(row1 == row2);
+}
+
+TEST_F(MediaGalleryDatabaseTest, StandardizePath) {
+#if defined(FILE_PATH_USES_WIN_SEPARATORS)

[Lei Zhang, 2012/03/07 21:24:37]

You can also write this as:

FilePath foo(FILE_PATH_LITERAL("path1"));
foo = foo.AppendASCII("path2");

[tpayne, 2012/03/07 21:34:55]

Done.

+#define PATH FILE_PATH_LITERAL("path1\\path2")
+#else
+#define PATH FILE_PATH_LITERAL("path1/path2")
+#endif  // FILE_PATH_USES_WIN_SEPARATORS
+  CollectionRow row1(FilePath(PATH),
+                     base::Time::FromDoubleT(12345),
+                     123,
+                     false);
+#undef PATH
+  CollectionId rowid = CreateCollectionRow(&row1);
+  EXPECT_EQ(rowid, row1.id);
+
+  CollectionRow row2;
+  EXPECT_TRUE(GetCollectionRow(rowid, &row2));
+  EXPECT_EQ(std::string("path1/path2"), row2.path.value());
+}
+
+}  // namespace media_gallery