1 /* 2 * Copyright (C) 2008 The Android Open Source Project 3 * 4 * Licensed under the Apache License, Version 2.0 (the "License"); 5 * you may not use this file except in compliance with the License. 6 * You may obtain a copy of the License at 7 * 8 * http://www.apache.org/licenses/LICENSE-2.0 9 * 10 * Unless required by applicable law or agreed to in writing, software 11 * distributed under the License is distributed on an "AS IS" BASIS, 12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 13 * See the License for the specific language governing permissions and 14 * limitations under the License. 15 */ 16 17 package android.test; 18 19 import com.google.android.collect.Sets; 20 21 import android.database.sqlite.SQLiteDatabase; 22 import android.database.Cursor; 23 24 import java.util.Set; 25 26 /** 27 * A collection of utilities for writing unit tests for database code. 28 * @hide pending API council approval 29 */ 30 @Deprecated 31 public class DatabaseTestUtils { 32 33 /** 34 * Compares the schema of two databases and asserts that they are equal. 35 * @param expectedDb the db that is known to have the correct schema 36 * @param db the db whose schema should be checked 37 */ assertSchemaEquals(SQLiteDatabase expectedDb, SQLiteDatabase db)38 public static void assertSchemaEquals(SQLiteDatabase expectedDb, SQLiteDatabase db) { 39 Set<String> expectedSchema = getSchemaSet(expectedDb); 40 Set<String> schema = getSchemaSet(db); 41 MoreAsserts.assertEquals(expectedSchema, schema); 42 } 43 getSchemaSet(SQLiteDatabase db)44 private static Set<String> getSchemaSet(SQLiteDatabase db) { 45 Set<String> schemaSet = Sets.newHashSet(); 46 47 Cursor entityCursor = db.rawQuery("SELECT sql FROM sqlite_master", null); 48 try { 49 while (entityCursor.moveToNext()) { 50 String sql = entityCursor.getString(0); 51 schemaSet.add(sql); 52 } 53 } finally { 54 entityCursor.close(); 55 } 56 return schemaSet; 57 } 58 } 59