@Override protected CursorQuery<T2> createQuery() { return new CursorQuery<T2>(this, dao, sql, initialValues.clone(), limitPosition, offsetPosition); }
/** Executes the query and returns a raw android.database.Cursor. Don't forget to close it. */ public Cursor query() { checkThread(); return dao.getDatabase().rawQuery(sql, parameters); }
/** For internal use by greenDAO only. */ public static <T2> CursorQuery<T2> internalCreate(AbstractDao<T2, ?> dao, String sql, Object[] initialValues) { return create(dao, sql, initialValues, -1, -1); }
static <T2> CursorQuery<T2> create(AbstractDao<T2, ?> dao, String sql, Object[] initialValues, int limitPosition, int offsetPosition) { QueryData<T2> queryData = new QueryData<T2>(dao, sql, toStringArray(initialValues), limitPosition, offsetPosition); return queryData.forCurrentThread(); }
public void testCursorQuerySimple() { insert(3); CursorQuery query = dao.queryBuilder().orderAsc(Properties.SimpleInteger).buildCursor(); Cursor cursor = query.query(); try { assertEquals(3, cursor.getCount()); assertTrue(cursor.moveToNext()); int columnIndex = cursor.getColumnIndexOrThrow(Properties.SimpleInteger.columnName); assertEquals(getSimpleInteger(0), cursor.getInt(columnIndex)); assertTrue(cursor.moveToNext()); assertEquals(getSimpleInteger(1), cursor.getInt(columnIndex)); assertTrue(cursor.moveToNext()); assertEquals(getSimpleInteger(2), cursor.getInt(columnIndex)); assertFalse(cursor.moveToNext()); } finally { cursor.close(); } }
static <T2> CursorQuery<T2> create(AbstractDao<T2, ?> dao, String sql, Object[] initialValues, int limitPosition, int offsetPosition) { QueryData<T2> queryData = new QueryData<T2>(dao, sql, toStringArray(initialValues), limitPosition, offsetPosition); return queryData.forCurrentThread(); }
/** * Builds a reusable query object for low level android.database.Cursor access. * (Query objects can be executed more efficiently than creating a QueryBuilder for each execution. */ public CursorQuery buildCursor() { StringBuilder builder = createSelectBuilder(); int limitPosition = checkAddLimit(builder); int offsetPosition = checkAddOffset(builder); String sql = builder.toString(); checkLog(sql); return CursorQuery.create(dao, sql, values.toArray(), limitPosition, offsetPosition); }
@Override protected CursorQuery<T2> createQuery() { return new CursorQuery<T2>(this, dao, sql, initialValues.clone(), limitPosition, offsetPosition); }
/** Executes the query and returns a raw android.database.Cursor. Don't forget to close it. */ public Cursor query() { checkThread(); return dao.getDatabase().rawQuery(sql, parameters); }
/** For internal use by greenDAO only. */ public static <T2> CursorQuery<T2> internalCreate(AbstractDao<T2, ?> dao, String sql, Object[] initialValues) { return create(dao, sql, initialValues, -1, -1); }
/** * Builds a reusable query object for low level android.database.Cursor access. * (Query objects can be executed more efficiently than creating a QueryBuilder for each execution. */ public CursorQuery buildCursor() { StringBuilder builder = createSelectBuilder(); int limitPosition = checkAddLimit(builder); int offsetPosition = checkAddOffset(builder); String sql = builder.toString(); checkLog(sql); return CursorQuery.create(dao, sql, values.toArray(), limitPosition, offsetPosition); }