19066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/* 29066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Copyright (C) 2008 The Android Open Source Project 39066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 49066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Licensed under the Apache License, Version 2.0 (the "License"); 59066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * you may not use this file except in compliance with the License. 69066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * You may obtain a copy of the License at 79066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 89066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * http://www.apache.org/licenses/LICENSE-2.0 99066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Unless required by applicable law or agreed to in writing, software 119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * distributed under the License is distributed on an "AS IS" BASIS, 129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * See the License for the specific language governing permissions and 149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * limitations under the License. 159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpackage android.test; 189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport com.google.android.collect.Sets; 209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDatabase; 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.Cursor; 239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.Set; 259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/** 279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * A collection of utilities for writing unit tests for database code. 289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @hide pending API council approval 299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 30b51617f4668ef8cf0e6d8d0fc3284eae51dbd8caStephan Linzner@Deprecated 319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic class DatabaseTestUtils { 329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Compares the schema of two databases and asserts that they are equal. 359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param expectedDb the db that is known to have the correct schema 369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param db the db whose schema should be checked 379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void assertSchemaEquals(SQLiteDatabase expectedDb, SQLiteDatabase db) { 399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Set<String> expectedSchema = getSchemaSet(expectedDb); 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Set<String> schema = getSchemaSet(db); 419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project MoreAsserts.assertEquals(expectedSchema, schema); 429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static Set<String> getSchemaSet(SQLiteDatabase db) { 459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Set<String> schemaSet = Sets.newHashSet(); 469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Cursor entityCursor = db.rawQuery("SELECT sql FROM sqlite_master", null); 489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project while (entityCursor.moveToNext()) { 509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String sql = entityCursor.getString(0); 519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project schemaSet.add(sql); 529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project entityCursor.close(); 559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return schemaSet; 579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project} 59