forked from szandany/Liquibase_Snowflake_Example
-
Notifications
You must be signed in to change notification settings - Fork 1
/
liquibase.checks-settings.conf.v4.23
258 lines (257 loc) · 12.2 KB
/
liquibase.checks-settings.conf.v4.23
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
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
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
Quality Checks Version: 1.0
IMPORTANT: DO NOT MODIFY THIS FILE DIRECTLY. UNRECOVERABLE and UNSUPPORTED ERRORS ARE LIKELY IF YOU EDIT THIS FILE DIRECTLY.
This file is created and modified by running commands in the Liquibase CLI.
For help using quality checks, visit the documentation at https://docs.liquibase.com/quality-checks
-----------------------------------------------------------------------------------------------
!!com.datical.liquibase.ext.checks.config.model.CheckSettingsConfig
rules:
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: true, id: !!java.util.UUID '38fc7edf-9a60-3d00-8b40-23c7e719745f',
severity: MAJOR}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: true, id: !!java.util.UUID '0b73828f-2e8d-3c36-b1c3-7153bcb6f160',
severity: MAJOR}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: true, id: !!java.util.UUID '218fa8f2-ea81-308e-b010-5c25cf62c8fc',
severity: MINOR}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: true, id: !!java.util.UUID '223ed841-5f53-3eab-8ca8-f66393c689a4',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: false, id: !!java.util.UUID 'e98e0a4d-0582-360b-a89f-37b2f65e65d2',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: This check scans raw SQL for the presence of specific patterns and
warns the user when they are found.
enabled: true
id: !!java.util.UUID '8f45647f-df45-30c5-b8b5-0b7b4486c0e9'
name: Check for specific patterns in sql
parameters:
- {parameter: SEARCH_STRING, value: '(?i)^(\s*)(CREATE ROLE)'}
- {parameter: MESSAGE, value: create role statement detected. This is not allowed.}
- {parameter: STRIP_COMMENTS, value: true}
parentRuleId: !!java.util.UUID '6fe07581-c90d-3add-9057-1547a1439727'
severity: CRITICAL
shortName: SqlCreateRoleCheck
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: This check scans raw SQL for the presence of specific patterns and
warns the user when they are found.
enabled: false
id: !!java.util.UUID '6fe07581-c90d-3add-9057-1547a1439727'
name: Check for specific patterns in sql
parameters:
- {parameter: SEARCH_STRING, value: null}
- {parameter: MESSAGE, value: A match for regular expression <SEARCH_STRING> was
detected in Changeset <CHANGESET>.}
- {parameter: STRIP_COMMENTS, value: true}
parentRuleId: null
severity: INFO
shortName: SqlUserDefinedPatternCheck
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: Ensures that no table has more than a threshold number of columns.
enabled: false
id: !!java.util.UUID '2abde5de-a71d-3ead-8fd6-e13a743c0aec'
name: Check Table Column Count
parameters:
- {parameter: MAX_COLUMNS, value: 50}
parentRuleId: null
severity: INFO
shortName: TableColumnLimit
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: This check warns a user when changeset includes or generates sql that
grants specific privileges to a user or role
enabled: false
id: !!java.util.UUID '751a7709-1676-36eb-b1fb-31819ff4b681'
name: Warn on Grant of Specific Privileges
parameters:
- {parameter: PRIVILEGE_LIST, value: null}
parentRuleId: null
severity: INFO
shortName: SqlGrantSpecificPrivsWarn
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: true, id: !!java.util.UUID '136bed9a-17c5-3edc-b1e7-30065052e859',
severity: BLOCKER}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: false, id: !!java.util.UUID '892b5881-6d02-3846-bdf0-c8538e7b013f',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: true, id: !!java.util.UUID 'a85a72fd-9d93-33cd-bbdb-59f21538af9d',
severity: BLOCKER}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: false, id: !!java.util.UUID '00da80be-8adf-3c05-9380-b2538ae3015a',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: false, id: !!java.util.UUID 'e56b7a4a-5953-3be3-96d2-0814eb8e7a02',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: false, id: !!java.util.UUID '517fcf2f-769c-3916-af1c-4c6aeef37914',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: false, id: !!java.util.UUID '9197d8c1-86e7-3277-b3d9-677c2f2b4213',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: false, id: !!java.util.UUID 'b36ff4e4-b647-3bfa-b73f-33c7a588c567',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: This check confirms the listed object names conform to the supplied
pattern.
enabled: false
id: !!java.util.UUID '51362082-ddc1-34dc-98f6-c7413345b19b'
name: Object name pattern match
parameters:
- {parameter: OPERATOR, value: STARTS_WITH}
- {parameter: SEARCH_STRING, value: null}
- {parameter: OBJECT_TYPES, value: null}
- {parameter: CASE_SENSITIVE, value: true}
parentRuleId: null
severity: INFO
shortName: ObjectNameMustMatch
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: This check confirms the listed object names do not match the supplied
pattern.
enabled: false
id: !!java.util.UUID '1bd2ac39-66fd-31fc-ac37-d6ba4c6319cc'
name: Object name pattern not match
parameters:
- {parameter: OPERATOR, value: STARTS_WITH}
- {parameter: SEARCH_STRING, value: null}
- {parameter: OBJECT_TYPES, value: null}
- {parameter: CASE_SENSITIVE, value: true}
parentRuleId: null
severity: INFO
shortName: ObjectNameMustNotMatch
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: Disallow Oracle reserved keywords from being used in database object
names. See https://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm
for complete list of keywords.
enabled: false
id: !!java.util.UUID 'b0530bd6-986c-3084-b2d7-d01261a6337e'
name: Disallow oracle reserved keywords
parameters:
- {parameter: OBJECT_TYPES, value: null}
- {parameter: ALLOWED_LIST, value: null}
- {parameter: CASE_SENSITIVE, value: true}
parentRuleId: null
severity: INFO
shortName: OracleReservedKeywords
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: Disallow SQL Server reserved keywords from being used in database object
names. See https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver16
for complete list of keywords.
enabled: false
id: !!java.util.UUID '3328f158-14fe-389e-ad3d-ed633c07cd8b'
name: Disallow sql server reserved keywords
parameters:
- {parameter: OBJECT_TYPES, value: null}
- {parameter: ALLOWED_LIST, value: null}
- {parameter: CASE_SENSITIVE, value: true}
parentRuleId: null
severity: INFO
shortName: SQLServerReservedKeywords
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: Disallow SQL Server's future reserved keywords from being used in database
object names. See https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver16
for complete list of keywords.
enabled: false
id: !!java.util.UUID 'e373a890-b092-3c11-b204-d71b84282a26'
name: Disallow sql server future reserved keywords
parameters:
- {parameter: OBJECT_TYPES, value: null}
- {parameter: ALLOWED_LIST, value: null}
- {parameter: CASE_SENSITIVE, value: true}
parentRuleId: null
severity: INFO
shortName: SQLServerFutureReservedKeywords
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: Disallow Postgres reserved keywords from being used in database object
names. See https://www.postgresql.org/docs/14/sql-keywords-appendix.html for complete
list of keywords.
enabled: false
id: !!java.util.UUID '23ba52ce-5e52-3025-8404-6c455797e53a'
name: Disallow postgres reserved keywords
parameters:
- {parameter: OBJECT_TYPES, value: null}
- {parameter: ALLOWED_LIST, value: null}
- {parameter: CASE_SENSITIVE, value: true}
parentRuleId: null
severity: INFO
shortName: PostgresReservedKeywords
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: Disallow SQL Server's ODBC reserved keywords from being used in database
object names. See https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver16
for complete list of keywords.
enabled: false
id: !!java.util.UUID '534bf3f7-941c-35a0-8127-a3b869f7eec2'
name: Disallow sql server odbc reserved keywords
parameters:
- {parameter: OBJECT_TYPES, value: null}
- {parameter: ALLOWED_LIST, value: null}
- {parameter: CASE_SENSITIVE, value: true}
parentRuleId: null
severity: INFO
shortName: SQLServerODBCReservedKeywords
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: Disallow Postgres non-reserved keywords from being used in database
object names. See https://www.postgresql.org/docs/14/sql-keywords-appendix.html
for complete list of keywords.
enabled: false
id: !!java.util.UUID 'f731c06a-1f37-31e4-82e2-1e7df7d9c930'
name: Disallow postgres non reserved keywords
parameters:
- {parameter: OBJECT_TYPES, value: null}
- {parameter: ALLOWED_LIST, value: null}
- {parameter: CASE_SENSITIVE, value: true}
parentRuleId: null
severity: INFO
shortName: PostgresNonReservedKeywords
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: This check warns a user when a ChangeSet includes a ChangeType listed
by the user as forbidden
enabled: true
id: !!java.util.UUID '467fd8ba-a898-30a7-b265-aa48a023ae21'
name: Warn on Use of User Defined ChangeTypes
parameters:
- {parameter: CHANGE_TYPE_LIST, value: 'dropTable,dropColumn'}
parentRuleId: null
severity: INFO
shortName: DetectChangeType
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: true, id: !!java.util.UUID 'd517b518-8a6f-3084-a5be-97e7d89c6860',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: This check warns when a create table action doesn't also include a
primary key.
enabled: true
id: !!java.util.UUID '8164f717-c798-323b-b268-65b5eca0784e'
name: Require primary key when creating table
parameters:
- {parameter: EXCEPTIONS_LIST, value: ''}
- {parameter: CASE_SENSITIVE, value: true}
parentRuleId: null
severity: INFO
shortName: PrimaryKeyOnCreateTable
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: true, id: !!java.util.UUID 'b945447e-9e2a-3422-b40c-543d7505568a',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: false, id: !!java.util.UUID 'f9a9e270-09b1-3a4c-90b1-e3ae1de98d77',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: This check triggers when specific user-supplied patterns are found
in Table Comments.
enabled: false
id: !!java.util.UUID '52e205f6-185c-3e14-9e90-18c66f1267a9'
name: Table Comment Pattern Check
parameters:
- {parameter: OPERATOR, value: CONTAINS}
- {parameter: SEARCH_STRING, value: null}
- {parameter: MESSAGE, value: A match for regular expression <SEARCH_STRING> was
detected in <IDENTIFIER>.}
parentRuleId: null
severity: INFO
shortName: TableCommentPatternCheck
- !!com.datical.liquibase.ext.checks.config.model.DynamicRule
description: Check for and alert when specified table does not contain the required
constraint(s).
enabled: false
id: !!java.util.UUID 'c3a5ceda-c901-3864-8394-18c04139036c'
name: Constraint must exist
parameters:
- {parameter: CONSTRAINT_OPERATOR, value: STARTS_WITH}
- {parameter: TABLE_NAME, value: null}
- {parameter: COLUMN_NAME, value: null}
- {parameter: CONSTRAINT, value: PRIMARYKEY}
- {parameter: CASE_SENSITIVE, value: true}
- {parameter: MESSAGE, value: The specified table '<TABLE_NAME>' does not contain
the required '<CONSTRAINT>' constraint.}
parentRuleId: null
severity: INFO
shortName: ConstraintMustExist
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: false, id: !!java.util.UUID 'af508207-cd38-3498-8a56-187ed76caebb',
severity: INFO}
- !!com.datical.liquibase.ext.checks.config.model.BasicRule {enabled: true, id: !!java.util.UUID '2b02222f-32cf-3761-add0-9615b821678f',
severity: INFO}