Lines Matching refs:cursor
27 private SQLiteCursor cursor;
49 String[] columnNames = cursor.getColumnNames();
57 String[] columnNames = cursor.getColumnNames();
66 assertThat(cursor.getColumnIndex("id"), equalTo(0));
67 assertThat(cursor.getColumnIndex("name"), equalTo(1));
72 assertThat(cursor.getColumnIndex("Fred"), equalTo(-1));
79 assertThat(cursor.getColumnIndex("id"), equalTo(0));
80 assertThat(cursor.getColumnIndex("name"), equalTo(1));
85 assertThat(cursor.getColumnIndexOrThrow("id"), equalTo(0));
86 assertThat(cursor.getColumnIndexOrThrow("name"), equalTo(1));
91 cursor.getColumnIndexOrThrow("Fred");
98 assertThat(cursor.getColumnIndexOrThrow("name"), equalTo(1));
105 cursor.getColumnIndexOrThrow("Fred");
110 assertThat(cursor.moveToFirst(), equalTo(true));
111 assertThat(cursor.getInt(0), equalTo(1234));
112 assertThat(cursor.getString(1), equalTo("Chuck"));
119 assertThat(cursor.moveToFirst(), equalTo(false));
124 cursor.moveToFirst();
126 assertThat(cursor.moveToNext(), equalTo(true));
127 assertThat(cursor.getInt(0), equalTo(1235));
128 assertThat(cursor.getString(1), equalTo("Julie"));
133 cursor.moveToFirst();
135 cursor.moveToNext();
136 cursor.moveToNext();
137 cursor.moveToNext();
139 assertThat(cursor.moveToNext(), equalTo(false));
144 assertThat(cursor.getPosition(), equalTo(-1));
146 cursor.moveToFirst();
147 assertThat(cursor.getPosition(), equalTo(0));
148 cursor.moveToNext();
149 assertThat(cursor.getPosition(), equalTo(1));
150 cursor.moveToNext();
151 assertThat(cursor.getPosition(), equalTo(2));
153 cursor.moveToFirst();
154 assertThat(cursor.getPosition(), equalTo(0));
155 cursor.moveToNext();
156 assertThat(cursor.getPosition(), equalTo(1));
157 cursor.moveToNext();
158 assertThat(cursor.getPosition(), equalTo(2));
160 cursor.moveToPosition(1);
161 assertThat(cursor.getPosition(), equalTo(1));
168 cursor.moveToFirst();
169 assertThat(cursor.moveToNext(), equalTo(false));
174 cursor.moveToFirst();
175 cursor.moveToNext();
177 assertThat(cursor.moveToPrevious(), equalTo(true));
178 assertThat(cursor.getInt(0), equalTo(1234));
179 assertThat(cursor.getString(1), equalTo("Chuck"));
184 cursor.moveToFirst();
186 // Possible to move cursor before the first item
187 assertThat(cursor.moveToPrevious(), equalTo(true));
188 // After that, attempts to move cursor back return false
189 assertThat(cursor.moveToPrevious(), equalTo(false));
195 cursor.moveToFirst();
197 assertThat(cursor.moveToPrevious(), equalTo(false));
202 cursor.moveToFirst();
203 assertThat(cursor.getPosition(), equalTo(0));
205 cursor.moveToNext();
206 assertThat(cursor.getPosition(), equalTo(1));
219 cursor.moveToFirst();
221 byte[] retrievedByteData = cursor.getBlob(5);
239 cursor.moveToFirst();
241 String actual = cursor.getString(6);
247 cursor.moveToFirst();
252 assertThat(cursor.getString(1), equalTo(aData));
253 cursor.moveToNext();
259 cursor.moveToFirst();
264 assertThat(cursor.getInt(0), equalTo(aData));
265 cursor.moveToNext();
271 cursor.moveToFirst();
273 assertThat(cursor.getLong(2), equalTo(3463L));
278 cursor.moveToFirst();
280 assertThat(cursor.getFloat(3), equalTo((float) 1.5));
285 cursor.moveToFirst();
287 assertThat(cursor.getDouble(4), equalTo(3.14159));
292 assertThat(cursor.isClosed(), equalTo(false));
293 cursor.close();
294 assertThat(cursor.isClosed(), equalTo(true));
299 cursor.moveToFirst();
300 assertThat(cursor.moveToNext(), equalTo(true));
302 assertThat(cursor.isNull(cursor.getColumnIndex("id")), equalTo(false));
303 assertThat(cursor.isNull(cursor.getColumnIndex("name")), equalTo(false));
305 assertThat(cursor.isNull(cursor.getColumnIndex("long_value")), equalTo(true));
306 assertThat(cursor.isNull(cursor.getColumnIndex("float_value")), equalTo(true));
307 assertThat(cursor.isNull(cursor.getColumnIndex("double_value")), equalTo(true));
312 cursor.moveToFirst();
315 assertThat(cursor.isNull(i), equalTo(false));
321 cursor.moveToFirst();
324 assertThat(cursor.isNull(5), equalTo(true));
343 cursor = new SQLiteCursor(null, null, null, null);
344 Robolectric.shadowOf(cursor).setResultSet(resultSet, sql);