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

Example 16 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int

use of org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int 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 17 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int

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

the class JSqlTest method loadEntitiesJaxSB.

@SuppressWarnings("unchecked")
static int loadEntitiesJaxSB(final Connection connection, final String name) throws ClassNotFoundException, IOException, SAXException, SQLException, TransformerException {
    Database.threadLocal((Class<? extends Schema>) Class.forName(Entities.class.getPackage().getName() + "." + name)).connectPrepared(() -> connection);
    final URL sqlx = ClassLoader.getSystemClassLoader().getResource("jaxdb/" + name + ".sqlx");
    assertNotNull(sqlx);
    final $Database database = ($Database) Bindings.parse(sqlx);
    final DDLx ddlx = new DDLx(ClassLoader.getSystemClassLoader().getResource(name + ".ddlx"));
    Schemas.truncate(connection, ddlx.getMergedSchema().getTable());
    final Batch batch = new Batch();
    final int expectedCount = DBVendor.valueOf(connection.getMetaData()) == DBVendor.ORACLE ? 0 : 1;
    for (final data.Table<?> table : Entities.toEntities(database)) batch.addStatement(INSERT(table), (s, e, c) -> assertEquals(expectedCount, c));
    return batch.execute();
}

Example 18 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int

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

Example 19 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int

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

the class SqlJaxSBLoader method INSERT.

int[] INSERT(final RowIterator iterator) throws IOException, SQLException {
    final DBVendor vendor = DBVendor.valueOf(connection.getMetaData());
    if (!iterator.hasNext())
        return new int[0];
    final int[] counts;
    final Compiler compiler = Compiler.getCompiler(vendor);
    final ArrayList<Row> rows = new ArrayList<>();
    final TableToColumnToIncrement tableToColumnToIncrement = new TableToColumnToIncrement();
    while (iterator.hasNext()) {
        loadRow(rows, iterator.next(), getDialect(), compiler, tableToColumnToIncrement);
    }
    rows.sort(null);
    try (final Statement statement = connection.createStatement()) {
        for (final Row row : rows) statement.addBatch(row.toString());
        counts = statement.executeBatch();
    }
    if (tableToColumnToIncrement.size() > 0)
        for (final Map.Entry<String, Map<String, Integer>> entry : tableToColumnToIncrement.entrySet()) for (final Map.Entry<String, Integer> columnToIncrement : entry.getValue().entrySet()) compiler.sequenceReset(connection, null, entry.getKey(), columnToIncrement.getKey(), columnToIncrement.getValue() + 1);
    return counts;
}

Example 20 with org.jaxdb.www.ddlx_0_5.xLygluGCXAA.$Int

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