@komtek/valiq

validation liquibase

liquibase xml migrations validation utility

Parameters

--path - directory with liquibase xml migrations files

Run

valiq --path=db-migrations/config

Validations

common rules

• first character only letter a-z
• last character only letter a-z or 0-9

remarks validations

• must not be empty string
• must not contain � character

examples and prefixes

• schemaName name_with_underscore
• viewName name_with_underscore_v (required suffix _v)
• tableName name_with_underscore
• columnName name_with_underscore
• primaryKeyName pk_name_with_underscore (required prefix pk_)
• indexName idx_name_with_underscore (required prefix idx_)
• addForeignKeyConstraint/@constraintName fx_name_with_underscore (required prefix fk_)
• addUniqueConstraint/@constraintName uk_name_with_underscore (required prefix uk_)

Copyright

Komtek LTD, 2022