de.opitzconsulting.orcas.diff.DatabaseHandler Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of orcas-main Show documentation
orcas main api
There is a newer version: 8.6.4
package de.opitzconsulting.orcas.diff;

import de.opitzconsulting.orcas.orig.diff.ColumnDiff;
import de.opitzconsulting.orcas.sql.CallableStatementProvider;
import de.opitzconsulting.origOrcasDsl.CharType;

import java.util.ArrayList;
import java.util.List;

import static de.opitzconsulting.origOrcasDsl.OrigOrcasDslPackage.Literals.*;

public abstract class DatabaseHandler {
    public abstract void createOrcasUpdatesTable(String pOrcasUpdatesTableName, CallableStatementProvider pOrcasCallableStatementProvider);

    public abstract void insertIntoOrcasUpdatesTable(String pOrcasUpdatesTableName, CallableStatementProvider pOrcasCallableStatementProvider, String pFilePart, String pLogname);

    public abstract LoadIst createLoadIst(CallableStatementProvider pCallableStatementProvider, Parameters pParameters);

    public abstract CharType getDefaultCharType(CallableStatementProvider pCallableStatementProvider);

    public abstract String getDefaultTablespace(CallableStatementProvider pCallableStatementProvider);

    public abstract DdlBuilder createDdlBuilder(Parameters pParameters);

    public abstract void executeDiffResultStatement(String pStatementToExecute, CallableStatementProvider pCallableStatementProvider);

    public abstract boolean isRenamePrimaryKey();

    public boolean isCanDiffFunctionBasedIndexExpression() {
        return true;
    }

    public boolean isCanDiffUniqueKeyIndex() {
        return true;
    }

    public String getSequenceDefaultMaxValueString() {
        return "9999999999999999999999999999";
    }

    public String getSequenceDefaultMinValueString() {
        return "1";
    }

    public abstract boolean isRenameIndex();

    public abstract boolean isRenameMView();

    public abstract boolean isRenameForeignKey();

    public abstract boolean isRenameUniqueKey();

    public abstract boolean isRenameConstraint();

    public abstract boolean isUpdateIdentity();

    public final boolean isExpressionDifferent(String pExpression1, String pExpression2) {
        if (pExpression1 == null && pExpression2 == null) {
            return false;
        }
        if (pExpression1 == null || pExpression2 == null) {
            return true;
        }
        return isExpressionDifferentNotNull(pExpression1, pExpression2);
    }

    public List isRecreateColumn(ColumnDiff pColumnDiff) {
        List lReturn = new ArrayList<>();

        if (pColumnDiff.data_typeNew != null && pColumnDiff.data_typeOld != null) {
            if (!pColumnDiff.data_typeIsEqual) {
                lReturn.add(new RecreateNeededBuilder.DifferenceImpl(COLUMN__DATA_TYPE, pColumnDiff));
            }

            if (isLessTahnOrNull(pColumnDiff.precisionNew, pColumnDiff.precisionOld)) {
                lReturn.add(new RecreateNeededBuilder.DifferenceImpl(COLUMN__PRECISION, pColumnDiff));
            }

            if (isLessTahnOrNull(pColumnDiff.scaleNew, pColumnDiff.scaleOld)) {
                lReturn.add(new RecreateNeededBuilder.DifferenceImpl(COLUMN__SCALE, pColumnDiff));
            }
        }

        if (!pColumnDiff.object_typeIsEqual) {
            lReturn.add(new RecreateNeededBuilder.DifferenceImpl(COLUMN__OBJECT_TYPE, pColumnDiff));
        }

        if (!pColumnDiff.unsignedIsEqual) {
            lReturn.add(new RecreateNeededBuilder.DifferenceImpl(COLUMN__UNSIGNED, pColumnDiff));
        }

        if (!pColumnDiff.virtualIsEqual) {
            lReturn.add(new RecreateNeededBuilder.DifferenceImpl(COLUMN__VIRTUAL, pColumnDiff));
        }

        return lReturn;
    }

    private boolean isLessTahnOrNull(Integer pValue1, Integer pValue2) {
        if (pValue1 == null && pValue2 == null) {
            return false;
        }

        if (pValue1 == null || pValue2 == null) {
            return true;
        }

        return pValue1 < pValue2;
    }

    protected boolean isExpressionDifferentNotNull(String pExpression1, String pExpression2) {
        return !pExpression1.equals(pExpression2);
    }

    public int getDefaultFloatPrecision() {
        return 126;
    }

    public Integer getDefaultNumberPrecision() {
        return null;
    }
}