ILIAS  release_5-4 Revision v5.4.26-12-gabc799a52e6
Public Member Functions
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.

Author
Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 9 of file class.ilDatabasePostgresTestsDataOutputs.php.

Member Function Documentation

◆ getCreationQueryBuildByILIAS()

ilDatabasePostgresTestsDataOutputs::getCreationQueryBuildByILIAS (   $table_name)
Parameters
$table_name
Returns
string

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

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

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

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

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

Definition at line 65 of file class.ilDatabasePostgresTestsDataOutputs.php.

66  {
67  return array(
68  0 => $table_name . '_pk',
69  );
70  }

◆ getTableFieldDefinition()

ilDatabasePostgresTestsDataOutputs::getTableFieldDefinition ( )

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

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: