@Test public void Max() { assertToString("max(cat.bodyWeight)", cat.bodyWeight.max()); }
@Test public void Aggregates_List_Max() { assertEquals(Integer.valueOf(6), query().from(cat).list(cat.id.max()).get(0)); }
@Test public void Aggregates_UniqueResult_Max() { assertEquals(Integer.valueOf(6), query().from(cat).uniqueResult(cat.id.max())); }
@Test public void Max() { query().from(cat).uniqueResult(cat.bodyWeight.max()); }
@Test public void EntityQueries3() { QCat catEntity = new QCat("animal_"); query().from(catEntity).list(catEntity.toes.max()); }
@Test public void DocoExamples95() throws Exception { query().from(cat) .select(cat.weight.avg(), cat.weight.sum(), cat.weight.max(), cat.count()) .parse(); }
@Test @SuppressWarnings("unchecked") public void Union_All() { SubQueryExpression<Integer> sq1 = sq().from(cat).unique(cat.id.max()); SubQueryExpression<Integer> sq2 = sq().from(cat).unique(cat.id.min()); List<Integer> list = query().unionAll(sq1, sq2).list(); assertFalse(list.isEmpty()); }
@Test @SuppressWarnings("unchecked") public void Union() throws SQLException { SubQueryExpression<Integer> sq1 = sq().from(cat).unique(cat.id.max()); SubQueryExpression<Integer> sq2 = sq().from(cat).unique(cat.id.min()); List<Integer> list = query().union(sq1, sq2).list(); assertFalse(list.isEmpty()); }
@SuppressWarnings("unchecked") @Override public TInterface getLatestInvoiceFromSeries(String series, String businessUID) { QJPAGenericInvoiceEntity genericInvoice = QJPAGenericInvoiceEntity.jPAGenericInvoiceEntity; QJPABusinessEntity business = QJPABusinessEntity.jPABusinessEntity; JPAQuery query = new JPAQuery(this.getEntityManager()); BusinessEntity businessEnity = query.from(business).where(business.uid.eq(businessUID)).uniqueResult(business); if (businessEnity == null) { throw new BillyRuntimeException(); } query = new JPAQuery(this.getEntityManager()); query.from(genericInvoice); query.where(genericInvoice.series.eq(series)); query.where(genericInvoice.business.eq(businessEnity)); query.where(genericInvoice.seriesNumber .eq(new JPASubQuery().from(genericInvoice).where(genericInvoice.series.eq(series)) .where(genericInvoice.business.eq(businessEnity)).unique(genericInvoice.seriesNumber.max()))); GenericInvoiceEntity invoice = query.uniqueResult(genericInvoice); return (TInterface) invoice; // FIXME: CAST } }