Liquibase Enterprise was formerly known as Datical DB.

Data Models for Rules

Owned by Former user (Deleted)
Mar 20, 2019
9 min read

A rule tests conditions against database objects. This section describes how those objects are represented in data models used by rules. 

Database Model

Hierarchy

DbModel                                           - import com.datical.dbsim.model.DbModel;
   Collection of Schemas                          - import com.datical.dbsim.model.Schema;
      Collection of Tables                        - import com.datical.dbsim.model.Table;
         List of Columns                          - import com.datical.dbsim.model.Column;
         Collection of Foreign Key Constraints    - import com.datical.dbsim.model.FkConstraint;
         Collection of Not Null Constraints       - import com.datical.dbsim.model.NotNullConstraint;
         Collection of Unique Constraints         - import com.datical.dbsim.model.UniqueConstraint;
         Collection of Check Constraints          - import com.datical.dbsim.model.CheckConstraint;
         Collection of Indices                    - import com.datical.dbsim.model.Index;
      Collection of Views                         - import com.datical.dbsim.model.View;
         List of Columns                          - import com.datical.dbsim.model.Column;
      Collection of Sequences                     - import com.datical.dbsim.model.Sequence;
      Collection of Procedures                    - import com.datical.dbsim.model.Procedure;
      Collection of Functions                     - import com.datical.dbsim.model.Function;
      Collection of Packages                      - import com.datical.dbsim.model.Package;
      Collection of Package Bodies                - import com.datical.dbsim.model.PackageBody;
      Collection of Triggers                      - import com.datical.dbsim.model.Trigger;
      Collection of Synonyms                      - import com.datical.dbsim.model.Synonym;


DBModel

import com.datical.dbsim.model.DbModel;

Collection<Schema> getSchemas();
Schema getSchema(String schemaName);
List<DbModelChangeSet> getModelChangeSets();
String getCatalogName();

Schema

import com.datical.dbsim.model.Schema;

String getName();
Collection<Table> getTables();
Collection<View> getViews();
Collection<Sequence> getSequences();
Collection<Procedure> getProcedures();
Collection<Function> getFunctions();
Collection<Package> getPackages();
Collection<PackageBody> getPackageBodies();
Collection<Trigger> getTriggers();
Collection<Synonym> getSynonyms();
List<Index> getIndices();
List<CheckConstraint> getCheckConstraints(String tableName);
List<UniqueConstraint> getUniqueConstraints(String tableName);
List<NotNullConstraint> getNotNullConstraints(String tableName);
List<FkConstraint> getFkConstraints(String tableName);
boolean exists(DbModel model, Object storedLogic);

Table

import com.datical.dbsim.model.Table;

String getName();
List<Column> getColumns();
Integer getRowCount();
PkConstraint getPkConstraint();
String getStorageOptions();
Collection<FkConstraint> getFkConstraints();
Collection<NotNullConstraint> getNotNullConstraints();
Collection<UniqueConstraint> getUniqueConstraints();
Collection<Index> getIndices();
Collection<CheckConstraint> getCheckConstraints(); 

// check to see if the Table object's name exists in the DbModel
boolean exists(DbModel model, Object table);

Column

import com.datical.dbsim.model.Column;

String getName();
String getType();
boolean isPk();
boolean isAutoIncrement();
DefaultValue getDefaultValue();

Foreign Key Constraint

import com.datical.dbsim.model.FkConstraint;

String getName();
String refTableName();
String refSchemaName(); 

// check to see if the FKConstraint object's table name matches a table in the DbModel
boolean exists(DbModel model, Object fkConstraint);

Not Null Constraint

import com.datical.dbsim.model.NotNullConstraint;

String getName();
String getColumnName(); 

// check to see if the NotNullConstraint object's table name matches a table in the DbModel
boolean exists(DbModel model, Object notNullConstraint);

Unique Constraint

import com.datical.dbsim.model.UniqueConstraint;

String getTableName();
String getName();
String getColumnName(); 

// check to see if the UniqueConstraint object's table name matches a table in the DbModel
boolean exists(DbModel model, Object uniqueConstraint);

Check Constraint

import com.datical.dbsim.model.CheckConstraint;

String getName();
boolean isDisabled(); 

// check to see if the CheckConstraint object's table name matches a table in the DbModel
boolean exists(DbModel model, Object checkConstraint);

Index

import com.datical.dbsim.model.Index;

String getName();
String getStorageOptions();
List<String> getColumns(); 

// check to see if the Index object's table name matches a table in the DbModel
boolean exists(DbModel model, Object index);

View

import com.datical.dbsim.model.View;

String getName();
List<Column> getColumns();

Sequence

import com.datical.dbsim.model.Sequence;

String getName(); 

// check to see if the Sequence object's name exists in the DbModel 
boolean exists(DbModel model, Object sequence);

Procedure

import com.datical.dbsim.model.Procedure;

String getName();

Function

import com.datical.dbsim.model.Function;

String getName();

Package

import com.datical.dbsim.model.Package;

String getName();

PackageBody

import com.datical.dbsim.model.PackageBody;

String getName();

Trigger

import com.datical.dbsim.model.Trigger;

String getName();
boolean isDisabled(); 

// check to see if the Trigger object's name exists in the DbModel
boolean exists(DbModel model, Object trigger);

Synonym

import com.datical.dbsim.model.Synonym;

String getName(); 

// check to see if the Synonym object's name exists in the DbModel
boolean exists(DbModel model, Object synonym);

DefaultValue

import com.datical.dbsim.model.DefaultValue;

enum TYPE { STRING, NUMERIC, BOOLEAN, DATE, COMPUTED } ;
TYPE getType();
String getValue();

Change Models

All Change Models

Boolean supportsRollback()
  • Returns a Boolean indicating that a change model supports auto-rollback (or not)

Auto Increment

  • AddAutoIncrementType import org.liquibase.xml.ns.dbchangelog.AddAutoIncrementType;
String getCatalogName();
String getColumnDataType();
String getColumnName();
long getIncrementBy();
String getSchemaName();
long getStartWith();
String getTableName();
boolean isSetIncrementBy();
boolean isSetStartWith();

Columns

  • AddColumnType import org.liquibase.xml.ns.dbchangelog.AddColumnType;
String getCatalogName();
List<ColumnAddColumnType> getColumn();
String getSchemaName();
String getTableName();
  • ColumnAddColumnType import org.liquibase.xml.ns.dbchangelog.ColumnAddColumnType;
String getAfterColumn();
String getBeforeColumn();
BigInteger getPosition();
  • ColumnBaseType import org.liquibase.xml.ns.dbchangelog.ColumnBaseType;
    Note: Call the RuleFunctions class static method getText(myColumnBaseType); to get the text associated with this refactoring. 
Object getAutoIncrement();
ConstraintsType getConstraints();
String getDefaultValue();
Object getDefaultValueBoolean();
String getDefaultValueComputed();
String getDefaultValueDate();
String getDefaultValueNumeric();
String getDefaultValueSequenceCurrent();
String getDefaultValueSequenceNext();
String getEncoding();
long getIncrementBy();
String getName();
String getRemarks();
long getStartWith();
String getType();
String getValue();
String getValueBlobFile();
String getValueBoolean();
String getValueClobFile();
String getValueComputed();
String getValueDate();
String getValueNumeric();
String getValueSequenceCurrent();
String getValueSequenceNext();
boolean isSetIncrementBy();
boolean isSetStartWith();
  • ColumnExistsType import org.liquibase.xml.ns.dbchangelog.ColumnExistsType;
String getCatalogName();
String getColumnName();
String getSchemaName();
String getTableName();
  • ColumnLoadDataType import org.liquibase.xml.ns.dbchangelog.ColumnLoadDataType;
String getDefaultValue();
Object getDefaultValueBoolean();
String getDefaultValueComputed();
String getDefaultValueDate();
String getDefaultValueNumeric();
String getHeader();
Object getIndex();
String getName();
String getType();
  • ColumnLoadUpdateDataType import org.liquibase.xml.ns.dbchangelog.ColumnLoadUpdateDataType;
String getDefaultValue();
Object getDefaultValueBoolean();
String getDefaultValueComputed();
String getDefaultValueDate();
String getDefaultValueNumeric();
String getHeader();
Object getIndex();
String getName();
String getType();
  • ColumnType import org.liquibase.xml.ns.dbchangelog.ColumnType;
    Note: Call the RuleFunctions class static method getText(myColumnType); to get the text associated with this refactoring.
Object getAutoIncrement();
Object getComputed();
ConstraintsType getConstraints();
String getDefaultValue();
Object getDefaultValueBoolean();
String getDefaultValueComputed();
String getDefaultValueDate();
String getDefaultValueNumeric();
String getDefaultValueSequenceCurrent();
String getDefaultValueSequenceNext();
String getEncoding();
long getIncrementBy();
String getName();
String getRemarks();
long getStartWith();
String getType();
String getValue();
String getValueBlobFile();
String getValueBoolean();
String getValueClobFile();
String getValueComputed();
String getValueDate();
String getValueNumeric();
String getValueSequenceCurrent();
String getValueSequenceNext();
boolean isSetIncrementBy();
boolean isSetStartWith();
  • DropColumnType import org.liquibase.xml.ns.dbchangelog.DropColumnType;
String getCatalogName();
String getColumnName();
String getSchemaName();
String getTableName();
  • MergeColumnsType import org.liquibase.xml.ns.dbchangelog.MergeColumnsType;
String getCatalogName();
String getColumn1Name();
String getColumn2Name();
String getFinalColumnName();
String getFinalColumnType();
String getJoinString();
String getSchemaName();
String getTableName();
  • RenameColumnType import org.liquibase.xml.ns.dbchangelog.RenameColumnType;
String getCatalogName();
String getColumnDataType();
String getNewColumnName();
String getOldColumnName();
String getRemarks();
String getSchemaName();
String getTableName();

Constraints

  • ConstraintsType import org.liquibase.xml.ns.dbchangelog.ConstraintsType;
String getCheckConstraint();
Object getDeferrable();
Object getDeleteCascade();
String getForeignKeyName();
Object getInitiallyDeferred();
Object getNullable();
Object getPrimaryKey();
String getPrimaryKeyName();
String getPrimaryKeyTablespace();
String getReferencedColumnNames();
String getReferencedTableName();
String getReferences();
Object getUnique();
String getUniqueConstraintName();

Check Constraints

  • AddCheckConstraintType import com.datical.xml.ns.storedlogic.AddCheckConstraintType;
    Note: Call the RuleFunctions class static method getText(myAddCheckConstraintType); to get the text associated with this refactoring. 


String getCatalogName();
String getConstraintName();
Boolean getDisabled();
String getSchemaName();
String getTableName();
String getXmlns();
  • DisableCheckConstraintType import com.datical.xml.ns.storedlogic.DisableCheckConstraintType;
    Note: Call the RuleFunctions class static method getText(myDisableCheckConstraintType); to get the text associated with this refactoring. 
String getCatalogName();
String getConstraintName();
String getSchemaName();
String getTableName();
String getXmlns();
  • DropCheckConstraintType import com.datical.xml.ns.storedlogic.DropCheckConstraintType;
String getCatalogName();
String getConstraintName();
String getSchemaName();
String getTableName();
String getXmlns();
  • EnableCheckConstraintType import com.datical.xml.ns.storedlogic.EnableCheckConstraintType;
    Note: Call the RuleFunctions class static method getText(myEnableCheckConstraintType); to get the text associated with this refactoring. 
String getCatalogName();
String getConstraintName();
String getSchemaName();
String getTableName();
String getXmlns();

Foreign Key Constraints

  • AddForeignKeyConstraintType import org.liquibase.xml.ns.dbchangelog.AddForeignKeyConstraintType;
String getBaseColumnNames();
String getBaseTableCatalogName();
String getBaseTableName();
String getBaseTableSchemaName();
String getConstraintName();
Object getDeferrable();
Object getDeleteCascade();
Object getInitiallyDeferred();
FkCascadeActionOptions getOnDelete();
FkCascadeActionOptions getOnUpdate();
String getReferencedColumnNames();
String getReferencedTableCatalogName();
String getReferencedTableName();
String getReferencedTableSchemaName();
Object getReferencesUniqueColumn();
boolean isSetOnDelete();
boolean isSetOnUpdate();
  • DropAllForeignKeyConstraintsType import org.liquibase.xml.ns.dbchangelog.DropAllForeignKeyConstraintsType;
String getBaseTableCatalogName();
String getBaseTableName();
String getBaseTableSchemaName();
  • DropForeignKeyConstraintType import org.liquibase.xml.ns.dbchangelog.DropForeignKeyConstraintType;
String getBaseTableCatalogName();
String getBaseTableName();
String getBaseTableSchemaName();
String getConstraintName();
  • ForeignKeyConstraintExistsType import org.liquibase.xml.ns.dbchangelog.ForeignKeyConstraintExistsType;
String getCatalogName();
String getForeignKeyName();
String getForeignKeyTableName();
String getSchemaName();

Not Null Constraints

  • AddNotNullConstraintType import org.liquibase.xml.ns.dbchangelog.AddNotNullConstraintType;
String getCatalogName();
String getColumnDataType();
String getColumnName();
String getDefaultNullValue();
String getSchemaName();
String getTableName();
  • DropNotNullConstraintType import org.liquibase.xml.ns.dbchangelog.DropNotNullConstraintType;
String getCatalogName();
String getColumnDataType();
String getColumnName();
String getSchemaName();
String getTableName();

Unique Constraints

  • AddUniqueConstraintType import org.liquibase.xml.ns.dbchangelog.AddUniqueConstraintType;


String getCatalogName();
String getColumnNames();
String getConstraintName();
Object getDeferrable();
Object getDisabled();
Object getInitiallyDeferred();
String getSchemaName();
String getTableName();
String getTablespace();
  • DropUniqueConstraintType import org.liquibase.xml.ns.dbchangelog.DropUniqueConstraintType;


String getCatalogName();
String getConstraintName();
String getSchemaName();
String getTableName();
String getUniqueColumns();

Default Values

  • AddDefaultValueType import org.liquibase.xml.ns.dbchangelog.AddDefaultValueType;
String getCatalogName();
String getColumnDataType();
String getColumnName();
String getDefaultValue();
String getDefaultValueBoolean();
String getDefaultValueComputed();
String getDefaultValueDate();
String getDefaultValueNumeric();
String getDefaultValueSequenceNext();
String getSchemaName();
String getTableName();
  • DropDefaultValueType import org.liquibase.xml.ns.dbchangelog.DropDefaultValueType;


String getCatalogName();
String getColumnDataType();
String getColumnName();
String getSchemaName();
String getTableName();

Functions

  • CreateFunctionType import com.datical.xml.ns.storedlogic.CreateFunctionType;
    Note: Call the RuleFunctions class static method getText(myCreateFunctionType); to get the text associated with this refactoring. 
String getCatalogName();
String getDbms();
String getEncoding();
String getFunctionName();
String getPath();
String getSchemaName();
String getXmlns();
boolean isSetRelativeToChangelogFile();
boolean isSetReplaceIfExists();
  • DropFunctionType import com.datical.xml.ns.storedlogic.DropFunctionType;


String getCatalogName();
String getFunctionName();
String getSchemaName();

Indices

  • CreateIndexType import org.liquibase.xml.ns.dbchangelog.CreateIndexType;
String getAssociatedWith();
String getCatalogName();
Object getClustered();
List<ColumnType> getColumn();
String getIndexName();
String getSchemaName();
StorageOptionsType getStorageOptions();
String getTableName();
String getTablespace();
Object getUnique();
  • DropIndexType import org.liquibase.xml.ns.dbchangelog.DropIndexType;
String getAssociatedWith();
String getCatalogName();
String getIndexName();
String getSchemaName();
String getTableName();
  • IndexExistsType import org.liquibase.xml.ns.dbchangelog.IndexExistsType;
String getCatalogName();
String getColumnNames();
String getIndexName();
String getSchemaName();
String getTableName();

Packages

  • CreatePackageBodyType import com.datical.xml.ns.storedlogic.CreatePackageBodyType;
    Note: Call the RuleFunctions class static method getText(myCreatePackageBodyType); to get the text associated with this refactoring. 
String getCatalogName();
String getDbms();
String getEncoding();
String getPackageBodyName();
String getPath();
String getSchemaName();
boolean isSetRelativeToChangelogFile();
  • CreatePackageType import com.datical.xml.ns.storedlogic.CreatePackageType;
    Note: Call the RuleFunctions class static method getText(myCreatePackageType); to get the text associated with this refactoring. 
String getCatalogName();
String getDbms();
String getEncoding();
String getPackageName();
String getPath();
String getSchemaName();
boolean isSetRelativeToChangelogFile();
  • DropPackageBodyType import com.datical.xml.ns.storedlogic.DropPackageBodyType;
String getCatalogName();
String getPackageBodyName();
String getSchemaName();
  • DropPackageType import com.datical.xml.ns.storedlogic.DropPackageType;
String getCatalogName();
String getPackageName();
String getSchemaName();

Primary Keys

  • AddPrimaryKeyType import org.liquibase.xml.ns.dbchangelog.AddPrimaryKeyType;
String getCatalogName();
String getColumnNames();
String getConstraintName();
String getSchemaName();
String getTableName();
String getTablespace();
  • DropPrimaryKeyType import org.liquibase.xml.ns.dbchangelog.DropPrimaryKeyType;
String getCatalogName();
String getConstraintName();
String getSchemaName();
String getTableName();
  • PrimaryKeyExistsType import org.liquibase.xml.ns.dbchangelog.PrimaryKeyExistsType;
String getCatalogName();
String getPrimaryKeyName();
String getSchemaName();
String getTableName();

Procedures

  • CreateProcedureType import org.liquibase.xml.ns.dbchangelog.CreateProcedureType;
    Note: Call the RuleFunctions class static method getText(myCreateProcedureType); to get the text associated with this refactoring. 
String getCatalogName();
String getComment();
String getDbms();
String getEncoding();
String getPath();
String getProcedureName();
Object getRelativeToChangelogFile();
Object getReplaceIfExists();
String getSchemaName();
  • DropProcedureType import org.liquibase.xml.ns.dbchangelog.DropProcedureType;
String getCatalogName();
String getProcedureName();
String getSchemaName();

Rollback

  • RollbackType import org.liquibase.xml.ns.dbchangelog.RollbackType;
    Note: Call the RuleFunctions class static method getText(myRollbackType); to get the text associated with this refactoring. 
List<AddAutoIncrementType> getAddAutoIncrement();
List<AddColumnType> getAddColumn();
List<AddDefaultValueType> getAddDefaultValue();
List<AddForeignKeyConstraintType> getAddForeignKeyConstraint();
List<AddLookupTableType> getAddLookupTable();
List<AddNotNullConstraintType> getAddNotNullConstraint();
List<AddPrimaryKeyType> getAddPrimaryKey();
List<AddUniqueConstraintType> getAddUniqueConstraint();
List<AlterSequenceType> getAlterSequence();
FeatureMap getAny();
String getChangeSetAuthor();
FeatureMap getChangeSetChildren();
String getChangeSetId();
String getChangeSetPath();
List<String> getComments();
List<CreateIndexType> getCreateIndex();
List<CreateProcedureType> getCreateProcedure();
List<CreateSequenceType> getCreateSequence();
List<CreateTableType> getCreateTable();
List<CreateViewType> getCreateView();
List<CustomChangeType> getCustomChange();
List<DeleteType> getDelete();
List<DropAllForeignKeyConstraintsType> getDropAllForeignKeyConstraints();
List<DropColumnType> getDropColumn();
List<DropDefaultValueType> getDropDefaultValue();
List<DropForeignKeyConstraintType> getDropForeignKeyConstraint();
List<DropIndexType> getDropIndex();
List<DropNotNullConstraintType> getDropNotNullConstraint();
List<DropPrimaryKeyType> getDropPrimaryKey();
List<DropSequenceType> getDropSequence();
List<DropTableType> getDropTable();
List<DropUniqueConstraintType> getDropUniqueConstraint();
List<DropViewType> getDropView();
List<ExecuteCommandType> getExecuteCommand();
List<InsertType> getInsert();
List<LoadDataType> getLoadData();
List<LoadUpdateDataType> getLoadUpdateData();
List<MergeColumnsType> getMergeColumns();
List<ModifyDataTypeType> getModifyDataType();
List<RenameColumnType> getRenameColumn();
List<RenameTableType> getRenameTable();
List<RenameViewType> getRenameView();
List<RollbackType> getRollback();
List<SqlType> getSql();
List<SqlFileType> getSqlFile();
List<StopType> getStop();
List<UpdateType> getUpdate();

Sequences

  • AlterSequenceType import org.liquibase.xml.ns.dbchangelog.AlterSequenceType;
String getCatalogName();
String getIncrementBy();
String getMaxValue();
String getMinValue();
Object getOrdered();
String getSchemaName();
String getSequenceName();
String getStartValue();
  • CreateSequenceType import org.liquibase.xml.ns.dbchangelog.CreateSequenceType;
int getCacheSize();
String getCatalogName();
Object getCycle();
String getIncrementBy();
String getMaxValue();
String getMinValue();
Object getOrdered();
String getSchemaName();
String getSequenceName();
String getStartValue();
boolean isSetCacheSize();
  • DropSequenceType import org.liquibase.xml.ns.dbchangelog.DropSequenceType;
String getCatalogName();
String getIncrementBy();
String getMaxValue();
String getMinValue();
Object getOrdered();
String getSchemaName();
String getSequenceName();
String getStartValue();
  • SequenceExistsType import org.liquibase.xml.ns.dbchangelog.SequenceExistsType;
String getCatalogName();
String getSchemaName();
String getSequenceName();

SQL

  • ModifySqlType import org.liquibase.xml.ns.dbchangelog.ModifySqlType;
List<AppendType> getAppend();
Object getApplyToRollback();
String getContext();
String getDbms();
String getLabels();
FeatureMap getModifySqlChildren();
List<PrependType> getPrepend();
List<RegExpReplaceType> getRegExpReplace();
List<ReplaceType> getReplace();
  • SqlFileType import org.liquibase.xml.ns.dbchangelog.SqlFileType;
String getDbms();
String getEncoding();
String getEndDelimiter();
String getPath();
Object getRelativeToChangelogFile();
Object getSplitStatements();
Object getStripComments();
boolean isSetEncoding();
  • SqlType import org.liquibase.xml.ns.dbchangelog.SqlType
Note: Call the RuleFunctions class static method getText(mySqlType); to get the text associated with this refactoring. 
String getComment();
String getDbms();
String getEndDelimiter();
Object getSplitStatements();
Object getStripComments();

Storage Options

  • StorageOptionsType import com.datical.xml.ns.appdba.StorageOptionsType;
    Note: Call the RuleFunctions class static method getText(myStorageOptionsType); to get the text associated with this refactoring. 
String getContext();
String getDbms();
String getPath();
boolean isSetRelativeToChangelogFile();
  • IndexStorageOptionsType import com.datical.xml.ns.appdba.IndexStorageOptionsType;
    Note: Call the RuleFunctions class static method getText(myIndexStorageOptionsType); to get the text associated with this refactoring. 
String getIndexName();
String getPath();
String getTableName();
  • TableStorageOptionsType import com.datical.xml.ns.appdba.TableStorageOptionsType;
    Note: Call the RuleFunctions class static method getText(myTableStorageOptionsType); to get the text associated with this refactoring. 
String getPath();
String getTableName();

Synonyms

  • CreateSynonymType import com.datical.xml.ns.appdba.CreateSynonymType;
String getObjectCatalogName();
String getObjectName();
String getObjectSchemaName();
String getObjectType();
String getSynonymCatalogName();
String getSynonymName();
String getSynonymSchemaName();
boolean isSetPrivate();
boolean isSetReplaceIfExists();
  • DropSynonymType import com.datical.xml.ns.appdba.DropSynonymType;
String getObjectType();
String getSynonymCatalogName();
String getSynonymName();
String getSynonymSchemaName();
boolean isSetPrivate();

Tables

  • CreateTableType import org.liquibase.xml.ns.dbchangelog.CreateTableType;
String getCatalogName();
List<ColumnType> getColumn();
String getRemarks();
String getSchemaName();
StorageOptionsType getStorageOptions();
String getTableName();
String getTablespace();
String getTemporary();
  • DropTableType import org.liquibase.xml.ns.dbchangelog.DropTableType;
Object getCascadeConstraints();
String getCatalogName();
String getSchemaName();
String getTableName();
  • RenameTableType import org.liquibase.xml.ns.dbchangelog.RenameTableType;
String getCatalogName();
String getNewTableName();
String getOldTableName();
String getSchemaName();
  • TableExistsType import org.liquibase.xml.ns.dbchangelog.TableExistsType;
String getCatalogName();
String getSchemaName();
String getTableName();
  • TableIsEmptyType import org.liquibase.xml.ns.dbchangelog.TableIsEmptyType;
String getCatalogName();
String getSchemaName();
String getTableName();

Triggers

  • CreateTriggerType import com.datical.xml.ns.storedlogic.CreateTriggerType;
    Note: Call the RuleFunctions class static method getText(myCreateTriggerType); to get the text associated with this refactoring. 
String getCatalogName();
String getDbms();
String getEncoding();
String getPath();
String getSchemaName();
String getScope();
String getTableName();
String getTriggerName();
String getXmlns();
boolean isSetDisabled();
boolean isSetRelativeToChangelogFile();
boolean isSetReplaceIfExists();
  • DisableTriggerType import com.datical.xml.ns.storedlogic.DisableTriggerType;
String getCatalogName();
String getSchemaName();
String getScope();
String getTriggerName();
String getXmlns();
  • DropTriggerType import com.datical.xml.ns.storedlogic.DropTriggerType;
    Note: Call the RuleFunctions class static method getText(myDropTriggerType); to get the text associated with this refactoring. 
String getCatalogName();
String getSchemaName();
String getScope();
String getTriggerName();
String getXmlns();
  • EnableTriggerType import com.datical.xml.ns.storedlogic.EnableTriggerType;
    Note: Call the RuleFunctions class static method getText(myEnableTriggerType); to get the text associated with this refactoring. 
String getCatalogName();
String getSchemaName();
String getScope();
String getTriggerName();
String getXmlns();
  • RenameTriggerType import com.datical.xml.ns.storedlogic.RenameTriggerType;
    Note: Call the RuleFunctions class static method getText(myRenameTriggerType); to get the text associated with this refactoring. 
String getCatalogName();
String getNewTriggerName();
String getOldTriggerName();
String getSchemaName();
String getXmlns();

Views

  • CreateViewType import org.liquibase.xml.ns.dbchangelog.CreateViewType;
String getCatalogName();
Object getFullDefinition();
Object getReplaceIfExists();
String getSchemaName();
String getValue();
String getViewName();
  • DropViewType import org.liquibase.xml.ns.dbchangelog.DropViewType;
String getCatalogName();
String getSchemaName();
String getViewName();
  • RenameViewType import org.liquibase.xml.ns.dbchangelog.RenameViewType;
String getCatalogName();
String getNewViewName();
String getOldViewName();
String getSchemaName();
  • ViewExistsType import org.liquibase.xml.ns.dbchangelog.ViewExistsType;
String getCatalogName();
String getSchemaName();
String getViewName();

Miscellaneous

ChangeLogs and ChangeSets

  • ChangeLogPropertyDefinedType import org.liquibase.xml.ns.dbchangelog.ChangeLogPropertyDefinedType;
String getProperty();
String getValue();
  • ChangeSetExecutedType import org.liquibase.xml.ns.dbchangelog.ChangeSetExecutedType;
String getAuthor();
String getChangeLogFile();
String getId();
  • ChangeSetType import org.liquibase.xml.ns.dbchangelog.ChangeSetType;
    Note: Call the RuleFunctions class static method getText(myChangeSetType); to get the text associated with this refactoring. 
List<AddAutoIncrementType> getAddAutoIncrement();
List<AddCheckConstraintType> getAddCheckConstraint();
List<AddColumnType> getAddColumn();
List<AddDefaultValueType> getAddDefaultValue();
List<AddForeignKeyConstraintType> getAddForeignKeyConstraint();
List<AddLookupTableType> getAddLookupTable();
List<AddNotNullConstraintType> getAddNotNullConstraint();
List<AddPrimaryKeyType> getAddPrimaryKey();
List<AddUniqueConstraintType> getAddUniqueConstraint();
List<AlterSequenceType> getAlterSequence();
FeatureMap getAny();
FeatureMap getAnyAttribute();
String getAuthor();
FeatureMap getChangeSetChildren();
List<CommentType> getComments();
String getContext();
List<CreateFunctionType> getCreateFunction();
List<CreateIndexType> getCreateIndex();
List<CreatePackageType> getCreatePackage();
List<CreatePackageBodyType> getCreatePackageBody();
List<CreateProcedureType> getCreateProcedure();
List<CreateSequenceType> getCreateSequence();
List<CreateSynonymType> getCreateSynonym();
List<CreateTableType> getCreateTable();
List<CreateTriggerType> getCreateTrigger();
List<CreateViewType> getCreateView();
List<CustomChangeType> getCustomChange();
String getDbms();
List<DeleteType> getDelete();
List<DisableCheckConstraintType> getDisableCheckConstraint();
List<DisableTriggerType> getDisableTrigger();
List<DropAllForeignKeyConstraintsType> getDropAllForeignKeyConstraints();
List<DropCheckConstraintType> getDropCheckConstraint();
List<DropColumnType> getDropColumn();
List<DropDefaultValueType> getDropDefaultValue();
List<DropForeignKeyConstraintType> getDropForeignKeyConstraint();
List<DropFunctionType> getDropFunction();
List<DropIndexType> getDropIndex();
List<DropNotNullConstraintType> getDropNotNullConstraint();
List<DropPackageType> getDropPackage();
List<DropPackageBodyType> getDropPackageBody();
List<DropPrimaryKeyType> getDropPrimaryKey();
List<DropProcedureType> getDropProcedure();
List<DropSequenceType> getDropSequence();
List<DropSynonymType> getDropSynonym();
List<DropTableType> getDropTable();
List<DropTriggerType> getDropTrigger();
List<DropUniqueConstraintType> getDropUniqueConstraint();
List<DropViewType> getDropView();
List<EnableCheckConstraintType> getEnableCheckConstraint();
List<EnableTriggerType> getEnableTrigger();
List<ExecuteCommandType> getExecuteCommand();
Object getFailOnError();
String getId();
List<InsertType> getInsert();
String getLabels();
List<LoadDataType> getLoadData();
List<LoadUpdateDataType> getLoadUpdateData();
String getLogicalFilePath();
List<MergeColumnsType> getMergeColumns();
List<ModifyDataTypeType> getModifyDataType();
List<ModifySqlType> getModifySql();
ObjectQuotingStrategy getObjectQuotingStrategy();
OnChangeSetValidationFail getOnValidationFail();
List<OutputType> getOutput();
PreConditionsType getPreConditions();
List<RenameColumnType> getRenameColumn();
List<RenameTableType> getRenameTable();
List<RenameTriggerType> getRenameTrigger();
List<RenameViewType> getRenameView();
List<RollbackType> getRollback();
Object getRunAlways();
Object getRunInTransaction();
Object getRunOnChange();
List<SqlType> getSql();
List<SqlFileType> getSqlFile();
List<StopType> getStop();
TagDatabaseType getTagDatabase();
List<UpdateType> getUpdate();
List<ValidCheckSumType> getValidCheckSum();
boolean isSetObjectQuotingStrategy();
boolean isSetOnValidationFail();
boolean isSetRunInTransaction();
  • CommentType import org.liquibase.xml.ns.dbchangelog.CommentType;
    Note: Call the RuleFunctions class static method getText(myCommentType); to get the text associated with this refactoring.


  • DatabaseChangeLogType import org.liquibase.xml.ns.dbchangelog.DatabaseChangeLogType;
FeatureMap getAnyAttribute();
List<ChangeSetType> getChangeSet();
FeatureMap getGroup();
List<IncludeType> getInclude();
List<IncludeAllType> getIncludeAll();
String getLogicalFilePath();
ObjectQuotingStrategy getObjectQuotingStrategy();
PreConditionsType1 getPreConditions();
List<PropertyType> getProperty();
boolean isSetObjectQuotingStrategy();

DML - Data Loading

  • AddLookupTableType import org.liquibase.xml.ns.dbchangelog.AddLookupTableType;
String getConstraintName();
String getExistingColumnName();
String getExistingTableCatalogName();
String getExistingTableName();
String getExistingTableSchemaName();
String getNewColumnDataType();
String getNewColumnName();
String getNewTableCatalogName();
String getNewTableName();
String getNewTableSchemaName();
  • LoadDataType import org.liquibase.xml.ns.dbchangelog.LoadDataType;
    Note: Call the RuleFunctions class static method getText(myLoadDataType); to get the text associated with this refactoring. 
String getCatalogName();
List<ColumnLoadDataType> getColumn();
String getEncoding();
String getFile();
String getQuotchar();
String getSchemaName();
String getSeparator();
String getTableName();
boolean isSetEncoding();
boolean isSetQuotchar();
boolean isSetSeparator();
  • LoadUpdateDataType import org.liquibase.xml.ns.dbchangelog.LoadUpdateDataType;
    Note: Call the RuleFunctions class static method getText(myLoadUpdateDataType); to get the text associated with this refactoring. 
String getCatalogName();
List<ColumnLoadUpdateDataType> getColumn();
String getEncoding();
String getFile();
String getPrimaryKey();
String getQuotchar();
String getSchemaName();
String getSeparator();
String getTableName();
boolean isSetEncoding();
boolean isSetQuotchar();
boolean isSetSeparator();

Miscellaneous

  • AndType import org.liquibase.xml.ns.dbchangelog.AndType;
List<AndType> getAnd();
FeatureMap getAny();
List<ChangeLogPropertyDefinedType> getChangeLogPropertyDefined();
List<ChangeSetExecutedType> getChangeSetExecuted();
List<ColumnExistsType> getColumnExists();
List<CustomPreconditionType> getCustomPrecondition();
List<DbmsType> getDbms();
List<ExpectedQuotingStrategyType> getExpectedQuotingStrategy();
List<ForeignKeyConstraintExistsType> getForeignKeyConstraintExists();
FeatureMap getGroup();
List<IndexExistsType> getIndexExists();
List<NotType> getNot();
List<OrType> getOr();
List<PrimaryKeyExistsType> getPrimaryKeyExists();
List<RowCountType> getRowCount();
List<RunningAsType> getRunningAs();
List<SequenceExistsType> getSequenceExists();
List<SqlCheckType> getSqlCheck();
List<TableExistsType> getTableExists();
List<TableIsEmptyType> getTableIsEmpty();
List<ViewExistsType> getViewExists();
  • AppendType import org.liquibase.xml.ns.dbchangelog.AppendType;
String getValue();
  • ArgType import org.liquibase.xml.ns.dbchangelog.ArgType;
String getValue();
  • CustomChangeType import org.liquibase.xml.ns.dbchangelog.CustomChangeType;
FeatureMap getAnyAttribute();
String getClass_();
List<ParamType1> getParam();
  • CustomPreconditionType import org.liquibase.xml.ns.dbchangelog.CustomPreconditionType;
String getClassName();
List<ParamType2> getParam();
  • DbmsType import org.liquibase.xml.ns.dbchangelog.DbmsType;
String getType();
  • DeleteType import org.liquibase.xml.ns.dbchangelog.DeleteType;
    Note: Call the RuleFunctions class static method getText(myDeleteType); to get the text associated with this refactoring. 
String getCatalogName();
String getSchemaName();
String getTableName();
EObject getWhere();
WhereParamsType getWhereParams();
  • ExecuteCommandType import org.liquibase.xml.ns.dbchangelog.ExecuteCommandType;
List<ArgType> getArg();
String getExecutable();
String getOs();
  • ExpectedQuotingStrategyType import org.liquibase.xml.ns.dbchangelog.ExpectedQuotingStrategyType;
String getStrategy();
  • IncludeAllType import org.liquibase.xml.ns.dbchangelog.IncludeAllType;
FeatureMap getAnyAttribute();
String getFilter();
String getPath();
Object getRelativeToChangelogFile();
  • IncludeType import org.liquibase.xml.ns.dbchangelog.IncludeType;
FeatureMap getAnyAttribute();
String getFile();
Object getRelativeToChangelogFile();
  • InsertType import org.liquibase.xml.ns.dbchangelog.InsertType;
String getCatalogName();
List<ColumnType> getColumn();
String getDbms();
String getSchemaName();
String getTableName();
  • ModifyDataTypeType import org.liquibase.xml.ns.dbchangelog.ModifyDataTypeType;
String getCatalogName();
String getColumnName();
String getNewDataType();
String getSchemaName();
String getTableName();
  • NotType import org.liquibase.xml.ns.dbchangelog.NotType;
List<AndType> getAnd();
FeatureMap getAny();
List<ChangeLogPropertyDefinedType> getChangeLogPropertyDefined();
List<ChangeSetExecutedType> getChangeSetExecuted();
List<ColumnExistsType> getColumnExists();
List<CustomPreconditionType> getCustomPrecondition();
List<DbmsType> getDbms();
List<ExpectedQuotingStrategyType> getExpectedQuotingStrategy();
List<ForeignKeyConstraintExistsType> getForeignKeyConstraintExists();
FeatureMap getGroup();
List<IndexExistsType> getIndexExists();
List<NotType> getNot();
List<OrType> getOr();
List<PrimaryKeyExistsType> getPrimaryKeyExists();
List<RowCountType> getRowCount();
List<RunningAsType> getRunningAs();
List<SequenceExistsType> getSequenceExists();
List<SqlCheckType> getSqlCheck();
List<TableExistsType> getTableExists();
List<TableIsEmptyType> getTableIsEmpty();
List<ViewExistsType> getViewExists();
  • OrType import org.liquibase.xml.ns.dbchangelog.OrType;
List<AndType> getAnd();
FeatureMap getAny();
List<ChangeLogPropertyDefinedType> getChangeLogPropertyDefined();
List<ChangeSetExecutedType> getChangeSetExecuted();
List<ColumnExistsType> getColumnExists();
List<CustomPreconditionType> getCustomPrecondition();
List<DbmsType> getDbms();
List<ExpectedQuotingStrategyType> getExpectedQuotingStrategy();
List<ForeignKeyConstraintExistsType> getForeignKeyConstraintExists();
FeatureMap getGroup();
List<IndexExistsType> getIndexExists();
List<NotType> getNot();
List<OrType> getOr();
List<PrimaryKeyExistsType> getPrimaryKeyExists();
List<RowCountType> getRowCount();
List<RunningAsType> getRunningAs();
List<SequenceExistsType> getSequenceExists();
List<SqlCheckType> getSqlCheck();
List<TableExistsType> getTableExists();
List<TableIsEmptyType> getTableIsEmpty();
List<ViewExistsType> getViewExists();
  • OutputType import org.liquibase.xml.ns.dbchangelog.OutputType;
    Note: Call the RuleFunctions class static method getText(myOutputType); to get the text associated with this refactoring. 
String getTarget();
  • ParamType import org.liquibase.xml.ns.dbchangelog.ParamType;
String getName();
String getValue();
String getValueBoolean();
String getValueComputed();
String getValueDate();
String getValueNumeric();
String getValueSequenceCurrent();
String getValueSequenceNext();
  • PreConditionsType import org.liquibase.xml.ns.dbchangelog.PreConditionsType;
List<AndType> getAnd();
FeatureMap getAny();
List<ChangeLogPropertyDefinedType> getChangeLogPropertyDefined();
List<ChangeSetExecutedType> getChangeSetExecuted();
List<ColumnExistsType> getColumnExists();
List<CustomPreconditionType> getCustomPrecondition();
List<DbmsType> getDbms();
List<ExpectedQuotingStrategyType> getExpectedQuotingStrategy();
List<ForeignKeyConstraintExistsType> getForeignKeyConstraintExists();
FeatureMap getGroup();
List<IndexExistsType> getIndexExists();
List<NotType> getNot();
OnChangeSetPreconditionErrorOrFail getOnError();
String getOnErrorMessage();
OnChangeSetPreconditionErrorOrFail getOnFail();
String getOnFailMessage();
OnChangeLogPreconditionOnSqlOutput getOnSqlOutput();
List<OrType> getOr();
List<PrimaryKeyExistsType> getPrimaryKeyExists();
List<RowCountType> getRowCount();
List<RunningAsType> getRunningAs();
List<SequenceExistsType> getSequenceExists();
List<SqlCheckType> getSqlCheck();
List<TableExistsType> getTableExists();
List<TableIsEmptyType> getTableIsEmpty();
List<ViewExistsType> getViewExists();
boolean isSetOnError();
boolean isSetOnFail();
boolean isSetOnSqlOutput();
  • PrependType import org.liquibase.xml.ns.dbchangelog.PrependType;
String getValue();
  • PropertyType import org.liquibase.xml.ns.dbchangelog.PropertyType;
String getContext();
String getDbms();
String getFile();
String getLabels();
String getName();
String getValue();
  • RegExpReplaceType import org.liquibase.xml.ns.dbchangelog.RegExpReplaceType;
String getReplace();
String getWith();
  • ReplaceType import org.liquibase.xml.ns.dbchangelog.ReplaceType;
String getReplace();
String getWith();
  • RowCountType import org.liquibase.xml.ns.dbchangelog.RowCountType;
String getCatalogName();
int getExpectedRows();
String getSchemaName();
String getTableName();
boolean isSetExpectedRows();
  • RunningAsType import org.liquibase.xml.ns.dbchangelog.RunningAsType;
String getUsername();
  • SqlCheckType import org.liquibase.xml.ns.dbchangelog.SqlCheckType;
    Note: Call the RuleFunctions class static method getText(mySqlCheckType); to get the text associated with this refactoring. 
String getExpectedResult();
  • StopType import org.liquibase.xml.ns.dbchangelog.StopType;
    Note: Call the RuleFunctions class static method getText(myStopType); to get the text associated with this refactoring.


  • TagDatabaseType import org.liquibase.xml.ns.dbchangelog.TagDatabaseType;
String getTag();
  • UpdateType import org.liquibase.xml.ns.dbchangelog.UpdateType;
    Note: Call the RuleFunctions class static method getText(myUpdateType); to get the text associated with this refactoring. 
String getCatalogName();
List<ColumnType> getColumn();
String getSchemaName();
String getTableName();
EObject getWhere();
WhereParamsType getWhereParams();
  • ValidCheckSumType import org.liquibase.xml.ns.dbchangelog.ValidCheckSumType;
    Note: Call the RuleFunctions class static method getText(myValidCheckSumType); to get the text associated with this refactoring. 
String getComment();
  • WhereParamsType import org.liquibase.xml.ns.dbchangelog.WhereParamsType;
    Note: Call the RuleFunctions class static method getText(myWhereParamsType); to get the text associated with this refactoring. 
List<ParamType> getParam();

Project Model

  • Project import com.datical.db.project.Project;
String getName();
String getDescription();
List<DatabaseDef> getDbDefs();
List<Plan> getPlans();
DatabaseChangeLogType getChangelog();
boolean isStoredLogicExternal();
String getChangelogPath();
String getChangelogResourcePath();
List<String> getFolders();
  • Plan import com.datical.db.project.Plan;
String getName();
String getDescription();
List<DatabaseDef> getDatabaseDefs();
List<Step> getSteps();
  • Step import com.datical.db.project.Step;
DatabaseDef getFrom();
DatabaseDef getTo();
  • DatabaseChangeLogType import org.liquibase.xml.ns.dbchangelog.DatabaseChangeLogType;
FeatureMap getAnyAttribute();
List<ChangeSetType> getChangeSet();
FeatureMap getGroup();
List<IncludeType> getInclude();
List<IncludeAllType> getIncludeAll();
String getLogicalFilePath();
ObjectQuotingStrategy getObjectQuotingStrategy();
PreConditionsType1 getPreConditions();
List<PropertyType> getProperty();
boolean isSetObjectQuotingStrategy();

Client System Model

  • ClientSystemInfo import com.datical.hammer.core.rules.ClientSystemInfo;
Date getCurrentDate();
String getDaticalVersion();
String getHostname();
String getIpAddress();
String getJavaVersion();
String getOsVersion();
String getUserName();

Database System Model

  • DatabaseDef import com.datical.db.project.DatabaseDef;
String getContexts();
String getDefaultCatalogName();
String getDefaultSchemaName();
String getDriver();
String getHostname();
String getName();
String getPassword();
Integer getPort();
String getUrl();
String getUsername();
boolean isStorageOptionCollectedAtSnapshot();

GeneratedSQL

  • GeneratedSQL Import com.datical.hammer.core.rules.GeneratedSQL;
String getOutputRollbackSQL();
String getOutputSQL();

Forecast Model

  • Forecast Import com.datical.db.forecastmodel.Forecast;
int getCountRuleErrors()
int getCountRuleInfos()
int getCountRuleWarnings()

Copyright © Liquibase 2012-2022 - Proprietary and Confidential