Examples with Person io.requery.test.model.Person used on opensource projects

Example 86 with Person

use of io.requery.test.model.Person in project requery by requery.

the class FunctionalTest method testQueryLike.

@Test
public void testQueryLike() {
    Person person = randomPerson();
    person.setName("Carol");
    data.insert(person);
    person = randomPerson();
    person.setName("Bob");
    data.insert(person);
    Person a = data.select(Person.class).where(Person.NAME.like("B%")).get().first();
    assertSame(a, person);
    a = data.select(Person.class).where(Person.NAME.lower().like("b%")).get().first();
    assertSame(a, person);
    Person b = data.select(Person.class).where(Person.NAME.notLike("B%")).get().firstOrNull();
    assertTrue(b != person);
}

Example 87 with Person

use of io.requery.test.model.Person in project requery by requery.

the class FunctionalTest method testInsertOneToMany.

@Test
public void testInsertOneToMany() {
    Person person = randomPerson();
    data.insert(person);
    Phone phone1 = randomPhone();
    Phone phone2 = randomPhone();
    phone1.setOwner(person);
    phone2.setOwner(person);
    data.insert(phone1);
    data.insert(phone2);
    HashSet<Phone> set = new HashSet<>(person.getPhoneNumbers().toList());
    assertEquals(2, set.size());
    assertTrue(set.containsAll(Arrays.asList(phone1, phone2)));
}

Example 88 with Person

use of io.requery.test.model.Person in project requery by requery.

the class FunctionalTest method testQueryBetween.

@Test
public void testQueryBetween() {
    Person person = randomPerson();
    person.setAge(75);
    data.insert(person);
    Person p = data.select(Person.class).where(Person.AGE.between(50, 100)).get().first();
    assertTrue(p == person);
}

Example 89 with Person

use of io.requery.test.model.Person in project requery by requery.

the class FunctionalTest method testQueryFromSub.

@Test
public void testQueryFromSub() {
    for (int i = 0; i < 10; i++) {
        Person person = randomPerson();
        person.setAge(i + 1);
        data.insert(person);
    }
    Integer result = data.select(NamedExpression.ofInteger("avg_age").avg()).from(data.select(Person.AGE.sum().as("avg_age")).groupBy(Person.AGE).as("t1")).get().first().get(0);
    // derby rounds up
    assertTrue(result >= 5);
}

Example 90 with Person

use of io.requery.test.model.Person in project requery by requery.

the class FunctionalTest method testDeleteBatch.

@Test
public void testDeleteBatch() {
    List<Person> persons = new ArrayList<>();
    for (int i = 0; i < 100; i++) {
        Person person = randomPerson();
        persons.add(person);
    }
    data.insert(persons);
    assertEquals(100, data.count(Person.class).get().value().intValue());
    data.delete(persons);
    assertEquals(0, data.count(Person.class).get().value().intValue());
}