/** * Return the qualified name of the field. * PERF: Cache the qualified name. */ public String getQualifiedNameDelimited(DatasourcePlatform platform) { if (hasTableName()) { return this.table.getQualifiedNameDelimited(platform) + "." + getNameDelimited(platform); } else { return getNameDelimited(platform); } } /**
/** * INTERNAL: * helper method, don't override. */ protected static void writeFieldsList(Writer writer, Collection fields, DatasourcePlatform platform) throws IOException { boolean isFirst = true; Iterator itFields = fields.iterator(); while(itFields.hasNext()) { if(isFirst) { isFirst = false; } else { writer.write(", "); } DatabaseField field = (DatabaseField)itFields.next(); writer.write(field.getNameDelimited(platform)); } }
/** * INTERNAL: * helper method, don't override. */ protected static void writeFieldsList(Writer writer, Collection fields, DatasourcePlatform platform) throws IOException { boolean isFirst = true; Iterator itFields = fields.iterator(); while(itFields.hasNext()) { if(isFirst) { isFirst = false; } else { writer.write(", "); } DatabaseField field = (DatabaseField)itFields.next(); writer.write(field.getNameDelimited(platform)); } }
public String toString() { return "=> " + getOutputField().getNameDelimited(dbplatform); } }
public String toString() { return "=> " + getOutputField().getNameDelimited(dbplatform); } }
/** * Return the qualified name of the field. * PERF: Cache the qualified name. */ public String getQualifiedNameDelimited(DatasourcePlatform platform) { if (hasTableName()) { return this.table.getQualifiedNameDelimited(platform) + "." + getNameDelimited(platform); } else { return getNameDelimited(platform); } } /**
/** * Return the qualified name of the field. * PERF: Cache the qualified name. */ public String getQualifiedNameDelimited(DatasourcePlatform platform) { if (hasTableName()) { return this.table.getQualifiedNameDelimited(platform) + "." + getNameDelimited(platform); } else { return getNameDelimited(platform); } } /**
/** * INTERNAL: * helper method, don't override. */ protected static void writeFieldsList(Writer writer, Collection fields, DatasourcePlatform platform) throws IOException { boolean isFirst = true; Iterator itFields = fields.iterator(); while(itFields.hasNext()) { if(isFirst) { isFirst = false; } else { writer.write(", "); } DatabaseField field = (DatabaseField)itFields.next(); writer.write(field.getNameDelimited(platform)); } }
public String toString() { return "=> " + getOutputField().getNameDelimited(dbplatform); } }
protected static void writeUniqueFieldName(Writer writer, DatabaseField field, DatasourcePlatform platform) throws IOException { // EMPLOYEE_EMP_ID writer.write(field.getTable().getNameDelimited(platform)); writer.write("_"); writer.write(field.getNameDelimited(platform)); }
protected static void writeUniqueFieldName(Writer writer, DatabaseField field, DatasourcePlatform platform) throws IOException { // EMPLOYEE_EMP_ID writer.write(field.getTable().getNameDelimited(platform)); writer.write("_"); writer.write(field.getNameDelimited(platform)); }
protected static void writeUniqueFieldName(Writer writer, DatabaseField field, DatasourcePlatform platform) throws IOException { // EMPLOYEE_EMP_ID writer.write(field.getTable().getNameDelimited(platform)); writer.write("_"); writer.write(field.getNameDelimited(platform)); }
/** * Build field definitions and foreign key constraints for all many-to-many relation table. */ private void buildRelationTableFields(TableDefinition tblDef, Vector fkFields, Vector targetFields) { assert fkFields.size() > 0 && fkFields.size() == targetFields.size(); DatabaseField fkField = null; DatabaseField targetField = null; Vector<String> fkFieldNames = new Vector(); Vector<String> targetFieldNames = new Vector(); for (int index = 0; index < fkFields.size(); index++) { fkField = (DatabaseField) fkFields.get(index); targetField = (DatabaseField) targetFields.get(index); fkFieldNames.add(fkField.getNameDelimited(databasePlatform)); targetFieldNames.add(targetField.getNameDelimited(databasePlatform)); fkField = resolveDatabaseField(fkField, targetField); setFieldToRelationTable(fkField, tblDef); } // add a foreign key constraint from fk field to target field DatabaseTable targetTable = targetField.getTable(); TableDefinition targetTblDef = getTableDefFromDBTable(targetTable); addForeignKeyConstraint(tblDef, targetTblDef, fkFieldNames, targetFieldNames); }
public void printField(DatabaseField field, DatabaseTable tableAlias) { if (field == null) { return; } try { // Print the field using either short or long notation i.e. owner + table name. if (shouldPrintQualifiedNames()) { getWriter().write(tableAlias.getQualifiedNameDelimited(platform)); getWriter().write("."); getWriter().write(field.getNameDelimited(platform)); } else { getWriter().write(field.getNameDelimited(platform)); } } catch (IOException exception) { throw ValidationException.fileError(exception); } }
public void printField(DatabaseField field) { if (field == null) { return; } try { // Print the field using either short or long notation i.e. owner + table name. if (shouldPrintQualifiedNames()) { getWriter().write(field.getQualifiedNameDelimited(platform)); } else { getWriter().write(field.getNameDelimited(platform)); } } catch (IOException exception) { throw ValidationException.fileError(exception); } }
public void printField(DatabaseField field) { if (field == null) { return; } try { // Print the field using either short or long notation i.e. owner + table name. if (shouldPrintQualifiedNames()) { getWriter().write(field.getQualifiedNameDelimited(platform)); } else { getWriter().write(field.getNameDelimited(platform)); } } catch (IOException exception) { throw ValidationException.fileError(exception); } }
public void printField(DatabaseField field) { if (field == null) { return; } try { // Print the field using either short or long notation i.e. owner + table name. if (shouldPrintQualifiedNames()) { getWriter().write(field.getQualifiedNameDelimited(platform)); } else { getWriter().write(field.getNameDelimited(platform)); } } catch (IOException exception) { throw ValidationException.fileError(exception); } }
protected void addFieldAliasIfNeeded(ExpressionSQLPrinter printer, DatabaseField field, SQLSelectStatement statement) { if (statement.getUseUniqueFieldAliases()){ printer.printString(" AS " + statement.generatedAlias(field.getNameDelimited(printer.getPlatform()))); } }
/** * INTERNAL: * Append the field name to the writer. Should be overridden for special operators such as functions. */ protected void writeField(ExpressionSQLPrinter printer, DatabaseField field, SQLSelectStatement statement) { //print ", " before each selected field except the first one if (printer.isFirstElementPrinted()) { printer.printString(", "); } else { printer.setIsFirstElementPrinted(true); } if (statement.requiresAliases()) { if (field.getTable() != lastTable) { lastTable = field.getTable(); currentAlias = aliasForTable(lastTable); } printer.printString(currentAlias.getQualifiedNameDelimited(printer.getPlatform())); printer.printString("."); } printer.printString(field.getNameDelimited(printer.getPlatform())); //bug6070214: unique field aliases need to be generated when required. if (statement.getUseUniqueFieldAliases()){ printer.printString(" AS " + statement.generatedAlias(field.getNameDelimited(printer.getPlatform()))); } }
/** * INTERNAL: * Append the field name to the writer. Should be overridden for special operators such as functions. */ protected void writeField(ExpressionSQLPrinter printer, DatabaseField field, SQLSelectStatement statement) { //print ", " before each selected field except the first one if (printer.isFirstElementPrinted()) { printer.printString(", "); } else { printer.setIsFirstElementPrinted(true); } if (statement.requiresAliases()) { if (field.getTable() != lastTable) { lastTable = field.getTable(); currentAlias = aliasForTable(lastTable); } printer.printString(currentAlias.getQualifiedNameDelimited(printer.getPlatform())); printer.printString("."); } printer.printString(field.getNameDelimited(printer.getPlatform())); //bug6070214: unique field aliases need to be generated when required. addFieldAliasIfNeeded(printer, field, statement); }