public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { // add conditions making sure no subclass tables have records for // this instance ClassMapping[] subs = base.getJoinablePCSubclassMappings(); SQLBuffer buf = null; Column[] pks; for (int i = 0; i < subs.length; i++) { pks = subs[i].getPrimaryKeyColumns(); if (pks.length == 0) continue; if (buf == null) { // make sure the base class is aliased first so that we don't // end up with our outer joins before the inner ones buf = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); sel.getColumnAlias(base.getPrimaryKeyColumns()[0], joins); } else buf.append(" AND "); buf.append(sel.getColumnAlias(pks[0], joins)).append(" IS NULL"); } return buf; } }
public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { // add conditions making sure no subclass tables have records for // this instance ClassMapping[] subs = base.getJoinablePCSubclassMappings(); SQLBuffer buf = null; Column[] pks; for (int i = 0; i < subs.length; i++) { pks = subs[i].getPrimaryKeyColumns(); if (pks.length == 0) continue; if (buf == null) { // make sure the base class is aliased first so that we don't // end up with our outer joins before the inner ones buf = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); sel.getColumnAlias(base.getPrimaryKeyColumns()[0], joins); } else buf.append(" AND "); buf.append(sel.getColumnAlias(pks[0], joins)).append(" IS NULL"); } return buf; } }
public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { // add conditions making sure no subclass tables have records for // this instance ClassMapping[] subs = base.getJoinablePCSubclassMappings(); SQLBuffer buf = null; Column[] pks; for (int i = 0; i < subs.length; i++) { pks = subs[i].getPrimaryKeyColumns(); if (pks.length == 0) continue; if (buf == null) { // make sure the base class is aliased first so that we don't // end up with our outer joins before the inner ones buf = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); sel.getColumnAlias(base.getPrimaryKeyColumns()[0], joins); } else buf.append(" AND "); buf.append(sel.getColumnAlias(pks[0], joins)).append(" IS NULL"); } return buf; } }
public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { // add conditions making sure no subclass tables have records for // this instance ClassMapping[] subs = base.getJoinablePCSubclassMappings(); SQLBuffer buf = null; Column[] pks; for (int i = 0; i < subs.length; i++) { pks = subs[i].getPrimaryKeyColumns(); if (pks.length == 0) continue; if (buf == null) { // make sure the base class is aliased first so that we don't // end up with our outer joins before the inner ones buf = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); sel.getColumnAlias(base.getPrimaryKeyColumns()[0], joins); } else buf.append(" AND "); buf.append(sel.getColumnAlias(pks[0], joins)).append(" IS NULL"); } return buf; } }
public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { // add conditions making sure no subclass tables have records for // this instance ClassMapping[] subs = base.getJoinablePCSubclassMappings(); SQLBuffer buf = null; Column[] pks; for (int i = 0; i < subs.length; i++) { pks = subs[i].getPrimaryKeyColumns(); if (pks.length == 0) continue; if (buf == null) { // make sure the base class is aliased first so that we don't // end up with our outer joins before the inner ones buf = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); sel.getColumnAlias(base.getPrimaryKeyColumns()[0], joins); } else buf.append(" AND "); buf.append(sel.getColumnAlias(pks[0], joins)).append(" IS NULL"); } return buf; } }
public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { Column col = disc.getColumns()[0]; SQLBuffer sql = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); String alias = sel.getColumnAlias(col, joins); boolean outer = joins != null && joins.isOuter(); if (outer) sql.append("("); sql.append(alias); // if not selecting subclasses, limit to just the given class ClassMapping[] subs = base.getJoinablePCSubclassMappings(); if (!outer && (!subclasses || subs.length == 0)) return sql.append(" = ").appendValue(getDiscriminatorValue(base), col); if (outer) sql.append(" IS ").appendValue(null).append(" OR ").append(alias); sql.append(" IN ("); sql.appendValue(getDiscriminatorValue(base), col); for (int i = 0; i < subs.length; i++) sql.append(", ").appendValue(getDiscriminatorValue(subs[i]), col); sql.append(")"); if (outer) sql.append(")"); return sql; } }
public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { Column col = disc.getColumns()[0]; SQLBuffer sql = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); String alias = sel.getColumnAlias(col, joins); boolean outer = joins != null && joins.isOuter(); if (outer) sql.append("("); sql.append(alias); // if not selecting subclasses, limit to just the given class ClassMapping[] subs = base.getJoinablePCSubclassMappings(); if (!outer && (!subclasses || subs.length == 0)) return sql.append(" = ").appendValue(getDiscriminatorValue(base), col); if (outer) sql.append(" IS ").appendValue(null).append(" OR ").append(alias); sql.append(" IN ("); sql.appendValue(getDiscriminatorValue(base), col); for (int i = 0; i < subs.length; i++) sql.append(", ").appendValue(getDiscriminatorValue(subs[i]), col); sql.append(")"); if (outer) sql.append(")"); return sql; } }
public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { Column col = disc.getColumns()[0]; SQLBuffer sql = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); boolean outer = joins != null && joins.isOuter(); if (outer) sql.append("("); String alias = sel.getColumnAlias(col, joins); sql.append(alias); // if not selecting subclasses, limit to just the given class ClassMapping[] subs = base.getJoinablePCSubclassMappings(); if (!outer && (!subclasses || subs.length == 0)) return sql.append(" = ").appendValue(getDiscriminatorValue(base), col); if (outer) sql.append(" IS ").appendValue(null).append(" OR ").append(alias); sql.append(" IN ("); sql.appendValue(getDiscriminatorValue(base), col); for (int i = 0; i < subs.length; i++) sql.append(", ").appendValue(getDiscriminatorValue(subs[i]), col); sql.append(")"); if (outer) sql.append(")"); return sql; } }
public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { Column col = disc.getColumns()[0]; SQLBuffer sql = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); String alias = sel.getColumnAlias(col, joins); boolean outer = joins != null && joins.isOuter(); if (outer) sql.append("("); sql.append(alias); // if not selecting subclasses, limit to just the given class ClassMapping[] subs = base.getJoinablePCSubclassMappings(); if (!outer && (!subclasses || subs.length == 0)) return sql.append(" = ").appendValue(getDiscriminatorValue(base), col); if (outer) sql.append(" IS ").appendValue(null).append(" OR ").append(alias); sql.append(" IN ("); sql.appendValue(getDiscriminatorValue(base), col); for (int i = 0; i < subs.length; i++) sql.append(", ").appendValue(getDiscriminatorValue(subs[i]), col); sql.append(")"); if (outer) sql.append(")"); return sql; } }
public SQLBuffer getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses) { Column col = disc.getColumns()[0]; SQLBuffer sql = new SQLBuffer(sel.getConfiguration(). getDBDictionaryInstance()); String alias = sel.getColumnAlias(col, joins); boolean outer = joins != null && joins.isOuter(); if (outer) sql.append("("); sql.append(alias); // if not selecting subclasses, limit to just the given class ClassMapping[] subs = base.getJoinablePCSubclassMappings(); if (!outer && (!subclasses || subs.length == 0)) return sql.append(" = ").appendValue(getDiscriminatorValue(base), col); if (outer) sql.append(" IS ").appendValue(null).append(" OR ").append(alias); sql.append(" IN ("); sql.appendValue(getDiscriminatorValue(base), col); for (int i = 0; i < subs.length; i++) sql.append(", ").appendValue(getDiscriminatorValue(subs[i]), col); sql.append(")"); if (outer) sql.append(")"); return sql; } }