MatrixCursorTest.java revision 9066cfe9886ac131c34d59ed0e2d287b0e3c0087
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 179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpackage android.database; 189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport junit.framework.TestCase; 209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.*; 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic class MatrixCursorTest extends TestCase { 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testEmptyCursor() { 269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Cursor cursor = new MatrixCursor(new String[] { "a" }); 279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(0, cursor.getCount()); 289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testNullValue() { 319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project MatrixCursor cursor = new MatrixCursor(new String[] { "a" }); 329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.newRow().add(null); 339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToNext(); 349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertTrue(cursor.isNull(0)); 359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testMatrixCursor() { 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project MatrixCursor cursor = newMatrixCursor(); 399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.newRow() 419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add("a") 429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add(1) 439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add(2) 449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add(3) 459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add(4) 469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add(5); 479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToNext(); 499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkValues(cursor); 519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.newRow() 539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add("a") 549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add("1") 559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add("2") 569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add("3") 579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add("4") 589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project .add("5"); 599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToNext(); 619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkValues(cursor); 629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToPrevious(); 649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkValues(cursor); 659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testAddArray() { 689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project MatrixCursor cursor = newMatrixCursor(); 699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.addRow(new Object[] { "a", 1, 2, 3, 4, 5 }); 719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToNext(); 729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkValues(cursor); 739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.addRow(new Object[0]); 769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project fail(); 779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (IllegalArgumentException e) { /* expected */ } 789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testAddIterable() { 819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project MatrixCursor cursor = newMatrixCursor(); 829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.addRow(Arrays.asList("a", 1, 2, 3, 4, 5)); 849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToNext(); 859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkValues(cursor); 869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.addRow(Collections.emptyList()); 899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project fail(); 909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (IllegalArgumentException e) { /* expected */ } 919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.addRow(Arrays.asList("a", 1, 2, 3, 4, 5, "Too many!")); 949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project fail(); 959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (IllegalArgumentException e) { /* expected */ } 969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void testAddArrayList() { 999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project MatrixCursor cursor = newMatrixCursor(); 1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.addRow(new NonIterableArrayList<Object>( 1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Arrays.asList("a", 1, 2, 3, 4, 5))); 1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToNext(); 1049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkValues(cursor); 1059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 1079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.addRow(new NonIterableArrayList<Object>()); 1089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project fail(); 1099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (IllegalArgumentException e) { /* expected */ } 1109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 1129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.addRow(new NonIterableArrayList<Object>( 1139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Arrays.asList("a", 1, 2, 3, 4, 5, "Too many!"))); 1149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project fail(); 1159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (IllegalArgumentException e) { /* expected */ } 1169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project static class NonIterableArrayList<T> extends ArrayList<T> { 1199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project NonIterableArrayList() {} 1219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project NonIterableArrayList(Collection<? extends T> ts) { 1239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project super(ts); 1249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 1279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public Iterator<T> iterator() { 1289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new AssertionError(); 1299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private MatrixCursor newMatrixCursor() { 1339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return new MatrixCursor(new String[] { 1349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "string", "short", "int", "long", "float", "double" }); 1359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private void checkValues(MatrixCursor cursor) { 1389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals("a", cursor.getString(0)); 1399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(1, cursor.getShort(1)); 1409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(2, cursor.getInt(2)); 1419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(3, cursor.getLong(3)); 1429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(4.0f, cursor.getFloat(4)); 1439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project assertEquals(5.0D, cursor.getDouble(5)); 1449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project} 147