Examples with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column used on opensource projects

Example 41 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column

use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column 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();
}

Example 42 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column

use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column in project jaxdb by jaxdb.

the class Compiler method createColumn.

private CreateStatement createColumn(final LinkedHashSet<CreateStatement> alterStatements, final $Table table, final $Column column, final Map<String, Map<String, String>> tableNameToEnumToOwner) {
    final StringBuilder builder = new StringBuilder();
    builder.append(q(column.getName$().text())).append(' ');
    // FIXME: Passing null to compile*() methods will throw a NPE
    if (column instanceof $Char) {
        final $Char type = ($Char) column;
        builder.append(getDialect().compileChar(type.getVarying$() != null && type.getVarying$().text(), type.getLength$() == null ? null : type.getLength$().text()));
    } else if (column instanceof $Binary) {
        final $Binary type = ($Binary) column;
        builder.append(getDialect().compileBinary(type.getVarying$() != null && type.getVarying$().text(), type.getLength$() == null ? null : type.getLength$().text()));
    } else if (column instanceof $Blob) {
        final $Blob type = ($Blob) column;
        builder.append(getDialect().compileBlob(type.getLength$() == null ? null : type.getLength$().text()));
    } else if (column instanceof $Clob) {
        final $Clob type = ($Clob) column;
        builder.append(getDialect().compileClob(type.getLength$() == null ? null : type.getLength$().text()));
    } else if (column instanceof $Integer) {
        builder.append(createIntegerColumn(($Integer) column));
    } else if (column instanceof $Float) {
        final $Float type = ($Float) column;
        builder.append(getDialect().declareFloat(type.getMin$() == null ? null : type.getMin$().text()));
    } else if (column instanceof $Double) {
        final $Double type = ($Double) column;
        builder.append(getDialect().declareDouble(type.getMin$() == null ? null : type.getMin$().text()));
    } else if (column instanceof $Decimal) {
        final $Decimal type = ($Decimal) column;
        builder.append(getDialect().declareDecimal(type.getPrecision$() == null ? null : type.getPrecision$().text(), type.getScale$() == null ? null : type.getScale$().text(), type.getMin$() == null ? null : type.getMin$().text()));
    } else if (column instanceof $Date) {
        builder.append(getDialect().declareDate());
    } else if (column instanceof $Time) {
        final $Time type = ($Time) column;
        builder.append(getDialect().declareTime(type.getPrecision$() == null ? null : type.getPrecision$().text()));
    } else if (column instanceof $Datetime) {
        final $Datetime type = ($Datetime) column;
        builder.append(getDialect().declareDateTime(type.getPrecision$() == null ? null : type.getPrecision$().text()));
    } else if (column instanceof $Boolean) {
        builder.append(getDialect().declareBoolean());
    } else if (column instanceof $Enum) {
        builder.append(getDialect().declareEnum(($Enum) column, tableNameToEnumToOwner));
    }
    final String autoIncrementFragment = column instanceof $Integer ? $autoIncrement(alterStatements, table, ($Integer) column) : null;
    if (autoIncrementFragment == null || autoIncrementFragment.length() == 0) {
        final String defaultFragment = $default(column);
        if (defaultFragment != null && defaultFragment.length() > 0)
            builder.append(" DEFAULT ").append(defaultFragment);
    }
    final String nullFragment = $null(table, column);
    if (nullFragment != null && nullFragment.length() > 0)
        builder.append(' ').append(nullFragment);
    if (autoIncrementFragment != null && autoIncrementFragment.length() > 0)
        builder.append(' ').append(autoIncrementFragment);
    return new CreateStatement(builder.toString());
}

Example 43 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column

use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column in project jaxdb by jaxdb.

the class Compiler method createColumns.

private String createColumns(final LinkedHashSet<CreateStatement> alterStatements, final $Table table, final Map<String, Map<String, String>> tableNameToEnumToOwner) {
    final StringBuilder builder = new StringBuilder();
    final Iterator<$Column> iterator = table.getColumn().iterator();
    $Column column = null;
    for (int i = 0; iterator.hasNext(); ++i) {
        if (i > 0) {
            builder.append(',');
            if (column != null && column.getDocumentation() != null)
                builder.append(" -- ").append(column.getDocumentation().text().replace('\n', ' '));
            builder.append('\n');
        }
        builder.append("  ").append(createColumn(alterStatements, table, column = iterator.next(), tableNameToEnumToOwner));
    }
    return builder.toString();
}

Example 44 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column

use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column 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 + ")";
}

Example 45 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column

use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Column in project jaxdb by jaxdb.

the class DDLx method consolidateEnums.

private static void consolidateEnums(final Schema schema) {
    final Map<String, String> enumToValues = new HashMap<>();
    final List<$Column> templates = schema.getTemplate();
    if (templates != null) {
        for (final $Column template : templates) {
            if (!(template instanceof $Enum))
                throw new IllegalStateException("Input schema is not normalized");
            enumToValues.put(template.getName$().text(), (($Enum) template).getValues$().text());
        }
    }
    final Map<String, $Table> tableNameToTable = new HashMap<>();
    for (final $Table table : schema.getTable()) {
        tableNameToTable.put(table.getName$().text(), table);
        if (table.getColumn() != null) {
            for (final $Column column : table.getColumn()) {
                if (column instanceof $Enum && column.getTemplate$() != null) {
                    final $Enum type = ($Enum) column;
                    final String values = enumToValues.get(column.getTemplate$().text());
                    type.setValues$(new $Enum.Values$(Objects.requireNonNull(values)));
                }
            }
        }
    }
}