|
1 package com.daffodilwoods.daffodildb.server.datadictionarysystem;
2
3
11
12 import com.daffodilwoods.database.general.QualifiedIdentifier;
13 import com.daffodilwoods.database.resource.DException;
14 import com.daffodilwoods.database.utility.P;
15
16 public class SystemTables {
17
18 public SystemTables() {
19 }
20
21 public static final String  systemCatalog = "system";
22 public static final String systemSchema = "Definition_Schema";
23
24 public static final QualifiedIdentifier schema_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Schemata");
25
26 public static final QualifiedIdentifier tables_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Tables");
27
28 public static final QualifiedIdentifier views_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Views");
29
30 public static final QualifiedIdentifier domains_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Domains");
31
32 public static final QualifiedIdentifier triggers_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Triggers");
33
34 public static final QualifiedIdentifier roles_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Roles");
35
36 public static final QualifiedIdentifier characterSets_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Character_Sets");
37
38 public static final QualifiedIdentifier collations_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Collations");
39
40 public static final QualifiedIdentifier assertions_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Assertions");
41
42 public static final QualifiedIdentifier translations_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Translations");
43
44 public static final QualifiedIdentifier userDefinedTypes_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "User_Defined_Types");
45
46 public static final QualifiedIdentifier sqlInvokedRoutines_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "SQLInvoked_Routines");
47
48 public static final QualifiedIdentifier columns_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Columns");
49
50 public static final QualifiedIdentifier table_constraints_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Table_Constraints");
51
52 public static final QualifiedIdentifier check_constraints_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Check_Constraints");
53
54 public static final QualifiedIdentifier referential_constraints_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Referential_Constraints");
55
56 public static final QualifiedIdentifier key_column_usage_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Key_Column_Usage");
57
58 public static final QualifiedIdentifier dataTypeDescriptor_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Data_Type_Descriptor");
59
60 public static final QualifiedIdentifier view_table_usage_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "View_Table_Usage");
61
62 public static final QualifiedIdentifier view_colum_usage_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "View_Column_Usage");
63
64 public static final QualifiedIdentifier triggered_update_columns_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Triggered_update_columns");
65
66 public static final QualifiedIdentifier trigger_table_usage_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Trigger_Table_Usage");
67
68 public static final QualifiedIdentifier trigger_column_usage_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Trigger_Column_Usage");
69
70 public static final QualifiedIdentifier check_table_usage_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Check_Table_Usage");
71
72 public static final QualifiedIdentifier check_column_usage_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Check_Column_Usage");
73
74 public static final QualifiedIdentifier domain_constraints_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Domain_Constraints");
75
76 public static final QualifiedIdentifier role_authorization_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Role_Authorization_Descriptors");
77
78 public static final QualifiedIdentifier table_privileges_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Table_Privileges");
79
80 public static final QualifiedIdentifier column_privileges_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Column_Privileges");
81
82 public static final QualifiedIdentifier usage_privileges_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Usage_Privileges");
83
84 public static final QualifiedIdentifier users_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Users");
85
86 public static final QualifiedIdentifier routine_privileges_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Routine_Privileges");
87
88 public static final QualifiedIdentifier sumtrigger_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Sumtrigger");
89
90 public static final QualifiedIdentifier transaction_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Transactions");
91
92 public static final QualifiedIdentifier parameters_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Parameters");
93
94 public static final QualifiedIdentifier routines_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Routines");
95
96 public static final QualifiedIdentifier user_defined_type_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "User_Defined_Types");
97
98 public static final QualifiedIdentifier user_defined_type_privileges_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "User_Defined_Type_Privileges");
99
100 public static final QualifiedIdentifier method_specifications_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Method_Specifications");
101
102 public static final QualifiedIdentifier method_specification_parameters_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Method_Specifications_Paramters");
103
104 public static final QualifiedIdentifier transforms_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Transforms_Table");
105
106 public static final QualifiedIdentifier INDEXINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "INDEXINFO");
107
108 public static final QualifiedIdentifier INDEXCOLUMNS = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "INDEXCOLUMNS");
109
110 public static final QualifiedIdentifier FULLTEXTINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "FULLTEXTINFO");
111 public static final QualifiedIdentifier FULLTEXTCOLUMNINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "FULLTEXTCOLUMNINFO");
112
113 public static final QualifiedIdentifier DATABASEFULLTEXTINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "DATABASEFULLTEXTINFO");
114 public static final QualifiedIdentifier DATABASEFULLTEXTCOLUMNINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "DATABASEFULLTEXTCOLUMNINFO");
115 public static final QualifiedIdentifier dualSystemTable = new QualifiedIdentifier(systemCatalog, "information_schema", "dualSystemTable");
116
117 public static final QualifiedIdentifier routine_table_usage_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Routine_Table_Usage");
118 public static final QualifiedIdentifier routine_column_usage_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "Routine_Column_Usage");
119
120
121 public static final QualifiedIdentifier TABLEINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "TableInfo");
122 public static final QualifiedIdentifier CLUSTERINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "CLUSTERINFO");
123 public static final QualifiedIdentifier DATABASEINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "DATABASEINFO");
124 public static final QualifiedIdentifier COLUMNINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "COLUMNINFO"); public static final QualifiedIdentifier DATABASEINDEXINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "DATABASEINDEXINFO");
126 public static final QualifiedIdentifier DATABASEINDEXCOLUMNS = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "DATABASEINDEXCOLUMNS");
127 public static final QualifiedIdentifier sequence_number_TableName = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "sequence_number");
128 public static final QualifiedIdentifier DATABASEFILEINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "DatabaseFileInfo");
129 public static final QualifiedIdentifier FREESPACEINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "FreeSpaceInfo");
130 public static final QualifiedIdentifier SCHEDULEINFO = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "SCHEDULEINFO");
131 public static final QualifiedIdentifier DIRTYDISTRIBUTEDTRANSACTIONS = new QualifiedIdentifier(systemCatalog, "Definition_Schema", "DIRTYDISTRIBUTEDTRANSACTIONS");
132
133 public static final String DEFAULT_CATALOG = "users";
134 public static final String DEFAULT_SCHEMA = "users";
135
136 public static final String PERSISTENCE_CATALOG = "system";
137 public static final String PERSISTENCE_SCHEMA = "persistence";
138
139 public static final String SYSTEM = "_SYSTEM";
140
141 public static final QualifiedIdentifier columns_ViewName = new QualifiedIdentifier(systemCatalog, "Information_Schema", "Columns");
142
143 public static final QualifiedIdentifier tables_ViewName = new QualifiedIdentifier(systemCatalog, "Information_Schema", "Tables");
144
145 public static boolean isSystemTable(String tableName) throws DException {
146 return P.indexOfIgnoreCase(SystemTablesCreator.tableNames, tableName) != -1 ||
147 tableName.equals(TABLEINFO) ||
148 tableName.equals(CLUSTERINFO) ||
149 tableName.equals(DATABASEINFO) ||
150 tableName.equals(COLUMNINFO);
151 }
152
153 public static boolean isSystemView(String viewName) throws DException {
154 return P.indexOfIgnoreCase(SystemTablesCreator.viewNames, viewName) != -1;
155 }
156 }
157 |
Popular Tags |
Java API By Example, From Geeks To Geeks.