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

Example 16 with Person

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

the class FunctionalTest method testInsertOneToManyInverse.

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

Example 17 with Person

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

the class FunctionalTest method testFindByCompositeKey.

@Test
public void testFindByCompositeKey() {
    Group group = new Group();
    group.setName("group");
    group.setType(GroupType.PRIVATE);
    Person person = randomPerson();
    person.getGroups().add(group);
    data.insert(person);
    assertTrue(person.getId() > 0);
    // create the composite key
    Map<Attribute<Group_Person, Integer>, Integer> map = new LinkedHashMap<>();
    map.put(Group_Person.GROUPS_ID, group.getId());
    map.put(Group_Person.PERSON_ID, person.getId());
    CompositeKey<Group_Person> compositeKey = new CompositeKey<>(map);
    Group_Person joined = data.findByKey(Group_Person.class, compositeKey);
    assertNotNull(joined);
}

Example 18 with Person

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

the class FunctionalTest method testQuerySelectTrim.

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

Example 19 with Person

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

the class FunctionalTest method testQueryFunctionRandom.

@Test
public void testQueryFunctionRandom() {
    for (int i = 0; i < 10; i++) {
        Person person = randomPerson();
        data.insert(person);
    }
    try (Result<Person> query = data.select(Person.class).orderBy(new Random()).get()) {
        assertEquals(10, query.toList().size());
    }
}

Example 20 with Person

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

the class FunctionalTest method testInsertOneToManyInverseUpdate.

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