1 files changed, 57 insertions, 0 deletions
diff --git a/test-runner/android/test/DatabaseTestUtils.java b/test-runner/android/test/DatabaseTestUtils.java
new file mode 100644
index 0000000..23e0aba
--- /dev/null
+++ b/test-runner/android/test/DatabaseTestUtils.java
@@ -0,0 +1,57 @@
+/*
+ * Copyright (C) 2008 The Android Open Source Project
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package android.test;
+
+import com.google.android.collect.Sets;
+
+import android.database.sqlite.SQLiteDatabase;
+import android.database.Cursor;
+
+import java.util.Set;
+
+/**
+ * A collection of utilities for writing unit tests for database code.
+ * @hide pending API council approval
+ */
+public class DatabaseTestUtils {
+
+    /**
+     * Compares the schema of two databases and asserts that they are equal.
+     * @param expectedDb the db that is known to have the correct schema
+     * @param db the db whose schema should be checked
+     */
+    public static void assertSchemaEquals(SQLiteDatabase expectedDb, SQLiteDatabase db) {
+        Set<String> expectedSchema = getSchemaSet(expectedDb);
+        Set<String> schema = getSchemaSet(db);
+        MoreAsserts.assertEquals(expectedSchema, schema);
+    }
+
+    private static Set<String> getSchemaSet(SQLiteDatabase db) {
+        Set<String> schemaSet = Sets.newHashSet();
+
+        Cursor entityCursor = db.rawQuery("SELECT sql FROM sqlite_master", null);
+        try {
+            while (entityCursor.moveToNext()) {
+                String sql = entityCursor.getString(0);
+                schemaSet.add(sql);
+            }
+        } finally {
+            entityCursor.close();
+        }
+        return schemaSet;
+    }
+}