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