private String getTableAlias( List<Join> joins, AliasedRIMType type ) { if ( joins != null ) { return joins.get( joins.size() - 1 ).getToTableAlias(); } return getTableAlias( type ); }
public static String repairAliasesInWhereClause( AbstractWhereBuilder builder, List<Join> usedJoins, List<Join> redundantJoins ) { String whereClause = builder.getWhere().getSQL().toString(); for ( Join redundantJoin : redundantJoins ) { Join usedJoin = getEquivalentJoin( redundantJoin, usedJoins ); String usedAlias = usedJoin.getToTableAlias(); String redundantAlias = redundantJoin.getToTableAlias(); whereClause = whereClause.replace( redundantAlias, usedAlias ); } return whereClause; }
protected void getPSBody( AbstractWhereBuilder builder, StringBuilder getDatasetIDs ) { String rootTableAlias = builder.getAliasManager().getRootTableAlias(); getDatasetIDs.append( " FROM " ); getDatasetIDs.append( mainTable ); getDatasetIDs.append( " " ); getDatasetIDs.append( rootTableAlias ); for ( PropertyNameMapping mappedPropName : builder.getMappedPropertyNames() ) { for ( Join join : mappedPropName.getJoins() ) { getDatasetIDs.append( " LEFT OUTER JOIN " ); getDatasetIDs.append( join.getToTable() ); getDatasetIDs.append( ' ' ); getDatasetIDs.append( join.getToTableAlias() ); getDatasetIDs.append( " ON " ); getDatasetIDs.append( join.getSQLJoinCondition() ); } } if ( builder.getWhere() != null ) { getDatasetIDs.append( " WHERE " ); getDatasetIDs.append( builder.getWhere().getSQL() ); } }
sql.append( join.getToTable() ); sql.append( ' ' ); sql.append( join.getToTableAlias() ); sql.append( " ON " ); sql.append( join.getSQLJoinCondition() );
sql.append( additionalJoin.getToTableAlias() ); sql.append( " ON " ); sql.append( additionalJoin.getSQLJoinCondition() );
idSelect.append( additionalJoin.getToTableAlias() ); idSelect.append( " ON " ); idSelect.append( additionalJoin.getSQLJoinCondition() );
sql.append( join.getToTable() ); sql.append( ' ' ); sql.append( join.getToTableAlias() ); sql.append( " ON " ); sql.append( join.getSQLJoinCondition() );
sql.append( join.getToTable() ); sql.append( ' ' ); sql.append( join.getToTableAlias() ); sql.append( " ON " ); sql.append( join.getSQLJoinCondition() );