use of io.requery.test.model.Person in project requery by requery.
the class FunctionalTest method testQueryNotNull.
@Test
public void testQueryNotNull() {
for (int i = 0; i < 10; i++) {
Person person = randomPerson();
data.insert(person);
}
assertNotNull(data.select(Person.class).where(Person.NAME.notNull()).get().first());
}
use of io.requery.test.model.Person in project requery by requery.
the class FunctionalTest method testQueryEqualsIgnoreCase.
@Test
public void testQueryEqualsIgnoreCase() {
Person person = randomPerson();
person.setName("Carol");
data.insert(person);
Person a = data.select(Person.class).where(Person.NAME.equalsIgnoreCase("carol")).get().first();
assertSame(a, person);
}
use of io.requery.test.model.Person in project requery by requery.
the class FunctionalTest method testListResult.
@Test
public void testListResult() {
Person person = randomPerson();
data.insert(person);
assertEquals(1, data.select(Person.class).get().toList().size());
}
use of io.requery.test.model.Person in project requery by requery.
the class FunctionalTest method testQueryConsume.
@Test
public void testQueryConsume() {
int count = 10;
for (int i = 0; i < count; i++) {
Person person = randomPerson();
data.insert(person);
}
final int[] counts = new int[] { 0 };
Result<Person> result = data.select(Person.class).get();
result.each(new Consumer<Person>() {
@Override
public void accept(Person e) {
counts[0] = counts[0] + 1;
}
});
assertEquals(counts[0], count);
}
use of io.requery.test.model.Person in project requery by requery.
the class FunctionalTest method testQuerySelectMin.
@SuppressWarnings("MagicConstant")
@Test
public void testQuerySelectMin() {
for (int i = 0; i < 10; i++) {
Person person = randomPerson();
if (i == 9) {
Calendar calendar = Calendar.getInstance();
calendar.set(1800, Calendar.NOVEMBER, 11, 0, 0, 0);
person.setBirthday(calendar.getTime());
}
data.insert(person);
}
try (Result<Tuple> query = data.select(Person.BIRTHDAY.min().as("oldestBday")).get()) {
Date date = query.first().get("oldestBday");
Calendar c = Calendar.getInstance();
c.setTime(date);
// just check the year...
assertTrue(c.get(Calendar.YEAR) == 1800);
}
}
Aggregations