ilDatabasePostgresTestsDataOutputs Class Reference
Class ilDatabaseCommonTestsDataOutputs. More...
Inheritance diagram for ilDatabasePostgresTestsDataOutputs:
Collaboration diagram for ilDatabasePostgresTestsDataOutputs:
Public Member Functions | |
| getCreationQueryBuildByILIAS ($table_name) | |
| getPrimaryInfo ($table_name='') | |
| getIndexInfo ($with_fulltext=false, $table_name='') | |
| getTableConstraints ($table_name='') | |
| getNativeTableIndices ($table_name='', $fulltext=false) | |
| getTableFieldDefinition () | |
| getListTables ($table_name) | |
| getTableSequences ($table_name) | |
| Public Member Functions inherited from ilDatabaseCommonTestsDataOutputs | |
| getIndexInfo ($with_fulltext=false, $table_name='') | |
| getPrimaryInfo ($table_name='') | |
| getCreationQueryBuildByILIAS ($table_name) | |
| getTableFieldDefinition () | |
| getTableSequences ($table_name) | |
| getNativeTableIndices ($table_name='', $fulltext=false) | |
| getTableConstraints ($table_name='') | |
| getTableFields () | |
| getListTables ($table_name) | |
Additional Inherited Members | |
| Static Public Attributes inherited from ilDatabaseCommonTestsDataOutputs | |
| static | $analyzer_field_info |
| static | $insert_sql_output |
| static | $select_usr_data_output |
| static | $select_usr_data_2_output |
| static | $output_after_native_update |
| static | $output_after_native_input |
| static | $table_index_definition_output |
| static | $table_constraint_definition_output |
Detailed Description
Class ilDatabaseCommonTestsDataOutputs.
Definition at line 9 of file class.ilDatabasePostgresTestsDataOutputs.php.
Member Function Documentation
◆ getCreationQueryBuildByILIAS()
| ilDatabasePostgresTestsDataOutputs::getCreationQueryBuildByILIAS | ( | $table_name | ) |
- Parameters
-
$table_name
- Returns
- string
Reimplemented from ilDatabaseCommonTestsDataOutputs.
Definition at line 15 of file class.ilDatabasePostgresTestsDataOutputs.php.
15 {
16 return "CREATE TABLE $table_name (id INT NOT NULL, is_online SMALLINT DEFAULT NULL, is_default SMALLINT DEFAULT 1, latitude FLOAT8 DEFAULT NULL, longitude FLOAT8 DEFAULT NULL, elevation FLOAT8 DEFAULT NULL, address VARCHAR(256) DEFAULT NULL NULL, init_mob_id INT DEFAULT NULL, comment_mob_id INT DEFAULT NULL, container_id INT DEFAULT NULL, big_data TEXT)";
17 }
◆ getIndexInfo()
| ilDatabasePostgresTestsDataOutputs::getIndexInfo | ( | $with_fulltext = false, |
|
$table_name = '' |
|||
| ) |
- Parameters
-
bool $with_fulltext string $table_name
- Returns
- array
Reimplemented from ilDatabaseCommonTestsDataOutputs.
Definition at line 41 of file class.ilDatabasePostgresTestsDataOutputs.php.
41 {
42 return array(
43 0 => array(
44 'name' => $table_name . '_i1',
45 'fulltext' => false,
46 'fields' => array(
47 'init_mob_id' => array(
48 'position' => 1,
49 'sorting' => 'ascending',
50 ),
51 ),
52 ),
53 );
54 }
◆ getListTables()
| ilDatabasePostgresTestsDataOutputs::getListTables | ( | $table_name | ) |
- Parameters
-
$table_name
- Returns
- array
Reimplemented from ilDatabaseCommonTestsDataOutputs.
Definition at line 105 of file class.ilDatabasePostgresTestsDataOutputs.php.
105 {
106 $tables = parent::getListTables($table_name);
107 unset($tables[0]);
108 return $tables;
109 }
◆ getNativeTableIndices()
| ilDatabasePostgresTestsDataOutputs::getNativeTableIndices | ( | $table_name = '', |
|
$fulltext = false |
|||
| ) |
- Parameters
-
string $table_name
- Returns
- array
Reimplemented from ilDatabaseCommonTestsDataOutputs.
Definition at line 72 of file class.ilDatabasePostgresTestsDataOutputs.php.
72 {
73 if ($fulltext) {
74 return array(
75 0 => $table_name . '_i1',
76 1 => $table_name . '_i2',
77 );
78 }
79
80 return array(
81 0 => $table_name . '_i1',
82 );
83 }
◆ getPrimaryInfo()
| ilDatabasePostgresTestsDataOutputs::getPrimaryInfo | ( | $table_name = '' | ) |
- Returns
- array
Reimplemented from ilDatabaseCommonTestsDataOutputs.
Definition at line 23 of file class.ilDatabasePostgresTestsDataOutputs.php.
23 {
24 return array(
25 'name' => $table_name . '_pk',
26 'fields' => array(
27 'id' => array(
28 'position' => 1,
29 'sorting' => 'ascending',
30 ),
31 ),
32 );
33 }
◆ getTableConstraints()
| ilDatabasePostgresTestsDataOutputs::getTableConstraints | ( | $table_name = '' | ) |
- Parameters
-
string $table_name
- Returns
- array
Reimplemented from ilDatabaseCommonTestsDataOutputs.
Definition at line 61 of file class.ilDatabasePostgresTestsDataOutputs.php.
61 {
62 return array(
63 0 => $table_name . '_pk',
64 );
65 }
◆ getTableFieldDefinition()
| ilDatabasePostgresTestsDataOutputs::getTableFieldDefinition | ( | ) |
- Returns
- array
Reimplemented from ilDatabaseCommonTestsDataOutputs.
Definition at line 86 of file class.ilDatabasePostgresTestsDataOutputs.php.
86 {
87 return array(
88 0 => array(
89 'notnull' => false,
90 'nativetype' => 'int4',
91 'length' => 4,
92 'unsigned' => false,
93 'default' => null,
94 'type' => 'integer',
95 'mdb2type' => 'integer',
96 ),
97 );
98 }
◆ getTableSequences()
| ilDatabasePostgresTestsDataOutputs::getTableSequences | ( | $table_name | ) |
- Parameters
-
$table_name
- Returns
- array
Reimplemented from ilDatabaseCommonTestsDataOutputs.
Definition at line 116 of file class.ilDatabasePostgresTestsDataOutputs.php.
116 {
117 return array(
118 0 => 'addressbook_mlist',
119 1 => 'addressbook_mlist_ass',
120 2 => 'adm_settings_template',
121 3 => 'adv_md_record',
122 4 => 'adv_mdf_definition',
123 5 => 'aicc_object',
124 6 => 'aicc_units',
125 7 => 'ass_log',
126 8 => 'benchmark',
127 9 => 'booking_entry',
128 10 => 'booking_object',
129 11 => 'booking_reservation',
130 12 => 'booking_reservation_group',
131 13 => 'booking_schedule',
132 14 => 'bookmark_data',
133 15 => 'bookmark_social_bm',
134 16 => 'cal_categories',
135 17 => 'cal_ch_group',
136 18 => 'cal_entries',
137 19 => 'cal_notification',
138 20 => 'cal_rec_exclusion',
139 21 => 'cal_recurrence_rules',
140 22 => 'chatroom_admconfig',
141 23 => 'chatroom_history',
142 24 => 'chatroom_prooms',
143 25 => 'chatroom_psessions',
144 26 => 'chatroom_sessions',
145 27 => 'chatroom_settings',
146 28 => 'chatroom_smilies',
147 29 => 'chatroom_uploads',
148 30 => 'cmi_comment',
149 31 => 'cmi_correct_response',
150 32 => 'cmi_interaction',
151 33 => 'cmi_node',
152 34 => 'cmi_objective',
153 35 => 'conditions',
154 36 => 'cp_node',
155 37 => 'crs_archives',
156 38 => 'crs_f_definitions',
157 39 => 'crs_file',
158 40 => 'crs_objective_lm',
159 41 => 'crs_objective_qst',
160 42 => 'crs_objective_tst',
161 43 => 'crs_objectives',
162 44 => 'crs_start',
163 45 => 'didactic_tpl_a',
164 46 => 'didactic_tpl_fp',
165 47 => 'didactic_tpl_settings',
166 48 => 'ecs_cmap_rule',
167 49 => 'ecs_cms_data',
168 50 => 'ecs_container_mapping',
169 51 => 'ecs_course_assignments',
170 52 => 'ecs_crs_mapping_atts',
171 53 => 'ecs_events',
172 54 => 'ecs_remote_user',
173 55 => 'ecs_server',
174 56 => 'event',
175 57 => 'event_appointment',
176 58 => 'event_file',
177 59 => 'exc_assignment',
178 60 => 'exc_crit',
179 61 => 'exc_crit_cat',
180 62 => 'exc_returned',
181 63 => 'frm_data',
182 64 => 'frm_notification',
183 65 => 'frm_posts',
184 66 => 'frm_posts_deleted',
185 67 => 'frm_posts_tree',
186 68 => 'frm_threads',
187 69 => 'glossary_definition',
188 70 => 'glossary_term',
189 71 => 'help_module',
190 72 => 'help_tooltip',
191 73 => 'history',
192 74 => 'il_bibl_attribute',
193 75 => 'il_bibl_entry',
194 76 => 'il_bibl_settings',
195 77 => 'il_blog_posting',
196 78 => 'il_custom_block',
197 79 => 'il_dcl_data',
198 80 => 'il_dcl_field',
199 81 => 'il_dcl_field_prop_s_b',
200 82 => 'il_dcl_record',
201 83 => 'il_dcl_record_field',
202 84 => 'il_dcl_stloc1_value',
203 85 => 'il_dcl_stloc2_value',
204 86 => 'il_dcl_stloc3_value',
205 87 => 'il_dcl_table',
206 88 => 'il_dcl_view',
207 89 => 'il_exc_team',
208 90 => 'il_exc_team_log',
209 91 => 'il_external_feed_block',
210 92 => 'il_gc_memcache_server',
211 93 => 'il_md_cpr_selections',
212 94 => 'il_meta_annotation',
213 95 => 'il_meta_classification',
214 96 => 'il_meta_contribute',
215 97 => 'il_meta_description',
216 98 => 'il_meta_educational',
217 99 => 'il_meta_entity',
218 100 => 'il_meta_format',
219 101 => 'il_meta_general',
220 102 => 'il_meta_identifier',
221 103 => 'il_meta_identifier_',
222 104 => 'il_meta_keyword',
223 105 => 'il_meta_language',
224 106 => 'il_meta_lifecycle',
225 107 => 'il_meta_location',
226 108 => 'il_meta_meta_data',
227 109 => 'il_meta_relation',
228 110 => 'il_meta_requirement',
229 111 => 'il_meta_rights',
230 112 => 'il_meta_tar',
231 113 => 'il_meta_taxon',
232 114 => 'il_meta_taxon_path',
233 115 => 'il_meta_technical',
234 116 => 'il_new_item_grp',
235 117 => 'il_news_item',
236 118 => 'il_poll_answer',
237 119 => 'il_qpl_qst_fq_res',
238 120 => 'il_qpl_qst_fq_res_unit',
239 121 => 'il_qpl_qst_fq_ucat',
240 122 => 'il_qpl_qst_fq_unit',
241 123 => 'il_qpl_qst_fq_var',
242 124 => 'il_rating_cat',
243 125 => $table_name,
244 126 => 'il_wiki_page',
245 127 => 'ldap_rg_mapping',
246 128 => 'ldap_role_assignments',
247 129 => 'ldap_server_settings',
248 130 => 'link_check',
249 131 => 'lm_data',
250 132 => 'lm_menu',
251 133 => 'loc_tst_assignments',
252 134 => 'mail',
253 135 => 'mail_man_tpl',
254 136 => 'mail_obj_data',
255 137 => 'media_item',
256 138 => 'mep_item',
257 139 => 'note',
258 140 => 'notification_data',
259 141 => 'notification_osd',
260 142 => 'obj_stat_log',
261 143 => 'object_data',
262 144 => 'object_reference',
263 145 => 'object_reference_ws',
264 146 => 'openid_provider',
265 147 => 'orgu_types',
266 148 => 'page_layout',
267 149 => 'page_style_usage',
268 150 => 'pg_amd_page_list',
269 151 => 'prg_settings',
270 152 => 'prg_translations',
271 153 => 'prg_type',
272 154 => 'prg_type_adv_md_rec',
273 155 => 'prg_usr_assignments',
274 156 => 'prg_usr_progress',
275 157 => 'qpl_a_cloze',
276 158 => 'qpl_a_errortext',
277 159 => 'qpl_a_essay',
278 160 => 'qpl_a_imagemap',
279 161 => 'qpl_a_matching',
280 162 => 'qpl_a_mc',
281 163 => 'qpl_a_mdef',
282 164 => 'qpl_a_mterm',
283 165 => 'qpl_a_ordering',
284 166 => 'qpl_a_sc',
285 167 => 'qpl_a_textsubset',
286 168 => 'qpl_fb_generic',
287 169 => 'qpl_fb_specific',
288 170 => 'qpl_hint_tracking',
289 171 => 'qpl_hints',
290 172 => 'qpl_num_range',
291 173 => 'qpl_questionpool',
292 174 => 'qpl_questions',
293 175 => 'qpl_sol_sug',
294 176 => 'rbac_log',
295 177 => 'rbac_operations',
296 178 => 'reg_er_assignments',
297 179 => 'reg_registration_codes',
298 180 => 'role_desktop_items',
299 181 => 'sahs_sc13_seq_node',
300 182 => 'sahs_sc13_seq_templts',
301 183 => 'sahs_sc13_tree_node',
302 184 => 'sc_resource_dependen',
303 185 => 'sc_resource_file',
304 186 => 'scorm_object',
305 187 => 'search_data',
306 188 => 'shib_role_assignment',
307 189 => 'skl_level',
308 190 => 'skl_profile',
309 191 => 'skl_self_eval',
310 192 => 'skl_tree_node',
311 193 => 'sty_media_query',
312 194 => 'style_parameter',
313 195 => 'style_template',
314 196 => 'svy_anonymous',
315 197 => 'svy_answer',
316 198 => 'svy_category',
317 199 => 'svy_constraint',
318 200 => 'svy_finished',
319 201 => 'svy_inv_usr',
320 202 => 'svy_material',
321 203 => 'svy_phrase',
322 204 => 'svy_phrase_cat',
323 205 => 'svy_qblk',
324 206 => 'svy_qblk_qst',
325 207 => 'svy_qpl',
326 208 => 'svy_qst_constraint',
327 209 => 'svy_qst_matrixrows',
328 210 => 'svy_qst_oblig',
329 211 => 'svy_qtype',
330 212 => 'svy_question',
331 213 => 'svy_relation',
332 214 => 'svy_settings',
333 215 => 'svy_svy',
334 216 => 'svy_svy_qst',
335 217 => 'svy_times',
336 218 => 'svy_variable',
337 219 => 'sysc_groups',
338 220 => 'sysc_tasks',
339 221 => 'tax_node',
340 222 => 'tos_acceptance_track',
341 223 => 'tos_versions',
342 224 => 'tst_active',
343 225 => 'tst_manual_fb',
344 226 => 'tst_mark',
345 227 => 'tst_rnd_cpy',
346 228 => 'tst_rnd_qpl_title',
347 229 => 'tst_rnd_quest_set_qpls',
348 230 => 'tst_solutions',
349 231 => 'tst_test_defaults',
350 232 => 'tst_test_question',
351 233 => 'tst_test_result',
352 234 => 'tst_test_rnd_qst',
353 235 => 'tst_tests',
354 236 => 'tst_times',
355 237 => 'udf_definition',
356 238 => 'usr_account_codes',
357 239 => 'usr_data_multi',
358 240 => 'usr_ext_profile_page',
359 241 => 'usr_portfolio_page',
360 242 => 'webr_items',
361 243 => 'webr_params',
362 244 => 'write_event',
363 245 => 'xhtml_page',
364 246 => 'xmlnestedset',
365 247 => 'xmlnestedsettmp',
366 248 => 'xmltags',
367 249 => 'xmlvalue',
368 );
369 }
The documentation for this class was generated from the following file:
- Services/Database/test/Implementations/data/Postgres/class.ilDatabasePostgresTestsDataOutputs.php
