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

Example 11 with Person

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

the class FunctionalTest method testFillResult.

@Test
public void testFillResult() {
    Person person = randomPerson();
    data.insert(person);
    assertEquals(1, data.select(Person.class).get().collect(new HashSet<Person>()).size());
}

Example 12 with Person

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

the class FunctionalTest method testFindByKey.

@Test
public void testFindByKey() {
    Person person = randomPerson();
    data.insert(person);
    assertTrue(person.getId() > 0);
    Person other = data.findByKey(Person.class, person.getId());
    assertSame(person, other);
}

Example 13 with Person

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

the class FunctionalTest method testQueryUpdate.

@Test
public void testQueryUpdate() {
    Person person = randomPerson();
    person.setAge(100);
    data.insert(person);
    int rowCount = data.update(Person.class).set(Person.ABOUT, "nothing").set(Person.AGE, 50).where(Person.AGE.equal(100)).get().value();
    assertEquals(1, rowCount);
}

Example 14 with Person

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

the class FunctionalTest method testQueryCompoundConditions.

@Test
public void testQueryCompoundConditions() {
    Person person = randomPerson();
    person.setAge(75);
    data.insert(person);
    Person person2 = randomPerson();
    person2.setAge(10);
    person2.setName("Carol");
    data.insert(person2);
    Person person3 = randomPerson();
    person3.setAge(0);
    person3.setName("Bob");
    data.insert(person3);
    List<Person> result = data.select(Person.class).where(Person.AGE.gt(5).and(Person.AGE.lt(75)).and(Person.NAME.ne("Bob"))).or(Person.NAME.eq("Bob")).get().toList();
    assertTrue(result.contains(person2));
    assertTrue(result.contains(person3));
    result = data.select(Person.class).where(Person.AGE.gt(10).or(Person.AGE.eq(75))).and(Person.NAME.eq("Bob")).get().toList();
    assertTrue(result.isEmpty());
}

Example 15 with Person

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

the class FunctionalTest method testQuerySelectSubstr.

@Test
public void testQuerySelectSubstr() {
    // TODO fix for SQLServer
    Person person = randomPerson();
    person.setName("  Name");
    data.insert(person);
    Tuple result = data.select(Person.NAME.substr(3, 6).as("name")).get().first();
    String name = result.get(0);
    assertEquals(name, "Name");
}