Home | History | Annotate | Download | only in database

Lines Matching refs:cur

808             Cursor cur = mDatabase.rawQuery("PRAGMA table_info(pragma_test)", null);
809 Assert.assertEquals(5, cur.getCount());
811 Assert.assertTrue(cur.moveToNext());
813 cur.getString(TABLE_INFO_PRAGMA_COLUMNNAME_INDEX));
815 cur.getString(TABLE_INFO_PRAGMA_DEFAULT_INDEX));
817 Assert.assertTrue(cur.moveToNext());
819 cur.getString(TABLE_INFO_PRAGMA_COLUMNNAME_INDEX));
820 Assert.assertNull(cur.getString(TABLE_INFO_PRAGMA_DEFAULT_INDEX));
822 Assert.assertTrue(cur.moveToNext());
824 cur.getString(TABLE_INFO_PRAGMA_COLUMNNAME_INDEX));
826 cur.getString(TABLE_INFO_PRAGMA_DEFAULT_INDEX));
828 Assert.assertTrue(cur.moveToNext());
830 cur.getString(TABLE_INFO_PRAGMA_COLUMNNAME_INDEX));
831 Assert.assertNull(cur.getString(TABLE_INFO_PRAGMA_DEFAULT_INDEX));
833 Assert.assertTrue(cur.moveToNext());
835 cur.getString(TABLE_INFO_PRAGMA_COLUMNNAME_INDEX));
837 cur.getString(TABLE_INFO_PRAGMA_DEFAULT_INDEX));
839 cur.close();
849 Cursor cur;
867 cur = mDatabase.rawQuery("SELECT * FROM insert_test WHERE _id == " + row, null);
868 Assert.assertTrue(cur.moveToFirst());
869 Assert.assertEquals("one", cur.getString(1));
870 Assert.assertEquals("hello world", cur.getString(2));
871 Assert.assertNull(cur.getString(3));
872 Assert.assertEquals(1234, cur.getLong(4));
873 Assert.assertNull(cur.getString(5));
874 cur.close();
880 cur = mDatabase.rawQuery("SELECT * FROM insert_test WHERE _id == " + row, null);
881 Assert.assertTrue(cur.moveToFirst());
882 Assert.assertEquals("two", cur.getString(1));
883 Assert.assertEquals("goodbye world", cur.getString(2));
884 Assert.assertNull(cur.getString(3));
885 Assert.assertEquals(1234, cur.getLong(4));
886 Assert.assertNull(cur.getString(5));
887 cur.close();
900 cur = mDatabase.rawQuery("SELECT * FROM insert_test WHERE _id == " + row, null);
901 Assert.assertTrue(cur.moveToFirst());
902 Assert.assertEquals("three", cur.getString(1));
903 Assert.assertEquals("hello world", cur.getString(2));
904 Assert.assertEquals(2345, cur.getLong(3));
905 Assert.assertEquals(3456, cur.getLong(4));
906 Assert.assertEquals("tricky", cur.getString(5));
907 cur.close();
915 cur = mDatabase.rawQuery("SELECT * FROM insert_test WHERE _id == " + row, null);
916 Assert.assertTrue(cur.moveToFirst());
917 Assert.assertEquals("three", cur.getString(1));
918 Assert.assertEquals("hello world", cur.getString(2));
919 Assert.assertEquals(6789, cur.getLong(3));
920 cur.close();
935 Cursor cur = mDatabase.rawQuery("PRAGMA database_list;", null);
936 cur.close();
938 cur = mDatabase.rawQuery("PRAGMA database_list;;", null);
939 cur.close();
1042 Cursor cur = mDatabase.rawQuery(
1044 assertTrue(cur.moveToFirst());
1045 assertEquals("\u30A2\u30E1\u30EA\u30AB", cur.getString(1));
1046 assertTrue(cur.moveToNext());
1047 assertEquals("\uFF75\uFF77\uFF85\uFF9C", cur.getString(1));
1048 assertTrue(cur.moveToNext());
1049 assertEquals("\u306B\u307B\u3093", cur.getString(1));