/** * Create a {@code source as alias} expression * * @param source source * @param alias alias * @return source as alias */ @SuppressWarnings({ "unchecked", "rawtypes" }) public static <D> SimpleExpression<D> constantAs(D source, Path<D> alias) { if (source == null) { return as((Expression) nullExpression(), alias); } else { return as(ConstantImpl.create(source), alias); } }
/** * Create a {@code source as alias} expression * * @param source source * @param alias alias * @return source as alias */ public static <D> SimpleExpression<D> as(Expression<D> source, String alias) { return as(source, ExpressionUtils.path(source.getType(), alias)); }
/** * Create a {@code source as alias} expression * * @param source source * @param alias alias * @param <D> * @return source as alias */ public static <D> SimpleExpression<D> as(Expression<D> source, Path<D> alias) { if (source == null) { return as(Expressions.<D>nullExpression(), alias); } else { return operation(alias.getType(), Ops.ALIAS, source, alias); } }
/** * Create an alias for the expression * * @param alias alias * @return this as alias */ public SimpleExpression<T> as(String alias) { return Expressions.as(this, alias); }
/** * Create an alias for the expression * * @param alias alias * @return this as alias */ @SuppressWarnings("unchecked") public SimpleExpression<T> as(Path<?> alias) { return Expressions.as(this, (Path) alias); }
@SuppressWarnings("unchecked") @Override public <P> Q from(CollectionExpression<?,P> target, Path<P> alias) { return queryMixin.from(Expressions.as((Path) target, alias)); }
@SuppressWarnings({ "unchecked", "rawtypes" }) @Override public <P> JpaQuery<T> from(CollectionExpression<?, P> target, Path<P> alias) { return queryMixin.from(Expressions.as((Path) target, alias)); }
/** * Create a {@code source as alias} expression * * @param source source * @param alias alias * @return source as alias */ @SuppressWarnings({ "unchecked", "rawtypes" }) public static <D> SimpleExpression<D> constantAs(D source, Path<D> alias) { if (source == null) { return as((Expression) nullExpression(), alias); } else { return as(ConstantImpl.create(source), alias); } }
/** * Create a {@code source as alias} expression * * @param source source * @param alias alias * @return source as alias */ public static <D> SimpleExpression<D> as(Expression<D> source, String alias) { return as(source, ExpressionUtils.path(source.getType(), alias)); }
/** * Create a {@code source as alias} expression * * @param source source * @param alias alias * @param <D> * @return source as alias */ public static <D> SimpleExpression<D> as(Expression<D> source, Path<D> alias) { if (source == null) { return as(Expressions.<D>nullExpression(), alias); } else { return operation(alias.getType(), Ops.ALIAS, source, alias); } }
@SuppressWarnings("unchecked") @Override protected Predicate exists(Context c, Predicate condition) { JPAQueryMixin<?> query = new JPAQueryMixin<Object>(); query.setProjection(Expressions.ONE); for (int i = 0; i < c.paths.size(); i++) { Path<?> child = c.paths.get(i).getMetadata().getParent(); EntityPath<Object> replacement = (EntityPath<Object>) c.replacements.get(i); if (c.paths.get(i).getType().isAnnotationPresent(Entity.class)) { query.addJoin(i == 0 ? JoinType.DEFAULT : JoinType.INNERJOIN, Expressions.as( Expressions.listPath((Class) c.paths.get(i).getType(), SimplePath.class, child.getMetadata()), replacement)); } else { // join via parent Path<?> parent = child.getMetadata().getParent(); EntityPathBase<Object> newParent = new EntityPathBase<Object>(parent.getType(), ExpressionUtils.createRootVariable(parent, Math.abs(condition.hashCode()))); EntityPath<Object> newChild = new EntityPathBase<Object>(child.getType(), PathMetadataFactory.forProperty(newParent, child.getMetadata().getName())); query.from(newParent); query.addJoin(JoinType.INNERJOIN, Expressions.as(newChild, replacement)); query.where(ExpressionUtils.eq(newParent, parent)); } } c.clear(); query.where(condition); return ExpressionUtils.predicate(Ops.EXISTS, asExpression(query.getMetadata())); }
SQLQuery<Tuple> query = new SQLQuery<>(connection, this.querydslConfiguration) .select(qBlob.blobId, qBlob.version.as("v"), Expressions.as(this.blobSelectionExpression, "b")) .from(qBlob) .where(qBlob.blobId.eq(blobId));
@Test @ExcludeIn({DB2, DERBY}) public void tuple2() { assertEquals(10, query().from(employee) .select(Expressions.as(ConstantImpl.create("1"), "code"), employee.id).fetch().size()); }