@Test public void deepPaths() { NoteRevision rev1 = new NoteRevision(); NoteRevision rev2 = new NoteRevision(); Note note = new Note(); note.latestRevision = rev1; rev1.note = note; rev2.note = note; session.saveAll(note, rev1, rev2); NoteRevision noteVar = Alias.alias(NoteRevision.class); Predicate where = $(noteVar).eq($(noteVar.getNote().getLatestRevision())); assertEquals(1, session.from($(noteVar)).where(where).list($(noteVar)).size()); }
@Test public void ResultSetAssertions() { assertEquals(1l, from($(u)).count()); assertEquals(1l, from($(u)).list($(u.getUserName())).size()); // where 1 assertEquals(1l, from($(u)).where($(u).eq(sample)).count()); assertEquals(0l, from($(u)).where($(u).ne(sample)).count()); assertEquals(1, from($(u)).where($(u).eq(sample)).list($(u)).size()); assertEquals(0, from($(u)).where($(u).ne(sample)).list($(u)).size()); // where 2 assertEquals(1l, from($(u)).where($(u.getUserName()).eq("Bobby")).count()); assertEquals(0l, from($(u)).where($(u.getUserName()).ne("Bobby")).count()); assertEquals(1, from($(u)).where($(u.getUserName()).eq("Bobby")).list($(u)).size()); assertEquals(0, from($(u)).where($(u.getUserName()).ne("Bobby")).list($(u)).size()); }
@Test public void test() { Company company = new Company(); Department department = new Department(); Employee employee = new Employee(); employee.department = department; department.company = company; session.save(company); session.save(department); session.save(employee); session.flush(); session.clear(); Company c = Alias.alias(Company.class); Department d = Alias.alias(Department.class); Employee e = Alias.alias(Employee.class); // count instances assertEquals(1l, session.from($(c)).count()); assertEquals(1l, session.from($(d)).count()); assertEquals(1l, session.from($(e)).count()); // direct assertEquals(1l, session.from($(d)).where($(d.getCompany()).eq(company)).count()); assertEquals(1l, session.from($(d)).where($(d.getCompany()).eq(company)).count()); assertEquals(1l, session.from($(e)).where($(e.getDepartment()).eq(department)).count()); // inverse assertEquals(1l, session.from($(c)).where($(c.getDepartment()).eq(department)).count()); assertEquals(1l, session.from($(c)).where($(c.getDepartments()).contains(department)).count()); assertEquals(1l, session.from($(d)).where($(d.getEmployees()).contains(employee)).count()); }
builder.or($(var.getText()).containsIgnoreCase("abc")); builder.or($(var.getRevisionOf().getTerm().getText2()).containsIgnoreCase("abc")); builder.and($(var).eq($(var.getRevisionOf().getLatestRevision()))); assertEquals(1, session.from($(var)).where(builder.getValue()).list($(var)).size()); builder.or($(var.getText()).containsIgnoreCase("def")); builder.or($(var.getRevisionOf().getTerm().getText2()).containsIgnoreCase("def")); builder.and($(var).eq($(var.getRevisionOf().getLatestRevision()))); assertEquals(1, session.from($(var)).where(builder.getValue()).list($(var)).size());
builder.and($(noteVar.getNote().getLatestRevision()).eq($(noteVar))); builder.or($(noteVar.getLemma()).containsIgnoreCase("c")); builder.or($(noteVar.getNote().getTerm().getMeaning()).containsIgnoreCase("c"));