|
1 package com.daffodilwoods.daffodildb.server.sql99.ddl.descriptors;
2
3 import java.util.*;
4
5 import com.daffodilwoods.daffodildb.server.datadictionarysystem.*;
6 import com.daffodilwoods.database.general.*;
7 import com.daffodilwoods.database.resource.*;
8
9
17
18 public class SystemConstraintsFactory {
19 private SystemConstraintsFactory() {
20 }
21
22 public static void getReferencingConstraints(TreeMap constraints, String  tableName, _DataDictionary dataDictionary) throws DException {
23 Object [] columnsAndIndexes = getForeignKeyInformation(tableName);
24 if (columnsAndIndexes != null) {
25 for (int i = 0; i < columnsAndIndexes.length; i++) {
26 Object [] columnsAndIndex = (Object []) columnsAndIndexes[i];
27
28 ReferentialConstraintDescriptor constraint = new ReferentialConstraintDescriptor();
29 TableConstraintDescriptor tableConstraintDescriptor = new TableConstraintDescriptor();
30 TableConstraintDescriptor referencedTableConstraintDescriptor = new TableConstraintDescriptor();
31
32 constraint.constraint_catalog = SystemTables.systemCatalog;
33 constraint.constraint_schema = SystemTables.systemSchema;
34 constraint.constraint_name = columnsAndIndex[0].toString();
35 constraint.unique_constraint_catalog = SystemTables.systemCatalog;
36 constraint.unique_constraint_schema = SystemTables.systemSchema;
37 constraint.unique_constraint_name = columnsAndIndex[3].toString();
38 constraint.match_option = columnsAndIndex[4].toString();
39 constraint.update_rule = SqlSchemaConstants.NoAction;
40 constraint.delete_rule = SqlSchemaConstants.NoAction;
41
42 referencedTableConstraintDescriptor.constraint_catalog = SystemTables.systemCatalog;
43 referencedTableConstraintDescriptor.constraint_schema = SystemTables.systemSchema;
44 referencedTableConstraintDescriptor.constraint_name = columnsAndIndex[3].toString();
45
46 tableConstraintDescriptor.constraint_catalog = SystemTables.systemCatalog;
47 tableConstraintDescriptor.constraint_schema = SystemTables.systemSchema;
48 tableConstraintDescriptor.constraint_name = columnsAndIndex[0].toString();
49 tableConstraintDescriptor.constraint_type = "Foreign Key";
50 tableConstraintDescriptor.table_catalog = SystemTables.systemCatalog;
51 tableConstraintDescriptor.table_schema = SystemTables.systemSchema;
52 tableConstraintDescriptor.table_name = tableName;
53 tableConstraintDescriptor.is_deferrable = SqlSchemaConstants.NO;
54 tableConstraintDescriptor.initially_deferred = SqlSchemaConstants.NO;
55
56 ArrayList arr = getKeyColumnDescriptors(columnsAndIndex, tableConstraintDescriptor);
57 tableConstraintDescriptor.constraintColumnDescriptors = arr;
58 tableConstraintDescriptor.intializeColumnIndexes(dataDictionary.getColumnCharacteristics(new QualifiedIdentifier(SystemTables.systemCatalog, SystemTables.systemSchema, tableName), true));
59
60 Object [] referencedColumnsAndIndexes = getPrimaryKeyInformation(columnsAndIndex[5].toString());
61 if (referencedColumnsAndIndexes != null) {
62 referencedTableConstraintDescriptor.table_catalog = SystemTables.systemCatalog;
63 referencedTableConstraintDescriptor.table_schema = SystemTables.systemSchema;
64 referencedTableConstraintDescriptor.table_name = columnsAndIndex[5].toString();
65 referencedTableConstraintDescriptor.constraint_catalog = SystemTables.systemCatalog;
66 referencedTableConstraintDescriptor.constraint_schema = SystemTables.systemSchema;
67 referencedTableConstraintDescriptor.initially_deferred = SqlSchemaConstants.NO;
68 referencedTableConstraintDescriptor.is_deferrable = SqlSchemaConstants.NO;
69 referencedTableConstraintDescriptor.constraint_type = "PRIMARY KEY";
70 referencedTableConstraintDescriptor.constraint_name = referencedColumnsAndIndexes[0].toString();
71 ArrayList arr1 = getKeyColumnDescriptors(referencedColumnsAndIndexes, referencedTableConstraintDescriptor);
72 referencedTableConstraintDescriptor.constraintColumnDescriptors = arr1;
73 referencedTableConstraintDescriptor.intializeColumnIndexes(dataDictionary.getColumnCharacteristics(new QualifiedIdentifier(SystemTables.systemCatalog, SystemTables.systemSchema, columnsAndIndex[5].toString()), true));
74 referencedTableConstraintDescriptor.constraintDescriptor = constraint;
75 constraint.referencedTableConstraintDescriptor = referencedTableConstraintDescriptor;
76 constraints.put(constraint.constraint_name, constraint);
77 }
78 constraint.tableConstraintDescriptor = tableConstraintDescriptor;
79 tableConstraintDescriptor.constraintDescriptor = constraint;
80 constraints.put(constraint.constraint_name, constraint);
81 }
82 }
83 }
84
85 private static Object [] getForeignKeyInformation(String tableName) throws DException {
86 if (tableName.equalsIgnoreCase("ROLE_AUTHORIZATION_DESCRIPTORS")) {
87
88
89 return new Object [] {new Object [] { "ROLE_AUTHORIZATION_DESCRIPTORS_FOREIGN_KEY_ROLES", new String [] {"ROLE_NAME"}
90 ,
91
92 new int[] {1}
93 , "ROLES_PRIMARY_KEY", "SIMPLE", "ROLES"}
94 };
95 } else if (tableName.equalsIgnoreCase("SCHEMATA")) {
96
97
98 return new Object [] {new Object [] {"SCHEMATA_FOREIGN_KEY", new String [] {"SCHEMA_OWNER"}
99 , new int[] {1}
100 , "USERS_PRIMARY_KEY", "SIMPLE", "USERS"}
101 };
102 } else if (tableName.equalsIgnoreCase("CHARACTER_SETS")) {
103
104
105 return new Object [] {new Object [] {"CHARACTER_SETS_FOREIGN_KEY_SCHEMATA", new String [] {"CHARACTER_SET_CATALOG", "CHARACTER_SET_SCHEMA"}
106 , new int[] {1, 2}
107 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"}
108 };
109 } else if (tableName.equalsIgnoreCase("COLLATIONS")) {
110
111
112 return new Object [] {new Object [] {"COLLATIONS_PAD_FOREIGN_KEY_SCHEMATA", new String [] {"COLLATION_CATALOG", "COLLATION_SCHEMA"}
113 , new int[] {1, 2}
114 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"}
115 };
116 } else if (tableName.equalsIgnoreCase("DOMAINS")) {
117
118
119 return new Object [] {new Object [] {"DOMAINS_FOREIGN_KEY_SCHEMATA", new String [] {"DOMAIN_CATALOG", "DOMAIN_SCHEMA"}
120 , new int[] {1, 2}
121 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"}
122 };
123 } else if (tableName.equalsIgnoreCase("TABLES")) {
124
125
126 return new Object [] {new Object [] {"TABLES_FOREIGN_KEY_SCHEMATA", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA"}
127 , new int[] {1, 2}
128 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"}
129 };
130 } else if (tableName.equalsIgnoreCase("COLUMNS")) {
131
132
133 return new Object [] {new Object [] {"COLUMNS_FOREIGN_KEY_TABLES", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME"}
134 , new int[] {1, 2, 3}
135 , "TABLES_PRIMARY_KEY", "SIMPLE", "TABLES"}
136 };
137 } else if (tableName.equalsIgnoreCase("DATA_TYPE_DESCRIPTOR")) {
138
139
140 return new Object [] {new Object [] {"DATA_TYPE_DESCRIPTOR_FOREIGN_KEY_SCHEMATA", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA"}
141 , new int[] {1, 2}
142 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"}
143 };
144 } else if (tableName.equalsIgnoreCase("KEY_COLUMN_USAGE")) {
145
146
147 return new Object [] {new Object [] {"KEY_COLUMN_USAGE_FOREIGN_KEY_COLUMNS", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME"}
148 , new int[] {1, 2, 3, 4}
149 , "COLUMNS_PRIMARY_KEY", "SIMPLE", "COLUMNS"}
150 };
151 } else if (tableName.equalsIgnoreCase("CHECK_COLUMN_USAGE")) {
152
153
154 return new Object [] {new Object [] {"CHECK_COLUMN_USAGE_FOREIGN_KEY_CHECK_CONSTRAINTS", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME"}
155 , new int[] {1, 2, 3}
156 , "CHECK_CONSTRAINTS_PRIMARY_KEY", "SIMPLE", "CHECK_CONSTRAINTS"}
157 };
158 } else if (tableName.equalsIgnoreCase("CHECK_TABLE_USAGE")) {
159
160
161 return new Object [] {new Object [] {"CHECK_TABLE_USAGE_FOREIGN_KEY_CHECK_CONSTRAINTS", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME"}
162 , new int[] {1, 2, 3}
163 , "CHECK_CONSTRAINTS_PRIMARY_KEY", "SIMPLE", "CHECK_CONSTRAINTS"}
164 };
165 } else if (tableName.equalsIgnoreCase("TRIGGERS")) {
166
167
168 return new Object [] {new Object [] {"TRIGGERS_FOREIGN_KEY_SCHEMATA", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA"}
169 , new int[] {1, 2}
170 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"}
171 };
172 } else if (tableName.equalsIgnoreCase("TRIGGER_TABLE_USAGE")) {
173
174
175 return new Object [] {new Object [] {"TRIGGER_TABLE_USAGE_FOREIGN_KEY_TRIGGERS", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME"}
176 , new int[] {1, 2, 3}
177 , "TRIGGERS_PRIMARY_KEY", "SIMPLE", "TRIGGERS"}
178 };
179 } else if (tableName.equalsIgnoreCase("TRIGGER_COLUMN_USAGE")) {
180
181
182
183 return new Object [] {new Object [] {"TRIGGER_COLUMN_USAGE_CHECK_REFERENCES_COLUMNS", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME"}
184 , new int[] {1, 2, 3, 4}
185 , "COLUMNS_PRIMARY_KEY", "SIMPLE", "COLUMNS"
186 }
187 , new Object [] {"TRIGGER_COLUMN_USAGE_FOREIGN_KEY_TRIGGERS", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME"}
188 , new int[] {1, 2, 3}
189 , "TRIGGERS_PRIMARY_KEY", "SIMPLE", "TRIGGERS"
190 }
191 };
192 } else if (tableName.equalsIgnoreCase("TRIGGERED_UPDATE_COLUMNS")) {
193
194
195
196 return new Object [] {new Object [] {"TRIGGERED_UPDATE_COLUMNS_FOREIGN_KEY_TRIGGERS", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME"}
197 , new int[] {1, 2, 3}
198 , "TRIGGERS_PRIMARY_KEY", "SIMPLE", "TRIGGERS"
199 }
200 , new Object [] {"TRIGGERED_UPDATE_COLUMNS_FOREIGN_KEY_COLUMNS", new String [] {"EVENT_OBJECT_CATALOG", "EVENT_OBJECT_SCHEMA", "EVENT_OBJECT_TABLE", "EVENT_OBJECT_COLUMN"}
201 , new int[] {1, 2, 3, 4}
202 , "COLUMNS_PRIMARY_KEY", "SIMPLE", "COLUMNS"
203 }
204 };
205 } else if (tableName.equalsIgnoreCase("VIEW_COLUMN_USAGE")) {
206
207
208 return new Object [] {new Object [] {"VIEW_COLUMN_USAGE_FOREIGN_KEY_VIEWS", new String [] {"VIEW_CATALOG", "VIEW_SCHEMA", "VIEW_NAME"}
209 , new int[] {1, 2, 3}
210 , "VIEWS_PRIMARY_KEY", "SIMPLE", "VIEWS"
211 }
212 };
213 } else if (tableName.equalsIgnoreCase("VIEW_TABLE_USAGE")) {
214
215
216 return new Object [] {new Object [] {"VIEW_TABLE_USAGE_FOREIGN_KEY_VIEWS", new String [] {"VIEW_CATALOG", "VIEW_SCHEMA", "VIEW_NAME"}
217 , new int[] {1, 2, 3}
218 , "VIEWS_PRIMARY_KEY", "SIMPLE", "VIEWS"}
219 };
220 } else if (tableName.equalsIgnoreCase("DOMAIN_CONSTRAINTS")) {
221
222
223
224
225 return new Object [] {new Object [] {"DOMAIN_CONSTRAINTS_FOREIGN_KEY_SCHEMATA", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA"}
226 , new int[] {1, 2}
227 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"
228 }
229 , new Object [] {"DOMAIN_CONSTRAINTS_FOREIGN_KEY_CHECK_CONSTRAINTS", new String [] {"DOMAIN_CATALOG", "DOMAIN_SCHEMA", "CONSTRAINT_NAME"}
230 , new int[] {1, 2, 3}
231 , "CHECK_CONSTRAINTS_PRIMARY_KEY", "SIMPLE", "CHECK_CONSTRAINTS"
232 }
233 , new Object [] {"DOMAIN_CONSTRAINTS_FOREIGN_KEY_DOMAINS", new String [] {"DOMAIN_CATALOG", "DOMAIN_SCHEMA", "DOMAIN_NAME"}
234 , new int[] {1, 2, 3}
235 , "DOMAINS_PRIMARY_KEY", "SIMPLE", "DOMAINS"
236 }
237 };
238 } else if (tableName.equalsIgnoreCase("COLUMN_PRIVILEGES")) {
239
240
241 return new Object [] {new Object [] {"COLUMN_PRIVILEGE_FOREIGN_KEY_COLUMNS", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME"}
242 , new int[] {1, 2, 3, 4}
243 , "COLUMNS_PRIMARY_KEY", "SIMPLE", "COLUMNS"}
244 };
245 } else if (tableName.equalsIgnoreCase("TABLE_PRIVILEGES")) {
246
247
248 return new Object [] {new Object [] {"TABLE_PRIVILEGE_FOREIGN_KEY_TABLES", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME"}
249 , new int[] {1, 2, 3}
250 , "TABLES_PRIMARY_KEY", "SIMPLE", "TABLES"}
251 };
252 } else if (tableName.equalsIgnoreCase("ROUTINES")) {
253
254
255 return new Object [] {new Object [] {"ROUTINES_FOREIGN_KEY_SCHEMATA", new String [] {"ROUTINE_CATALOG", "ROUTINE_SCHEMA"}
256 , new int[] {1, 2}
257 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"}
258 };
259 } else if (tableName.equalsIgnoreCase("PARAMETERS")) {
260
261
262 return new Object [] {new Object [] {"PARAMETERS_FOREIGN_KEY_SCHEMATA", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA"}
263 , new int[] {1, 2}
264 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"}
265 };
266 } else if (tableName.equalsIgnoreCase("ROUTINE_PRIVILEGES")) {
267
268
269 return new Object [] {new Object [] {"ROUTINE_PRIVILEGES_FOREIGN_KEY_TABLES", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME"}
270 , new int[] {1, 2, 3}
271 , "ROUTINES_PRIMARY_KEY", "SIMPLE", "ROUTINES"}
272 };
273 } else if (tableName.equalsIgnoreCase("INDEXCOLUMNS")) {
274
275
276 return new Object [] {new Object [] {"INDEXCOLUMNS_FOREIGN_KEY_COLUMNS", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME"}
277 , new int[] {1, 2, 3, 4}
278 , "INDEXINFO_PRIMARY_KEY", "SIMPLE", "INDEXINFO"}
279 };
280 } else if (tableName.equalsIgnoreCase("FULLTEXTCOLUMNINFO")) {
281
282
283 return new Object [] {new Object [] {"FULLTEXTINDEXCOLUMNS_FOREIGN_KEY_COLUMNS", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME"}
284 , new int[] {1, 2, 3, 4}
285 , "FULLTEXTINDEX_PRIMARY_KEY", "SIMPLE", "FULLTEXTINFO"}
286 };
287 } else if (tableName.equalsIgnoreCase("User_Defined_Types")) {
288
289
290
291 return new Object [] {new Object [] {"USER_DEFINED_TYPES_FOREIGN_KEY_SCHEMATA", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA"}
292 , new int[] {1, 2}
293 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"
294 }
295 , new Object [] {"USER_DEFINED_TYPES_FOREIGN_KEY_ROUTINES", new String [] {"ORDERING_ROUTINE_CATALOG", "ORDERING_ROUTINE_SCHEMA", "ORDERING_ROUTINE_NAME"}
296 , new int[] {1, 2, 3}
297 , "ROUTINES_PRIMARY_KEY", "SIMPLE", "ROUTINES"
298 }
299 };
300 } else if (tableName.equalsIgnoreCase("User_Defined_Type_Privileges")) {
301
302
303 return new Object [] {new Object [] {"USER_DEFINED_TYPE_PRIVILEGES_FOREIGN_KEY_USER_DEFINED_TYPE", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA", "USER_DEFINED_TYPE_NAME"}
304 , new int[] {1, 2, 3}
305 , "USER_DEFINED_TYPES_PRIMARY_KEY", "SIMPLE", "USER_DEFINED_TYPES"}
306 };
307 } else if (tableName.equalsIgnoreCase("Transforms_Table")) {
308
309
310
311 return new Object [] {new Object [] {"TRANSFORMS_TYPES_FOREIGN_KEY", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA", "USER_DEFINED_TYPE_NAME"}
312 , new int[] {1, 2, 3}
313 , "USER_DEFINED_TYPES_PRIMARY_KEY", "SIMPLE", "USER_DEFINED_TYPES"
314 }
315 , new Object [] {"TRANSFORMS_ROUTINES_FOREIGN_KEY", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME"}
316 , new int[] {1, 2, 3}
317 , "ROUTINES_PRIMARY_KEY", "SIMPLE", "ROUTINES"
318 }
319 };
320 } else if (tableName.equalsIgnoreCase("Method_Specifications")) {
321
322
323
324
325
326 return new Object [] {new Object [] {"METHOD_SPECIFICATIONS_FOREIGN_KEY_SCHEMATA", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA"}
327 , new int[] {1, 2}
328 , "SCHEMATA_PRIMARY_KEY", "SIMPLE", "SCHEMATA"
329 }
330 , new Object [] {"METHOD_SPECIFICATIONS_FOREIGN_KEY_USER_DEFINED_TYPES", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA", "USER_DEFINED_TYPE_NAME"}
331 , new int[] {1, 2, 3}
332 , "USER_DEFINED_TYPES_PRIMARY_KEY", "FULL", "USER_DEFINED_TYPES"
333 }
334 };
335 } else if (tableName.equalsIgnoreCase("Method_Specifications_Paramters")) {
336
337
338 return new Object [] {new Object [] {"METHOD_SPECIFICATION_PARAMETERS_FOREIGN_KEY", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME"}
339 , new int[] {1, 2, 3}
340 , "METHOD_SPECIFICATIONS_PRIMARY_KEY", "SIMPLE", "Method_Specifications"}
341 };
342 } else if (tableName.equalsIgnoreCase("ROUTINE_TABLE_USAGE")) {
343 return new Object [] {new Object [] {"ROUTINE_TABLE_USAGE_FOREIGN_KEY_ROUTINES", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME"}
344 , new int[] {1, 2, 3}
345 , "ROUTINES_PRIMARY_KEY", "SIMPLE", "ROUTINES"}
346 };
347 } else if (tableName.equalsIgnoreCase("ROUTINE_COLUMN_USAGE")) {
348 return new Object [] {new Object [] {"ROUTINE_COLUMN_USAGE_FOREIGN_KEY_ROUTINES", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME"}
349 , new int[] {1, 2, 3}
350 , "ROUTINES_PRIMARY_KEY", "SIMPLE", "ROUTINES"}
351 };
352 }
353 return null;
354 }
355
356 public static _UniqueConstraint getPrimaryKeyConstraints(String tableName, _ColumnCharacteristics columnCharacteristics) throws DException {
357 Object [] columnsAndIndexes = getPrimaryKeyInformation(tableName);
358 if (columnsAndIndexes != null) {
359 TableConstraintDescriptor tableConstraintDescriptor = new TableConstraintDescriptor();
360 UniqueConstraintDescriptor constraint = new UniqueConstraintDescriptor();
361 tableConstraintDescriptor.table_catalog = SystemTables.systemCatalog;
362 tableConstraintDescriptor.table_schema = SystemTables.systemSchema;
363 tableConstraintDescriptor.table_name = tableName;
364 tableConstraintDescriptor.constraint_catalog = SystemTables.systemCatalog;
365 tableConstraintDescriptor.constraint_schema = SystemTables.systemSchema;
366 tableConstraintDescriptor.initially_deferred = SqlSchemaConstants.NO;
367 tableConstraintDescriptor.is_deferrable = SqlSchemaConstants.NO;
368 tableConstraintDescriptor.constraint_type = "PRIMARY KEY";
369 tableConstraintDescriptor.constraint_name = columnsAndIndexes[0].toString();
370 ArrayList arr = getKeyColumnDescriptors(columnsAndIndexes, tableConstraintDescriptor);
371 tableConstraintDescriptor.constraintColumnDescriptors = arr;
372 tableConstraintDescriptor.intializeColumnIndexes(columnCharacteristics);
373 tableConstraintDescriptor.constraintDescriptor = constraint;
374 constraint.tableConstraintDescriptor = tableConstraintDescriptor;
375 return constraint;
376 }
377 return null;
378 }
379
380 public static void getUniqueKeyConstraints(String tableName, TreeMap constraints, _ColumnCharacteristics columnCharacteristics) throws DException {
381 Object [] columnsAndIndexes = getUniqueKeyInformation(tableName);
382 if (columnsAndIndexes != null) {
383 TableConstraintDescriptor tableConstraintDescriptor = new TableConstraintDescriptor();
384 UniqueConstraintDescriptor constraint = new UniqueConstraintDescriptor();
385 tableConstraintDescriptor.table_catalog = SystemTables.systemCatalog;
386 tableConstraintDescriptor.table_schema = SystemTables.systemSchema;
387 tableConstraintDescriptor.table_name = tableName;
388 tableConstraintDescriptor.constraint_catalog = SystemTables.systemCatalog;
389 tableConstraintDescriptor.constraint_schema = SystemTables.systemSchema;
390 tableConstraintDescriptor.initially_deferred = SqlSchemaConstants.NO;
391 tableConstraintDescriptor.is_deferrable = SqlSchemaConstants.NO;
392 tableConstraintDescriptor.constraint_type = "UNIQUE";
393 tableConstraintDescriptor.constraint_name = columnsAndIndexes[0].toString();
394 ArrayList arr = getKeyColumnDescriptors(columnsAndIndexes, tableConstraintDescriptor);
395 tableConstraintDescriptor.constraintColumnDescriptors = arr;
396 tableConstraintDescriptor.intializeColumnIndexes(columnCharacteristics);
397 tableConstraintDescriptor.constraintDescriptor = constraint;
398 constraint.tableConstraintDescriptor = tableConstraintDescriptor;
399 constraints.put(tableConstraintDescriptor.constraint_name, constraint);
400 }
401 }
402
403 public static void getCheckConstraints(DataDictionary dataDictionary, String tableName, TreeMap constraints) throws DException {
404 Object [] constraintsAndClause = getCheckConstraintInformation(tableName);
405 if (constraintsAndClause != null) {
406 String [] constraintNames = (String []) constraintsAndClause[0];
407 String [] checkClause = (String []) constraintsAndClause[1];
408 int[] columnIndexes = (int[]) constraintsAndClause[2];
409 for (int i = 0; i < constraintNames.length; i++) {
410 TableConstraintDescriptor tableConstraintDescriptor = new TableConstraintDescriptor();
411 CheckConstraintDescriptor constraint = new CheckConstraintDescriptor();
412 tableConstraintDescriptor.constraint_catalog = SystemTables.systemCatalog;
413 tableConstraintDescriptor.constraint_schema = SystemTables.systemSchema;
414 tableConstraintDescriptor.constraint_name = constraintNames[i];
415 tableConstraintDescriptor.constraint_type = "CHECK";
416 tableConstraintDescriptor.table_catalog = SystemTables.systemCatalog;
417 tableConstraintDescriptor.table_schema = SystemTables.systemSchema;
418 tableConstraintDescriptor.table_name = tableName;
419 tableConstraintDescriptor.is_deferrable = SqlSchemaConstants.NO;
420 tableConstraintDescriptor.initially_deferred = SqlSchemaConstants.NO;
421 constraint.constraint_catalog = tableConstraintDescriptor.constraint_catalog;
422 constraint.constraint_schema = tableConstraintDescriptor.constraint_schema;
423 constraint.constraint_name = tableConstraintDescriptor.constraint_name;
424 constraint.tableConstraintDescriptor = tableConstraintDescriptor;
425 tableConstraintDescriptor.constraintDescriptor = constraint;
426 constraint.check_clause = checkClause[i];
427 constraint.columnIndexes = columnIndexes;
428 constraints.put(constraint.constraint_name, constraint);
429 }
430 }
431 Object [] constraintsAndClauseForDomain = getCheckConstraintInformationForDomain(tableName);
432 if (constraintsAndClauseForDomain != null) {
433 for (int j = 0; j < constraintsAndClauseForDomain.length; j++) {
434 Object [] constraintsAndColumnForDomain = (Object []) constraintsAndClauseForDomain[j];
435 ColumnCharacteristics columnCharacteristics = (ColumnCharacteristics) dataDictionary.getColumnCharacteristics(new QualifiedIdentifier(SystemTables.systemCatalog, SystemTables.systemSchema, tableName), true);
436 int[] domainColumnIndexes = columnCharacteristics.getDomainColumnIndexes();
437 if (domainColumnIndexes == null)
438 return;
439 for (int i = 0; i < domainColumnIndexes.length; i++) {
440 CheckConstraintDescriptor[] checkConstraints = getCheckConstraintForDomain(constraintsAndColumnForDomain);
441 if (checkConstraints != null) {
442 for (int k = 0; k < checkConstraints.length; k++) {
443 CheckConstraintDescriptor constraint = null;
444 constraints.put(checkConstraints[k].constraint_name,
445 constraint = checkConstraints[k]);
446
447 constraint.addColumnIndex(domainColumnIndexes[i],
448 new String [] {SystemTables.systemCatalog, SystemTables.systemSchema, tableName,
449 columnCharacteristics.getColumnName(
450 domainColumnIndexes[i])});
451 }
452 }
453 }
454 }
455 }
456 }
457
458 private static CheckConstraintDescriptor[] getCheckConstraintForDomain(Object [] constraintsAndClauseForDomain) throws DException {
459 ArrayList constraintsList = new ArrayList();
460 CheckConstraintDescriptor[] constraints = null;
461 String [] constraintNames = (String []) constraintsAndClauseForDomain[0];
462 String [] checkClause = (String []) constraintsAndClauseForDomain[1];
463 for (int i = 0; i < constraintNames.length; i++) {
464 DomainConstraintDescriptor domainConstraintDescriptor = new DomainConstraintDescriptor();
465 CheckConstraintDescriptor constraint = new CheckConstraintDescriptor();
466 domainConstraintDescriptor.domain_catalog = SystemTables.systemCatalog;
467 domainConstraintDescriptor.domain_schema = "INFORMATION_SCHEMA";
468 domainConstraintDescriptor.domain_name = "CARDINAL_NUMBER";
469 domainConstraintDescriptor.is_deferrable = SqlSchemaConstants.NO;
470 domainConstraintDescriptor.initially_deferred = SqlSchemaConstants.NO;
471 domainConstraintDescriptor.constraint_catalog = SystemTables.systemCatalog;
472 domainConstraintDescriptor.constraint_schema = "INFORMATION_SCHEMA";
473 domainConstraintDescriptor.constraint_name = constraintNames[i];
474 constraint.constraint_catalog = SystemTables.systemCatalog;
475 constraint.constraint_schema = "INFORMATION_SCHEMA";
476 constraint.constraint_name = constraintNames[i];
477 constraint.domainConstraintDescriptor = domainConstraintDescriptor;
478 constraint.check_clause = checkClause[i];
479 constraintsList.add(constraint);
480 }
481 constraints = (CheckConstraintDescriptor[]) constraintsList.toArray(new CheckConstraintDescriptor[0]);
482 return constraints;
483 }
484
485 private static Object [] getCheckConstraintInformationForDomain(String tableName) throws DException {
486 if (tableName.equalsIgnoreCase("CHARACTER_SETS")) {
487
488 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
489 , new String [] {"NUMBER_OF_CHARACTERS >= 0"}
490 }
491 };
492 } else if (tableName.equalsIgnoreCase("COLUMNS")) {
493 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
494 , new String [] {"ORDINAL_POSITION >= 0"}
495 }
496 };
497 } else if (tableName.equalsIgnoreCase("DATA_TYPE_DESCRIPTOR")) {
498 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
499 , new String [] {"CHARACTER_MAXIMUM_LENGTH >= 0"}
500 }
501 ,
502 new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
503 , new String [] {"CHARACTER_OCTET_LENGTH >= 0"}
504 }
505 ,
506 new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
507 , new String [] {"NUMERIC_PRECISION >= 0"}
508 }
509 ,
510 new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
511 , new String [] {"NUMERIC_PRECISION_RADIX >= 0"}
512 }
513 ,
514 new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
515 , new String [] {"NUMERIC_SCALE >= 0"}
516 }
517 ,
518 new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
519 , new String [] {"DATETIME_PRECISION >= 0"}
520 }
521 ,
522 new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
523 , new String [] {"INTERVAL_PRECISION >= 0"}
524 }
525 ,
526 new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
527 , new String [] {"MAXIMUM_CARDINALITY >= 0"}
528 }
529 };
530 } else if (tableName.equalsIgnoreCase("KEY_COLUMN_USAGE")) {
531 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
532 , new String [] {"ORDINAL_POSITION >= 0"}
533 }
534 };
535 } else if (tableName.equalsIgnoreCase("TRIGGERS")) {
536 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
537 , new String [] {"ACTION_ORDER >= 0"}
538 }
539 };
540 } else if (tableName.equalsIgnoreCase("ROUTINES")) {
541 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
542 , new String [] {"MAX_DYNAMIC_RESULT_SETS >= 0"}
543 }
544 };
545 } else if (tableName.equalsIgnoreCase("PARAMETERS")) {
546 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
547 , new String [] {"ORDINAL_POSITION >= 0"}
548 }
549 };
550 } else if (tableName.equalsIgnoreCase("INDEXINFO")) {
551 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
552 , new String [] {"NumberOfRecords >= 0"}
553 ,
554 new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
555 , new String [] {"RootClusterSize >= 0"}
556 }
557 ,
558 new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
559 , new String [] {"RootRecordNumber >= 0"}
560 }
561 }
562 };
563 } else if (tableName.equalsIgnoreCase("INDEXCOLUMNS")) {
564 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
565 , new String [] {"ORDINAL_POSITION >= 0"}
566 }
567 };
568 } else if (tableName.equalsIgnoreCase("FULLTEXTCOLUMNINFO")) {
569 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
570 , new String [] {"ORDINAL_POSITION >= 0"}
571 }
572 };
573 } else if (tableName.equalsIgnoreCase("Method_Specifications_Paramters")) {
574 return new Object [] {new Object [] {new String [] {"CARDINAL_NUMBER_DOMAIN_CHECK"}
575 , new String [] {"ORDINAL_POSITION >= 0"}
576 }
577 };
578 }
579 return null;
580 }
581
582 private static Object [] getCheckConstraintInformation(String tableName) throws DException {
583 if (tableName.equalsIgnoreCase("USERS")) {
584
585 return new Object [] {new String [] {"USERS_CHECK"}
586 , new String [] {"USER_NAME NOT IN (SELECT ROLE_NAME FROM system.Definition_Schema.Roles)"}
587 , new int[] {5}
588 };
589 } else if (tableName.equalsIgnoreCase("ROLES")) {
590
591 return new Object [] {new String [] {"ROLES_CHECK"}
592 , new String [] {"ROLE_NAME NOT IN(SELECT USER_NAME FROM system.Definition_Schema.Users)"}
593 , new int[] {0}
594 };
595 } else if (tableName.equalsIgnoreCase("ROLE_AUTHORIZATION_DESCRIPTORS")) {
596
597
598
599
600
601
602
603 return new Object [] {new String [] {"ROLE_AUTHORIZATION_DESCRIPTORS_GRANTEE_CHECK", "ROLE_AUTHORIZATION_DESCRIPTORS_GRANTOR_CHECK", "ROLE_AUTHORIZATION_DESCRIPTORS_IS_GRANTABLE_CHECK"}
604 , new String [] {"GRANTEE IN (SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTEE IN (SELECT USER_NAME FROM system.Definition_Schema.Users) ", "GRANTOR IN (SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTOR IN ('_SYSTEM') OR GRANTOR IN (SELECT USER_NAME FROM system.Definition_Schema.Users)", "IS_GRANTABLE IN ('YES', 'NO')"}
605 , new int[] {1, 2, 3}
606 };
607 } else if (tableName.equalsIgnoreCase("SCHEMATA")) {
608
609
610
611
612
613
614
615
616
617
618
619 return new Object [] {new String [] {"SCHEMA_OWNER_NOT_NULL", "DEFAULT_CHARACTER_SET_CATALOG_NOT_NULL", "DEFAULT_CHARACTER_SET_SCHEMA_NOT_NULL", "DEFAULT_CHARACTER_SET_NAME_NOT_NULL"}
620 , new String [] {"\"SCHEMA_OWNER\" is not null", "\"DEFAULT_CHARACTER_SET_CATALOG\" is not null", "\"DEFAULT_CHARACTER_SET_SCHEMA\" is not null", "\"DEFAULT_CHARACTER_SET_NAME\" is not null"}
621 , new int[] {2, 3, 4, 5}
622 };
623 } else if (tableName.equalsIgnoreCase("CHARACTER_SETS")) {
624
625
626
627
628
629
630
631
632
633
634 return new Object [] {new String [] {"CHARACTER_SETS_DEFAULT_COLLATE_CATALOG_NOT_NULL", "CHARACTER_SETS_DEFAULT_COLLATE_SCHEMA_NOT_NULL", "CHARACTER_SETS_DEFAULT_COLLATE_NAME_NOT_NULL", "CHARACTER_SETS_CHECK_REFERENCES_COLLATIONS"}
635 , new String [] {"\"DEFAULT_COLLATE_CATALOG\" is not null", "\"DEFAULT_COLLATE_SCHEMA\" is not null", "\"DEFAULT_COLLATE_NAME\" is not null", "DEFAULT_COLLATE_CATALOG NOT IN ( SELECT CATALOG_NAME FROM system . Definition_Schema . Schemata ) OR ( DEFAULT_COLLATE_CATALOG , DEFAULT_COLLATE_SCHEMA , DEFAULT_COLLATE_NAME ) IN ( SELECT COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME FROM system . Definition_Schema . Collations )"}
636 , new int[] {5, 6, 7}
637 };
638 } else if (tableName.equalsIgnoreCase("COLLATIONS")) {
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653 return new Object [] {new String [] {"COLLATIONS_CHARACTER_SET_CATALOG_NOT_NULL", "COLLATIONS_CHARACTER_SET_SCHEMA_NOT_NULL", "COLLATIONS_CHARACTER_SET_NAME_NOT_NULL", "COLLATIONS_PAD_ATTRIBUTE_CHECK", "COLLATIONS_CHECK_REFERENCES_CHARACTER_SETS"}
654 , new String [] {"\"CHARACTER_SET_CATALOG\" is not null", "\"CHARACTER_SET_SCHEMA\" is not null", "\"CHARACTER_SET_NAME\" is not null", "PAD_ATTRIBUTE IN ( 'NO PAD', 'PAD SPACE' )", "CHARACTER_SET_CATALOG NOT IN ( SELECT CATALOG_NAME FROM system . Definition_Schema . Schemata ) OR ( CHARACTER_SET_CATALOG , CHARACTER_SET_SCHEMA , CHARACTER_SET_NAME ) IN ( SELECT CHARACTER_SET_CATALOG , CHARACTER_SET_SCHEMA , CHARACTER_SET_NAME FROM system . Definition_Schema . Character_Sets )"}
655 , new int[] {3, 4, 5, 6}
656 };
657 } else if (tableName.equalsIgnoreCase("DOMAINS")) {
658
659
660 return new Object [] {new String [] {"DOMAIN_CHECK_DATA_TYPE"}
661 , new String [] {"DOMAIN_CATALOG NOT IN (SELECT CATALOG_NAME FROM system . Definition_Schema . Schemata ) OR ( DOMAIN_CATALOG , DOMAIN_SCHEMA , DOMAIN_NAME , 'DOMAIN', DTD_IDENTIFIER ) IN ( SELECT OBJECT_CATALOG , OBJECT_SCHEMA , OBJECT_NAME, OBJECT_TYPE, DTD_IDENTIFIER FROM system.Definition_Schema.Data_Type_Descriptor)"}
662 , new int[] {0}
663 };
664
665
666
667
668
669 } else if (tableName.equalsIgnoreCase("COLUMNS")) {
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703 return new Object [] {new String [] {"COLUMNS_ORDINAL_POSITION_NOT_NULL", "COLUMNS_ORDINAL_POSITION_GREATER_THAN_ZERO_CHECK", "COLUMNS_IS_NULLABLE_NOT_NULL", "COLUMNS_IS_NULLABLE_CHECK", "COLUMNS_IS_SELF_REFERENCING_NOT_NULL", "COLUMNS_IS_SELF_REFERENCING_CHECK", "COLUMNS_IS_AUTOINCREMENT_NOT_NULL", "COLUMNS_IS_AUTOINCREMENT_CHECK", "COLUMNS_CHECK_REFERENCES_DOMAIN" }
704 , new String [] {"\"ORDINAL_POSITION\" is not null", "ORDINAL_POSITION > 0" , "\"IS_NULLABLE\" is not null", "IS_NULLABLE IN ( 'YES', 'NO' )", "\"IS_SELF_REFERENCING\" is not null", "IS_SELF_REFERENCING IN ( 'YES', 'NO' )", "\"IS_AUTOINCREMENT\" is not null", "IS_AUTOINCREMENT IN ( 'YES', 'NO' )", "DOMAIN_CATALOG NOT IN (SELECT CATALOG_NAME FROM system.Definition_Schema.Schemata) OR (DOMAIN_CATALOG , DOMAIN_SCHEMA , DOMAIN_NAME) IN (SELECT DOMAIN_CATALOG, DOMAIN_SCHEMA, DOMAIN_NAME FROM system.Definition_Schema.Domains)"
706 }
707 , new int[] {4, 0, 2, 10, 11, 12, }
708 };
709 } else if (tableName.equalsIgnoreCase("DATA_TYPE_DESCRIPTOR")) {
710
711
712
713
714
715
716
717
718
719
720
721 return new Object [] {new String [] {"DATA_TYPE_DESCRIPTOR_OBJECT_DATA_TYPE_NOT_NULL", "DATA_TYPE_DESCRIPTOR_CHECK_OBJECT_TYPE", "DATA_TYPE_DESCRIPTOR_DATA_TYPE_CHECK_COMBINATIONS", "DATA_TYPE_DESCRIPTOR_CHECK_REFERENCES_UDT", "DATA_TYPE_DESCRIPTOR_CHECK_REFERENCES_COLLATION"}
722 , new String [] {"\"DATA_TYPE\" is not null", "OBJECT_TYPE IN ( 'TABLE', 'DOMAIN', 'USER-DEFINED TYPE', 'ROUTINE' )", "( DATA_TYPE IN ( 'CHAR', 'VARCHAR', 'CHARACTER', 'CHAR VARYING', 'CHARACTER VARYING', 'CHARACTER LARGE OBJECT', 'CHAR LARGE OBJECT', 'CLOB', 'LONG VARCHAR', 'TABLEKEY' ) AND ( CHARACTER_MAXIMUM_LENGTH , CHARACTER_OCTET_LENGTH ) IS NOT NULL AND ( NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION , USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NULL AND ( INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE IN ( 'BIT', 'BIT VARYING', 'BINARY', 'VARBINARY' ) AND ( CHARACTER_MAXIMUM_LENGTH , CHARACTER_OCTET_LENGTH ) IS NOT NULL AND ( COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME ) IS NULL AND ( NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION , USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NULL AND ( INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE IN ( 'BINARY LARGE OBJECT', 'BLOB', 'LONG VARBINARY' ) AND ( CHARACTER_MAXIMUM_LENGTH , CHARACTER_OCTET_LENGTH ) IS NOT NULL AND ( COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME , NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION , USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NULL AND ( INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE IN ( 'INTEGER', 'SMALLINT', 'BYTE', 'INT', 'TINYINT', 'LONG', 'BIGINT' ) AND ( CHARACTER_MAXIMUM_LENGTH , CHARACTER_OCTET_LENGTH , COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME ) IS NULL AND NUMERIC_PRECISION_RADIX IN ( 2, 10 ) AND NUMERIC_PRECISION IS NOT NULL AND NUMERIC_SCALE = 0 AND DATETIME_PRECISION IS NULL AND ( INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE IN ( 'NUMERIC', 'DECIMAL', 'DEC' ) AND ( CHARACTER_MAXIMUM_LENGTH , CHARACTER_OCTET_LENGTH , COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME ) IS NULL AND NUMERIC_PRECISION_RADIX = 10 AND ( NUMERIC_PRECISION , NUMERIC_SCALE ) IS NOT NULL AND DATETIME_PRECISION IS NULL AND ( INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE IN ( 'REAL', 'DOUBLE PRECISION', 'FLOAT' ) AND ( CHARACTER_MAXIMUM_LENGTH , CHARACTER_OCTET_LENGTH , COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME ) IS NULL AND NUMERIC_PRECISION IS NOT NULL AND NUMERIC_PRECISION_RADIX = 2 AND NUMERIC_SCALE IS NULL AND DATETIME_PRECISION IS NULL AND ( USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NULL AND ( INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE IN ( 'DATE', 'TIME', 'TIMESTAMP', 'TIME WITH TIME ZONE', 'TIMESTAMP WITH TIME ZONE' ) AND ( CHARACTER_MAXIMUM_LENGTH , CHARACTER_OCTET_LENGTH , COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME ) IS NULL AND ( NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX ) IS NULL AND NUMERIC_SCALE IS NULL AND DATETIME_PRECISION IS NOT NULL AND ( USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NULL AND ( INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE = 'INTERVAL' AND ( CHARACTER_MAXIMUM_LENGTH , CHARACTER_OCTET_LENGTH , COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME ) IS NULL AND ( NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX ) IS NOT NULL AND NUMERIC_SCALE IS NULL AND DATETIME_PRECISION IS NOT NULL AND ( USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NULL AND INTERVAL_TYPE IN ( 'YEAR', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'SECOND', 'YEAR TO MONTH', 'DAY TO HOUR', 'DAY TO MINUTE', 'DAY TO SECOND', 'HOUR TO MINUTE', 'HOUR TO SECOND', 'MINUTE TO SECOND' ) AND INTERVAL_PRECISION IS NOT NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE = 'BOOLEAN' AND ( CHARACTER_MAXIMUM_LENGTH , CHARACTER_OCTET_LENGTH , COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME ) IS NULL AND ( NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX ) IS NULL AND NUMERIC_SCALE IS NULL AND DATETIME_PRECISION IS NULL AND ( INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE = 'USER-DEFINED' AND ( NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION , CHARACTER_OCTET_LENGTH , CHARACTER_MAXIMUM_LENGTH , INTERVAL_TYPE , INTERVAL_PRECISION , SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND ( USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NOT NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE = 'REF' AND ( NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION , CHARACTER_OCTET_LENGTH , CHARACTER_MAXIMUM_LENGTH , INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NOT NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE = 'ARRAY' AND ( NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION , CHARACTER_OCTET_LENGTH , CHARACTER_MAXIMUM_LENGTH , INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NOT NULL ) OR ( DATA_TYPE = 'ROW' AND ( NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION , CHARACTER_OCTET_LENGTH , CHARACTER_MAXIMUM_LENGTH , INTERVAL_TYPE , INTERVAL_PRECISION ) IS NULL AND ( USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IS NULL AND ( SCOPE_CATALOG , SCOPE_SCHEMA , SCOPE_NAME ) IS NULL AND MAXIMUM_CARDINALITY IS NULL ) OR ( DATA_TYPE NOT IN ( 'CHAR', 'CHARACTER', 'VARCHAR', 'CHARACTER VARYING', 'CHARACTER LARGE OBJECT', 'CHAR LARGE OBJECT', 'CLOB', 'LONG VARCHAR', 'BINARY LARGE OBJECT', 'BLOB', 'LONG VARBINARY', 'BIT', 'BIT VARYING', 'BINARY', 'VARBINARY', 'INT', 'INTEGER', 'SMALLINT', 'TINYINT', 'BYTE', 'LONG', 'BIGINT', 'NUMERIC', 'DECIMAL', 'DEC', 'REAL', 'DOUBLE PRECISION', 'FLOAT', 'DATE', 'TIME', 'TIMESTAMP', 'INTERVAL', 'BOOLEAN', 'USER-DEFINED', 'REF', 'ARRAY', 'ROW' ) )"
723 , "USER_DEFINED_TYPE_CATALOG <> ANY ( SELECT CATALOG_NAME FROM system . Definition_Schema . Schemata ) OR ( USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME ) IN ( SELECT USER_DEFINED_TYPE_CATALOG , USER_DEFINED_TYPE_SCHEMA , USER_DEFINED_TYPE_NAME FROM system . Definition_Schema . User_Defined_Types )", "COLLATION_CATALOG <> ANY ( SELECT CATALOG_NAME FROM system . Definition_Schema . Schemata ) OR ( COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME ) IN ( SELECT COLLATION_CATALOG , COLLATION_SCHEMA , COLLATION_NAME FROM system . Definition_Schema . Collations )"}
724 , new int[] {5, 3, 6, 7, 11, 12, 13, 14, 17, 18, 19, 15, 16, 20, 21, 22, 23, 8, 9, 10}
725 };
726 } else if (tableName.equalsIgnoreCase("TABLE_CONSTRAINTS")) {
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756 return new Object [] {new String [] {"CONSTRAINT_TYPE_NOT_NULL", "CONSTRAINT_TYPE_CHECK", "TABLE_CONSTRAINTS_TABLE_CATALOG_NOT_NULL", "TABLE_CONSTRAINTS_TABLE_SCHEMA_NOT_NULL", "TABLE_CONSTRAINTS_TABLE_NAME_NOT_NULL", "TABLE_CONSTRAINTS_IS_DEFERRABLE_NOT_NULL", "TABLE_CONSTRAINTS_INITIALLY_DEFERRED_NOT_NULL", "TABLE_CONSTRAINTS_DEFERRED_CHECK", "TABLE_CONSTRAINTS_CHECK_VIEWS"}
757 ,
758 new String [] {"\"CONSTRAINT_TYPE\"is not null", "CONSTRAINT_TYPE IN('UNIQUE','PRIMARY KEY','FOREIGN KEY','CHECK' )", "\"TABLE_CATALOG\"is not null", "\"TABLE_SCHEMA\"is not null", "\"TABLE_NAME\"is not null", "\"IS_DEFERRABLE\"is not null", "\"INITIALLY_DEFERRED\"is not null", "(IS_DEFERRABLE, INITIALLY_DEFERRED) IN( ('NO','NO' ), ('YES','NO' ), ('YES','YES' ))", "TABLE_CATALOG NOT IN(SELECT CATALOG_NAME FROM system.Definition_Schema.Schemata) OR( (TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME) IN(SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME FROM system.Definition_Schema.Tables WHERE TABLE_TYPE <> 'VIEW' ))"}
759 , new int[] {3, 4, 5, 6, 7, 8}
760 };
761 } else if (tableName.equalsIgnoreCase("KEY_COLUMN_USAGE")) {
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783 return new Object [] {new String [] {"KEY_COLUMN_TABLE_CATALOG_NOT_NULL", "KEY_COLUMN_TABLE_SCHEMA_NOT_NULL", "KEY_COLUMN_TABLE_NAME_NOT_NULL", "KEY_COLUMN_ORDINAL_POSITION_NOT_NULL", "KEY_COLUMN_USAGE_ORDINAL_POSITION_GREATER_THAN_ZERO_CHECK", "KEY_COLUMN_USAGE_ORDINAL_POSITION_CONTIGUOUS_CHECK", "KEY_COLUMN_CONSTRAINT_TYPE_CHECK"}
784 ,
785 new String [] {"\"TABLE_CATALOG\"is not null", "\"TABLE_SCHEMA\"is not null", "\"TABLE_NAME\"is not null", "\"ORDINAL_POSITION\"is not null", "ORDINAL_POSITION > 0", "0 = ALL(SELECT MAX(ORDINAL_POSITION) - COUNT( * ) FROM system.Definition_Schema.Key_Column_Usage GROUP BY CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME)", "(CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME) IN(SELECT CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME FROM system.Definition_Schema.Table_Constraints WHERE CONSTRAINT_TYPE IN('UNIQUE','PRIMARY KEY','FOREIGN KEY' ))"}
786 , new int[] {3, 4, 5, 7, 0, 1, 2}
787 };
788 } else if (tableName.equalsIgnoreCase("REFERENTIAL_CONSTRAINTS")) {
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820 return new Object [] {new String [] {"UNIQUE_CONSTRAINT_CATALOG_NOT_NULL", "UNIQUE_CONSTRAINT_SCHEMA_NOT_NULL", "UNIQUE_CONSTRAINT_NAME_NOT_NULL", "REFERENTIAL_MATCH_OPTION_NOT_NULL", "REFERENTIAL_MATCH_OPTION_CHECK", "REFERENTIAL_UPDATE_RULE_NOT_NULL", "REFERENTIAL_UPDATE_RULE_CHECK", "REFERENTIAL_DELETE_RULE_NOT_NULL", "REFERENTIAL_DELETE_RULE_CHECK", "REFERENTIAL_CONSTRAINTS_CONSTRAINT_TYPE_CHECK", "UNIQUE_CONSTRAINT_CHECK_REFERENCES_UNIQUE_CONSTRAINT"}
821 ,
822 new String [] {"\"UNIQUE_CONSTRAINT_CATALOG\"is not null", "\"UNIQUE_CONSTRAINT_SCHEMA\"is not null", "\"UNIQUE_CONSTRAINT_NAME\"is not null", "\"MATCH_OPTION\"is not null", "MATCH_OPTION IN('SIMPLE','PARTIAL','FULL' )", "\"UPDATE_RULE\"is not null", "UPDATE_RULE IN('CASCADE','SET NULL','SET DEFAULT','RESTRICT','NO ACTION' )", "\"DELETE_RULE\"is not null", "DELETE_RULE IN('CASCADE','SET NULL','SET DEFAULT','RESTRICT','NO ACTION' )", "(CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME) IN(SELECT CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME FROM system.Definition_Schema.Table_Constraints WHERE CONSTRAINT_TYPE = 'FOREIGN KEY' )", "UNIQUE_CONSTRAINT_CATALOG NOT IN(SELECT CATALOG_NAME FROM system.Definition_Schema.Schemata) OR( (UNIQUE_CONSTRAINT_CATALOG, UNIQUE_CONSTRAINT_SCHEMA, UNIQUE_CONSTRAINT_NAME) IN(SELECT CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME FROM system.Definition_Schema.Table_Constraints WHERE CONSTRAINT_TYPE IN('UNIQUE','PRIMARY KEY' )))"}
823 , new int[] {3, 4, 5, 6, 7, 8, 0, 1, 2}
824 };
825 } else if (tableName.equalsIgnoreCase("CHECK_COLUMN_USAGE")) {
826
827 return new Object [] {new String [] {"CHECK_COLUMN_USAGE_CHECK_REFERENCES_COLUMNS"}
828 , new String [] {"TABLE_CATALOG NOT IN(SELECT CATALOG_NAME FROM system.Definition_Schema.Schemata) OR(TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME) IN(SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM system.Definition_Schema.Columns)"}
829 , new int[] {3, 4, 5, 6}
830 };
831 } else if (tableName.equalsIgnoreCase("CHECK_TABLE_USAGE")) {
832
833 return new Object [] {new String [] {"CHECK_TABLE_USAGE_CHECK_REFERENCES_TABLES"}
834 , new String [] {"TABLE_CATALOG NOT IN(SELECT CATALOG_NAME FROM system.Definition_Schema.Schemata) OR(TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME) IN(SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME FROM system.Definition_Schema.Tables)"}
835 , new int[] {3, 4, 5}
836 };
837 } else if (tableName.equalsIgnoreCase("TRIGGERS")) {
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863 return new Object [] {new String [] {"TRIGGERS_EVENT_MANIPULATION_CHECK", "TRIGGERS_EVENT_OBJECT_CATALOG_NOT_NULL", "TRIGGERS_EVENT_OBJECT_SCHEMA_NOT_NULL", "TRIGGERS_EVENT_OBJECT_TABLE_NOT_NULL", "TRIGGERS_ACTION_ORDER_NOT_NULL", "TRIGGERS_ACTION_STATEMENT_NOT_NULL", "TRIGGERS_ACTION_ORIENTATION_CHECK", "TRIGGERS_CONDITION_TIMING_CHECK", "TRIGGERS_REFERENCES_TABLES"}
864 ,
865 new String [] {"EVENT_MANIPULATION IN('INSERT','DELETE','UPDATE' )", "\"EVENT_OBJECT_CATALOG\"is not null", "\"EVENT_OBJECT_SCHEMA\"is not null", "\"EVENT_OBJECT_TABLE\"is not null", "\"ACTION_ORDER\"is not null", "\"ACTION_STATEMENT\"is not null", "ACTION_ORIENTATION IN('ROW','STATEMENT' )", "CONDITION_TIMING IN('BEFORE','AFTER' )", "EVENT_OBJECT_CATALOG <> ANY(SELECT CATALOG_NAME FROM system.Definition_Schema.Schemata) OR(EVENT_OBJECT_CATALOG, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE) IN(SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME FROM system.Definition_Schema.Tables)"}
866 , new int[] {3, 4, 5, 6, 7, 9, 10, 11}
867 };
868 } else if (tableName.equalsIgnoreCase("TRIGGER_TABLE_USAGE")) {
869
870 return new Object [] {new String [] {"TRIGGER_TABLE_USAGE_CHECK_REFERENCES_TABLES"}
871 , new String [] {"TABLE_CATALOG NOT IN(SELECT CATALOG_NAME FROM system.Definition_Schema.Schemata) OR(TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME) IN(SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME FROM system.Definition_Schema.Tables)"}
872 , new int[] {3, 4, 5}
873 };
874 } else if (tableName.equalsIgnoreCase("TRIGGER_COLUMN_USAGE")) {
875
876 return new Object [] {new String [] {"TRIGGER_COLUMN_USAGE_EVENT_NOT_UPDATE_CHECK"}
877 , new String [] {"(TRIGGER_CATALOG, TRIGGER_SCHEMA, TRIGGER_NAME) IN(SELECT TRIGGER_CATALOG, TRIGGER_SCHEMA, TRIGGER_NAME FROM system.Definition_Schema.Triggers WHERE EVENT_MANIPULATION <> 'UPDATE' )"}
878 , new int[] {0, 1, 2}
879 };
880 } else if (tableName.equalsIgnoreCase("TRIGGERED_UPDATE_COLUMNS")) {
881
882
883
884
885
886
887
888
889
890
891
892 return new Object [] {new String [] {"EVENT_OBJECT_CATALOG_NOT_NULL", "EVENT_OBJECT_SCHEMA_NOT_NULL", "EVENT_OBJECT_TABLE_NOT_NULL", "TRIGGERED_UPDATE_COLUMNS_EVENT_MANIPULATION_CHECK"}
893 ,
894 new String [] {"\"EVENT_OBJECT_CATALOG\"is not null", "\"EVENT_OBJECT_SCHEMA\"is not null", "\"EVENT_OBJECT_TABLE\"is not null", "(TRIGGER_CATALOG, TRIGGER_SCHEMA, TRIGGER_NAME) IN(SELECT TRIGGER_CATALOG, TRIGGER_SCHEMA, TRIGGER_NAME FROM system.Definition_Schema.Triggers WHERE EVENT_MANIPULATION = 'UPDATE' )"}
895 , new int[] {3, 4, 5, 0, 1, 2}
896 };
897 } else if (tableName.equalsIgnoreCase("VIEWS")) {
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922 return new Object [] {new String [] {"CHECK_OPTION_NOT_NULL", "CHECK_OPTION_CHECK", "IS_UPDATABLE_NOT_NULL", "IS_UPDATABLE_CHECK", "IS_INSERTABLE_INTO_NOT_NULL", "IS_INSERTABLE_INTO_CHECK", "VIEWS_IN_TABLES_CHECK", "VIEWS_IS_UPDATABLE_CHECK_OPTION_CHECK"}
923 ,
924 new String [] {"\"CHECK_OPTION\"is not null", "CHECK_OPTION IN('CASCADED','LOCAL','NONE' )", "\"IS_UPDATABLE\"is not null", "IS_UPDATABLE IN('YES','NO' )", "\"IS_INSERTABLE_INTO\"is not null", "IS_INSERTABLE_INTO IN('YES','NO' )", "(TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME) IN(SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME FROM system.Definition_Schema.Tables WHERE TABLE_TYPE = 'VIEW' )", "(IS_UPDATABLE, CHECK_OPTION) NOT IN( ('NO','CASCADED' ), ('NO','LOCAL' ))"}
925 , new int[] {4, 5, 6, 0, 1, 2}
926 };
927 } else if (tableName.equalsIgnoreCase("VIEW_COLUMN_USAGE")) {
928
929
930 return new Object [] {new String [] {"VIEW_COLUMN_USAGE_CHECK_REFERENCES_COLUMNS"}
931 , new String [] {"TABLE_CATALOG NOT IN(SELECT CATALOG_NAME FROM system.Definition_Schema.Schemata) OR(TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME) IN(SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM system.Definition_Schema.Columns)"}
932 , new int[] {3, 4, 5, 6}
933 };
934 } else if (tableName.equalsIgnoreCase("VIEW_TABLE_USAGE")) {
935
936 return new Object [] {new String [] {"VIEW_TABLE_USAGE_CHECK_REFERENCES_TABLES"}
937 , new String [] {"TABLE_CATALOG NOT IN(SELECT CATALOG_NAME FROM system.Definition_Schema.Schemata) OR(TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME) IN(SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME FROM system.Definition_Schema.Tables)"}
938 , new int[] {3, 4, 5}
939 };
940 } else if (tableName.equalsIgnoreCase("DOMAIN_CONSTRAINTS")) {
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957 return new Object [] {new String [] {"DOMAIN_CATALOG_NOT_NULL", "DOMAIN_SCHEMA_NOT_NULL", "DOMAIN_NAME_NOT_NULL", "DOMAIN_CONSTRAINTS_DEFERRABLE_NOT_NULL", "DOMAIN_CONSTRAINTS_INITIALLY_DEFERRED_NOT_NULL", "DOMAIN_CONSTRAINTS_CHECK_DEFERRABLE"}
958 ,
959 new String [] {"\"DOMAIN_CATALOG\"is not null", "\"DOMAIN_SCHEMA\"is not null", "\"DOMAIN_NAME\"is not null", "\"IS_DEFERRABLE\"is not null", "\"INITIALLY_DEFERRED\"is not null", "(IS_DEFERRABLE, INITIALLY_DEFERRED) IN( ('NO','NO' ), ('YES','NO' ), ('YES','YES' ))"}
960 , new int[] {3, 4, 5, 6, 7}
961 };
962 } else if (tableName.equalsIgnoreCase("COLUMN_PRIVILEGES")) {
963
964
965
966
967
968
969
970
971
972
973
974
975
976 return new Object [] {new String [] {"COLUMN_PRIVILEGE_TYPE_CHECK", "COLUMN_PRIVILEGE_IS_GRANTABLE_NOT_NULL", "COLUMN_PRIVILEGE_IS_GRANTABALE_CHECK", "COLUMN_PRIVILEGE_GRANTOR_CHECK", "COLUMN_PRIVILEGE_GRANTEE_CHECK"}
977 ,
978 new String [] {"PRIVILEGE_TYPE IN('SELECT','INSERT','UPDATE','REFERENCES' )", "\"IS_GRANTABLE\"is not null", "IS_GRANTABLE IN('YES','NO' )", "GRANTOR IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTOR IN('_SYSTEM' ) OR GRANTOR IN(SELECT USER_NAME FROM system.Definition_Schema.Users)", "GRANTEE IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTEE IN(SELECT USER_NAME FROM system.Definition_Schema.Users) OR GRANTEE IN('PUBLIC' )"}
979 , new int[] {6, 7, 0, 1}
980 };
981 } else if (tableName.equalsIgnoreCase("TABLE_PRIVILEGES")) {
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001 return new Object [] {new String [] {"TABLE_PRIVILEGE_TYPE_CHECK", "TABLE_PRIVILEGE_GRANTABLE_NOT_NULL", "TABLE_PRIVILEGE_GRANTABLE_CHECK", "TABLE_PRIVILEGE_WITH_HIERARCHY_NOT_NULL", "TABLE_PRIVILEGE_WITH_HIERARCHY_CHECK", "TABLE_PRIVILEGE_GRANTOR_CHECK", "TABLE_PRIVILEGE_GRANTEE_CHECK"}
1002 ,
1003 new String [] {"PRIVILEGE_TYPE IN('SELECT','INSERT','DELETE','UPDATE','TRIGGER','REFERENCES' )", "\"IS_GRANTABLE\"is not null", "IS_GRANTABLE IN('YES','NO' )", "\"WITH_HIERARCHY\"is not null", "WITH_HIERARCHY IN('YES','NO' )", "GRANTOR IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTOR IN('_SYSTEM' ) OR GRANTOR IN(SELECT USER_NAME FROM system.Definition_Schema.Users)", "GRANTEE IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTEE IN(SELECT USER_NAME FROM system.Definition_Schema.Users) OR GRANTEE IN('PUBLIC' )"}
1004 , new int[] {5, 6, 7, 0, 1}
1005 };
1006 } else if (tableName.equalsIgnoreCase("USAGE_PRIVILEGES")) {
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020 return new Object [] {new String [] {"USAGE_PRIVILEGES_OBJECT_TYPE_CHECK", "USAGE_PRIVILEGES_IS_GRANTABLE_NOT_NULL", "USAGE_PRIVILEGES_IS_GRANTABLE_CHECK", "USAGE_PRIVILEGE_GRANTOR_CHECK", "USAGE_PRIVILEGE_GRANTEE_CHECK"}
1021 ,
1022 new String [] {"OBJECT_TYPE IN('DOMAIN','CHARACTER SET','COLLATION','TRANSLATION' )", "\"IS_GRANTABLE\"is not null", "IS_GRANTABLE IN('YES','NO' )", "GRANTOR IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTOR IN('_SYSTEM' ) OR GRANTOR IN(SELECT USER_NAME FROM system.Definition_Schema.Users)", "GRANTEE IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTEE IN(SELECT USER_NAME FROM system.Definition_Schema.Users)"}
1023 , new int[] {5, 6, 0, 1}
1024 };
1025 } else if (tableName.equalsIgnoreCase("ROUTINES")) {
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079 return new Object [] {new String [] {"ROUTINE_TYPE_NOT_NULL", "ROUTINE_TYPE_CHECK", "ROUTINE_BODY_NOT_NULL", "ROUTINE_BODY_CHECK", "EXTERNAL_LANGUAGE_CHECK", "PARAMETER_STYLE_CHECK", "IS_DETERMINISTIC_CHECK", "ROUTINES_SQL_DATA_ACCESS_NOT_NULL", "ROUTINES_SQL_DATA_ACCESS_CHECK", "ROUTINES_IS_USER_DEFINED_CAST_NOT_NULL", "ROUTINES_IS_USER_DEFINED_CAST_CHECK", "ROUTINES_IS_IMPLICITLY_INVOCABLE_CHECK", "ROUTINES_SECURITY_TYPE_CHECK", "ROUTINES_AS_LOCATOR_CHECK", "ROUTINES_IS_NULL_CALL_CHECK", "ROUTINES_COMBINATIONS", "ROUTINES_SAME_SCHEMA", "ROUTINES_CHECK_RESULT_TYPE"}
1080 ,
1081 new String [] {"\"ROUTINE_TYPE\"is not null", "ROUTINE_TYPE IN('PROCEDURE','FUNCTION','INSTANCE METHOD','STATIC METHOD' )", "\"ROUTINE_BODY\"is not null", "ROUTINE_BODY IN('SQL','EXTERNAL' )", "EXTERNAL_LANGUAGE IN('JAVA', 'ADA', 'C', 'COBOL','FORTRAN','MUMPS','PASCAL','PLI' ) OR EXTERNAL_LANGUAGE IS NULL", "PARAMETER_STYLE IN('SQL','GENERAL' ) OR PARAMETER_STYLE IS NULL", "IS_DETERMINISTIC IN('YES','NO' )", "\"SQL_DATA_ACCESS\"is not null", "SQL_DATA_ACCESS IN('NONE','CONTAINS','READS','MODIFIES' )", "\"IS_USER_DEFINED_CAST\"is not null", "IS_USER_DEFINED_CAST IN('YES','NO' )", "IS_IMPLICITLY_INVOCABLE IN('YES','NO' ) OR IS_IMPLICITLY_INVOCABLE IS NULL", "SECURITY_TYPE IN('DEFINER','INVOKER','IMPLEMENTATION DEFINED' )", "AS_LOCATOR IN('YES','NO' )", "IS_NULL_CALL IN('YES','NO' ) OR IS_NULL_CALL IS NULL", "(ROUTINE_BODY = 'SQL' AND(EXTERNAL_NAME, EXTERNAL_LANGUAGE, PARAMETER_STYLE) IS NULL) OR(ROUTINE_BODY = 'EXTERNAL' AND(EXTERNAL_NAME, EXTERNAL_LANGUAGE, PARAMETER_STYLE) IS NOT NULL)",
1082 "(SPECIFIC_CATALOG, SPECIFIC_SCHEMA) = (ROUTINE_CATALOG, ROUTINE_SCHEMA) OR(SPECIFIC_CATALOG, SPECIFIC_SCHEMA) = (MODULE_CATALOG, MODULE_SCHEMA) OR(SPECIFIC_CATALOG, SPECIFIC_SCHEMA) = (USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA)"
1083 , "(ROUTINE_TYPE = 'PROCEDURE' AND DTD_IDENTIFIER IS NULL) OR(ROUTINE_TYPE <> 'PROCEDURE' AND(SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, 'ROUTINE',DTD_IDENTIFIER) IN(SELECT OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, DTD_IDENTIFIER FROM system.Definition_Schema.Data_Type_Descriptor))"}
1084 , new int[] {12, 14, 17, 18, 19, 20, 25, 26, 27, 31, 21, 16, 0, 1, 3, 4, 6, 7, 9, 10, 13, 2}
1085 };
1086 } else if (tableName.equalsIgnoreCase("PARAMETERS")) {
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109 return new Object [] {new String [] {"PARAMETERS_POSITION_NOT_NULL", "PARAMETERS_ORDINAL_POSITION_GREATER_THAN_ZERO_CHECK", "PARAMETERS_ORDINAL_POSITION_CONTIGUOUS_CHECK", "PARAMETER_MODE_NOT_NULL", "PARAMETER_MODE_CHECK", "PARAMETERS_IS_RESULT_CHECK", "PARAMETERS_AS_LOCATOR_CHECK", "PARAMETERS_CHECK_DATA_TYPE"}
1110 ,
1111 new String [] {"\"ORDINAL_POSITION\"is not null", "ORDINAL_POSITION > 0", "0 = ALL(SELECT MAX(ORDINAL_POSITION) - COUNT( * ) FROM system.Definition_Schema.Parameters GROUP BY SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME)", "\"PARAMETER_MODE\"is not null", "PARAMETER_MODE IN('IN','OUT','INOUT' )", "IS_RESULT IN('YES','NO' )", "AS_LOCATOR IN('YES','NO' )", "(SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, 'ROUTINE',DTD_IDENTIFIER) IN(SELECT OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, DTD_IDENTIFIER FROM system.Definition_Schema.Data_Type_Descriptor)"}
1112 , new int[] {3, 0, 1, 2, 5, 6, 7, 4}
1113 };
1114 } else if (tableName.equalsIgnoreCase("ROUTINE_PRIVILEGES")) {
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128 return new Object [] {new String [] {"ROUTINE_PRIVILEGES_TYPE_CHECK", "ROUTINE_PRIVILEGES_GRANTABLE_NOT_NULL", "ROUTINE_PRIVILEGES_GRANTABLE_CHECK", "ROUTINE_PRIVILEGE_GRANTOR_CHECK", "ROUTINE_PRIVILEGE_GRANTEE_CHECK"}
1129 ,
1130 new String [] {"PRIVILEGE_TYPE IN('EXECUTE' )", "\"IS_GRANTABLE\"is not null", "IS_GRANTABLE IN('YES','NO' )", "GRANTOR IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTOR IN('_SYSTEM' ) OR GRANTOR IN(SELECT USER_NAME FROM system.Definition_Schema.Users)", "GRANTEE IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTEE IN(SELECT USER_NAME FROM system.Definition_Schema.Users)"}
1131 , new int[] {5, 6, 0, 1}
1132 };
1133 } else if (tableName.equalsIgnoreCase("INDEXCOLUMNS")) {
1134
1135 return new Object [] {new String [] {"INDEX_COLUMNS_ORDINAL_POSITION_NOT_NULL"}
1136 , new String [] {"\"ORDINAL_POSITION\"is not null"}
1137 , new int[] {6}
1138 };
1139 } else if (tableName.equalsIgnoreCase("FULLTEXTCOLUMNINFO")) {
1140
1141 return new Object [] {new String [] {"FULLTEXTINDEX_COLUMNS_ORDINAL_POSITION_NOT_NULL"}
1142 , new String [] {"\"ORDINAL_POSITION\"is not null"}
1143 , new int[] {6}
1144 };
1145 } else if (tableName.equalsIgnoreCase("User_Defined_Types")) {
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186 return new Object [] {new String [] {"USER_DEFINED_TYPES_USER_DEFINED_TYPE_CATEGORY_NOT_NULL", "USER_DEFINED_TYPES_USER_DEFINED_TYPE_CATEGORY_CHECK", "USER_DEFINED_TYPES_IS_INSTANTIABLE_NOT_NULL", "USER_DEFINED_TYPES_IS_INSTANTIABLE_CHECK", "USER_DEFINED_TYPES_IS_FINAL_NOT_NULL", "USER_DEFINED_TYPES_IS_FINAL_CHECK", "USER_DEFINED_TYPES_ORDERING_FORM_NOT_NULL", "USER_DEFINED_TYPES_ORDERING_FORM_CHECK", "USER_DEFINED_TYPES_ORDERING_CATEGORY_CHECK", "USER_DEFINED_TYPES_REFERENCE_TYPE_CHECK", "USER_DEFINED_TYPES_CHECK_SOURCE_TYPE", "USER_DEFINED_TYPES_CHECK_USER_GENERATED_REFERENCE_TYPE"}
1187 ,
1188 new String [] {"\"USER_DEFINED_TYPE_CATEGORY\"is not null", "USER_DEFINED_TYPE_CATEGORY IN('STRUCTURED','DISTINCT' )", "\"IS_INSTANTIABLE\"is not null", "IS_INSTANTIABLE IN('YES','NO' )", "\"IS_FINAL\"is not null", "IS_FINAL IN('YES','NO' )", "\"ORDERING_FORM\"is not null", "ORDERING_FORM IN('NONE','FULL','EQUALS' )", "ORDERING_CATEGORY IN('RELATIVE','MAP','STATE' )", "REFERENCE_TYPE IN('SYSTEM GENERATED','USER GENERATED','DERIVED' )", "(USER_DEFINED_TYPE_CATEGORY = 'STRUCTURED' AND SOURCE_DTD_IDENTIFIER IS NULL) OR(USER_DEFINED_TYPE_CATEGORY = 'DISTINCT' AND(USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA, USER_DEFINED_TYPE_NAME, SOURCE_DTD_IDENTIFIER) IS NOT NULL AND(USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA, USER_DEFINED_TYPE_NAME, 'USER - DEFINED TYPE',SOURCE_DTD_IDENTIFIER) IN(SELECT OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, DTD_IDENTIFIER FROM system.Definition_Schema.Data_Type_Descriptor WHERE DATA_TYPE NOT IN('ROW','ARRAY','REFERENCE','USER - DEFINED' )))",
1189 "(REFERENCE_TYPE <> 'USER GENERATED' AND(USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA, USER_DEFINED_TYPE_NAME, 'USER - DEFINED TYPE',REF_DTD_IDENTIFIER) NOT IN(SELECT OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, DTD_IDENTIFIER FROM system.Definition_Schema.Data_Type_Descriptor)) OR(REFERENCE_TYPE = 'USER GENERATED' AND(USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA, USER_DEFINED_TYPE_NAME, 'USER - DEFINED TYPE',REF_DTD_IDENTIFIER) IN(SELECT OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, DTD_IDENTIFIER FROM system.Definition_Schema.Data_Type_Descriptor WHERE DATA_TYPE IN('CHARACTER','INTEGER' )))"
1190 }
1191 , new int[] {3, 5, 6, 7, 8, 12, 4, 0, 1, 2, 13}
1192 };
1193 } else if (tableName.equalsIgnoreCase("User_Defined_Type_Privileges")) {
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207 return new Object [] {new String [] {"PRIVILEGE_TYPE_CHECK", "USER_DEFINED_TYPE_PRIVILEGES_IS_GRANTABLE_NOT_NULL", "USER_DEFINED_TYPE_PRIVILEGES_IS_GRANTABLE_CHECK", "USER_DEFINED_TYPE_PRIVILEGES_GRANTOR_CHECK", "USER_DEFINED_TYPE_PRIVILEGES_GRANTEE_CHECK"}
1208 ,
1209 new String [] {"PRIVILEGE_TYPE = 'TYPE USAGE'", "\"IS_GRANTABLE\"is not null", "IS_GRANTABLE IN('YES','NO' )", "GRANTOR IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTOR IN('_SYSTEM' ) OR GRANTOR IN(SELECT USER_NAME FROM system.Definition_Schema.Users)", "GRANTEE IN(SELECT ROLE_NAME FROM system.Definition_Schema.Roles) OR GRANTEE IN(SELECT USER_NAME FROM system.Definition_Schema.Users)"}
1210 , new int[] {5, 6, 0, 1}
1211 };
1212 } else if (tableName.equalsIgnoreCase("Transforms_Table")) {
1213
1214
1215
1216
1217 return new Object [] {new String [] {"TRANSFORM_TYPE_NOT_NULL", "TRANSFORM_TYPE_CHECK"}
1218 ,
1219 new String [] {"\"TRANSFORM_TYPE\"is not null", "TRANSFORM_TYPE IN('TO SQL','FROM SQL' )"}
1220 , new int[] {7}
1221 };
1222 } else if (tableName.equalsIgnoreCase("Method_Specifications")) {
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254 return new Object [] {new String [] {"METHOD_SPECIFICATION_IS_STATIC_CHECK", "METHOD_SPECIFICATION_IS_OVERRIDING_CHECK", "METHOD_SPECIFICATIONS_LANGUAGE_CHECK", "METHOD_SPECIFICATIONS_PARAMETER_STYLE_CHECK", "METHOD_SPECIFICATIONS_IS_DETERMINISTIC_CHECK", "METHOD_SPECIFICATIONS_SQL_DATA_ACCESS_CHECK", "METHOD_SPECIFICATIONS_IS_NULL_CALL_CHECK", "METHOD_SPECIFICATIONS_AS_LOCATOR_CHECK", "METHOD_SPECIFICATIONS_CHECK_DATA_TYPE", "METHOD_SPECIFICATIONS_COMBINATIONS", "METHOD_SPECIFICATIONS_SAME_SCHEMA"}
1255 , new String [] {"IS_STATIC IN('YES','NO' )", "IS_OVERRIDING IN('YES','NO' )", "METHOD_LANGUAGE IN('SQL','ADA','C', 'COBOL','FORTRAN','MUMPS','PASCAL','PLI' )", "PARAMETER_STYLE IN('SQL','GENERAL' ) OR PARAMETER_STYLE IS NULL", "IS_DETERMINISTIC IN('YES','NO' )", "SQL_DATA_ACCESS IN('NONE','CONTAINS','READS','MODIFIES' )", "IS_NULL_CALL IN('YES','NO' )", "AS_LOCATOR IN('YES','NO' )", "(USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA, USER_DEFINED_TYPE_NAME, 'USER - DEFINED TYPE',DTD_IDENTIFIER) IN(SELECT OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, DTD_IDENTIFIER FROM system.Definition_Schema.Data_Type_Descriptor)", "( (METHOD_LANGUAGE = 'SQL' AND IS_DETERMINISTIC IS NULL) OR(METHOD_LANGUAGE <> 'SQL' AND IS_DETERMINISTIC IS NOT NULL))", "(SPECIFIC_CATALOG, SPECIFIC_SCHEMA) = (USER_DEFINED_TYPE_CATALOG, USER_DEFINED_TYPE_SCHEMA)"}
1256 , new int[] {7, 8, 9, 10, 12, 13, 14, 18, 3, 4, 5, 11, 0, 1}
1257 };
1258 } else if (tableName.equalsIgnoreCase("Method_Specifications_Paramters")) {
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279 return new Object [] {new String [] {"METHOD_SPECIFICATION_PARAMETER_POSITION_NOT_NULL", "METHOD_SPECIFICATION_PARAMETERS_ORDINAL_POSITION_GREATER_THAN_ZERO_CHECK", "METHOD_SPECIFICATION_PARAMETERS_ORDINAL_POSITION_CONTIGUOUS_CHECK", "METHOD_SPECIFICATION_PARAMETER_MODE_CHECK", "METHOD_SPECIFICATION_PARAMETER_IS_RESULT_CHECK", "METHOD_SPECIFICATION_PARAMETER_AS_LOCATOR_CHECK", "METHOD_SPECIFICATION_PARAMETERS_CHECK_DATA_TYPE"}
1280 , new String [] {"\"ORDINAL_POSITION\"is not null", "ORDINAL_POSITION > 0", "0 = ALL(SELECT MAX(ORDINAL_POSITION) - COUNT( * ) FROM system.Definition_Schema.Method_Specifications_Paramters GROUP BY SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME)", "PARAMETER_MODE IN('IN' )", "IS_RESULT IN('YES','NO' )", "AS_LOCATOR IN('YES','NO' )", "(SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, 'USER - DEFINED TYPE',DTD_IDENTIFIER) IN(SELECT OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, DTD_IDENTIFIER FROM system.Definition_Schema.Data_Type_Descriptor)"}
1281 , new int[] {7, 0, 1, 2, 9, 10, 11, 8}
1282 };
1283 } else if (tableName.equalsIgnoreCase("ROUTINE_TABLE_USAGE")) {
1284 return new Object [] {new String [] {"ROUTINE_TABLE_USAGE_CHECK_REFERENCES_TABLES"}
1285 , new String [] {"(TABLE_CATALOG <> ANY ( SELECT CATALOG_NAME FROM system.Definition_Schema.SCHEMATA ) OR ( TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME ) IN ( SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME FROM system.Definition_Schema.TABLES))"}
1286 , new int[] {3, 4, 5}
1287 };
1288 } else if (tableName.equalsIgnoreCase("ROUTINE_COLUMN_USAGE")) {
1289 return new Object [] {new String [] {"ROUTINE_COLUMN_USAGE_CHECK_REFERENCES_COLUMNS"}
1290 , new String [] {"( TABLE_CATALOG <> ANY ( SELECT CATALOG_NAME FROM system.Definition_Schema.SCHEMATA ) OR ( TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME ) IN ( SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM system.Definition_Schema.COLUMNS ) )"}
1291 , new int[] {3, 4, 5, 6}
1292 };
1293 }
1294 return null;
1295 }
1296
1297 private static Object [] getUniqueKeyInformation(String tableName) throws DException {
1298 if (tableName.equalsIgnoreCase("COLUMNS")) {
1299
1300 return new Object [] {"COLUMNS_UNIQUE", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "ORDINAL_POSITION"}
1301 , new int[] {1, 2, 3, 4}
1302 };
1303
1304 } else if (tableName.equalsIgnoreCase("KEY_COLUMN_USAGE")) {
1305 return new Object [] {"KEY_COLUMN_USAGE_UNIQUE", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", "ORDINAL_POSITION"}
1306 , new int[] {1, 2, 3, 4}
1307 };
1308 }
1309 return null;
1310 }
1311
1312 private static Object [] getPrimaryKeyInformation(String tableName) throws DException {
1313 if (tableName.equalsIgnoreCase("USERS")) {
1314
1315
1316 return new Object [] {"USERS_PRIMARY_KEY", new String [] {"USER_NAME"}
1317 , new int[] {1}
1318 };
1319 } else if (tableName.equalsIgnoreCase("ROLES")) {
1320
1321
1322 return new Object [] {"ROLES_PRIMARY_KEY", new String [] {"ROLE_NAME"}
1323 , new int[] {1}
1324 };
1325 } else if (tableName.equalsIgnoreCase("ROLE_AUTHORIZATION_DESCRIPTORS")) {
1326
1327
1328
1329 return new Object [] {"ROLE_AUTHORIZATION_DESCRIPTORS_PRIMARY_KEY", new String [] {"ROLE_NAME", "GRANTEE"}
1330 , new int[] {1, 2}
1331 };
1332 } else if (tableName.equalsIgnoreCase("SCHEMATA")) {
1333
1334
1335
1336 return new Object [] {"SCHEMATA_PRIMARY_KEY", new String [] {"CATALOG_NAME", "SCHEMA_NAME"}
1337 , new int[] {1, 2}
1338 };
1339 } else if (tableName.equalsIgnoreCase("CHARACTER_SETS")) {
1340
1341
1342
1343
1344 return new Object [] {"CHARACTER_SETS_PRIMARY_KEY", new String [] {"CHARACTER_SET_CATALOG", "CHARACTER_SET_SCHEMA", "CHARACTER_SET_NAME"}
1345 , new int[] {1, 2, 3}
1346 };
1347 } else if (tableName.equalsIgnoreCase("COLLATIONS")) {
1348
1349
1350
1351
1352 return new Object [] {"COLLATIONS_PAD_PRIMARY_KEY", new String [] {"COLLATION_CATALOG", "COLLATION_SCHEMA", "COLLATION_NAME"}
1353 , new int[] {1, 2, 3}
1354 };
1355 } else if (tableName.equalsIgnoreCase("DOMAINS")) {
1356
1357
1358
1359
1360 return new Object [] {"DOMAINS_PRIMARY_KEY", new String [] {"DOMAIN_CATALOG", "DOMAIN_SCHEMA", "DOMAIN_NAME"}
1361 , new int[] {1, 2, 3}
1362 };
1363 } else if (tableName.equalsIgnoreCase("TABLES")) {
1364
1365
1366
1367
1368 return new Object [] {"TABLES_PRIMARY_KEY", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME"}
1369 , new int[] {1, 2, 3}
1370 };
1371 } else if (tableName.equalsIgnoreCase("COLUMNS")) {
1372
1373
1374
1375
1376
1377 return new Object [] {"COLUMNS_PRIMARY_KEY", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME"}
1378 , new int[] {1, 2, 3, 4}
1379 };
1380 } else if (tableName.equalsIgnoreCase("DATA_TYPE_DESCRIPTOR")) {
1381
1382
1383
1384
1385
1386
1387 return new Object [] {"DATA_TYPE_DESCRIPTOR_PRIMARY_KEY", new String [] {"OBJECT_CATALOG", "OBJECT_SCHEMA", "OBJECT_NAME", "OBJECT_TYPE", "DTD_IDENTIFIER"}
1388 , new int[] {1, 2, 3, 4, 5}
1389 };
1390 } else if (tableName.equalsIgnoreCase("TABLE_CONSTRAINTS")) {
1391
1392
1393
1394
1395 return new Object [] {"TABLE_CONSTRAINTS_PRIMARY_KEY", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME"}
1396 , new int[] {1, 2, 3}
1397 };
1398 } else if (tableName.equalsIgnoreCase("KEY_COLUMN_USAGE")) {
1399
1400
1401
1402
1403
1404 return new Object [] {"KEY_COLUMN_USAGE_PRIMARY_KEY", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", "COLUMN_NAME"}
1405 , new int[] {1, 2, 3, 4}
1406 };
1407 } else if (tableName.equalsIgnoreCase("REFERENTIAL_CONSTRAINTS")) {
1408
1409
1410
1411
1412 return new Object [] {"REFERENTIAL_CONSTRAINTS_PRIMARY_KEY", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME"}
1413 , new int[] {1, 2, 3}
1414 };
1415 } else if (tableName.equalsIgnoreCase("CHECK_CONSTRAINTS")) {
1416
1417
1418
1419
1420 return new Object [] {"CHECK_CONSTRAINTS_PRIMARY_KEY", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME"}
1421 , new int[] {1, 2, 3}
1422 };
1423 } else if (tableName.equalsIgnoreCase("CHECK_COLUMN_USAGE")) {
1424
1425
1426
1427
1428
1429
1430
1431
1432 return new Object [] {"CHECK_COLUMN_USAGE_PRIMARY_KEY", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME"}
1433 , new int[] {1, 2, 3, 4, 5, 6, 7}
1434 };
1435 } else if (tableName.equalsIgnoreCase("CHECK_TABLE_USAGE")) {
1436
1437
1438
1439
1440
1441
1442
1443 return new Object [] {"CHECK_TABLE_USAGE_PRIMARY_KEY", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME"}
1444 , new int[] {1, 2, 3, 4, 5, 6}
1445 };
1446 } else if (tableName.equalsIgnoreCase("TRIGGERS")) {
1447
1448
1449
1450
1451 return new Object [] {"TRIGGERS_PRIMARY_KEY", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME"}
1452 , new int[] {1, 2, 3}
1453 };
1454 } else if (tableName.equalsIgnoreCase("TRIGGER_TABLE_USAGE")) {
1455
1456
1457
1458
1459
1460
1461
1462 return new Object [] {"TRIGGER_TABLE_USAGE_PRIMARY_KEY", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME"}
1463 , new int[] {1, 2, 3, 4, 5, 6}
1464 };
1465 } else if (tableName.equalsIgnoreCase("TRIGGER_COLUMN_USAGE")) {
1466
1467
1468
1469
1470
1471
1472
1473
1474 return new Object [] {"TRIGGER_COLUMN_USAGE_PRIMARY_KEY", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME"}
1475 , new int[] {1, 2, 3, 4, 5, 6, 7}
1476 };
1477 } else if (tableName.equalsIgnoreCase("TRIGGERED_UPDATE_COLUMNS")) {
1478
1479
1480
1481
1482
1483 return new Object [] {"TRIGGERED_UPDATE_COLUMNS_PRIMARY_KEY", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME", "EVENT_OBJECT_COLUMN"}
1484 , new int[] {1, 2, 3, 4}
1485 };
1486 } else if (tableName.equalsIgnoreCase("VIEWS")) {
1487
1488
1489
1490
1491 return new Object [] {"VIEWS_PRIMARY_KEY", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME"}
1492 , new int[] {1, 2, 3}
1493 };
1494 } else if (tableName.equalsIgnoreCase("VIEW_COLUMN_USAGE")) {
1495
1496
1497
1498
1499
1500
1501
1502
1503 return new Object [] {"VIEW_COLUMN_USAGE_PRIMARY_KEY", new String [] {"VIEW_CATALOG", "VIEW_SCHEMA", "VIEW_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME"}
1504 , new int[] {1, 2, 3, 4, 5, 6, 7}
1505 };
1506 } else if (tableName.equalsIgnoreCase("VIEW_TABLE_USAGE")) {
1507
1508
1509
1510
1511
1512
1513
1514 return new Object [] {"VIEW_TABLE_USAGE_PRIMARY_KEY", new String [] {"VIEW_CATALOG", "VIEW_SCHEMA", "VIEW_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME"}
1515 , new int[] {1, 2, 3, 4, 5, 6}
1516 };
1517 } else if (tableName.equalsIgnoreCase("DOMAIN_CONSTRAINTS")) {
1518
1519
1520
1521
1522 return new Object [] {"DOMAIN_CONSTRAINTS_PRIMARY_KEY", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME"}
1523 , new int[] {1, 2, 3}
1524 };
1525 } else if (tableName.equalsIgnoreCase("COLUMN_PRIVILEGES")) {
1526
1527
1528
1529
1530
1531
1532
1533
1534 return new Object [] {"COLUMN_PRIVILEGE_PRIMARY_KEY", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "PRIVILEGE_TYPE", "COLUMN_NAME", "GRANTOR", "GRANTEE"}
1535 , new int[] {1, 2, 3, 4, 5, 6, 7}
1536 };
1537 } else if (tableName.equalsIgnoreCase("TABLE_PRIVILEGES")) {
1538
1539
1540
1541
1542
1543
1544
1545 return new Object [] {"TABLE_PRIVILEGE_PRIMARY_KEY", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "PRIVILEGE_TYPE", "GRANTOR", "GRANTEE"}
1546 , new int[] {1, 2, 3, 4, 5, 6}
1547 };
1548 } else if (tableName.equalsIgnoreCase("USAGE_PRIVILEGES")) {
1549
1550
1551
1552
1553
1554
1555
1556 return new Object [] {"USAGE_PRIVILEGES_PRIMARY_KEY", new String [] {"OBJECT_CATALOG", "OBJECT_SCHEMA", "OBJECT_NAME", "OBJECT_TYPE", "GRANTOR", "GRANTEE"}
1557 , new int[] {1, 2, 3, 4, 5, 6}
1558 };
1559 } else if (tableName.equalsIgnoreCase("ROUTINES")) {
1560
1561
1562
1563
1564 return new Object [] {"ROUTINES_PRIMARY_KEY", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME"}
1565 , new int[] {1, 2, 3}
1566 };
1567 } else if (tableName.equalsIgnoreCase("PARAMETERS")) {
1568
1569
1570
1571
1572
1573 return new Object [] {"PARAMETERS_PRIMARY_KEY", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", "ORDINAL_POSITION"}
1574 , new int[] {1, 2, 3, 4}
1575 };
1576 } else if (tableName.equalsIgnoreCase("ROUTINE_PRIVILEGES")) {
1577
1578
1579
1580
1581
1582
1583
1584 return new Object [] {"ROUTINE_PRIVILEGES_PRIMARY_KEY", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", "PRIVILEGE_TYPE", "GRANTOR", "GRANTEE"}
1585 , new int[] {1, 2, 3, 4, 5, 6}
1586 };
1587 } else if (tableName.equalsIgnoreCase("INDEXINFO")) {
1588
1589
1590
1591
1592
1593 return new Object [] {"INDEXINFO_PRIMARY_KEY", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME"}
1594 , new int[] {1, 2, 3, 4}
1595 };
1596 } else if (tableName.equalsIgnoreCase("INDEXCOLUMNS")) {
1597
1598
1599
1600
1601
1602
1603 return new Object [] {"INDEXCOLUMNS_PRIMARY_KEY", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME", "COLUMN_NAME"}
1604 , new int[] {1, 2, 3, 4, 5}
1605 };
1606 } else if (tableName.equalsIgnoreCase("FULLTEXTINFO")) {
1607
1608
1609
1610
1611
1612 return new Object [] {"FULLTEXTINDEX_PRIMARY_KEY", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME"}
1613 , new int[] {1, 2, 3, 4}
1614 };
1615 } else if (tableName.equalsIgnoreCase("FULLTEXTCOLUMNINFO")) {
1616
1617
1618
1619
1620
1621
1622 return new Object [] {"FULLTEXTINDEXCOLUMNS_PRIMARY_KEY", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME", "COLUMN_NAME"}
1623 , new int[] {1, 2, 3, 4, 5}
1624 };
1625 } else if (tableName.equalsIgnoreCase("User_Defined_Types")) {
1626
1627
1628
1629
1630 return new Object [] {"USER_DEFINED_TYPES_PRIMARY_KEY", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA", "USER_DEFINED_TYPE_NAME"}
1631 , new int[] {1, 2, 3}
1632 };
1633 } else if (tableName.equalsIgnoreCase("User_Defined_Type_Privileges")) {
1634
1635
1636
1637
1638
1639
1640
1641 return new Object [] {"USER_DEFINED_TYPE_PRIVILEGES_PRIMARY_KEY", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA", "USER_DEFINED_TYPE_NAME", "PRIVILEGE_TYPE", "GRANTOR", "GRANTEE"}
1642 , new int[] {1, 2, 3, 4, 5, 6}
1643 };
1644 } else if (tableName.equalsIgnoreCase("Transforms_Table")) {
1645
1646
1647
1648
1649
1650
1651 return new Object [] {"TRANSFORMS_PRIMARY_KEY", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA", "USER_DEFINED_TYPE_NAME", "GROUP_NAME", "TRANSFORM_TYPE"}
1652 , new int[] {1, 2, 3, 4, 5}
1653 };
1654 } else if (tableName.equalsIgnoreCase("Method_Specifications")) {
1655
1656
1657
1658
1659 return new Object [] {"METHOD_SPECIFICATIONS_PRIMARY_KEY", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME"}
1660 , new int[] {1, 2, 3}
1661 };
1662 } else if (tableName.equalsIgnoreCase("Method_Specifications_Paramters")) {
1663
1664
1665
1666
1667
1668
1669
1670
1671
1672 return new Object [] {"METHOD_SPECIFICATION_PARAMETERS_PRIMARY_KEY", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", "METHOD_CATALOG", "METHOD_SCHEMA", "METHOD_NAME", "METHOD_SPECIFICATION_IDENTIFIER", "ORDINAL_POSITION"}
1673 , new int[] {1, 2, 3, 4, 5, 6, 7, 8}
1674 };
1675 } else if (tableName.equalsIgnoreCase("sequence_number")) {
1676
1677
1678
1679
1680 return new Object [] {"SEQUENCE_NUMBER_PRIMARY_KEY", new String [] {"SEQUENCE_CATALOG", "SEQUENCE_SCHEMA", "SEQUENCE_NAME"}
1681 , new int[] {1, 2, 3}
1682 };
1683 } else if (tableName.equalsIgnoreCase("ROUTINE_TABLE_USAGE")) {
1684 return new Object [] {"ROUTINE_TABLE_USAGE_PRIMARY_KEY", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME"}
1685 , new int[] {1, 2, 3, 4, 5, 6}
1686 };
1687 } else if (tableName.equalsIgnoreCase("ROUTINE_COLUMN_USAGE")) {
1688 return new Object [] {"ROUTINE_COLUMN_USAGE_PRIMARY_KEY", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME"}
1689 , new int[] {1, 2, 3, 4, 5, 6, 7}
1690 };
1691 }
1692 return null;
1693 }
1694
1695 private static ArrayList getKeyColumnDescriptors(Object [] ColumnsAndIndexes, TableConstraintDescriptor tableConsDes) throws DException {
1696 String [] columnNames = (String []) ColumnsAndIndexes[1];
1697 int[] oridinalPosition = (int[]) ColumnsAndIndexes[2];
1698 ArrayList arr = new ArrayList(5);
1699
1700 for (int i = 0; i < columnNames.length; i++) {
1701 KeyColumnUsageDescriptor kcud = new KeyColumnUsageDescriptor();
1702 kcud.constraint_catalog = SystemTables.systemCatalog;
1703 kcud.constraint_schema = SystemTables.systemSchema;
1704 kcud.constraint_name = ColumnsAndIndexes[0].toString();
1705 kcud.table_catalog = SystemTables.systemCatalog;
1706 kcud.table_schema = SystemTables.systemSchema;
1707 kcud.table_name = tableConsDes.table_name;
1708 kcud.column_name = columnNames[i];
1709 kcud.ordinal_position = oridinalPosition[i];
1710 kcud.tableConstraintDescriptor = tableConsDes;
1711 arr.add(kcud);
1712 }
1713 return arr;
1714 }
1715}
1716 |
Popular Tags |
Java API By Example, From Geeks To Geeks.