public void testEmptyProjectionWithMapUsesDefault() { final Field<?>[] expectedProjection = new Field<?>[]{ TestModel.ID, TestModel.FIRST_NAME.as(COL_GIVEN_NAME), TestModel.LAST_NAME.as(COL_SURNAME), TestModel.LUCKY_NUMBER, TestModel.IS_HAPPY }; ContentProviderQueryBuilder builder = getBuilder(); Query query = builder.setDataSource(TestModel.TABLE).build(null, null, null, null); assertEquals(Arrays.asList(expectedProjection), query.getFields()); }
@Override @SuppressWarnings("unchecked") public EnumProperty<T> as(SqlTable<?> newTable, String columnAlias) { return (EnumProperty<T>) super.as(newTable, columnAlias); }
@Override @SuppressWarnings("unchecked") public EnumProperty<T> as(String tableAlias, String columnAlias) { return (EnumProperty<T>) super.as(tableAlias, columnAlias); }
@Override @SuppressWarnings("unchecked") public EnumProperty<T> as(String newAlias) { return (EnumProperty<T>) super.as(newAlias); }
public void testSubqueryJoin() { StringProperty managerName = Employee.NAME.as("managerName"); Query query = Query .fromSubquery(Query.select(Employee.MANAGER_ID).from(Employee.TABLE).groupBy(Employee.MANAGER_ID), "subquery"); query.selectMore(managerName); query.join(Join.inner(Employee.TABLE, query.getTable().qualifyField(Employee.MANAGER_ID).eq(Employee.ID))) .orderBy(Employee.MANAGER_ID.asc()); SquidCursor<Employee> cursor = database.query(Employee.class, query); try { assertEquals(3, cursor.getCount()); cursor.moveToFirst(); assertEquals("bigBird", cursor.get(managerName)); cursor.moveToNext(); assertEquals("cookieMonster", cursor.get(managerName)); cursor.moveToNext(); assertEquals("bert", cursor.get(managerName)); } finally { cursor.close(); } }
@Override @SuppressWarnings("unchecked") public JSONProperty<T> as(SqlTable<?> newTable, String columnAlias) { return (JSONProperty<T>) super.as(newTable, columnAlias); }
@Override @SuppressWarnings("unchecked") public JSONProperty<T> as(String tableAlias, String columnAlias) { return (JSONProperty<T>) super.as(tableAlias, columnAlias); }
@Override @SuppressWarnings("unchecked") public JSONProperty<T> as(String newAlias) { return (JSONProperty<T>) super.as(newAlias); }
@Override @SuppressWarnings("unchecked") public EnumProperty<T> as(SqlTable<?> newTable, String columnAlias) { return (EnumProperty<T>) super.as(newTable, columnAlias); }
@Override @SuppressWarnings("unchecked") public EnumProperty<T> as(String tableAlias, String columnAlias) { return (EnumProperty<T>) super.as(tableAlias, columnAlias); }
@Override @SuppressWarnings("unchecked") public EnumProperty<T> as(String newAlias) { return (EnumProperty<T>) super.as(newAlias); }