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