Package liquibase.structure.core

Examples of liquibase.structure.core.Sequence

83
84
85
86
87
88
89
        return new Sql[]{new UnparsedSql(buffer.toString(), getAffectedSequence(statement))};
    }

    protected Sequence getAffectedSequence(CreateSequenceStatement statement) {
        return new Sequence().setName(statement.getSequenceName()).setSchema(statement.getCatalogName(), statement.getSchemaName());
    }
View Full Code Here
58
59
60
61
62
63
64
                )
        };
    }

    protected Sequence getAffectedNewSequence(RenameSequenceStatement statement) {
        return new Sequence().setName(statement.getNewSequenceName()).setSchema(statement.getCatalogName(), statement.getSchemaName());
    }
View Full Code Here
62
63
64
65
66
67
68
    protected Sequence getAffectedNewSequence(RenameSequenceStatement statement) {
        return new Sequence().setName(statement.getNewSequenceName()).setSchema(statement.getCatalogName(), statement.getSchemaName());
    }

    protected Sequence getAffectedOldSequence(RenameSequenceStatement statement) {
        return new Sequence().setName(statement.getOldSequenceName()).setSchema(statement.getCatalogName(), statement.getSchemaName());
    }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
            //noinspection unchecked
            List<Map<String, ?>> sequenceNames = ExecutorService.getInstance().getExecutor(database).queryForList(new RawSqlStatement(getSelectSequenceSql(schema, database)));

            if (sequenceNames != null) {
                for (Map<String, ?> sequence : sequenceNames) {
                    schema.addDatabaseObject(new Sequence().setName(cleanNameFromDatabase((String) sequence.get("SEQUENCE_NAME"), database)).setSchema(schema));
                }
            }
        }
    }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
        List<Map<String, ?>> sequences = ExecutorService.getInstance().getExecutor(database).queryForList(new RawSqlStatement(getSelectSequenceSql(example.getSchema(), database)));
        for (Map<String, ?> sequenceRow : sequences) {
            String name = cleanNameFromDatabase((String) sequenceRow.get("SEQUENCE_NAME"), database);
            if ((database.isCaseSensitive() && name.equals(example.getName()) || (!database.isCaseSensitive() && name.equalsIgnoreCase(example.getName())))) {
                Sequence seq = new Sequence();
                seq.setName(name);
                seq.setSchema(example.getSchema());
                seq.setStartValue(toBigInteger(sequenceRow.get("START_VALUE"), database));
                seq.setMinValue(toBigInteger(sequenceRow.get("MIN_VALUE"), database));
                seq.setMaxValue(toBigInteger(sequenceRow.get("MAX_VALUE"), database));
                seq.setCacheSize(toBigInteger(sequenceRow.get("CACHE_SIZE"), database));
                seq.setIncrementBy(toBigInteger(sequenceRow.get("INCREMENT_BY"), database));
                seq.setWillCycle(toBoolean(sequenceRow.get("WILL_CYCLE"), database));
                seq.setOrdered(toBoolean(sequenceRow.get("IS_ORDERED"), database));


                return seq;

            }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
    }

    @Override
    public ChangeStatus checkStatus(Database database) {
        try {
            return new ChangeStatus().assertComplete(!SnapshotGeneratorFactory.getInstance().has(new Sequence(getCatalogName(), getSchemaName(), getSequenceName()), database), "Sequence exists");
        } catch (Exception e) {
            return new ChangeStatus().unknown(e);
        }
    }
View Full Code Here
26
27
28
29
30
31
32
        return new Change[] {createSequenceChange };
    }

    @Override
    public void checkDiffResult(DiffResult diffResult, DropSequenceChange change) {
        assertNotNull(diffResult.getMissingObject(new Sequence(change.getCatalogName(), change.getSchemaName(), change.getSequenceName())));
    }
View Full Code Here
55
56
57
58
59
60
61
        commands.add(alterSequenceOwner);
        return commands.toArray(new Sql[commands.size()]);
    }

    protected Sequence getAffectedSequence(SequenceNextValueFunction sequenceFunction) {
        return new Sequence().setName(sequenceFunction.getValue());
    }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
    }

    @Override
    public void checkDiffResult(DiffResult diffResult, AlterSequenceChange change) {
        if (change.getMinValue() != null) {
            ObjectDifferences diff = diffResult.getChangedObject(new Sequence(change.getCatalogName(), change.getSchemaName(), change.getSequenceName()));
            assertEquals(change.getMinValue(), diff.getDifference("minValue").getComparedValue());
        }

        if (change.getMaxValue() != null) {
            ObjectDifferences diff = diffResult.getChangedObject(new Sequence(change.getCatalogName(), change.getSchemaName(), change.getSequenceName()));
            assertEquals(change.getMaxValue(), diff.getDifference("maxValue").getComparedValue());
        }

        if (change.getIncrementBy() != null) {
            ObjectDifferences diff = diffResult.getChangedObject(new Sequence(change.getCatalogName(), change.getSchemaName(), change.getSequenceName()));
            assertEquals(change.getIncrementBy(), diff.getDifference("incrementBy").getComparedValue());
        }

        if (change.isOrdered() != null) {
            ObjectDifferences diff = diffResult.getChangedObject(new Sequence(change.getCatalogName(), change.getSchemaName(), change.getSequenceName()));
            assertEquals(change.isOrdered(), diff.getDifference("ordered").getComparedValue());
        }
    }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
    @Override
    public ChangeStatus checkStatus(Database database) {
        ChangeStatus result = new ChangeStatus();
        try {
            Sequence sequence = SnapshotGeneratorFactory.getInstance().createSnapshot(new Sequence(getCatalogName(), getSchemaName(), getSequenceName()), database);
            if (sequence == null) {
                return result.unknown("Sequence " + getSequenceName() + " does not exist");
            }

            if (getIncrementBy() != null) {
                result.assertCorrect(getIncrementBy().equals(sequence.getIncrementBy()), "Increment by has a different value");
            }
            if (getMinValue() != null) {
                result.assertCorrect(getMinValue().equals(sequence.getMinValue()), "Min Value is different");
            }
            if (getMaxValue() != null) {
                result.assertCorrect(getMaxValue().equals(sequence.getMaxValue()), "Max Value is different");
            }
            if (isOrdered() != null) {
                result.assertCorrect(isOrdered().equals(sequence.getOrdered()), "Max Value is different");
            }
        } catch (Exception e) {
            return result.unknown(e);
        }
        return result;
View Full Code Here
TOP

Related Classes of liquibase.structure.core.Sequence

  • liquibase.change.core.AlterSequenceChange
  • liquibase.change.core.CreateSequenceChange
  • liquibase.change.core.DropSequenceChange
  • liquibase.change.core.supplier.AlterSequenceChangeSupplier
  • liquibase.change.core.supplier.CreateSequenceChangeSupplier
  • liquibase.change.core.supplier.DropSequenceChangeSupplier
  • liquibase.diff.output.changelog.core.MissingSequenceChangeGenerator
  • liquibase.diff.output.changelog.core.UnexpectedSequenceChangeGenerator
  • liquibase.ext.hibernate.snapshot.SequenceSnapshotGenerator
  • liquibase.precondition.core.SequenceExistsPrecondition
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.