CursorWindowTest.java revision 9066cfe9886ac131c34d59ed0e2d287b0e3c0087
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 com.android.unit_tests; 189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.AbstractCursor; 209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.test.suitebuilder.annotation.SmallTest; 219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport com.android.internal.database.ArrayListCursor; 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.CursorWindow; 239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.test.PerformanceTestCase; 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport com.google.android.collect.Lists; 269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.ArrayList; 289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.Arrays; 299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.Random; 309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport junit.framework.TestCase; 329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic class CursorWindowTest extends TestCase implements PerformanceTestCase { 349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public boolean isPerformanceOnly() { 359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return false; 369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // These test can only be run once. 399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public int startPerformance(Intermediates intermediates) { 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return 1; 419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @SmallTest 449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testWriteCursorToWindow() throws Exception { 459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // create cursor 469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] colNames = new String[]{"name", "number", "profit"}; 479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int colsize = colNames.length; 489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ArrayList<ArrayList> list = createTestList(10, colsize); 499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project AbstractCursor cursor = new ArrayListCursor(colNames, (ArrayList<ArrayList>) list); 509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // fill window 529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project CursorWindow window = new CursorWindow(false); 539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.fillWindow(0, window); 549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // read from cursor window 569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < list.size(); i++) { 579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ArrayList<Integer> col = list.get(i); 589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int j = 0; j < colsize; j++) { 599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String s = window.getString(i, j); 609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int r2 = col.get(j); 619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int r1 = Integer.parseInt(s); 629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(r2, r1); 639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // test cursor window handle startpos != 0 679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project window.clear(); 689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.fillWindow(1, window); 699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // read from cursor from window 709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 1; i < list.size(); i++) { 719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ArrayList<Integer> col = list.get(i); 729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int j = 0; j < colsize; j++) { 739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String s = window.getString(i, j); 749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int r2 = col.get(j); 759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int r1 = Integer.parseInt(s); 769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(r2, r1); 779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // Clear the window and make sure it's empty 819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project window.clear(); 829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(0, window.getNumRows()); 839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @SmallTest 869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testValuesLocalWindow() { 879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project doTestValues(new CursorWindow(true)); 889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @SmallTest 919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testValuesRemoteWindow() { 929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project doTestValues(new CursorWindow(false)); 939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private void doTestValues(CursorWindow window) { 969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.setNumColumns(7)); 979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.allocRow()); 989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project double db1 = 1.26; 999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.putDouble(db1, 0, 0)); 1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project double db2 = window.getDouble(0, 0); 1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(db1, db2); 1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project long int1 = Long.MAX_VALUE; 1049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.putLong(int1, 0, 1)); 1059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project long int2 = window.getLong(0, 1); 1069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(int1, int2); 1079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.putString("1198032740000", 0, 3)); 1099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals("1198032740000", window.getString(0, 3)); 1109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(1198032740000L, window.getLong(0, 3)); 1119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.putString(Long.toString(1198032740000L), 0, 3)); 1139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(Long.toString(1198032740000L), window.getString(0, 3)); 1149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(1198032740000L, window.getLong(0, 3)); 1159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.putString(Double.toString(42.0), 0, 4)); 1179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(Double.toString(42.0), window.getString(0, 4)); 1189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(42.0, window.getDouble(0, 4)); 1199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // put blob 1219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project byte[] blob = new byte[1000]; 1229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project byte value = 99; 1239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Arrays.fill(blob, value); 1249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.putBlob(blob, 0, 6)); 1259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(Arrays.equals(blob, window.getBlob(0, 6))); 1269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @SmallTest 1299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testNull() { 1309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project CursorWindow window = getOneByOneWindow(); 1319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // Put in a null value and read it back as various types 1339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.putNull(0, 0)); 1349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertNull(window.getString(0, 0)); 1359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(0, window.getLong(0, 0)); 1369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(0.0, window.getDouble(0, 0)); 1379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertNull(window.getBlob(0, 0)); 1389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @SmallTest 1419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testEmptyString() { 1429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project CursorWindow window = getOneByOneWindow(); 1439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // put size 0 string and read it back as various types 1459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.putString("", 0, 0)); 1469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals("", window.getString(0, 0)); 1479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(0, window.getLong(0, 0)); 1489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(0.0, window.getDouble(0, 0)); 1499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private CursorWindow getOneByOneWindow() { 1529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project CursorWindow window = new CursorWindow(false); 1539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.setNumColumns(1)); 1549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(window.allocRow()); 1559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return window; 1569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static ArrayList<ArrayList> createTestList(int rows, int cols) { 1599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ArrayList<ArrayList> list = Lists.newArrayList(); 1609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Random generator = new Random(); 1619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < rows; i++) { 1639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ArrayList<Integer> col = Lists.newArrayList(); 1649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project list.add(col); 1659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int j = 0; j < cols; j++) { 1669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // generate random number 1679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Integer r = generator.nextInt(); 1689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project col.add(r); 1699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return list; 1729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project} 174