private void scanCursor(SquidCursor<Thing> cursor, String formatString) { for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { int i = cursor.getPosition(); assertEquals(String.format(formatString, i), cursor.get(Thing.FOO)); } }
assertEquals(rowsWithManager, cursor.getCount()); int index = 0; for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext(), index++) { String eName = cursor.get(employeeName); String mName = cursor.get(managerName);
int index = 0; int start = offset > 0 ? offset : 0; for (cursor.moveToPosition(start); !cursor.isAfterLast(); cursor.moveToNext()) { if (index == expectedIds.length) { break; try { int index = 0; for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { assertEquals(expectedIds[index++], cursor.get(Employee.ID).intValue());
for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { long id = cursor.get(Employee.ID); String coworkersList = cursor.get(coworkers);
try { int index = 0; for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { int newValue = cursor.get(TestModel.LUCKY_NUMBER) + 1; expectedResults[index++] = newValue; try { int index = 0; for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { assertEquals(expectedResults[index++], cursor.get(TestModel.LUCKY_NUMBER).intValue());
int numTestModels = modelCursor.getCount(); try { for (modelCursor.moveToFirst(); !modelCursor.isAfterLast(); modelCursor.moveToNext()) { int luckyNumber = modelCursor.get(TestModel.LUCKY_NUMBER); expectedBefore.add(luckyNumber); assertEquals(expectedTriggers, triggerCursor.getCount()); for (triggerCursor.moveToFirst(); !triggerCursor.isAfterLast(); triggerCursor.moveToNext()) { int before = triggerCursor.get(TriggerTester.VALUE_1); int after = triggerCursor.get(TriggerTester.VALUE_2);
assertEquals(3, cursor.getCount()); ThingJoin thingJoin = new ThingJoin(); for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { int position = cursor.getPosition(); thingJoin.readPropertiesFromCursor(cursor);
public void testOrderByField() { TestModel one = new TestModel().setFirstName("Sam").setLastName("Bosley"); TestModel two = new TestModel().setFirstName("Kevin").setLastName("Lim"); TestModel three = new TestModel().setFirstName("Jonathan").setLastName("Koren"); database.persist(one); database.persist(two); database.persist(three); String[] nameOrder = new String[]{"Kevin", "Sam", "Jonathan"}; SquidCursor<TestModel> nameOrderCursor = database.query(TestModel.class, Query.select(TestModel.PROPERTIES) .orderBy(Order.byArray(TestModel.FIRST_NAME, nameOrder))); try { assertEquals(3, nameOrderCursor.getCount()); for (nameOrderCursor.moveToFirst(); !nameOrderCursor.isAfterLast(); nameOrderCursor.moveToNext()) { assertEquals(nameOrder[nameOrderCursor.getPosition()], nameOrderCursor.get(TestModel.FIRST_NAME)); } } finally { nameOrderCursor.close(); } Long[] idOrder = new Long[]{3L, 1L, 2L}; SquidCursor<TestModel> idOrderCursor = database.query(TestModel.class, Query.select(TestModel.PROPERTIES) .orderBy(Order.byArray(TestModel.ID, idOrder))); try { assertEquals(3, idOrderCursor.getCount()); for (idOrderCursor.moveToFirst(); !idOrderCursor.isAfterLast(); idOrderCursor.moveToNext()) { assertEquals(idOrder[idOrderCursor.getPosition()], idOrderCursor.get(TestModel.ID)); } } finally { idOrderCursor.close(); } }
public void testJoinOnLiteralValue() { TestModel modelOne = new TestModel().setFirstName("Sam").setLastName("Bosley"); TestModel modelTwo = new TestModel().setFirstName("Kevin").setLastName("Lim"); TestModel modelThree = new TestModel().setFirstName("Jonathan").setLastName("Koren"); Thing thingOne = new Thing().setFoo("Thing1").setBar(5); Thing thingTwo = new Thing().setFoo("Thing2").setBar(-1); Thing thingThree = new Thing().setFoo("Thing3").setBar(100); database.persist(modelOne); database.persist(modelTwo); database.persist(modelThree); database.persist(thingOne); database.persist(thingTwo); database.persist(thingThree); Query query = Query.select(TestModel.FIRST_NAME, TestModel.LAST_NAME).selectMore(Thing.FOO, Thing.BAR) .from(TestModel.TABLE) .join(Join.inner(Thing.TABLE, Thing.BAR.gt(0))); SquidCursor<TestModel> cursor = database.query(TestModel.class, query); try { assertEquals(6, cursor.getCount()); for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { assertTrue(cursor.get(Thing.BAR) > 0); } } finally { cursor.close(); } }
assertTrue(cursor.getCount() > 0); try { for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) { assertTrue(cursor.get(TriggerTester.VALUE_2) > threshold);