private static void renderPredicate( final StringBuilder sb, final DatabaseNamingConvention naming, final int stageIndex, final int foreignStageIndex, final HasComparableOperators<?, ?> field, final HasComparableOperators<?, ?> foreignField, final String operator ) { sb.append(tableAlias(stageIndex)) .append(".") .append(naming.encloseField(field.identifier().getColumnId())) .append(" ") .append(operator) .append(" ") .append(tableAlias(foreignStageIndex)) .append(".") .append(naming.encloseField(foreignField.identifier().getColumnId())); }
protected String encloseField(Dbms dbms, String fieldName) { return dbmsTypeOf(dbmsHandlerComponent, dbms).getDatabaseNamingConvention().encloseField(fieldName); }
SqlStage( final SqlInfo info, final Stage<?> stage, final int stageIndex ) { requireNonNull(info); this.stage = requireNonNull(stage); this.stageIndex = requireNonNegative(stageIndex); this.table = DocumentDbUtil.referencedTable(info.project(), stage.identifier()); final String tableAlias = JoinSqlUtil.tableAlias(stageIndex); this.sqlColumnList = table.columns() .filter(Column::isEnabled) .map(Column::getName) .map(n -> tableAlias + "." + info.namingConvention().encloseField(n)) .collect(joining(",")); this.sqlTableReference = info.namingConvention().fullNameOf(table) + (DbmsType.SubSelectAlias.PROHIBITED.equals(info.dbmsType().getSubSelectAlias()) ? " " : " AS ") + tableAlias; }
final FieldPredicate<ENTITY> fieldPredicate = (FieldPredicate<ENTITY>) predicate; final SqlPredicateFragment fragment = sqlInfo.fieldPredicateView().transform( f -> tableAlias(stageIndex) + "." + sqlInfo.namingConvention().encloseField(f.identifier().getColumnId()), f -> f.findColumn(sqlInfo.project()).get().findDatabaseType(), fieldPredicate
.collect(toMap(identity(), c -> naming.encloseField(c.getColumnId())));
protected String encloseField(Dbms dbms, String fieldName) { return dbmsTypeOf(dbmsHandlerComponent, dbms).getDatabaseNamingConvention().encloseField(fieldName); }
private static void renderPredicate( final StringBuilder sb, final DatabaseNamingConvention naming, final int stageIndex, final int foreignStageIndex, final HasComparableOperators<?, ?> field, final HasComparableOperators<?, ?> foreignField, final String operator ) { sb.append(tableAlias(stageIndex)) .append(".") .append(naming.encloseField(field.identifier().getColumnId())) .append(" ") .append(operator) .append(" ") .append(tableAlias(foreignStageIndex)) .append(".") .append(naming.encloseField(foreignField.identifier().getColumnId())); }
.collect(toMap(identity(), c -> naming.encloseField(c.getColumnId())));
SqlStage( final SqlInfo info, final Stage<?> stage, final int stageIndex ) { requireNonNull(info); this.stage = requireNonNull(stage); this.stageIndex = requireNonNegative(stageIndex); this.table = DocumentDbUtil.referencedTable(info.project(), stage.identifier()); final String tableAlias = JoinSqlUtil.tableAlias(stageIndex); this.sqlColumnList = table.columns() .filter(Column::isEnabled) .map(Column::getName) .map(n -> tableAlias + "." + info.namingConvention().encloseField(n)) .collect(joining(",")); this.sqlTableReference = info.namingConvention().fullNameOf(table) + (DbmsType.SubSelectAlias.PROHIBITED.equals(info.dbmsType().getSubSelectAlias()) ? " " : " AS ") + tableAlias; }
final FieldPredicate<ENTITY> fieldPredicate = (FieldPredicate<ENTITY>) predicate; final SqlPredicateFragment fragment = sqlInfo.fieldPredicateView().transform( f -> tableAlias(stageIndex) + "." + sqlInfo.namingConvention().encloseField(f.identifier().getColumnId()), f -> f.findColumn(sqlInfo.project()).get().findDatabaseType(), fieldPredicate