/** * Generate an indirection table * * @param col the CollectionDescriptor to generate table for * @return a String representing the schema for the indirection table */ protected String generateIndirectionTable(CollectionDescriptor col) { StringBuffer sb = new StringBuffer(); String table = DatabaseUtil.getIndirectionTableName(col); String column1 = DatabaseUtil.getInwardIndirectionColumnName(col, schema.getVersion()); String column2 = DatabaseUtil.getOutwardIndirectionColumnName(col, schema.getVersion()); sb.append(INDENT + "<table name=\"") .append(table) .append("\">" + ENDL) .append(generateColumn(column1, "int")) .append(generateColumn(column2, "int")) .append(INDENT + "</table>" + ENDL); return sb.toString(); }
/** * Generate an indirection table * * @param col the CollectionDescriptor to generate table for * @return a String representing the schema for the indirection table */ protected String generateIndirectionTable(CollectionDescriptor col) { StringBuffer sb = new StringBuffer(); String table = DatabaseUtil.getIndirectionTableName(col); String column1 = DatabaseUtil.getInwardIndirectionColumnName(col, schema.getVersion()); String column2 = DatabaseUtil.getOutwardIndirectionColumnName(col, schema.getVersion()); sb.append(INDENT + "<table name=\"") .append(table) .append("\">" + ENDL) .append(generateColumn(column1, "int")) .append(generateColumn(column2, "int")) .append(INDENT + "</table>" + ENDL); return sb.toString(); }
String inwardIndirectionCol = indirectTableAlias + "." + DatabaseUtil.getInwardIndirectionColumnName(arg1ColDesc, schema.getVersion()); buffer.append(indirectionTable + " AS " + indirectTableAlias); buffer.append(" WHERE " + inwardIndirectionCol + " = " + arg1Alias);
String indirectTableName = DatabaseUtil.getIndirectionTableName(coll); String inwardColumnName = DatabaseUtil.getInwardIndirectionColumnName(coll, schema.getVersion()); String outwardColumnName = DatabaseUtil.getOutwardIndirectionColumnName(coll, schema.getVersion()); boolean swap = (inwardColumnName.compareTo(outwardColumnName) > 0); String[] indirColNames = tableToColNameArray.get(indirectTableName);
String inwardColumnName = DatabaseUtil.getInwardIndirectionColumnName(collection, schema.getVersion()); String outwardColumnName = DatabaseUtil.getOutwardIndirectionColumnName(collection, schema.getVersion()); boolean swap = (inwardColumnName.compareTo(outwardColumnName) > 0); String[] indirColNames = tableToColNameArray.get(indirectTableName);
String inwardColumnName = DatabaseUtil.getInwardIndirectionColumnName(collection, schema.getVersion()); String outwardColumnName = DatabaseUtil.getOutwardIndirectionColumnName(collection, schema.getVersion()); boolean swap = (inwardColumnName.compareTo(outwardColumnName) > 0); String[] indirColNames = tableToColNameArray.get(indirectTableName);
String indirectTableName = DatabaseUtil.getIndirectionTableName(coll); String inwardColumnName = DatabaseUtil.getInwardIndirectionColumnName(coll, schema.getVersion()); String outwardColumnName = DatabaseUtil.getOutwardIndirectionColumnName(coll, schema.getVersion()); boolean swap = (inwardColumnName.compareTo(outwardColumnName) > 0); String[] indirColNames = tableToColNameArray.get(indirectTableName);
String inwardIndirectionCol = indirectTableAlias + "." + DatabaseUtil.getInwardIndirectionColumnName(arg1ColDesc, schema.getVersion()); buffer.append(indirectionTable + " AS " + indirectTableAlias); buffer.append(" WHERE " + inwardIndirectionCol + " = " + arg1Alias);
String tableName = DatabaseUtil.getIndirectionTableName(col).toLowerCase(); String columnName = DatabaseUtil.getInwardIndirectionColumnName(col, schema.getVersion()); String columnName2 = DatabaseUtil.getOutwardIndirectionColumnName(col, schema.getVersion()); if ((columnName.compareTo(columnName2) < 0) || (col.getReverseReferenceDescriptor() == null)) {
String tableName = DatabaseUtil.getIndirectionTableName(col).toLowerCase(); String columnName = DatabaseUtil.getInwardIndirectionColumnName(col, schema.getVersion()); String columnName2 = DatabaseUtil.getOutwardIndirectionColumnName(col, schema.getVersion()); if ((columnName.compareTo(columnName2) < 0) || (col.getReverseReferenceDescriptor() == null)) {
String indirectTableAlias = state.getIndirectAlias(); String arg2Alias = indirectTableAlias + "." + DatabaseUtil.getInwardIndirectionColumnName(arg1ColDesc, schema.getVersion()); state.addToFrom(DatabaseUtil.getIndirectionTableName(arg1ColDesc) + " AS " + indirectTableAlias); schema.getVersion()) + " = "); if (arg2 == null) { buffer.append("" + arg2Obj.getId());
String indirectTableAlias = state.getIndirectAlias(); String arg2Alias = indirectTableAlias + "." + DatabaseUtil.getInwardIndirectionColumnName(arg1ColDesc, schema.getVersion()); state.addToFrom(DatabaseUtil.getIndirectionTableName(arg1ColDesc) + " AS " + indirectTableAlias); schema.getVersion()) + " = "); if (arg2 == null) { buffer.append("" + arg2Obj.getId());