Пример #1
0
 @Test
 public void testQueryKey() {
   XCriteriaBuilder cb = this.getEntityManager().getCriteriaBuilder();
   XCriteriaQuery<String> cq = cb.createQuery(String.class);
   XRoot<Computer> computer = cq.from(Computer.class);
   cq.where(cb.equal(computer.get(Computer_.id), 1L));
   cq.select(computer.join(Computer_.cpus).key());
   List<String> keys = this.getEntityManager().createQuery(cq).getResultList();
   Assert.assertEquals(2, keys.size());
   Assert.assertEquals("first-cpu", keys.get(0));
   Assert.assertEquals("second-cpu", keys.get(1));
 }
Пример #2
0
 @Test
 public void testQueryValue() {
   XCriteriaBuilder cb = this.getEntityManager().getCriteriaBuilder();
   XCriteriaQuery<CPU> cq = cb.createQuery(CPU.class);
   XRoot<Computer> computer = cq.from(Computer.class);
   cq.where(cb.equal(computer.get(Computer_.id), 1L));
   cq.select(computer.join(Computer_.cpus).value());
   List<CPU> values = this.getEntityManager().createQuery(cq).getResultList();
   Assert.assertEquals(2, values.size());
   Assert.assertEquals(1L, values.get(0).getId().longValue());
   Assert.assertEquals("Intel Core-i5", values.get(0).getName());
   Assert.assertEquals(2L, values.get(1).getId().longValue());
   Assert.assertEquals("Intel Core-i7", values.get(1).getName());
 }
Пример #3
0
 @SuppressWarnings({"unchecked", "rawtypes"})
 @Test
 public void testQueryEntry() {
   XCriteriaBuilder cb = this.getEntityManager().getCriteriaBuilder();
   XCriteriaQuery<Entry<String, CPU>> cq = (XCriteriaQuery) cb.createQuery(Entry.class);
   XRoot<Computer> computer = cq.from(Computer.class);
   cq.where(cb.equal(computer.get(Computer_.id), 1L));
   cq.orderBy(cb.asc(computer.join(Computer_.cpus).key()));
   cq.select(computer.join(Computer_.cpus).entry());
   List<Entry<String, CPU>> entries = this.getEntityManager().createQuery(cq).getResultList();
   Assert.assertEquals(2, entries.size());
   Assert.assertEquals("first-cpu", entries.get(0).getKey());
   Assert.assertEquals(1L, entries.get(0).getValue().getId().longValue());
   Assert.assertEquals("Intel Core-i5", entries.get(0).getValue().getName());
   Assert.assertEquals("second-cpu", entries.get(1).getKey());
   Assert.assertEquals(2L, entries.get(1).getValue().getId().longValue());
   Assert.assertEquals("Intel Core-i7", entries.get(1).getValue().getName());
 }