@Override public Long doInSession(Session session) { BeanQuery countQry = session.from(sources); if (condition != null) { countQry.where(condition); } return countQry.count(); } });
@Test public void AllDistinctInstances() { System.out.println("allDistinctInstances"); assertEquals(2, session.from(var).listDistinct(var).size()); }
@Override protected Pair<Projectable, Expression<?>[]> createQuery(Predicate filter) { return Pair.of((Projectable) session.from(v1, v2).where(filter), new Expression<?>[] { v1, v2 }); } };
public List<T> doInSession(Session session) { BeanQuery qry = session.from(sources).offset(from).limit(to - from).orderBy(order); if (condition != null) { qry.where(condition); } return qry.list(projection); } });
@Test public void QueryAll() { System.out.println("Query all notes"); PathBuilder<Note> note = new PathBuilder<Note>(Note.class, "note"); List<Note> notes = session.from(note).list(note); assertEquals(2, notes.size()); }
@Test public void List() { List<SimpleType> result = session.from(var).list(projection); assertEquals(4, result.size()); for (SimpleType st : result) { assertNotNull(st.directProperty); } }
@Test(expected = IllegalArgumentException.class) public void FindUnknown2() { // launchpad bug : #576846 PathBuilder<SessionTest> entity = new PathBuilder<SessionTest>(SessionTest.class, "var"); session.from(entity).list(entity); }
@Test public void UniqueResult() { assertTrue(session.from(var).limit(1).uniqueResult(projection) instanceof SimpleType); }
@Test public void ById() { System.out.println("byId"); String id = session.from(var).list(var.id).get(0); instance = where(var.id.eq(id)).uniqueResult(var); assertNotNull(instance); assertEquals(id, instance.getId()); }
@Test public void ByIdNegated() { System.out.println("byIdNegated"); instances = session.from(var).list(var); instance = where(var.id.ne(instances.get(0).getId())).uniqueResult(var); assertNotNull(instance); assertEquals(instances.get(1).getId(), instance.getId()); }
@Test public void OrderBy() throws IOException { session.save(new User()); User user = Alias.alias(User.class, "user"); List<String> results = session.from($(user)).list($(user.getFirstName())); assertFalse(results.isEmpty()); assertNull(results.get(0)); }
@Test public void Counts() { assertEquals(1, session.from($(e1)).where($(e1.getProperty()).isNotNull()).list($(e1)).size()); assertEquals(1, session.from($(e2)).where($(e2.getProperty()).isNotNull()).list($(e2)).size()); assertEquals(1, session.from($(e3)).where($(e3.getProperty()).isNotNull()).list($(e3)).size()); }
@Test public void List_uses_Cache() { Session session = SessionUtil.openSession(Example.class); Example example1 = new Example(); Example example2 = new Example(); session.saveAll(example1, example2); Example var = Alias.alias(Example.class); List<Example> examples = session.from($(var)).list($(var)); assertTrue(examples.contains(example1)); assertTrue(examples.contains(example2)); }
@Test public void List_populates_Cache() { Session session = SessionUtil.openSession(Example.class); Example example1 = new Example(); Example example2 = new Example(); session.saveAll(example1, example2); session.clear(); Example var = Alias.alias(Example.class); List<Example> examples = session.from($(var)).list($(var)); assertTrue(examples.contains(session.getById(example1.id, Example.class))); assertTrue(examples.contains(session.getById(example2.id, Example.class))); }
@Test public void test3() { BeanQuery query = session.from($(n)); BooleanBuilder filter = new BooleanBuilder(); filter.or($(n.getTypes()).contains(NoteType.TYPE1)); filter.or($(n.getTypes()).contains(NoteType.TYPE2)); assertEquals(1, query.where(filter).list($(n)).size()); }
@Test public void order() { session.save(new Note(NoteType.A)); session.save(new Note(NoteType.B)); session.flush(); assertEquals( Arrays.asList(null, NoteType.A, NoteType.B, NoteType.TYPE1), session.from($(n)).orderBy($(n.getType()).asc()).list($(n.getType()))); }
@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 test() { Entity1 entity1 = new Entity1(); Entity2 entity2 = new Entity2(); session.save(entity1); session.save(entity2); Entity1 e1 = Alias.alias(Entity1.class); Entity2 e2 = Alias.alias(Entity2.class); SimplePath<ID> idPath = new SimplePath<ID>(ID.class, $(e1), "id"); assertEquals(entity1, session.from($(e1)).where(idPath.eq(entity1.getId())).uniqueResult($(e1))); assertEquals(entity2, session.from($(e2)).where($(e2.getId()).eq(entity2.getId())).uniqueResult($(e2))); }
@Test public void test() { EntityRevision revision = new EntityRevision(); revision.text = "a bcd e"; session.save(revision); session.flush(); session.clear(); EntityRevision var = Alias.alias(EntityRevision.class); assertNotNull(session.from($(var)).where($(var.getText()).containsIgnoreCase("a bcd e")).uniqueResult($(var))); }