public static final String proposeSqlBasedLogicalColumnId(
String locale, LogicalTable businessTable, SqlPhysicalColumn physicalColumn) {
String baseID = Util.toId(businessTable.getName(locale));
String namePart =
Util.toId(Util.NVL(physicalColumn.getName(locale), physicalColumn.getTargetColumn()));
String id = Util.getLogicalColumnIdPrefix() + baseID + "_" + namePart; // $NON-NLS-1$
return id.toUpperCase();
}
public static final String proposeSqlBasedLogicalTableId(
String locale, LogicalTable businessTable, SqlPhysicalTable physicalTable) {
String baseID = Util.toId(businessTable.getName(locale));
String namePart =
Util.toId(Util.NVL(physicalTable.getName(locale), physicalTable.getTargetTable()));
String id = Settings.getBusinessTableIDPrefix() + baseID + "_" + namePart; // $NON-NLS-1$
if (Settings.isAnIdUppercase()) id = id.toUpperCase();
return id;
}
public static final String proposeSqlBasedCategoryId(
String locale, LogicalTable table, Category category) {
String baseID =
(table != null)
? Util.toId((String) table.getProperty(SqlPhysicalTable.TARGET_TABLE))
: ""; //$NON-NLS-1$
String namePart =
((category != null) && (category.getName(locale) != null))
? "_" + Util.toId(category.getName(locale))
: ""; //$NON-NLS-1$ //$NON-NLS-2$
String id = Util.getCategoryIdPrefix() + baseID + namePart;
return id.toUpperCase();
}