/** * Return the alias for the give column */ public String getColumnAlias(Column col, Object path) { Table table = col.getTable(); String tableAlias = null; Iterator itr = getJoinIterator(); while (itr.hasNext()) { Join join = (Join) itr.next(); if (join != null) { if (join.getTable1() == table) tableAlias = join.getAlias1(); else if (join.getTable2() == table) tableAlias = join.getAlias2(); if (tableAlias != null) return new StringBuilder(tableAlias).append("."). append(_dict.getNamingUtil().toDBName(col.getIdentifier())).toString(); } } throw new InternalException("Can not resolve alias for field: " + path.toString() + " mapped to column: " + col.getIdentifier().getName() + " table: "+table.getIdentifier().getName()); }
/** * Return the alias for the give column */ public String getColumnAlias(Column col, Object path) { Table table = col.getTable(); String tableAlias = null; Iterator itr = getJoinIterator(); while (itr.hasNext()) { Join join = (Join) itr.next(); if (join != null) { if (join.getTable1() == table) tableAlias = join.getAlias1(); else if (join.getTable2() == table) tableAlias = join.getAlias2(); if (tableAlias != null) return new StringBuilder(tableAlias).append("."). append(_dict.getNamingUtil().toDBName(col.getIdentifier())).toString(); } } throw new InternalException("Can not resolve alias for field: " + path.toString() + " mapped to column: " + col.getIdentifier().getName() + " table: "+table.getIdentifier().getName()); }
/** * Return the alias for the give column */ public String getColumnAlias(Column col, Object path) { Table table = col.getTable(); String tableAlias = null; Iterator itr = getJoinIterator(); while (itr.hasNext()) { Join join = (Join) itr.next(); if (join != null) { if (join.getTable1() == table) tableAlias = join.getAlias1(); else if (join.getTable2() == table) tableAlias = join.getAlias2(); if (tableAlias != null) return new StringBuilder(tableAlias).append("."). append(_dict.getNamingUtil().toDBName(col.getIdentifier())).toString(); } } throw new InternalException("Can not resolve alias for field: " + path.toString() + " mapped to column: " + col.getIdentifier().getName() + " table: "+table.getIdentifier().getName()); }
/** * Return the alias for the give column */ public String getColumnAlias(Column col, Object path) { Table table = col.getTable(); String tableAlias = null; Iterator itr = getJoinIterator(); while (itr.hasNext()) { Join join = (Join) itr.next(); if (join != null) { if (join.getTable1() == table) tableAlias = join.getAlias1(); else if (join.getTable2() == table) tableAlias = join.getAlias2(); if (tableAlias != null) return new StringBuilder(tableAlias).append("."). append(_dict.getNamingUtil().toDBName(col.getIdentifier())).toString(); } } throw new InternalException("Can not resolve alias for field: " + path.toString() + " mapped to column: " + col.getIdentifier().getName() + " table: "+table.getIdentifier().getName()); }
buf.append(" "); buf.append(join.getTable2()).append(" ").append(join.getAlias2()); if (forUpdate && tableForUpdateClause != null) buf.append(" ").append(tableForUpdateClause);
/** * Use the given join instance to create SQL joining its tables in * the SQL92 style. */ public SQLBuffer toSQL92Join(Join join, boolean forUpdate, boolean first) { SQLBuffer buf = new SQLBuffer(this); if (first) { buf.append(join.getTable1()).append(" "). append(join.getAlias1()); if (forUpdate && tableForUpdateClause != null) buf.append(" ").append(tableForUpdateClause); } buf.append(" "); if (join.getType() == Join.TYPE_OUTER) buf.append(outerJoinClause); else if (join.getType() == Join.TYPE_INNER) buf.append(innerJoinClause); else // cross buf.append(crossJoinClause); buf.append(" "); buf.append(join.getTable2()).append(" ").append(join.getAlias2()); if (forUpdate && tableForUpdateClause != null) buf.append(" ").append(tableForUpdateClause); if (join.getForeignKey() != null) buf.append(" ON ").append(toTraditionalJoin(join)); else if (requiresConditionForCrossJoin && join.getType() == Join.TYPE_CROSS) buf.append(" ON (1 = 1)"); return buf; }
buf.append(" "); buf.append(join.getTable2()).append(" ").append(join.getAlias2()); if (forUpdate && tableForUpdateClause != null) buf.append(" ").append(tableForUpdateClause);
buf.append(" "); buf.append(join.getTable2()).append(" ").append(join.getAlias2()); if (forUpdate && tableForUpdateClause != null) buf.append(" ").append(tableForUpdateClause);
buf.append(" "); buf.append(join.getTable2()).append(" ").append(join.getAlias2()); if (forUpdate && tableForUpdateClause != null) buf.append(" ").append(tableForUpdateClause);
buf.append(join.getAlias1()).append(".").append(from[i]); buf.append(" = "); buf.append(join.getAlias2()).append(".").append(to[i]); buf.append("(+)");
buf.append(join.getAlias1()).append(".").append(from[i]); buf.append(" = "); buf.append(join.getAlias2()).append(".").append(to[i]); buf.append("(+)");
buf.append(join.getAlias1()).append(".").append(from[i]); buf.append(" = "); buf.append(join.getAlias2()).append(".").append(to[i]); buf.append("(+)");
buf.append(join.getAlias1()).append(".").append(from[i]); buf.append(" = "); buf.append(join.getAlias2()).append(".").append(to[i]); buf.append("(+)");
buf.append(join.getAlias1()).append(".").append(from[i]); buf.append(" = "); buf.append(join.getAlias2()).append(".").append(to[i]); buf.append("(+)");