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); } });
private void assertResultSize(int total, int size, @Nullable QueryModifiers modifiers) { // via list assertEquals(size, createQuery(modifiers).list($(entity)).size()); System.out.println(); // via results SearchResults<?> results = createQuery(modifiers).listResults($(entity)); assertEquals(total, results.getTotal()); assertEquals(size, results.getResults().size()); System.out.println(); // via iterator assertEquals(size, IteratorAdapter.asList(createQuery(modifiers).iterate($(entity))).size()); System.out.println(); }
@Test public void LocalizedMap2() { System.out.println("localizedMap2"); assertEquals(1, where(var.localizedAsMap.get(new Locale("en")).eq("en")).list(var).size()); assertEquals(1, where(var.localizedAsMap.get(new Locale("fi")).eq("en")).list(var).size()); assertEquals(0, where(var.localizedAsMap.get(new Locale("")).eq("en")).list(var).size()); }
@Test(expected = IllegalArgumentException.class) public void in_empty() { where(var.directProperty.in(Collections.<String> emptySet())).list(var); }
@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 TypeOf() { System.out.println("typeOf"); assertEquals(2, where(var.instanceOf(SimpleType.class)).list(var).size()); }
@Test public void LocalizedMap() { System.out.println("localizedMap"); assertEquals(1, where(var.localizedAsMap.get(new Locale("fi")).eq("fi")).list(var).size()); assertEquals(1, where(var.localizedAsMap.get(new Locale("en")).eq("fi")).list(var).size()); assertEquals(0, where(var.localizedAsMap.get(new Locale("")).eq("fi")).list(var).size()); }
@Test public void Query_For_Notes() { 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 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 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()); }