19066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/* 29066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Copyright (C) 2007 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 171a44d5dcabc18cd5ef111f732ccff91683a1a093Neal Nguyenpackage android.database; 189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDatabase; 209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.Cursor; 219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.test.suitebuilder.annotation.MediumTest; 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.test.suitebuilder.annotation.SmallTest; 239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.util.Log; 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.test.MoreAsserts; 259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.ArrayList; 279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.Locale; 289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport junit.framework.TestCase; 309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic class DatabaseLocaleTest extends TestCase { 329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteDatabase mDatabase; 349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final String[] STRINGS = { 369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "c\u00f4t\u00e9", 379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "cote", 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "c\u00f4te", 399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "cot\u00e9", 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "boy", 419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "dog", 429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "COTE", 439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project }; 449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project protected void setUp() throws Exception { 479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project super.setUp(); 489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDatabase = SQLiteDatabase.create(null); 49c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project mDatabase.execSQL( 50c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project "CREATE TABLE test (id INTEGER PRIMARY KEY, data TEXT COLLATE LOCALIZED);"); 51c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project } 52c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project 53c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project private void insertStrings() { 549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (String s : STRINGS) { 55c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project mDatabase.execSQL("INSERT INTO test (data) VALUES('" + s + "');"); 569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project protected void tearDown() throws Exception { 619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDatabase.close(); 629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project super.tearDown(); 639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private String[] query(String sql) { 669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.i("LocaleTest", "Querying: " + sql); 679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Cursor c = mDatabase.rawQuery(sql, null); 689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertNotNull(c); 699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ArrayList<String> items = new ArrayList<String>(); 709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project while (c.moveToNext()) { 719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project items.add(c.getString(0)); 729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.i("LocaleTest", "...." + c.getString(0)); 739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] result = items.toArray(new String[items.size()]); 759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(STRINGS.length, result.length); 769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project c.close(); 779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return result; 789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @MediumTest 819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testLocaleInsertOrder() throws Exception { 82c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project insertStrings(); 839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] results = query("SELECT data FROM test"); 849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project MoreAsserts.assertEquals(STRINGS, results); 859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @MediumTest 889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testLocaleenUS() throws Exception { 89c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project insertStrings(); 909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.i("LocaleTest", "about to call setLocale en_US"); 919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDatabase.setLocale(new Locale("en", "US")); 929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] results; 939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project results = query("SELECT data FROM test ORDER BY data COLLATE LOCALIZED ASC"); 949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // The database code currently uses PRIMARY collation strength, 969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // meaning that all versions of a character compare equal (regardless 979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // of case or accents), leaving the "cote" flavors in database order. 989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project MoreAsserts.assertEquals(results, new String[] { 999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project STRINGS[4], // "boy" 1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project STRINGS[0], // sundry forms of "cote" 1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project STRINGS[1], 1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project STRINGS[2], 1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project STRINGS[3], 1049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project STRINGS[6], // "COTE" 1059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project STRINGS[5], // "dog" 1069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project }); 1079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 108c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project 109c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project @SmallTest 110c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project public void testHoge() throws Exception { 111c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project Cursor cursor = null; 112c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project try { 113c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project String expectedString = new String(new int[] {0xFE000}, 0, 1); 114c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project mDatabase.execSQL("INSERT INTO test(id, data) VALUES(1, '" + expectedString + "')"); 115c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project cursor = mDatabase.rawQuery("SELECT data FROM test WHERE id = 1", null); 116c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project 117c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project assertNotNull(cursor); 118c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project assertTrue(cursor.moveToFirst()); 119c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project String actualString = cursor.getString(0); 120c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project assertEquals(expectedString.length(), actualString.length()); 121c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project for (int i = 0; i < expectedString.length(); i++) { 122c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project assertEquals((int)expectedString.charAt(i), (int)actualString.charAt(i)); 123c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project } 124c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project assertEquals(expectedString, actualString); 125c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project } finally { 126c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project if (cursor != null) cursor.close(); 127c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project } 128c39a6e0c51e182338deb8b63d07933b585134929The Android Open Source Project } 1291a44d5dcabc18cd5ef111f732ccff91683a1a093Neal Nguyen} 130