Example 1 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named
use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named in project jaxdb by jaxdb.
the class Generator method getType.
private Type getType(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 type = ($Char) column;
if (type.getSqlxGenerateOnInsert$() != null) {
if ($Char.GenerateOnInsert$.UUID.text().equals(type.getSqlxGenerateOnInsert$().text()))
generateOnInsert = GenerateOn.UUID;
else
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + type.getSqlxGenerateOnInsert$().text());
}
return new Type(table, column, isPrimary, data.CHAR.class, commonParams, type.getDefault$() == null ? null : type.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, type.getLength$() == null ? null : type.getLength$().text(), isVarying(type.getVarying$()));
}
if (column instanceof $Clob) {
final $Clob type = ($Clob) column;
return new Type(table, column, isPrimary, data.CLOB.class, commonParams, null, generateOnInsert, generateOnUpdate, isKeyForUpdate, type.getLength$() == null ? null : type.getLength$().text());
}
if (column instanceof $Binary) {
final $Binary type = ($Binary) column;
return new Type(table, column, isPrimary, data.BINARY.class, commonParams, type.getDefault$() == null ? null : type.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, type.getLength$() == null ? null : type.getLength$().text(), isVarying(type.getVarying$()));
}
if (column instanceof $Blob) {
final $Blob type = ($Blob) column;
return new Type(table, column, isPrimary, data.BLOB.class, commonParams, null, generateOnInsert, generateOnUpdate, isKeyForUpdate, type.getLength$() == null ? null : type.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 Type(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 Type(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 Type(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 Type(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 type = ($Float) column;
final Class<? extends data.Column<?>> col = data.FLOAT.class;
final Number min = type.getMin$() != null ? type.getMin$().text() : null;
final Number max = type.getMax$() != null ? type.getMax$().text() : null;
return new Type(table, column, isPrimary, col, commonParams, type.getDefault$() == null ? null : type.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, min, max);
}
if (column instanceof $Double) {
final $Double type = ($Double) column;
final Class<? extends data.Column<?>> col = data.DOUBLE.class;
final Number min = type.getMin$() != null ? type.getMin$().text() : null;
final Number max = type.getMax$() != null ? type.getMax$().text() : null;
return new Type(table, column, isPrimary, col, commonParams, type.getDefault$() == null ? null : type.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, min, max);
}
if (column instanceof $Decimal) {
final $Decimal type = ($Decimal) column;
return new Type(table, column, isPrimary, data.DECIMAL.class, commonParams, type.getDefault$() == null ? null : type.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, type.getPrecision$() == null ? null : type.getPrecision$().text().intValue(), type.getScale$() == null ? null : type.getScale$().text().intValue(), type.getMin$() == null ? null : type.getMin$().text(), type.getMax$() == null ? null : type.getMax$().text());
}
if (column instanceof $Date) {
final $Date type = ($Date) column;
if (type.getSqlxGenerateOnInsert$() != null) {
if ($Date.GenerateOnInsert$.TIMESTAMP.text().equals(type.getSqlxGenerateOnInsert$().text()))
generateOnInsert = GenerateOn.TIMESTAMP;
else
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + type.getSqlxGenerateOnInsert$().text());
}
if (type.getSqlxGenerateOnUpdate$() != null) {
if ($Date.GenerateOnUpdate$.TIMESTAMP.text().equals(type.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: " + type.getSqlxGenerateOnUpdate$().text());
}
}
return new Type(table, column, isPrimary, data.DATE.class, commonParams, type.getDefault$() == null ? null : type.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate);
}
if (column instanceof $Time) {
final $Time type = ($Time) column;
if (type.getSqlxGenerateOnInsert$() != null) {
if ($Time.GenerateOnInsert$.TIMESTAMP.text().equals(type.getSqlxGenerateOnInsert$().text()))
generateOnInsert = GenerateOn.TIMESTAMP;
else
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + type.getSqlxGenerateOnInsert$().text());
}
if (type.getSqlxGenerateOnUpdate$() != null) {
if ($Time.GenerateOnUpdate$.TIMESTAMP.text().equals(type.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: " + type.getSqlxGenerateOnUpdate$().text());
}
}
return new Type(table, column, isPrimary, data.TIME.class, commonParams, type.getDefault$() == null ? null : type.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, type.getPrecision$() == null ? null : type.getPrecision$().text());
}
if (column instanceof $Datetime) {
final $Datetime type = ($Datetime) column;
if (type.getSqlxGenerateOnInsert$() != null) {
if ($Datetime.GenerateOnInsert$.TIMESTAMP.text().equals(type.getSqlxGenerateOnInsert$().text()))
generateOnInsert = GenerateOn.TIMESTAMP;
else
throw new GeneratorExecutionException("Unknown generateOnInsert specification: " + type.getSqlxGenerateOnInsert$().text());
}
if (type.getSqlxGenerateOnUpdate$() != null) {
if ($Datetime.GenerateOnUpdate$.TIMESTAMP.text().equals(type.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: " + type.getSqlxGenerateOnUpdate$().text());
}
}
return new Type(table, column, isPrimary, data.DATETIME.class, commonParams, type.getDefault$() == null ? null : type.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate, type.getPrecision$() == null ? null : type.getPrecision$().text());
}
if (column instanceof $Boolean) {
final $Boolean type = ($Boolean) column;
return new Type(table, column, isPrimary, data.BOOLEAN.class, commonParams, type.getDefault$() == null ? null : type.getDefault$().text(), generateOnInsert, generateOnUpdate, isKeyForUpdate);
}
if (column instanceof $Enum) {
final $Enum type = ($Enum) column;
return new Type(table, column, isPrimary, data.ENUM.class, commonParams, type.getDefault$() == null ? null : getClassNameOfEnum(table, type).append('.').append(enumStringToEnum(type.getDefault$().text())), generateOnInsert, generateOnUpdate, isKeyForUpdate);
}
throw new IllegalArgumentException("Unknown type: " + cls);
}
Also used :
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Char(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Char)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Decimal(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Decimal)
org.jaxdb.jsql.data(org.jaxdb.jsql.data)
GeneratorExecutionException(org.jaxdb.ddlx.GeneratorExecutionException)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Enum(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Enum)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Boolean(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Boolean)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Clob(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Clob)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Datetime(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Datetime)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Integer(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Integer)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Float(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Float)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Double(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Double)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Date(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Date)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Time(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Time)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Blob(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Blob)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Binary(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Binary)
Example 2 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named
use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named in project jaxdb by jaxdb.
the class Compiler method createConstraints.
private CreateStatement createConstraints(final Map<String, ColumnRef> columnNameToColumn, final $Table table) throws GeneratorExecutionException {
final StringBuilder constraintsBuilder = new StringBuilder();
if (table.getConstraints() != null) {
final $Constraints constraints = table.getConstraints();
// unique constraint
final List<$Columns> uniques = constraints.getUnique();
if (uniques != null) {
final StringBuilder uniqueString = new StringBuilder();
final StringBuilder uniqueBuilder = new StringBuilder();
for (final $Columns unique : uniques) {
final List<$Named> columns = unique.getColumn();
final int[] columnIndexes = new int[columns.size()];
for (int i = 0, len = columns.size(); i < len; ++i) {
if (i > 0)
uniqueBuilder.append(", ");
final String columnName = columns.get(i).getName$().text();
uniqueBuilder.append(q(columnName));
columnIndexes[i] = columnNameToColumn.get(columnName).index;
}
uniqueString.append(",\n CONSTRAINT ").append(q(getConstraintName("uq", table, null, columnIndexes))).append(" UNIQUE (").append(uniqueBuilder).append(')');
uniqueBuilder.setLength(0);
}
constraintsBuilder.append(uniqueString);
}
// check constraint
final List<$CheckReference> checks = constraints.getCheck();
if (checks != null) {
final StringBuilder checkBuilder = new StringBuilder();
for (final $CheckReference check : checks) {
final String checkRule = recurseCheckRule(check);
final String checkClause = checkRule.startsWith("(") ? checkRule : "(" + checkRule + ")";
checkBuilder.append(",\n CONSTRAINT ").append(q(getConstraintName("ck", new StringBuilder(hash(table.getName$().text() + checkClause))))).append(" CHECK ").append(checkClause);
}
constraintsBuilder.append(checkBuilder);
}
// primary key constraint
final String primaryKeyConstraint = blockPrimaryKey(table, constraints, columnNameToColumn);
if (primaryKeyConstraint != null)
constraintsBuilder.append(primaryKeyConstraint);
// foreign key constraints
final List<$ForeignKeyComposite> foreignKeyComposites = constraints.getForeignKey();
if (foreignKeyComposites != null) {
for (final $ForeignKeyComposite foreignKeyComposite : foreignKeyComposites) {
final List<$ForeignKeyComposite.Column> columns = foreignKeyComposite.getColumn();
final int[] columnIndexes = new int[columns.size()];
final String[] foreignKeyColumns = new String[columns.size()];
final String[] foreignKeyReferences = new String[columns.size()];
for (int i = 0, len = columns.size(); i < len; ++i) {
final $ForeignKeyComposite.Column column = columns.get(i);
final String columnName = column.getName$().text();
foreignKeyColumns[i] = q(columnName);
foreignKeyReferences[i] = q(column.getReferences$().text());
columnIndexes[i] = columnNameToColumn.get(columnName).index;
}
constraintsBuilder.append(",\n ").append(foreignKey(table, foreignKeyComposite.getReferences$(), columnIndexes)).append(" (").append(ArrayUtil.toString(foreignKeyColumns, ", "));
constraintsBuilder.append(") REFERENCES ").append(q(foreignKeyComposite.getReferences$().text()));
constraintsBuilder.append(" (").append(ArrayUtil.toString(foreignKeyReferences, ", ")).append(')');
appendOnDeleteOnUpdate(constraintsBuilder, foreignKeyComposite);
}
}
}
if (table.getColumn() != null) {
final List<$Column> columns = table.getColumn();
for (int c = 0, len = columns.size(); c < len; ++c) {
final $Column column = columns.get(c);
final $ForeignKeyUnary foreignKey = column.getForeignKey();
if (foreignKey != null) {
constraintsBuilder.append(",\n ").append(foreignKey(table, foreignKey.getReferences$(), c)).append(" (").append(q(column.getName$().text()));
constraintsBuilder.append(") REFERENCES ").append(q(foreignKey.getReferences$().text()));
constraintsBuilder.append(" (").append(q(foreignKey.getColumn$().text())).append(')');
appendOnDeleteOnUpdate(constraintsBuilder, foreignKey);
}
}
// Parse the min & max constraints of numeric types
for (int c = 0, len = columns.size(); c < len; ++c) {
final $Column column = columns.get(c);
String minCheck = null;
String maxCheck = null;
if (column instanceof $Integer) {
if (column instanceof $Tinyint) {
final $Tinyint type = ($Tinyint) column;
minCheck = type.getMin$() != null ? String.valueOf(type.getMin$().text()) : null;
maxCheck = type.getMax$() != null ? String.valueOf(type.getMax$().text()) : null;
} else if (column instanceof $Smallint) {
final $Smallint type = ($Smallint) column;
minCheck = type.getMin$() != null ? String.valueOf(type.getMin$().text()) : null;
maxCheck = type.getMax$() != null ? String.valueOf(type.getMax$().text()) : null;
} else if (column instanceof $Int) {
final $Int type = ($Int) column;
minCheck = type.getMin$() != null ? String.valueOf(type.getMin$().text()) : null;
maxCheck = type.getMax$() != null ? String.valueOf(type.getMax$().text()) : null;
} else if (column instanceof $Bigint) {
final $Bigint type = ($Bigint) column;
minCheck = type.getMin$() != null ? String.valueOf(type.getMin$().text()) : null;
maxCheck = type.getMax$() != null ? String.valueOf(type.getMax$().text()) : null;
} else {
throw new UnsupportedOperationException("Unsupported type: " + column.getClass().getName());
}
} else if (column instanceof $Float) {
final $Float type = ($Float) column;
minCheck = type.getMin$() != null ? String.valueOf(type.getMin$().text()) : null;
maxCheck = type.getMax$() != null ? String.valueOf(type.getMax$().text()) : null;
} else if (column instanceof $Double) {
final $Double type = ($Double) column;
minCheck = type.getMin$() != null ? String.valueOf(type.getMin$().text()) : null;
maxCheck = type.getMax$() != null ? String.valueOf(type.getMax$().text()) : null;
} else if (column instanceof $Decimal) {
final $Decimal type = ($Decimal) column;
minCheck = type.getMin$() != null ? String.valueOf(type.getMin$().text()) : null;
maxCheck = type.getMax$() != null ? String.valueOf(type.getMax$().text()) : null;
}
final String minCheckExp = minCheck == null ? null : q(column.getName$().text()) + " >= " + minCheck;
final String maxCheckExp = maxCheck == null ? null : q(column.getName$().text()) + " <= " + maxCheck;
if (minCheck != null) {
if (maxCheck != null)
constraintsBuilder.append(",\n ").append(check(table, c, Operator.GTE, minCheck, Operator.LTE, maxCheck)).append(" (").append(minCheckExp).append(" AND ").append(maxCheckExp).append(')');
else
constraintsBuilder.append(",\n ").append(check(table, c, Operator.GTE, minCheck, null, null)).append(" (").append(minCheckExp).append(')');
} else if (maxCheck != null) {
constraintsBuilder.append(",\n ").append(check(table, c, Operator.LTE, maxCheck, null, null)).append(" (").append(maxCheckExp).append(')');
}
}
// parse the <check/> element per type
for (int c = 0, len = columns.size(); c < len; ++c) {
final $Column column = columns.get(c);
Operator operator = null;
String condition = null;
if (column instanceof $Char) {
final $Char type = ($Char) column;
if (type.getCheck() != null) {
operator = Operator.valueOf(type.getCheck().getOperator$().text());
condition = "'" + type.getCheck().getValue$().text() + "'";
}
} else if (column instanceof $Tinyint) {
final $Tinyint type = ($Tinyint) column;
if (type.getCheck() != null) {
operator = Operator.valueOf(type.getCheck().getOperator$().text());
condition = String.valueOf(type.getCheck().getValue$().text());
}
} else if (column instanceof $Smallint) {
final $Smallint type = ($Smallint) column;
if (type.getCheck() != null) {
operator = Operator.valueOf(type.getCheck().getOperator$().text());
condition = String.valueOf(type.getCheck().getValue$().text());
}
} else if (column instanceof $Int) {
final $Int type = ($Int) column;
if (type.getCheck() != null) {
operator = Operator.valueOf(type.getCheck().getOperator$().text());
condition = String.valueOf(type.getCheck().getValue$().text());
}
} else if (column instanceof $Bigint) {
final $Bigint type = ($Bigint) column;
if (type.getCheck() != null) {
operator = Operator.valueOf(type.getCheck().getOperator$().text());
condition = String.valueOf(type.getCheck().getValue$().text());
}
} else if (column instanceof $Float) {
final $Float type = ($Float) column;
if (type.getCheck() != null) {
operator = Operator.valueOf(type.getCheck().getOperator$().text());
condition = String.valueOf(type.getCheck().getValue$().text());
}
} else if (column instanceof $Double) {
final $Double type = ($Double) column;
if (type.getCheck() != null) {
operator = Operator.valueOf(type.getCheck().getOperator$().text());
condition = String.valueOf(type.getCheck().getValue$().text());
}
} else if (column instanceof $Decimal) {
final $Decimal type = ($Decimal) column;
if (type.getCheck() != null) {
operator = Operator.valueOf(type.getCheck().getOperator$().text());
condition = String.valueOf(type.getCheck().getValue$().text());
}
}
if (operator != null) {
if (condition != null)
constraintsBuilder.append(",\n ").append(check(table, c, operator, condition, null, null)).append(" (").append(q(column.getName$().text())).append(' ').append(operator.symbol).append(' ').append(condition).append(')');
else
throw new UnsupportedOperationException("Unsupported 'null' condition encountered on column '" + column.getName$().text());
} else if (condition != null) {
throw new UnsupportedOperationException("Unsupported 'null' operator encountered on column '" + column.getName$().text());
}
}
}
return constraintsBuilder.length() == 0 ? null : new CreateStatement(constraintsBuilder.toString());
}
Also used :
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Char(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Char)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Decimal(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Decimal)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$ForeignKeyUnary(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$ForeignKeyUnary)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$ForeignKeyComposite(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$ForeignKeyComposite)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$CheckReference(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$CheckReference)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Constraints(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Constraints)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Integer(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Integer)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Float(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Float)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Double(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Double)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int)
Example 3 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named
use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named in project jaxdb by jaxdb.
the class Compiler method indexes.
List<CreateStatement> indexes(final $Table table, final Map<String, ColumnRef> columnNameToColumn) {
final List<CreateStatement> statements = new ArrayList<>();
if (table.getIndexes() != null) {
for (final $Table.Indexes.Index index : table.getIndexes().getIndex()) {
final List<$Named> columns = index.getColumn();
final int[] columnIndexes = new int[columns.size()];
for (int c = 0, len = columns.size(); c < len; ++c) {
final $Named column = columns.get(c);
columnIndexes[c] = columnNameToColumn.get(column.getName$().text()).index;
}
final CreateStatement createIndex = createIndex(index.getUnique$() != null && index.getUnique$().text(), getIndexName(table, index, columnIndexes), index.getType$(), table.getName$().text(), index.getColumn().toArray(new $Named[index.getColumn().size()]));
if (createIndex != null)
statements.add(createIndex);
}
}
if (table.getColumn() != null) {
final List<$Column> columns = table.getColumn();
for (int c = 0, len = columns.size(); c < len; ++c) {
final $Column column = columns.get(c);
if (column.getIndex() != null) {
final CreateStatement createIndex = createIndex(column.getIndex().getUnique$() != null && column.getIndex().getUnique$().text(), getIndexName(table, column.getIndex(), c), column.getIndex().getType$(), table.getName$().text(), column);
if (createIndex != null)
statements.add(createIndex);
}
}
}
return statements;
}
Also used :
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named)
ArrayList(java.util.ArrayList)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column)
Example 4 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named
use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named in project jaxdb by jaxdb.
the class SQLiteCompiler method $autoIncrement.
@Override
String $autoIncrement(final LinkedHashSet<CreateStatement> alterStatements, final $Table table, final $Integer column) {
if (!Generator.isAuto(column))
return null;
final $Columns primaryKey;
if (table.getConstraints() == null || (primaryKey = table.getConstraints().getPrimaryKey()) == null) {
if (logger.isWarnEnabled())
logger.warn("AUTO_INCREMENT is only allowed on an INT PRIMARY KEY -- Ignoring AUTO_INCREMENT spec.");
return null;
}
if (primaryKey.getColumn().size() > 1) {
if (logger.isWarnEnabled())
logger.warn("AUTO_INCREMENT is not allowed for tables with composite primary keys -- Ignoring AUTO_INCREMENT spec.");
return null;
}
for (final $Named primaryColumn : primaryKey.getColumn()) {
if (primaryColumn.getName$().text().equals(column.getName$().text())) {
final String min = getAttr("min", column);
if (min != null && logger.isWarnEnabled())
logger.warn("AUTO_INCREMENT does not consider min=\"" + min + "\" -- Ignoring min spec.");
final String max = getAttr("max", column);
if (max != null && logger.isWarnEnabled())
logger.warn("AUTO_INCREMENT does not consider max=\"" + max + "\" -- Ignoring max spec.");
final String _default = getAttr("default", column);
if (_default != null && logger.isWarnEnabled())
logger.warn("AUTO_INCREMENT does not consider default=\"" + _default + "\" -- Ignoring default spec.");
return "PRIMARY KEY";
}
}
if (logger.isWarnEnabled())
logger.warn("AUTO_INCREMENT is only allowed on an INT PRIMARY KEY -- Ignoring AUTO_INCREMENT spec.");
return null;
}
Also used :
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns)
Example 5 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named
use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named 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 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) + " (" + builder + ")";
}
Also used :
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named)
ColumnRef(org.jaxdb.ddlx.Generator.ColumnRef)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint)
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint(org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint)
Aggregations
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Named)5
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Bigint)4
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Smallint)4
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Tinyint)4
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Char (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Char)2
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column)2
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Columns)2
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Decimal (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Decimal)2
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Double (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Double)2
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Float (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Float)2
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int)2
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Integer (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Integer)2
ArrayList (java.util.ArrayList)1
ColumnRef (org.jaxdb.ddlx.Generator.ColumnRef)1
GeneratorExecutionException (org.jaxdb.ddlx.GeneratorExecutionException)1
org.jaxdb.jsql.data (org.jaxdb.jsql.data)1
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Binary (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Binary)1
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Blob (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Blob)1
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Boolean (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Boolean)1
org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$CheckReference (org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$CheckReference)1
