Examples with TableChange org.jumpmind.db.alter.TableChange used on opensource projects

Example 11 with TableChange

use of org.jumpmind.db.alter.TableChange in project symmetric-ds by JumpMind.

the class H2DdlBuilder method processTableStructureChanges.

@Override
protected void processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, List<TableChange> changes, StringBuilder ddl) {
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        if (change instanceof AddColumnChange) {
            AddColumnChange addColumnChange = (AddColumnChange) change;
            processChange(currentModel, desiredModel, addColumnChange, ddl);
            changeIt.remove();
        } else if (change instanceof CopyColumnValueChange) {
            CopyColumnValueChange copyColumnChange = (CopyColumnValueChange) change;
            processChange(currentModel, desiredModel, copyColumnChange, ddl);
            changeIt.remove();
        } else if (change instanceof RemoveColumnChange) {
            processChange(currentModel, desiredModel, (RemoveColumnChange) change, ddl);
            changeIt.remove();
        } else if (change instanceof ColumnDefaultValueChange) {
            ColumnDefaultValueChange defaultChange = (ColumnDefaultValueChange) change;
            defaultChange.getChangedColumn().setDefaultValue(defaultChange.getNewDefaultValue());
            writeAlterColumn(change.getChangedTable(), defaultChange.getChangedColumn(), ddl);
            changeIt.remove();
        } else if (change instanceof ColumnRequiredChange) {
            ColumnRequiredChange defaultChange = (ColumnRequiredChange) change;
            defaultChange.getChangedColumn().setRequired(!defaultChange.getChangedColumn().isRequired());
            writeAlterColumn(change.getChangedTable(), defaultChange.getChangedColumn(), ddl);
            changeIt.remove();
        } else if (change instanceof ColumnSizeChange) {
            ColumnSizeChange sizeChange = (ColumnSizeChange) change;
            sizeChange.getChangedColumn().setSizeAndScale(sizeChange.getNewSize(), sizeChange.getNewScale());
            writeAlterColumn(change.getChangedTable(), sizeChange.getChangedColumn(), ddl);
            changeIt.remove();
        } else if (change instanceof ColumnAutoIncrementChange) {
            ColumnAutoIncrementChange defaultChange = (ColumnAutoIncrementChange) change;
            defaultChange.getColumn().setAutoIncrement(!defaultChange.getColumn().isAutoIncrement());
            writeAlterColumn(change.getChangedTable(), defaultChange.getColumn(), ddl);
            changeIt.remove();
        }
    }
    super.processTableStructureChanges(currentModel, desiredModel, sourceTable, targetTable, changes, ddl);
}

Example 12 with TableChange

use of org.jumpmind.db.alter.TableChange in project symmetric-ds by JumpMind.

the class HsqlDbDdlBuilder method processTableStructureChanges.

@Override
protected void processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, List<TableChange> changes, StringBuilder ddl) {
    // HsqlDb can only drop columns that are not part of a primary key
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        if ((change instanceof RemoveColumnChange) && ((RemoveColumnChange) change).getColumn().isPrimaryKey()) {
            return;
        }
    }
    // in order to utilize the ALTER TABLE ADD COLUMN BEFORE statement
    // we have to apply the add column changes in the correct order
    // thus we first gather all add column changes and then execute them
    // Since we get them in target table column order, we can simply
    // iterate backwards
    ArrayList<AddColumnChange> addColumnChanges = new ArrayList<AddColumnChange>();
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        if (change instanceof AddColumnChange) {
            addColumnChanges.add((AddColumnChange) change);
            changeIt.remove();
        }
    }
    for (ListIterator<AddColumnChange> changeIt = addColumnChanges.listIterator(addColumnChanges.size()); changeIt.hasPrevious(); ) {
        AddColumnChange addColumnChange = (AddColumnChange) changeIt.previous();
        processChange(currentModel, desiredModel, addColumnChange, ddl);
        changeIt.remove();
    }
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        if (change instanceof RemoveColumnChange) {
            RemoveColumnChange removeColumnChange = (RemoveColumnChange) change;
            processChange(currentModel, desiredModel, removeColumnChange, ddl);
            changeIt.remove();
        } else if (change instanceof CopyColumnValueChange) {
            CopyColumnValueChange copyColumnChange = (CopyColumnValueChange) change;
            processChange(currentModel, desiredModel, copyColumnChange, ddl);
            changeIt.remove();
        }
    }
}

Example 13 with TableChange

use of org.jumpmind.db.alter.TableChange in project symmetric-ds by JumpMind.

the class InterbaseDdlBuilder method processTableStructureChanges.

@Override
protected void processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, List<TableChange> changes, StringBuilder ddl) {
    // TODO: Dropping of primary keys is currently not supported because we
    // cannot
    // determine the pk constraint names and drop them in one go
    // (We could used a stored procedure if Interbase would allow them to
    // use DDL)
    // This will be easier once named primary keys are supported
    boolean pkColumnAdded = false;
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        if (change instanceof AddColumnChange) {
            AddColumnChange addColumnChange = (AddColumnChange) change;
            // add a new one afterwards which is not supported yet
            if (addColumnChange.getNewColumn().isPrimaryKey()) {
                pkColumnAdded = true;
            } else {
                processChange(currentModel, desiredModel, addColumnChange, ddl);
                changeIt.remove();
            }
        } else if (change instanceof RemoveColumnChange) {
            RemoveColumnChange removeColumnChange = (RemoveColumnChange) change;
            // add a new one afterwards which is not supported yet
            if (!removeColumnChange.getColumn().isPrimaryKey()) {
                processChange(currentModel, desiredModel, removeColumnChange, ddl);
                changeIt.remove();
            }
        } else if (change instanceof CopyColumnValueChange) {
            CopyColumnValueChange copyColumnChange = (CopyColumnValueChange) change;
            processChange(currentModel, desiredModel, copyColumnChange, ddl);
            changeIt.remove();
        }
    }
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        // i.e. none was added during this alteration
        if ((change instanceof AddPrimaryKeyChange) && !pkColumnAdded) {
            processChange(currentModel, desiredModel, (AddPrimaryKeyChange) change, ddl);
            changeIt.remove();
        }
    }
}

Example 14 with TableChange

use of org.jumpmind.db.alter.TableChange in project symmetric-ds by JumpMind.

the class SqlAnywhereDdlBuilder method processTableStructureChanges.

@Override
protected void processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, List<TableChange> changes, StringBuilder ddl) {
    // First we drop primary keys as necessary
    for (Iterator changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = (TableChange) changeIt.next();
        if (change instanceof RemovePrimaryKeyChange) {
            processChange(currentModel, desiredModel, (RemovePrimaryKeyChange) change, ddl);
            changeIt.remove();
        } else if (change instanceof PrimaryKeyChange) {
            PrimaryKeyChange pkChange = (PrimaryKeyChange) change;
            RemovePrimaryKeyChange removePkChange = new RemovePrimaryKeyChange(pkChange.getChangedTable(), pkChange.getOldPrimaryKeyColumns());
            processChange(currentModel, desiredModel, removePkChange, ddl);
        }
    }
    HashMap columnChanges = new HashMap();
    // Next we add/remove columns
    for (Iterator changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = (TableChange) changeIt.next();
        if (change instanceof AddColumnChange) {
            AddColumnChange addColumnChange = (AddColumnChange) change;
            // Sybase can only add not insert columns
            if (addColumnChange.isAtEnd()) {
                processChange(currentModel, desiredModel, addColumnChange, ddl);
                changeIt.remove();
            }
        } else if (change instanceof RemoveColumnChange) {
            processChange(currentModel, desiredModel, (RemoveColumnChange) change, ddl);
            changeIt.remove();
        } else if (change instanceof CopyColumnValueChange) {
            CopyColumnValueChange copyColumnChange = (CopyColumnValueChange) change;
            processChange(currentModel, desiredModel, copyColumnChange, ddl);
            changeIt.remove();
        } else if (change instanceof ColumnAutoIncrementChange) {
            // Sybase has no way of adding or removing an IDENTITY
            // constraint
            // Thus we have to rebuild the table anyway and can ignore all
            // the other
            // column changes
            columnChanges = null;
        } else if ((change instanceof ColumnChange) && (columnChanges != null)) {
            // we gather all changed columns because we can use the ALTER
            // TABLE ALTER COLUMN
            // statement for them
            ColumnChange columnChange = (ColumnChange) change;
            ArrayList changesPerColumn = (ArrayList) columnChanges.get(columnChange.getChangedColumn());
            if (changesPerColumn == null) {
                changesPerColumn = new ArrayList();
                columnChanges.put(columnChange.getChangedColumn(), changesPerColumn);
            }
            changesPerColumn.add(change);
        }
    }
    if (columnChanges != null) {
        for (Iterator changesPerColumnIt = columnChanges.entrySet().iterator(); changesPerColumnIt.hasNext(); ) {
            Map.Entry entry = (Map.Entry) changesPerColumnIt.next();
            Column sourceColumn = (Column) entry.getKey();
            ArrayList changesPerColumn = (ArrayList) entry.getValue();
            // different handler
            if ((changesPerColumn.size() == 1) && (changesPerColumn.get(0) instanceof ColumnDefaultValueChange)) {
                processChange(currentModel, desiredModel, (ColumnDefaultValueChange) changesPerColumn.get(0), ddl);
            } else {
                Column targetColumn = targetTable.findColumn(sourceColumn.getName(), delimitedIdentifierModeOn);
                processColumnChange(sourceTable, targetTable, sourceColumn, targetColumn, ddl);
            }
            for (Iterator changeIt = changesPerColumn.iterator(); changeIt.hasNext(); ) {
                ((ColumnChange) changeIt.next()).apply(currentModel, delimitedIdentifierModeOn);
            }
        }
    }
    // Finally we add primary keys
    for (Iterator changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = (TableChange) changeIt.next();
        if (change instanceof AddPrimaryKeyChange) {
            processChange(currentModel, desiredModel, (AddPrimaryKeyChange) change, ddl);
            changeIt.remove();
        } else if (change instanceof PrimaryKeyChange) {
            PrimaryKeyChange pkChange = (PrimaryKeyChange) change;
            AddPrimaryKeyChange addPkChange = new AddPrimaryKeyChange(pkChange.getChangedTable(), pkChange.getNewPrimaryKeyColumns());
            processChange(currentModel, desiredModel, addPkChange, ddl);
            changeIt.remove();
        }
    }
}

Example 15 with TableChange

use of org.jumpmind.db.alter.TableChange in project symmetric-ds by JumpMind.

the class MsSql2000DdlBuilder method processTableStructureChanges.

@Override
protected void processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, List<TableChange> changes, StringBuilder ddl) {
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        if (change instanceof ColumnAutoIncrementChange) {
            /*
             * Sql Server has no way of adding or removing an IDENTITY
             * constraint thus we have to rebuild the table anyway and can
             * ignore all the other column changes
             */
            return;
        }
    }
    // First we drop primary keys as necessary
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        if (change instanceof RemovePrimaryKeyChange) {
            processChange(currentModel, desiredModel, (RemovePrimaryKeyChange) change, ddl);
            changeIt.remove();
        } else if (change instanceof PrimaryKeyChange) {
            PrimaryKeyChange pkChange = (PrimaryKeyChange) change;
            RemovePrimaryKeyChange removePkChange = new RemovePrimaryKeyChange(pkChange.getChangedTable(), pkChange.getOldPrimaryKeyColumns());
            processChange(currentModel, desiredModel, removePkChange, ddl);
        }
    }
    ArrayList<ColumnChange> columnChanges = new ArrayList<ColumnChange>();
    // Next we add/remove columns
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        if (change instanceof AddColumnChange) {
            AddColumnChange addColumnChange = (AddColumnChange) change;
            processChange(currentModel, desiredModel, addColumnChange, ddl);
            changeIt.remove();
        } else if (change instanceof RemoveColumnChange) {
            processChange(currentModel, desiredModel, (RemoveColumnChange) change, ddl);
            changeIt.remove();
        } else if (change instanceof CopyColumnValueChange) {
            CopyColumnValueChange copyColumnChange = (CopyColumnValueChange) change;
            processChange(currentModel, desiredModel, copyColumnChange, ddl);
            changeIt.remove();
        } else if ((change instanceof ColumnChange) && (columnChanges != null)) {
            /*
                 * We gather all changed columns because we can use the ALTER
                 * TABLE ALTER COLUMN statement for them
                 */
            columnChanges.add((ColumnChange) change);
        }
    }
    if (columnChanges != null) {
        HashSet<Column> processedColumns = new HashSet<Column>();
        for (Iterator<ColumnChange> changeIt = columnChanges.iterator(); changeIt.hasNext(); ) {
            ColumnChange change = changeIt.next();
            Column sourceColumn = change.getChangedColumn();
            if (!sourceColumn.isPrimaryKey()) {
                Column targetColumn = targetTable.findColumn(sourceColumn.getName(), delimitedIdentifierModeOn);
                if (!processedColumns.contains(targetColumn)) {
                    processColumnChange(sourceTable, targetTable, sourceColumn, targetColumn, (change instanceof ColumnDataTypeChange) || (change instanceof ColumnSizeChange), ddl);
                    processedColumns.add(targetColumn);
                }
                changes.remove(change);
                change.apply(currentModel, delimitedIdentifierModeOn);
            } else {
                log.debug("Cannot alter a primay key column on sql server (azure).  Just let the table rebuild.");
            }
        }
    }
    // Finally we add primary keys
    for (Iterator<TableChange> changeIt = changes.iterator(); changeIt.hasNext(); ) {
        TableChange change = changeIt.next();
        if (change instanceof AddPrimaryKeyChange) {
            processChange(currentModel, desiredModel, (AddPrimaryKeyChange) change, ddl);
            changeIt.remove();
        } else if (change instanceof PrimaryKeyChange) {
            PrimaryKeyChange pkChange = (PrimaryKeyChange) change;
            AddPrimaryKeyChange addPkChange = new AddPrimaryKeyChange(pkChange.getChangedTable(), pkChange.getNewPrimaryKeyColumns());
            processChange(currentModel, desiredModel, addPkChange, ddl);
            changeIt.remove();
        }
    }
}