use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns in project jaxdb by jaxdb.
the class Generator method getColumnMeta.
private ColumnMeta getColumnMeta(final Table table, final $Column column) throws GeneratorExecutionException {
final String columnName = column.getName$().text();
boolean isKeyForUpdate = false;
// FIXME: Make efficient
if (table.getJsqlKeyForUpdate() != null)
for (final xLygluGCXAA.$Named col : table.getJsqlKeyForUpdate().getColumn()) if (isKeyForUpdate = columnName.equals(col.getName$().text()))
break;
final Class<?> cls = column.getClass().getSuperclass();
GenerateOn<?> generateOnInsert = null;
GenerateOn<?> generateOnUpdate = null;
final boolean isPrimary = ddlx.isPrimary(table, column);
final Object[] commonParams = { THIS, MUTABLE, "\"" + column.getName$().text() + "\"", ddlx.isUnique(table, column), isPrimary, isNull(column) };
if (column instanceof $Char) {
final $Char col = ($Char) column;
if (col.getSqlxGenerateOnInsert$() != null) {
if ($Char.GenerateOnInsert$.UUID.text().equals(col.getSqlxGenerateOnInsert$().text()))
generateOnInsert = GenerateOn.UUID;
else
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + col.getSqlxGenerateOnInsert$().text());
}
return new ColumnMeta(table, column, isPrimary, data.CHAR.class, commonParams, col.getDefault$() == null ? null : col.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, col.getLength$() == null ? null : col.getLength$().text(), isVarying(col.getVarying$()));
}
if (column instanceof $Clob) {
final $Clob col = ($Clob) column;
return new ColumnMeta(table, column, isPrimary, data.CLOB.class, commonParams, null, generateOnInsert, generateOnUpdate, isKeyForUpdate, col.getLength$() == null ? null : col.getLength$().text());
}
if (column instanceof $Binary) {
final $Binary col = ($Binary) column;
return new ColumnMeta(table, column, isPrimary, data.BINARY.class, commonParams, col.getDefault$() == null ? null : col.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, col.getLength$() == null ? null : col.getLength$().text(), isVarying(col.getVarying$()));
}
if (column instanceof $Blob) {
final $Blob col = ($Blob) column;
return new ColumnMeta(table, column, isPrimary, data.BLOB.class, commonParams, null, generateOnInsert, generateOnUpdate, isKeyForUpdate, col.getLength$() == null ? null : col.getLength$().text());
}
if (column instanceof $Integer) {
final $Integer integerColumn = ($Integer) column;
if (integerColumn.getGenerateOnInsert$() != null) {
if ($Integer.GenerateOnInsert$.AUTO_5FINCREMENT.text().equals(integerColumn.getGenerateOnInsert$().text())) {
generateOnInsert = GenerateOn.AUTO_GENERATED;
} else {
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + integerColumn.getGenerateOnInsert$().text());
}
}
if (column instanceof $Tinyint) {
final $Tinyint integer = ($Tinyint) column;
if (integer.getSqlxGenerateOnUpdate$() != null) {
if ($Tinyint.GenerateOnUpdate$.INCREMENT.text().equals(integer.getSqlxGenerateOnUpdate$().text())) {
if (isPrimary)
throw new GeneratorExecutionException("Primary column \"" + table.getName$().text() + "." + column.getName$().text() + "\" cannot specify generateOnUpdate");
generateOnUpdate = GenerateOn.INCREMENT;
} else {
throw new GeneratorExecutionException("Unknown generateOnUpdate specification: " + integer.getSqlxGenerateOnUpdate$().text());
}
}
return new ColumnMeta(table, column, isPrimary, data.TINYINT.class, commonParams, integer.getDefault$() == null ? null : integer.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, integer.getPrecision$() == null ? null : integer.getPrecision$().text().intValue(), integer.getMin$() == null ? null : integer.getMin$().text(), integer.getMax$() == null ? null : integer.getMax$().text());
}
if (column instanceof $Smallint) {
final $Smallint integer = ($Smallint) column;
if (integer.getSqlxGenerateOnUpdate$() != null) {
if ($Smallint.GenerateOnUpdate$.INCREMENT.text().equals(integer.getSqlxGenerateOnUpdate$().text())) {
if (isPrimary)
throw new GeneratorExecutionException("Primary column \"" + table.getName$().text() + "." + column.getName$().text() + "\" cannot specify generateOnUpdate");
generateOnUpdate = GenerateOn.INCREMENT;
} else {
throw new GeneratorExecutionException("Unknown generateOnUpdate specification: " + integer.getSqlxGenerateOnUpdate$().text());
}
}
return new ColumnMeta(table, column, isPrimary, data.SMALLINT.class, commonParams, integer.getDefault$() == null ? null : integer.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, integer.getPrecision$() == null ? null : integer.getPrecision$().text().intValue(), integer.getMin$() == null ? null : integer.getMin$().text(), integer.getMax$() == null ? null : integer.getMax$().text());
}
if (column instanceof $Int) {
final $Int integer = ($Int) column;
if (integer.getSqlxGenerateOnInsert$() != null) {
if (generateOnInsert != null)
throw new GeneratorExecutionException("ddlx:generateOnInsert and sqlx:generateOnInsert are mutually exclusive");
if ($Int.GenerateOnInsert$.EPOCH_5FMINUTES.text().equals(integer.getSqlxGenerateOnInsert$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 8)
throw new GeneratorExecutionException("INT(" + integer.getPrecision$().text() + ") requires minimum precision of 8 for EPOCH_MINUTES");
generateOnInsert = GenerateOn.EPOCH_MINUTES;
} else if ($Int.GenerateOnInsert$.EPOCH_5FSECONDS.text().equals(integer.getSqlxGenerateOnInsert$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 10)
throw new GeneratorExecutionException("INT(" + integer.getPrecision$().text() + ") requires minimum precision of 10 for EPOCH_SECONDS");
generateOnInsert = GenerateOn.EPOCH_SECONDS;
} else {
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + integer.getSqlxGenerateOnInsert$().text());
}
}
if (integer.getSqlxGenerateOnUpdate$() != null) {
if (isPrimary)
throw new GeneratorExecutionException("Primary column \"" + table.getName$().text() + "." + column.getName$().text() + "\" cannot specify generateOnUpdate");
if ($Int.GenerateOnUpdate$.INCREMENT.text().equals(integer.getSqlxGenerateOnUpdate$().text())) {
generateOnUpdate = GenerateOn.INCREMENT;
} else if ($Int.GenerateOnUpdate$.EPOCH_5FMINUTES.text().equals(integer.getSqlxGenerateOnUpdate$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 8)
throw new GeneratorExecutionException("INT(" + integer.getPrecision$().text() + ") requires minimum precision of 8 for EPOCH_MINUTES");
generateOnUpdate = GenerateOn.EPOCH_MINUTES;
} else if ($Int.GenerateOnUpdate$.EPOCH_5FSECONDS.text().equals(integer.getSqlxGenerateOnUpdate$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 10)
throw new GeneratorExecutionException("INT(" + integer.getPrecision$().text() + ") requires minimum precision of 10 for EPOCH_SECONDS");
generateOnUpdate = GenerateOn.EPOCH_SECONDS;
} else {
throw new GeneratorExecutionException("Unknown generateOnUpdate specification: " + integer.getSqlxGenerateOnUpdate$().text());
}
}
return new ColumnMeta(table, column, isPrimary, data.INT.class, commonParams, integer.getDefault$() == null ? null : integer.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, integer.getPrecision$() == null ? null : integer.getPrecision$().text().intValue(), integer.getMin$() == null ? null : integer.getMin$().text(), integer.getMax$() == null ? null : integer.getMax$().text());
}
if (column instanceof $Bigint) {
final $Bigint integer = ($Bigint) column;
if (integer.getSqlxGenerateOnInsert$() != null) {
if (generateOnInsert != null)
throw new GeneratorExecutionException("ddlx:generateOnInsert and sqlx:generateOnInsert are mutually exclusive");
if ($Bigint.GenerateOnInsert$.EPOCH_5FMINUTES.text().equals(integer.getSqlxGenerateOnInsert$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 8)
throw new GeneratorExecutionException("BIGINT(" + integer.getPrecision$().text() + ") requires minimum precision of 8 for EPOCH_MINUTES");
generateOnInsert = GenerateOn.EPOCH_MINUTES;
} else if ($Bigint.GenerateOnInsert$.EPOCH_5FSECONDS.text().equals(integer.getSqlxGenerateOnInsert$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 10)
throw new GeneratorExecutionException("BIGINT(" + integer.getPrecision$().text() + ") requires minimum precision of 10 for EPOCH_SECONDS");
generateOnInsert = GenerateOn.EPOCH_SECONDS;
} else if ($Bigint.GenerateOnInsert$.EPOCH_5FMILLIS.text().equals(integer.getSqlxGenerateOnInsert$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 13)
throw new GeneratorExecutionException("BIGINT(" + integer.getPrecision$().text() + ") requires minimum precision of 13 for EPOCH_MILLIS");
generateOnInsert = GenerateOn.EPOCH_MILLIS;
} else {
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + integer.getSqlxGenerateOnInsert$().text());
}
}
if (integer.getSqlxGenerateOnUpdate$() != null) {
if (isPrimary)
throw new GeneratorExecutionException("Primary column \"" + table.getName$().text() + "." + column.getName$().text() + "\" cannot specify generateOnUpdate");
if ($Bigint.GenerateOnUpdate$.INCREMENT.text().equals(integer.getSqlxGenerateOnUpdate$().text())) {
generateOnUpdate = GenerateOn.INCREMENT;
} else if ($Bigint.GenerateOnUpdate$.EPOCH_5FMINUTES.text().equals(integer.getSqlxGenerateOnUpdate$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 8)
throw new GeneratorExecutionException("BIGINT(" + integer.getPrecision$().text() + ") requires minimum precision of 8 for EPOCH_MINUTES");
generateOnUpdate = GenerateOn.EPOCH_MINUTES;
} else if ($Bigint.GenerateOnUpdate$.EPOCH_5FSECONDS.text().equals(integer.getSqlxGenerateOnUpdate$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 10)
throw new GeneratorExecutionException("BIGINT(" + integer.getPrecision$().text() + ") requires minimum precision of 10 for EPOCH_SECONDS");
generateOnUpdate = GenerateOn.EPOCH_SECONDS;
} else if ($Bigint.GenerateOnUpdate$.EPOCH_5FMILLIS.text().equals(integer.getSqlxGenerateOnUpdate$().text())) {
if (integer.getPrecision$().text() != null && integer.getPrecision$().text() < 13)
throw new GeneratorExecutionException("BIGINT(" + integer.getPrecision$().text() + ") requires minimum precision of 13 for EPOCH_MILLIS");
generateOnUpdate = GenerateOn.EPOCH_MILLIS;
} else {
throw new GeneratorExecutionException("Unknown generateOnUpdate specification: " + integer.getSqlxGenerateOnUpdate$().text());
}
}
return new ColumnMeta(table, column, isPrimary, data.BIGINT.class, commonParams, integer.getDefault$() == null ? null : integer.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, integer.getPrecision$() == null ? null : integer.getPrecision$().text().intValue(), integer.getMin$() == null ? null : integer.getMin$().text(), integer.getMax$() == null ? null : integer.getMax$().text());
}
}
if (column instanceof $Float) {
final $Float col = ($Float) column;
final Number min = col.getMin$() != null ? col.getMin$().text() : null;
final Number max = col.getMax$() != null ? col.getMax$().text() : null;
return new ColumnMeta(table, column, isPrimary, data.FLOAT.class, commonParams, col.getDefault$() == null ? null : col.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, min, max);
}
if (column instanceof $Double) {
final $Double col = ($Double) column;
final Number min = col.getMin$() != null ? col.getMin$().text() : null;
final Number max = col.getMax$() != null ? col.getMax$().text() : null;
return new ColumnMeta(table, column, isPrimary, data.DOUBLE.class, commonParams, col.getDefault$() == null ? null : col.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, min, max);
}
if (column instanceof $Decimal) {
final $Decimal col = ($Decimal) column;
return new ColumnMeta(table, column, isPrimary, data.DECIMAL.class, commonParams, col.getDefault$() == null ? null : col.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, col.getPrecision$() == null ? null : col.getPrecision$().text().intValue(), col.getScale$() == null ? null : col.getScale$().text().intValue(), col.getMin$() == null ? null : col.getMin$().text(), col.getMax$() == null ? null : col.getMax$().text());
}
if (column instanceof $Date) {
final $Date col = ($Date) column;
if (col.getSqlxGenerateOnInsert$() != null) {
if ($Date.GenerateOnInsert$.TIMESTAMP.text().equals(col.getSqlxGenerateOnInsert$().text()))
generateOnInsert = GenerateOn.TIMESTAMP;
else
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + col.getSqlxGenerateOnInsert$().text());
}
if (col.getSqlxGenerateOnUpdate$() != null) {
if ($Date.GenerateOnUpdate$.TIMESTAMP.text().equals(col.getSqlxGenerateOnUpdate$().text())) {
if (isPrimary)
throw new GeneratorExecutionException("Primary column \"" + table.getName$().text() + "." + column.getName$().text() + "\" cannot specify generateOnUpdate");
generateOnUpdate = GenerateOn.TIMESTAMP;
} else {
throw new GeneratorExecutionException("Unknown generateOnUpdate specification: " + col.getSqlxGenerateOnUpdate$().text());
}
}
return new ColumnMeta(table, column, isPrimary, data.DATE.class, commonParams, col.getDefault$() == null ? null : col.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate);
}
if (column instanceof $Time) {
final $Time col = ($Time) column;
if (col.getSqlxGenerateOnInsert$() != null) {
if ($Time.GenerateOnInsert$.TIMESTAMP.text().equals(col.getSqlxGenerateOnInsert$().text()))
generateOnInsert = GenerateOn.TIMESTAMP;
else
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + col.getSqlxGenerateOnInsert$().text());
}
if (col.getSqlxGenerateOnUpdate$() != null) {
if ($Time.GenerateOnUpdate$.TIMESTAMP.text().equals(col.getSqlxGenerateOnUpdate$().text())) {
if (isPrimary)
throw new GeneratorExecutionException("Primary column \"" + table.getName$().text() + "." + column.getName$().text() + "\" cannot specify generateOnUpdate");
generateOnUpdate = GenerateOn.TIMESTAMP;
} else {
throw new GeneratorExecutionException("Unknown generateOnUpdate specification: " + col.getSqlxGenerateOnUpdate$().text());
}
}
return new ColumnMeta(table, column, isPrimary, data.TIME.class, commonParams, col.getDefault$() == null ? null : col.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, col.getPrecision$() == null ? null : col.getPrecision$().text());
}
if (column instanceof $Datetime) {
final $Datetime col = ($Datetime) column;
if (col.getSqlxGenerateOnInsert$() != null) {
if ($Datetime.GenerateOnInsert$.TIMESTAMP.text().equals(col.getSqlxGenerateOnInsert$().text()))
generateOnInsert = GenerateOn.TIMESTAMP;
else
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + col.getSqlxGenerateOnInsert$().text());
}
if (col.getSqlxGenerateOnUpdate$() != null) {
if ($Datetime.GenerateOnUpdate$.TIMESTAMP.text().equals(col.getSqlxGenerateOnUpdate$().text())) {
if (isPrimary)
throw new GeneratorExecutionException("Primary column \"" + table.getName$().text() + "." + column.getName$().text() + "\" cannot specify generateOnUpdate");
generateOnUpdate = GenerateOn.TIMESTAMP;
} else {
throw new GeneratorExecutionException("Unknown generateOnUpdate specification: " + col.getSqlxGenerateOnUpdate$().text());
}
}
return new ColumnMeta(table, column, isPrimary, data.DATETIME.class, commonParams, col.getDefault$() == null ? null : col.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, col.getPrecision$() == null ? null : col.getPrecision$().text());
}
if (column instanceof $Boolean) {
final $Boolean col = ($Boolean) column;
return new ColumnMeta(table, column, isPrimary, data.BOOLEAN.class, commonParams, col.getDefault$() == null ? null : col.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate);
}
if (column instanceof $Enum) {
final $Enum col = ($Enum) column;
return new ColumnMeta(table, column, isPrimary, data.ENUM.class, commonParams, col.getDefault$() == null ? null : getClassNameOfEnum(table, col).append('.').append(enumStringToEnum(col.getDefault$().text())), generateOnInsert, generateOnUpdate, isKeyForUpdate);
}
throw new IllegalArgumentException("Unknown class: " + cls);
}
use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns in project jaxdb by jaxdb.
the class Generator method makeForeignRelations.
void makeForeignRelations(final SchemaManifest schemaManifest, final TableMeta table, final List<ColumnMeta> columns, final TableMeta referencesTable, final List<ColumnMeta> referencesColumns) {
final List<TableMeta> descendents = schemaManifest.tableNameToDescendents.get(table.tableName);
for (final TableMeta descendent : descendents) {
if (!descendent.isAbstract) {
final IndexType indexTypeForeign = assertNotNull(referencesTable.columnNameToIndexType.get(referencesColumns));
final IndexType indexType = table.columnNameToIndexType.getOrDefault(columns, indexTypeForeign.getNonUnique());
final Foreign forward = makeForeignRelation(descendent, columns, referencesTable, referencesColumns, indexType, indexTypeForeign);
final Foreign reverse = makeForeignRelation(referencesTable, referencesColumns, descendent, columns, indexTypeForeign, indexType);
forward.reverses.add(reverse);
reverse.reverses.add(forward);
referencesTable.columnNameToRelations.get(referencesColumns).add(reverse);
descendent.columnNameToRelations.get(columns).add(forward);
}
}
}
use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns in project jaxdb by jaxdb.
the class Generator method makeTable.
private String makeTable(final TableMeta tableMeta) {
final Table table = tableMeta.table;
final ColumnMeta[] columns = tableMeta.columns;
final Info info = tableMeta.info;
final String tableName = table.getName$().text();
final int noColumnsLocal = table.getColumn() == null ? 0 : table.getColumn().size();
final int noColumnsTotal = columns.length;
final String classSimpleName = Identifiers.toClassCase(tableName);
final String className = schemaClassName + "." + classSimpleName;
final String instanceName = Identifiers.toInstanceCase(tableName);
final StringBuilder out = new StringBuilder();
if (!table.getAbstract$().text()) {
out.append("\n private static final ").append(className).append(" $").append(instanceName).append(" = new ").append(className).append("(false, false) {");
out.append("\n @").append(Override.class.getName());
final Class<?> primaryCacheMap = tableMeta.primaryKey.size() == 0 ? RelationMap.class : tableMeta.columnNameToIndexType.get(tableMeta.primaryKey).getConcreteClass();
out.append("\n final ").append(primaryCacheMap.getName()).append('<').append(className).append("> getCache() {");
out.append("\n return ").append(tableMeta.primaryKey.size() == 0 ? "null" : getInstanceNameForCache(tableMeta, tableMeta.primaryKey)).append(";");
out.append("\n }\n");
out.append("\n final void _initCache$() {");
out.append("\n if (").append(className).append("._cacheEnabled$)");
out.append("\n return;\n");
out.append("\n ").append(className).append("._cacheEnabled$ = true;");
final Set<String> declared = new HashSet<>();
for (final List<Relation> relations : tableMeta.columnNameToRelations.values()) {
for (final Relation relation : relations) {
write("\n ", relation.writeCacheInit(), out, declared);
}
}
out.append("\n }");
out.append("\n };\n");
out.append("\n public static ").append(className).append(' ').append(classSimpleName).append("() {");
out.append("\n return $").append(instanceName).append(";");
out.append("\n }\n");
}
final String ext = table.getExtends$() == null ? data.Table.class.getCanonicalName() + "<" + className + ">" : Identifiers.toClassCase(table.getExtends$().text());
final String abs = table.getAbstract$().text() ? " abstract" : "";
out.append(getDoc(table, 1, '\0', '\n'));
out.append("\n public").append(abs).append(" static class ").append(classSimpleName).append(" extends ").append(ext).append(" {");
if (table.getExtends$() == null) {
out.append("\n private final ").append(data.MutableKey.class.getCanonicalName()).append(" _primaryKey$ = ").append(data.Key.class.getCanonicalName()).append(".cur(_primary$);\n");
out.append("\n @").append(Override.class.getName());
out.append("\n public final ").append(data.MutableKey.class.getCanonicalName()).append(" getKey() {");
out.append("\n return _primaryKey$;");
out.append("\n }\n");
out.append("\n private final ").append(data.MutableKey.class.getCanonicalName()).append(" _primaryKey$Old = ").append(data.Key.class.getCanonicalName()).append(".old(_primary$);\n");
out.append("\n @").append(Override.class.getName());
out.append("\n final ").append(data.MutableKey.class.getCanonicalName()).append(" getKeyOld() {");
out.append("\n return _primaryKey$Old;");
out.append("\n }\n");
}
if (!table.getAbstract$().text()) {
final Set<String> declared = new HashSet<>();
out.append("\n private static boolean _cacheEnabled$;\n");
out.append("\n @").append(Override.class.getName());
out.append("\n void _commitInsert$() {");
out.append("\n if (!").append(className).append("._cacheEnabled$)");
out.append("\n return;\n");
for (final List<Relation> relations : tableMeta.columnNameToRelations.values()) {
for (final Relation relation : relations) {
write("\n ", relation.writeCacheInsert(classSimpleName, "get"), out, declared);
}
}
out.append("\n }\n");
out.append("\n @").append(Override.class.getName());
out.append("\n void _commitDelete$() {");
out.append("\n if (!").append(className).append("._cacheEnabled$)");
out.append("\n return;\n");
final Collection<Relation> onChangeRelations = new ArrayList<>(1);
for (final Map.Entry<List<ColumnMeta>, List<Relation>> entry : tableMeta.columnNameToRelations.entrySet()) {
onChangeRelations.addAll(entry.getValue());
}
if (onChangeRelations.size() > 0) {
for (final Relation onChangeRelation : onChangeRelations) {
if (onChangeRelation instanceof Foreign) {
final Foreign relation = (Foreign) onChangeRelation;
boolean added = false;
for (final Foreign reverse : relation.reverses) added |= write(" ", reverse.writeOnChangeReverse(relation.fieldName), out, declared);
if (added)
out.append('\n');
write("\n ", relation.writeOnChangeForward(), out, declared);
}
}
declared.clear();
for (final Relation onChangeRelation : onChangeRelations) {
write("\n ", onChangeRelation.writeOnChangeClearCache(classSimpleName, onChangeRelation.keyClause, ""), out, declared);
}
}
out.append("\n }\n");
out.append("\n private static final ").append(String.class.getName()).append("[] _columnName$ = {");
for (int i = 0; i < noColumnsTotal; ++i) // FIXME: Hacking this to record what is the index of each column
columns[i].column.text(String.valueOf(i));
final List<$Column> sortedColumns = new ArrayList<>();
for (final ColumnMeta columnMeta : columns) sortedColumns.add(columnMeta.column);
sortedColumns.sort(namedComparator);
for (final $Column column : sortedColumns) out.append('"').append(column.getName$().text()).append("\", ");
out.setCharAt(out.length() - 2, '}');
out.setCharAt(out.length() - 1, ';');
out.append('\n');
out.append("\n @").append(Override.class.getName());
out.append("\n ").append(String.class.getName()).append("[] _columnName$() {");
out.append("\n return _columnName$;");
out.append("\n }\n");
out.append("\n private static final byte[] _columnIndex$ = {");
for (final $Column column : sortedColumns) out.append(column.text()).append(", ");
out.setCharAt(out.length() - 2, '}');
out.setCharAt(out.length() - 1, ';');
out.append('\n');
out.append("\n @").append(Override.class.getName());
out.append("\n byte[] _columnIndex$() {");
out.append("\n return _columnIndex$;");
out.append("\n }\n");
out.append("\n @").append(Override.class.getName());
out.append("\n public ").append(String.class.getName()).append(" getName() {");
out.append("\n return \"").append(tableName).append("\";");
out.append("\n }\n");
out.append("\n @").append(Override.class.getName());
out.append("\n ").append(className).append(" newInstance() {");
out.append("\n return new ").append(className).append("(true, true);");
out.append("\n }\n");
out.append("\n @").append(Override.class.getName());
out.append("\n ").append(className).append(" singleton() {");
out.append("\n return $").append(instanceName).append(";");
out.append("\n }\n");
out.append("\n @").append(Override.class.getName());
out.append("\n ").append(Schema.class.getName()).append(" getSchema() {");
out.append("\n return ").append(schemaClassName).append(".getSchema();");
out.append("\n }\n");
final StringBuilder init = new StringBuilder();
newColumnArray(init, noColumnsTotal).append(", ");
newColumnArray(init, info.totalPrimaryCount.count).append(", ");
newColumnArray(init, info.totalKeyForUpdateCount.count).append(", ");
newColumnArray(init, info.totalAutoCount.count);
out.append("\n ").append(classSimpleName).append("(final boolean _mutable$, final boolean _wasSelected$) {");
out.append("\n this(_mutable$, _wasSelected$, ").append(init).append(");");
out.append("\n }\n");
out.append("\n /** Creates a new {@link ").append(className).append("}. */");
out.append("\n public ").append(classSimpleName).append("() {");
out.append("\n this(true);");
out.append("\n }\n");
// Constructor with primary key columns
if (info.totalPrimaryCount.count > 0) {
final StringBuilder set = new StringBuilder();
out.append("\n /** Creates a new {@link ").append(className).append("} with the specified primary key. */");
out.append("\n public ").append(classSimpleName).append("(");
final StringBuilder params = new StringBuilder();
for (final ColumnMeta columnMeta : columns) {
if (columnMeta.isPrimary) {
params.append("final ").append(columnMeta.rawType).append(' ').append(columnMeta.camelCase).append(", ");
final String fieldName = Identifiers.toCamelCase(columnMeta.column.getName$().text());
set.append(" this.").append(fieldName).append(".set(").append(fieldName).append(");\n");
}
}
params.setLength(params.length() - 2);
out.append(params).append(") {");
out.append("\n this();\n");
if (set.length() > 0) {
set.setLength(set.length() - 1);
out.append(set);
}
out.append("\n }\n");
}
out.append("\n ").append(classSimpleName).append("(final boolean _mutable$) {");
out.append("\n this(_mutable$, false, ").append(init).append(");");
out.append("\n }\n");
// Copy constructor
out.append("\n /** Creates a new {@link ").append(className).append("} as a copy of the provided {@link ").append(className).append("} instance. */");
out.append("\n public ").append(classSimpleName).append("(final ").append(className).append(" copy) {");
out.append("\n this(true, copy);");
out.append("\n }\n");
out.append("\n /** Creates a new {@link ").append(className).append("} as a copy of the provided {@link ").append(className).append("} instance. */");
out.append("\n ").append(classSimpleName).append("(final boolean _mutable$, final ").append(className).append(" copy) {");
out.append("\n this(_mutable$, false, ").append(init).append(", copy);");
out.append("\n }\n\n");
}
for (int x = 0; x < 2; ++x) {
if (x == 0) {
out.append(" ").append(classSimpleName).append("(final boolean _mutable$, final boolean _wasSelected$, final ").append(data.Column.class.getCanonicalName()).append("<?>[] _column$, final ").append(data.Column.class.getCanonicalName()).append("<?>[] _primary$, final ").append(data.Column.class.getCanonicalName()).append("<?>[] _keyForUpdate$, final ").append(data.Column.class.getCanonicalName()).append("<?>[] _auto$) {\n");
out.append(" super(_mutable$, _wasSelected$, _column$, _primary$, _keyForUpdate$, _auto$);\n");
} else {
out.append(" ").append(classSimpleName).append("(final boolean _mutable$, final boolean _wasSelected$, final ").append(data.Column.class.getCanonicalName()).append("<?>[] _column$, final ").append(data.Column.class.getCanonicalName()).append("<?>[] _primary$, final ").append(data.Column.class.getCanonicalName()).append("<?>[] _keyForUpdate$, final ").append(data.Column.class.getCanonicalName()).append("<?>[] _auto$, final ").append(className).append(" copy) {\n");
out.append(" super(_mutable$, _wasSelected$, _column$, _primary$, _keyForUpdate$, _auto$");
if (table.getExtends$() != null)
out.append(", copy");
out.append(");\n");
}
int primaryIndex = info.totalPrimaryCount.offset;
int keyForUpdateIndex = info.totalKeyForUpdateCount.offset;
int autoIndex = info.totalAutoCount.offset;
for (int s = columns.length - noColumnsLocal, i = s; i < columns.length; ++i) {
if (i > s)
out.append('\n');
final ColumnMeta columnMeta = columns[i];
out.append(" _column$[").append(i).append("] = ");
if (columnMeta.isPrimary)
out.append("_primary$[").append(primaryIndex++).append("] = ");
if (columnMeta.keyForUpdate)
out.append("_keyForUpdate$[").append(keyForUpdateIndex++).append("] = ");
if (org.jaxdb.ddlx.Generator.isAuto(columnMeta.column))
out.append("_auto$[").append(autoIndex++).append("] = ");
if (x == 0)
columnMeta.assignColumn(out);
else
columnMeta.assignClone(out);
// This section executed onChanged() for each column to clear the foreign Key
// Map<String,String> foreignKeyColumns = tableToForeignKeyColumns.get(table);
// if (foreignKeyColumns == null) {
// tableToForeignKeyColumns.put(table, foreignKeyColumns = new HashMap<>());
// for (final ColumnMeta t : columns) {
// if (t.column.getForeignKey() != null) {
// final String privateKeyName = "_foreignKey$" + t.instanceCase;
// foreignKeyColumns.put(t.column.getName$().text(), privateKeyName);
// }
// }
//
// if (table.getConstraints() != null && table.getConstraints().getForeignKey() != null) {
// for (final $ForeignKeyComposite foreignKey : table.getConstraints().getForeignKey()) {
// final StringBuilder foreignKeyName = new StringBuilder();
// for (final $ForeignKeyComposite.Column column : foreignKey.getColumn()) {
// final String camelCase = Identifiers.toCamelCase(column.getName$().text());
// foreignKeyName.append(camelCase).append('$');
// }
//
// foreignKeyName.setLength(foreignKeyName.length() - 1);
// final String privateKeyName = "_foreignKey$" + foreignKeyName;
// for (final $ForeignKeyComposite.Column column : foreignKey.getColumn()) {
// foreignKeyColumns.put(column.getName$().text(), privateKeyName);
// }
// }
// }
// }
//
final List<Relation> onChangeRelations = new ArrayList<>(1);
for (final Map.Entry<List<ColumnMeta>, List<Relation>> entry : tableMeta.columnNameToRelations.entrySet()) {
final List<ColumnMeta> columnNames = entry.getKey();
if (columnNames.contains(columnMeta))
onChangeRelations.addAll(entry.getValue());
}
final Set<String> declared = new HashSet<>();
if (onChangeRelations.size() > 0) {
out.append(" {\n @").append(Override.class.getName());
out.append("\n protected void _commitUpdate$() {");
out.append("\n if (!").append(className).append("._cacheEnabled$)");
out.append("\n return;\n");
for (final Relation onChangeRelation : onChangeRelations) {
if (onChangeRelation instanceof Foreign) {
final Foreign relation = (Foreign) onChangeRelation;
boolean added = false;
for (final Foreign reverse : relation.reverses) added |= write("\n ", reverse.writeOnChangeClearCacheForeign(classSimpleName, onChangeRelation.keyClause, "getOld", "get"), out, declared);
if (added)
out.append('\n');
write("\n ", relation.writeOnChangeForward(), out, declared);
}
}
for (final Relation onChangeRelation : onChangeRelations) {
write("\n ", onChangeRelation.writeOnChangeClearCache(classSimpleName, onChangeRelation.keyClause, "Old"), out, declared);
}
for (final Relation onChangeRelation : onChangeRelations) {
write("\n ", onChangeRelation.writeCacheInsert(classSimpleName, "get"), out, declared);
}
if (columnMeta.isPrimary) {
for (final Map.Entry<List<ColumnMeta>, List<Relation>> entry : tableMeta.columnNameToRelations.entrySet()) {
for (final Relation onChangeRelation : entry.getValue()) {
if (onChangeRelation instanceof Foreign) {
final Foreign relation = (Foreign) onChangeRelation;
if (entry.getKey().contains(columnMeta) || onChangeRelation instanceof ManyToManyRelation) {
write("\n ", relation.writeOnChangeClearCache(classSimpleName, relation.keyClause, "Old"), out, declared);
write("\n ", relation.writeCacheInsert(classSimpleName, "get"), out, declared);
}
// for (final Foreign reverse : relation.reverses) {
// if (reverse.referencesColumns.contains(columnMeta))
// write(" ", reverse.writeOnChangeClearCache(classSimpleName, relation.keyClause, "Old"), "\n", out, declared);
// }
}
}
}
}
out.append("\n }\n }");
}
out.append(';');
}
out.append("\n }\n\n");
}
out.append(" // CACHES\n");
final Set<String> declared = new HashSet<>();
for (final List<Relation> relations : tableMeta.columnNameToRelations.values()) {
for (final Relation relation : relations) {
write("\n", relation.writeCacheDeclare(), out, declared);
}
}
if (declared.size() > 0)
out.append('\n');
out.append(" // FOREIGN KEYS\n\n");
for (final List<Relation> relations : tableMeta.columnNameToRelations.values()) for (final Relation relation : relations) if (relation instanceof Foreign)
((Foreign) relation).writeDeclaration(out, classSimpleName);
out.append(" @").append(Override.class.getName()).append('\n');
out.append(" void _merge$(final ").append(info.rootClassName).append(" table) {\n");
if (table.getExtends$() != null) {
out.append(" super._merge$(table);\n");
out.append(" final ").append(className).append(" t = (").append(className).append(")table;\n");
} else {
out.append(" final ").append(className).append(" t = table;\n");
}
boolean hasColumnsToMerge = false;
for (int s = columns.length - noColumnsLocal, i = s; i < columns.length; ++i) {
final ColumnMeta columnMeta = columns[i];
if (hasColumnsToMerge)
out.append('\n');
hasColumnsToMerge = true;
final String fieldName = Identifiers.toCamelCase(columnMeta.column.getName$().text());
out.append(" if (t.").append(fieldName).append(".setByCur != null)\n");
out.append(" ").append(fieldName).append(".copy(t.").append(fieldName).append(");\n");
}
out.append(" }\n");
for (int s = columns.length - noColumnsLocal, i = s; i < columns.length; ++i) out.append(columns[i].declareColumn());
out.append("\n\n");
if (table.getAbstract$().text()) {
out.append(" @").append(Override.class.getName()).append('\n');
out.append(" abstract ").append(className).append(" clone(final boolean _mutable$);\n\n");
out.append(" public abstract ").append(className).append(" clone();\n\n");
} else {
out.append(" @").append(Override.class.getName()).append('\n');
out.append(" ").append(className).append(" clone(final boolean _mutable$) {\n");
out.append(" return new ").append(className).append("(_mutable$, this);\n");
out.append(" }\n\n");
out.append(" @").append(Override.class.getName()).append('\n');
out.append(" public ").append(className).append(" clone() {\n");
out.append(" return clone(true);\n");
out.append(" }\n\n");
}
out.append(" @").append(Override.class.getName()).append('\n');
out.append(" public boolean equals(final ").append(Object.class.getName()).append(" obj) {\n");
out.append(" if (obj == this)\n");
out.append(" return true;\n\n");
out.append(" if (!(obj instanceof ").append(className).append("))\n");
out.append(" return false;\n\n");
if (table.getExtends$() != null) {
out.append(" if (!super.equals(obj))\n");
out.append(" return false;\n\n");
}
out.append(" final ").append(className).append(" that = (").append(className).append(")obj;");
for (int s = columns.length - noColumnsLocal, i = s; i < columns.length; ++i) {
final ColumnMeta columnMeta = columns[i];
out.append("\n if (this.").append(columnMeta.getInstanceName()).append(".isNull() ? !that.").append(columnMeta.getInstanceName()).append(".isNull() : !this.").append(columnMeta.getInstanceName()).append(".get().equals(that.").append(columnMeta.getInstanceName()).append(".get()))");
out.append("\n return false;\n");
}
out.append("\n return true;");
out.append("\n }\n\n");
out.append(" @").append(Override.class.getName()).append('\n');
out.append(" public int hashCode() {\n");
if (table.getExtends$() != null)
out.append(" int hashCode = super.hashCode();");
else
out.append(" int hashCode = ").append(tableName.hashCode()).append(";");
for (int s = columns.length - noColumnsLocal, i = s; i < columns.length; ++i) {
final ColumnMeta columnMeta = columns[i];
out.append("\n if (!this.").append(columnMeta.getInstanceName()).append(".isNull())");
out.append("\n hashCode = 31 * hashCode + this.").append(columnMeta.getInstanceName()).append(".get().hashCode();\n");
}
out.append("\n return hashCode;");
out.append("\n }\n\n");
out.append(" @").append(Override.class.getName()).append('\n');
out.append(" protected void toString(final boolean wasSetOnly, final ").append(StringBuilder.class.getName()).append(" s) {\n");
if (table.getExtends$() != null)
out.append(" super.toString(wasSetOnly, s);\n");
for (int s = columns.length - noColumnsLocal, i = s; i < columns.length; ++i) {
final ColumnMeta columnMeta = columns[i];
final boolean ifClause = !columnMeta.isPrimary && !columnMeta.keyForUpdate;
if (ifClause)
out.append(" if (!wasSetOnly || this.").append(columnMeta.getInstanceName()).append(".setByCur != null)\n ");
out.append(" s.append(\",\\\"").append(columnMeta.column.getName$().text()).append("\\\":\").append(this.").append(columnMeta.getInstanceName()).append(".toJson());\n");
if (ifClause)
out.append('\n');
}
out.append(" if (s.length() > 0)\n");
out.append(" s.setCharAt(0, '{');\n");
out.append(" else\n");
out.append(" s.append('{');\n\n");
out.append(" s.append('}');");
out.append("\n }");
out.append("\n }");
return out.toString();
}
use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns in project jaxdb by jaxdb.
the class SqlJaxSBLoader method loadRow.
@SuppressWarnings("unchecked")
private static void loadRow(final ArrayList<Row> rows, final $Row row, final Dialect dialect, final Compiler compiler, final TableToColumnToIncrement tableToColumnToIncrement) {
try {
final int i = row.id().lastIndexOf('-');
final String tableName = row.id().substring(0, i);
final int weight = Integer.parseInt(row.id().substring(i + 1));
final StringBuilder columns = new StringBuilder();
final StringBuilder values = new StringBuilder();
boolean hasValues = false;
final Method[] methods = Classes.getDeclaredMethodsDeep(row.getClass());
for (final Method method : methods) {
if (!method.getName().startsWith("get") || !Attribute.class.isAssignableFrom(method.getReturnType()))
continue;
final Id id = method.getReturnType().getAnnotation(Id.class);
if (id == null)
continue;
final String idValue = id.value();
final int d1 = idValue.indexOf('-');
final int d2 = idValue.indexOf('-', d1 + 1);
final String columnName;
final String generateOnInsert;
final boolean isAutoIncremented;
if (d2 != -1) {
columnName = idValue.substring(d1 + 1, d2);
generateOnInsert = idValue.substring(d2 + 1);
isAutoIncremented = "AUTO_INCREMENT".equals(generateOnInsert);
} else {
columnName = idValue.substring(d1 + 1);
generateOnInsert = null;
isAutoIncremented = false;
}
final $AnySimpleType<?> attribute = ($AnySimpleType<?>) method.invoke(row);
String value = getValue(compiler, attribute);
if (value == null) {
if (generateOnInsert == null || isAutoIncremented)
continue;
value = generateValue(dialect, compiler, (Class<? extends $AnySimpleType<?>>) method.getReturnType(), generateOnInsert);
} else if (isAutoIncremented) {
final Map<String, Integer> columnToIncrement = tableToColumnToIncrement.get(tableName);
final Integer increment = columnToIncrement.get(columnName);
final Integer intValue = Integer.valueOf(value);
if (increment == null || increment < intValue)
columnToIncrement.put(columnName, intValue);
}
if (hasValues) {
columns.append(", ");
values.append(", ");
}
columns.append(dialect.quoteIdentifier(columnName));
values.append(value);
hasValues = true;
}
if (columns.length() == 0)
throw new IllegalStateException();
rows.add(new Row(weight, compiler.insert(tableName, columns, values)));
} catch (final IllegalAccessException e) {
throw new RuntimeException(e);
} catch (final InvocationTargetException e) {
if (e.getCause() instanceof RuntimeException)
throw (RuntimeException) e.getCause();
throw new RuntimeException(e.getCause());
}
}
use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns in project jaxdb by jaxdb.
the class Compiler method blockPrimaryKey.
String blockPrimaryKey(final $Table table, final $Constraints constraints, final Map<String, ColumnRef> columnNameToColumn) throws GeneratorExecutionException {
if (constraints.getPrimaryKey() == null)
return "";
final StringBuilder builder = new StringBuilder();
final List<$Named> columns = constraints.getPrimaryKey().getColumn();
final PrimaryKey.Using$ using = constraints.getPrimaryKey().getUsing$();
final int[] columnIndexes = new int[columns.size()];
final Iterator<$Named> iterator = columns.iterator();
for (int i = 0; iterator.hasNext(); ++i) {
final $Named primaryColumn = iterator.next();
final String primaryKeyColumn = primaryColumn.getName$().text();
final ColumnRef ref = columnNameToColumn.get(primaryKeyColumn);
if (ref == null)
throw new GeneratorExecutionException("PRIMARY KEY column " + table.getName$().text() + "." + primaryKeyColumn + " is not defined");
if (ref.column.getNull$() == null || ref.column.getNull$().text())
throw new GeneratorExecutionException("Column " + ref.column.getName$() + " must be NOT NULL to be a PRIMARY KEY");
if (i > 0)
builder.append(", ");
builder.append(q(primaryKeyColumn));
columnIndexes[i] = ref.index;
}
return ",\n " + primaryKey(table, columnIndexes, using) + " (" + builder + ")";
}
Aggregations