ilDatabaseCommonTestsDataOutputs Class Reference
Class ilDatabaseCommonTestsDataOutputs. More...
Inheritance diagram for ilDatabaseCommonTestsDataOutputs:
Collaboration diagram for ilDatabaseCommonTestsDataOutputs:
Public Member Functions | |
| 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) | |
Static Public Attributes | |
| 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 8 of file class.ilDatabaseCommonTestsDataOutputs.php.
Member Function Documentation
◆ getCreationQueryBuildByILIAS()
|
abstract |
- Parameters
-
$table_name
- Returns
- string
Reimplemented in ilDatabaseMySQLTestsDataOutputs, and ilDatabasePostgresTestsDataOutputs.
◆ getIndexInfo()
| ilDatabaseCommonTestsDataOutputs::getIndexInfo | ( | $with_fulltext = false, |
|
$table_name = '' |
|||
| ) |
- Parameters
-
bool $with_fulltext string $table_name
- Returns
- array
Reimplemented in ilDatabasePostgresTestsDataOutputs.
Definition at line 16 of file class.ilDatabaseCommonTestsDataOutputs.php.
17 {
18 if ($with_fulltext) {
19 return array(
20 0 => array(
21 'name' => 'i1',
22 'fulltext' => false,
23 'fields' => array(
24 'init_mob_id' => array(
25 'position' => 1,
26 'sorting' => 'ascending',
27 ),
28 ),
29 ),
30 1 => array(
31 'name' => 'i2',
32 'fulltext' => true,
33 'fields' => array(
34 'address' => array(
35 'position' => 1,
36 'sorting' => null,
37 ),
38 ),
39 ),
40 );
41 } else {
42 return array(
43 0 => array(
44 'name' => 'i1',
45 'fulltext' => false,
46 'fields' => array(
47 'init_mob_id' => array(
48 'position' => 1,
49 'sorting' => 'ascending',
50 ),
51 ),
52 ),
53 );
54 }
55 }
◆ getListTables()
| ilDatabaseCommonTestsDataOutputs::getListTables | ( | $table_name | ) |
- Parameters
-
$table_name
- Returns
- array
Reimplemented in ilDatabasePostgresTestsDataOutputs.
Definition at line 644 of file class.ilDatabaseCommonTestsDataOutputs.php.
645 {
646 return array(
647 0 => 'abstraction_progress',
648 1 => 'acc_access_key',
649 2 => 'acc_cache',
650 3 => 'acc_user_access_key',
651 4 => 'acl_ws',
652 5 => 'addressbook_mlist',
653 6 => 'addressbook_mlist_ass',
654 7 => 'adl_shared_data',
655 8 => 'adm_set_templ_hide_tab',
656 9 => 'adm_set_templ_value',
657 10 => 'adm_settings_template',
658 11 => 'adv_md_obj_rec_select',
659 12 => 'adv_md_record',
660 13 => 'adv_md_record_objs',
661 14 => 'adv_md_substitutions',
662 15 => 'adv_md_values_date',
663 16 => 'adv_md_values_datetime',
664 17 => 'adv_md_values_float',
665 18 => 'adv_md_values_int',
666 19 => 'adv_md_values_location',
667 20 => 'adv_md_values_text',
668 21 => 'adv_mdf_definition',
669 22 => 'aicc_course',
670 23 => 'aicc_object',
671 24 => 'aicc_units',
672 25 => 'ass_log',
673 26 => 'background_task',
674 27 => 'badge_badge',
675 28 => 'badge_image_templ_type',
676 29 => 'badge_image_template',
677 30 => 'badge_user_badge',
678 31 => 'benchmark',
679 32 => 'booking_entry',
680 33 => 'booking_obj_assignment',
681 34 => 'booking_object',
682 35 => 'booking_reservation',
683 36 => 'booking_schedule',
684 37 => 'booking_schedule_slot',
685 38 => 'booking_settings',
686 39 => 'booking_user',
687 40 => 'bookmark_data',
688 41 => 'bookmark_tree',
689 42 => 'buddylist',
690 43 => 'buddylist_requests',
691 44 => 'cache_clob',
692 45 => 'cache_text',
693 46 => 'cal_auth_token',
694 47 => 'cal_cat_assignments',
695 48 => 'cal_categories',
696 49 => 'cal_categories_hidden',
697 50 => 'cal_ch_group',
698 51 => 'cal_ch_settings',
699 52 => 'cal_entries',
700 53 => 'cal_entry_responsible',
701 54 => 'cal_notification',
702 55 => 'cal_rec_exclusion',
703 56 => 'cal_recurrence_rules',
704 57 => 'cal_registrations',
705 58 => 'cal_shared',
706 59 => 'cal_shared_status',
707 60 => 'catch_write_events',
708 61 => 'chatroom_admconfig',
709 62 => 'chatroom_bans',
710 63 => 'chatroom_history',
711 64 => 'chatroom_proomaccess',
712 65 => 'chatroom_prooms',
713 66 => 'chatroom_psessions',
714 67 => 'chatroom_sessions',
715 68 => 'chatroom_settings',
716 69 => 'chatroom_smilies',
717 70 => 'chatroom_uploads',
718 71 => 'chatroom_users',
719 72 => 'cmi_comment',
720 73 => 'cmi_correct_response',
721 74 => 'cmi_custom',
722 75 => 'cmi_gobjective',
723 76 => 'cmi_interaction',
724 77 => 'cmi_node',
725 78 => 'cmi_objective',
726 79 => 'conditions',
727 80 => 'container_reference',
728 81 => 'container_settings',
729 82 => 'container_sorting',
730 83 => 'container_sorting_bl',
731 84 => 'container_sorting_set',
732 85 => 'content_object',
733 86 => 'copg_multilang',
734 87 => 'copg_multilang_lang',
735 88 => 'copg_pc_def',
736 89 => 'copg_pobj_def',
737 90 => 'copg_section_timings',
738 91 => 'copy_wizard_options',
739 92 => 'cp_auxilaryresource',
740 93 => 'cp_condition',
741 94 => 'cp_datamap',
742 95 => 'cp_dependency',
743 96 => 'cp_file',
744 97 => 'cp_hidelmsui',
745 98 => 'cp_item',
746 99 => 'cp_manifest',
747 100 => 'cp_mapinfo',
748 101 => 'cp_node',
749 102 => 'cp_objective',
750 103 => 'cp_organization',
751 104 => 'cp_package',
752 105 => 'cp_resource',
753 106 => 'cp_rule',
754 107 => 'cp_sequencing',
755 108 => 'cp_suspend',
756 109 => 'cp_tree',
757 110 => 'cron_job',
758 111 => 'crs_archives',
759 113 => 'crs_f_definitions',
760 114 => 'crs_file',
761 115 => 'crs_groupings',
762 116 => 'crs_items',
763 117 => 'crs_lm_history',
764 118 => 'crs_objective_lm',
765 119 => 'crs_objective_qst',
766 120 => 'crs_objective_status',
767 121 => 'crs_objective_status_p',
768 122 => 'crs_objective_tst',
769 123 => 'crs_objectives',
770 124 => 'crs_settings',
771 125 => 'crs_start',
772 126 => 'crs_timings_planed',
773 127 => 'crs_timings_usr_accept',
774 128 => 'crs_user_data',
775 129 => 'crs_waiting_list',
776 130 => 'ctrl_calls',
777 131 => 'ctrl_classfile',
778 132 => 'ctrl_structure',
779 133 => 'data_cache',
780 134 => 'dav_lock',
781 135 => 'dav_property',
782 136 => 'dbk_translations',
783 137 => 'desktop_item',
784 138 => 'didactic_tpl_a',
785 139 => 'didactic_tpl_abr',
786 140 => 'didactic_tpl_alp',
787 141 => 'didactic_tpl_alr',
788 142 => 'didactic_tpl_en',
789 143 => 'didactic_tpl_fp',
790 144 => 'didactic_tpl_objs',
791 145 => 'didactic_tpl_sa',
792 146 => 'didactic_tpl_settings',
793 147 => 'ecs_cmap_rule',
794 148 => 'ecs_cms_data',
795 149 => 'ecs_cms_tree',
796 150 => 'ecs_community',
797 151 => 'ecs_container_mapping',
798 152 => 'ecs_course_assignments',
799 153 => 'ecs_crs_mapping_atts',
800 154 => 'ecs_data_mapping',
801 155 => 'ecs_events',
802 156 => 'ecs_export',
803 157 => 'ecs_import',
804 158 => 'ecs_node_mapping_a',
805 159 => 'ecs_part_settings',
806 160 => 'ecs_remote_user',
807 161 => 'ecs_server',
808 162 => 'event',
809 163 => 'event_appointment',
810 164 => 'event_file',
811 165 => 'event_items',
812 166 => 'event_participants',
813 167 => 'exc_assignment',
814 168 => 'exc_assignment_peer',
815 169 => 'exc_crit',
816 170 => 'exc_crit_cat',
817 171 => 'exc_data',
818 172 => 'exc_idl',
819 173 => 'exc_mem_ass_status',
820 174 => 'exc_members',
821 175 => 'exc_returned',
822 176 => 'exc_usr_tutor',
823 177 => 'export_file_info',
824 178 => 'export_options',
825 179 => 'file_based_lm',
826 180 => 'file_data',
827 181 => 'file_usage',
828 182 => 'frm_data',
829 183 => 'frm_drafts_history',
830 184 => 'frm_notification',
831 185 => 'frm_posts',
832 186 => 'frm_posts_deleted',
833 187 => 'frm_posts_drafts',
834 188 => 'frm_posts_tree',
835 189 => 'frm_settings',
836 190 => 'frm_thread_access',
837 191 => 'frm_threads',
838 192 => 'frm_user_read',
839 193 => 'glo_advmd_col_order',
840 194 => 'glo_glossaries',
841 195 => 'glo_term_reference',
842 196 => 'glossary',
843 197 => 'glossary_definition',
844 198 => 'glossary_term',
845 199 => 'grp_settings',
846 200 => 'help_map',
847 201 => 'help_module',
848 202 => 'help_tooltip',
849 203 => 'history',
850 204 => 'il_bibl_attribute',
851 205 => 'il_bibl_data',
852 206 => 'il_bibl_entry',
853 207 => 'il_bibl_overview_model',
854 208 => 'il_bibl_settings',
855 209 => 'il_block_setting',
856 210 => 'il_blog',
857 211 => 'il_blog_posting',
858 212 => 'il_certificate',
859 213 => 'il_cld_data',
860 214 => 'il_component',
861 215 => 'il_custom_block',
862 216 => 'il_dcl_data',
863 217 => 'il_dcl_datatype',
864 218 => 'il_dcl_datatype_prop',
865 219 => 'il_dcl_field',
866 220 => 'il_dcl_field_prop',
867 221 => 'il_dcl_field_prop_b',
868 222 => 'il_dcl_field_prop_s_b',
869 223 => 'il_dcl_record',
870 224 => 'il_dcl_record_field',
871 225 => 'il_dcl_stloc1_value',
872 226 => 'il_dcl_stloc2_value',
873 227 => 'il_dcl_stloc3_value',
874 228 => 'il_dcl_table',
875 229 => 'il_dcl_tableview',
876 230 => 'il_dcl_tfield_set',
877 231 => 'il_dcl_tview_set',
878 232 => 'il_disk_quota',
879 233 => 'il_event_handling',
880 234 => 'il_exc_team',
881 235 => 'il_exc_team_log',
882 236 => 'il_external_feed_block',
883 237 => 'il_gc_memcache_server',
884 238 => 'il_html_block',
885 239 => 'il_md_cpr_selections',
886 240 => 'il_media_cast_data',
887 241 => 'il_media_cast_data_ord',
888 242 => 'il_meta_annotation',
889 243 => 'il_meta_classification',
890 244 => 'il_meta_contribute',
891 245 => 'il_meta_description',
892 246 => 'il_meta_educational',
893 247 => 'il_meta_entity',
894 248 => 'il_meta_format',
895 249 => 'il_meta_general',
896 250 => 'il_meta_identifier',
897 251 => 'il_meta_identifier_',
898 252 => 'il_meta_keyword',
899 253 => 'il_meta_language',
900 254 => 'il_meta_lifecycle',
901 255 => 'il_meta_location',
902 256 => 'il_meta_meta_data',
903 257 => 'il_meta_relation',
904 258 => 'il_meta_requirement',
905 259 => 'il_meta_rights',
906 260 => 'il_meta_tar',
907 261 => 'il_meta_taxon',
908 262 => 'il_meta_taxon_path',
909 263 => 'il_meta_technical',
910 264 => 'il_new_item_grp',
911 265 => 'il_news_item',
912 266 => 'il_news_read',
913 267 => 'il_news_subscription',
914 268 => 'il_object_def',
915 269 => 'il_object_group',
916 270 => 'il_object_sub_type',
917 271 => 'il_object_subobj',
918 272 => 'il_plugin',
919 273 => 'il_pluginslot',
920 274 => 'il_poll',
921 275 => 'il_poll_answer',
922 276 => 'il_poll_vote',
923 277 => 'il_qpl_qst_fq_res',
924 278 => 'il_qpl_qst_fq_res_unit',
925 279 => 'il_qpl_qst_fq_ucat',
926 280 => 'il_qpl_qst_fq_unit',
927 281 => 'il_qpl_qst_fq_var',
928 282 => 'il_rating',
929 283 => 'il_rating_cat',
930 284 => 'il_request_token',
931 285 => 'il_subscribers',
932 286 => 'il_tag',
933 287 => 'il_translations',
934 288 => $table_name,
935 289 => 'il_verification',
936 290 => 'il_wac_secure_path',
937 291 => 'il_wiki_contributor',
938 292 => 'il_wiki_data',
939 293 => 'il_wiki_imp_pages',
940 294 => 'il_wiki_missing_page',
941 295 => 'il_wiki_page',
942 296 => 'int_link',
943 297 => 'item_group_item',
944 298 => 'itgr_data',
945 299 => 'last_visited',
946 300 => 'ldap_attribute_mapping',
947 301 => 'ldap_rg_mapping',
948 302 => 'ldap_role_assignments',
949 303 => 'ldap_server_settings',
950 304 => 'license_data',
951 305 => 'link_check',
952 306 => 'link_check_report',
953 307 => 'lm_data',
954 308 => 'lm_data_transl',
955 309 => 'lm_glossaries',
956 310 => 'lm_menu',
957 311 => 'lm_read_event',
958 312 => 'lm_tree',
959 313 => 'lng_data',
960 314 => 'lng_log',
961 315 => 'lng_modules',
962 316 => 'lo_access',
963 317 => 'loc_rnd_qpl',
964 318 => 'loc_settings',
965 319 => 'loc_tst_assignments',
966 320 => 'loc_tst_run',
967 321 => 'loc_user_results',
968 322 => 'log_components',
969 323 => 'loginname_history',
970 324 => 'mail',
971 325 => 'mail_attachment',
972 326 => 'mail_cron_orphaned',
973 327 => 'mail_man_tpl',
974 328 => 'mail_obj_data',
975 329 => 'mail_options',
976 330 => 'mail_saved',
977 331 => 'mail_template',
978 332 => 'mail_tpl_ctx',
979 333 => 'mail_tree',
980 334 => 'map_area',
981 335 => 'mass_info_settings',
982 336 => 'mass_members',
983 337 => 'mass_settings',
984 338 => 'media_item',
985 339 => 'member_agreement',
986 340 => 'member_noti',
987 341 => 'member_noti_user',
988 342 => 'mep_data',
989 343 => 'mep_item',
990 344 => 'mep_tree',
991 345 => 'mob_parameter',
992 346 => 'mob_usage',
993 347 => 'module_class',
994 348 => 'note',
995 349 => 'note_settings',
996 350 => 'notification',
997 351 => 'notification_channels',
998 352 => 'notification_data',
999 353 => 'notification_listener',
1000 354 => 'notification_osd',
1001 355 => 'notification_queue',
1002 356 => 'notification_types',
1003 357 => 'notification_usercfg',
1004 358 => 'obj_content_master_lng',
1005 359 => 'obj_lp_stat',
1006 360 => 'obj_members',
1007 361 => 'obj_stat',
1008 362 => 'obj_stat_log',
1009 363 => 'obj_stat_tmp',
1010 364 => 'obj_type_stat',
1011 365 => 'obj_user_data_hist',
1012 366 => 'obj_user_stat',
1013 367 => 'object_data',
1014 368 => 'object_data_del',
1015 369 => 'object_description',
1016 370 => 'object_reference',
1017 371 => 'object_reference_ws',
1018 372 => 'object_translation',
1019 373 => 'openid_provider',
1020 374 => 'orgu_data',
1021 375 => 'orgu_path_storage',
1022 376 => 'orgu_types',
1023 377 => 'orgu_types_adv_md_rec',
1024 378 => 'orgu_types_trans',
1025 379 => 'osc_activity',
1026 380 => 'osc_conversation',
1027 381 => 'osc_messages',
1028 382 => 'page_anchor',
1029 383 => 'page_editor_settings',
1030 384 => 'page_history',
1031 385 => 'page_layout',
1032 386 => 'page_object',
1033 387 => 'page_pc_usage',
1034 388 => 'page_qst_answer',
1035 389 => 'page_question',
1036 390 => 'page_style_usage',
1037 391 => 'personal_clipboard',
1038 392 => 'personal_pc_clipboard',
1039 393 => 'pg_amd_page_list',
1040 394 => 'preview_data',
1041 395 => 'prg_settings',
1042 396 => 'prg_translations',
1043 397 => 'prg_type',
1044 398 => 'prg_type_adv_md_rec',
1045 399 => 'prg_usr_assignments',
1046 400 => 'prg_usr_progress',
1047 401 => 'qpl_a_cloze',
1048 402 => 'qpl_a_cloze_combi_res',
1049 403 => 'qpl_a_errortext',
1050 404 => 'qpl_a_essay',
1051 405 => 'qpl_a_imagemap',
1052 406 => 'qpl_a_kprim',
1053 407 => 'qpl_a_lome',
1054 408 => 'qpl_a_matching',
1055 409 => 'qpl_a_mc',
1056 410 => 'qpl_a_mdef',
1057 411 => 'qpl_a_mterm',
1058 412 => 'qpl_a_ordering',
1059 413 => 'qpl_a_sc',
1060 414 => 'qpl_a_textsubset',
1061 415 => 'qpl_fb_generic',
1062 416 => 'qpl_fb_specific',
1063 417 => 'qpl_hint_tracking',
1064 418 => 'qpl_hints',
1065 419 => 'qpl_num_range',
1066 420 => 'qpl_qst_cloze',
1067 421 => 'qpl_qst_errortext',
1068 422 => 'qpl_qst_essay',
1069 423 => 'qpl_qst_fileupload',
1070 424 => 'qpl_qst_flash',
1071 425 => 'qpl_qst_horder',
1072 426 => 'qpl_qst_imagemap',
1073 427 => 'qpl_qst_javaapplet',
1074 428 => 'qpl_qst_kprim',
1075 429 => 'qpl_qst_lome',
1076 430 => 'qpl_qst_matching',
1077 431 => 'qpl_qst_mc',
1078 432 => 'qpl_qst_numeric',
1079 433 => 'qpl_qst_ordering',
1080 434 => 'qpl_qst_sc',
1081 435 => 'qpl_qst_skl_assigns',
1082 436 => 'qpl_qst_skl_sol_expr',
1083 437 => 'qpl_qst_textsubset',
1084 438 => 'qpl_qst_type',
1085 439 => 'qpl_questionpool',
1086 440 => 'qpl_questions',
1087 441 => 'qpl_sol_sug',
1088 442 => 'rbac_fa',
1089 443 => 'rbac_log',
1090 444 => 'rbac_operations',
1091 445 => 'rbac_pa',
1092 446 => 'rbac_ta',
1093 447 => 'rbac_templates',
1094 448 => 'rbac_ua',
1095 449 => 'rcat_settings',
1096 450 => 'read_event',
1097 451 => 'reg_access_limit',
1098 452 => 'reg_er_assignments',
1099 453 => 'reg_registration_codes',
1100 454 => 'remote_course_settings',
1101 464 => 'rfil_settings',
1102 465 => 'rglo_settings',
1103 466 => 'rgrp_settings',
1104 467 => 'rlm_settings',
1105 468 => 'role_data',
1106 469 => 'role_desktop_items',
1107 470 => 'rtst_settings',
1108 471 => 'rwik_settings',
1109 472 => 'sahs_lm',
1110 473 => 'sahs_sc13_sco',
1111 474 => 'sahs_sc13_seq_assign',
1112 475 => 'sahs_sc13_seq_cond',
1113 476 => 'sahs_sc13_seq_course',
1114 477 => 'sahs_sc13_seq_item',
1115 478 => 'sahs_sc13_seq_mapinfo',
1116 479 => 'sahs_sc13_seq_node',
1117 480 => 'sahs_sc13_seq_obj',
1118 481 => 'sahs_sc13_seq_rule',
1119 482 => 'sahs_sc13_seq_templ',
1120 483 => 'sahs_sc13_seq_templts',
1121 484 => 'sahs_sc13_seq_tree',
1122 485 => 'sahs_sc13_tree',
1123 486 => 'sahs_sc13_tree_node',
1124 487 => 'sahs_user',
1125 488 => 'sc_item',
1126 489 => 'sc_manifest',
1127 490 => 'sc_organization',
1128 491 => 'sc_organizations',
1129 492 => 'sc_resource',
1130 493 => 'sc_resource_dependen',
1131 494 => 'sc_resource_file',
1132 495 => 'sc_resources',
1133 496 => 'scorm_object',
1134 497 => 'scorm_tracking',
1135 498 => 'scorm_tree',
1136 499 => 'search_command_queue',
1137 500 => 'search_data',
1138 501 => 'service_class',
1139 502 => 'settings',
1140 503 => 'settings_deactivated_s',
1141 504 => 'shib_role_assignment',
1142 505 => 'skl_assigned_material',
1143 506 => 'skl_level',
1144 507 => 'skl_personal_skill',
1145 508 => 'skl_profile',
1146 509 => 'skl_profile_level',
1147 510 => 'skl_profile_user',
1148 511 => 'skl_self_eval',
1149 512 => 'skl_self_eval_level',
1150 513 => 'skl_skill_resource',
1151 514 => 'skl_templ_ref',
1152 515 => 'skl_tree',
1153 516 => 'skl_tree_node',
1154 517 => 'skl_usage',
1155 518 => 'skl_user_has_level',
1156 519 => 'skl_user_skill_level',
1157 520 => 'sty_media_query',
1158 521 => 'style_char',
1159 522 => 'style_color',
1160 523 => 'style_data',
1161 524 => 'style_folder_styles',
1162 525 => 'style_parameter',
1163 526 => 'style_setting',
1164 527 => 'style_template',
1165 528 => 'style_template_class',
1166 529 => 'style_usage',
1167 530 => 'svy_360_appr',
1168 531 => 'svy_360_rater',
1169 532 => 'svy_anonymous',
1170 533 => 'svy_answer',
1171 534 => 'svy_category',
1172 535 => 'svy_constraint',
1173 536 => 'svy_finished',
1174 537 => 'svy_inv_usr',
1175 538 => 'svy_material',
1176 539 => 'svy_phrase',
1177 540 => 'svy_phrase_cat',
1178 541 => 'svy_qblk',
1179 542 => 'svy_qblk_qst',
1180 543 => 'svy_qpl',
1181 544 => 'svy_qst_constraint',
1182 545 => 'svy_qst_matrix',
1183 546 => 'svy_qst_matrixrows',
1184 547 => 'svy_qst_mc',
1185 548 => 'svy_qst_metric',
1186 549 => 'svy_qst_oblig',
1187 550 => 'svy_qst_sc',
1188 551 => 'svy_qst_text',
1189 552 => 'svy_qtype',
1190 553 => 'svy_quest_skill',
1191 554 => 'svy_question',
1192 555 => 'svy_relation',
1193 556 => 'svy_settings',
1194 557 => 'svy_skill_threshold',
1195 558 => 'svy_svy',
1196 559 => 'svy_svy_qst',
1197 560 => 'svy_times',
1198 561 => 'svy_variable',
1199 562 => 'sysc_groups',
1200 563 => 'sysc_tasks',
1201 564 => 'syst_style_cat',
1202 565 => 'table_properties',
1203 566 => 'table_templates',
1204 567 => 'tax_data',
1205 568 => 'tax_node',
1206 569 => 'tax_node_assignment',
1207 570 => 'tax_tree',
1208 571 => 'tax_usage',
1209 572 => 'tos_acceptance_track',
1210 573 => 'tos_versions',
1211 574 => 'tree',
1212 575 => 'tree_workspace',
1213 576 => 'tst_active',
1214 577 => 'tst_addtime',
1215 578 => 'tst_dyn_quest_set_cfg',
1216 579 => 'tst_invited_user',
1217 580 => 'tst_manual_fb',
1218 581 => 'tst_mark',
1219 582 => 'tst_pass_result',
1220 583 => 'tst_qst_solved',
1221 584 => 'tst_result_cache',
1222 585 => 'tst_rnd_cpy',
1223 586 => 'tst_rnd_qpl_title',
1224 587 => 'tst_rnd_quest_set_cfg',
1225 588 => 'tst_rnd_quest_set_qpls',
1226 589 => 'tst_seq_qst_answstatus',
1227 590 => 'tst_seq_qst_checked',
1228 591 => 'tst_seq_qst_optional',
1229 592 => 'tst_seq_qst_postponed',
1230 593 => 'tst_seq_qst_tracking',
1231 594 => 'tst_sequence',
1232 595 => 'tst_skl_thresholds',
1233 596 => 'tst_solutions',
1234 597 => 'tst_test_defaults',
1235 598 => 'tst_test_question',
1236 599 => 'tst_test_result',
1237 600 => 'tst_test_rnd_qst',
1238 601 => 'tst_tests',
1239 602 => 'tst_times',
1240 603 => 'udf_clob',
1241 604 => 'udf_data',
1242 605 => 'udf_definition',
1243 606 => 'udf_text',
1244 607 => 'user_action_activation',
1245 608 => 'usr_account_codes',
1246 609 => 'usr_cron_mail_reminder',
1247 610 => 'usr_data',
1248 611 => 'usr_data_multi',
1249 612 => 'usr_ext_profile_page',
1250 613 => 'usr_form_settings',
1251 614 => 'usr_portf_acl',
1252 615 => 'usr_portfolio',
1253 616 => 'usr_portfolio_page',
1254 617 => 'usr_pref',
1255 618 => 'usr_pwassist',
1256 619 => 'usr_search',
1257 620 => 'usr_sess_istorage',
1258 621 => 'usr_session',
1259 622 => 'usr_session_log',
1260 623 => 'usr_session_stats',
1261 624 => 'usr_session_stats_raw',
1262 625 => 'ut_lp_coll_manual',
1263 626 => 'ut_lp_collections',
1264 627 => 'ut_lp_defaults',
1265 628 => 'ut_lp_marks',
1266 629 => 'ut_lp_settings',
1267 630 => 'ut_lp_user_status',
1268 631 => 'ut_online',
1269 632 => 'webr_items',
1270 633 => 'webr_params',
1271 634 => 'wfe_det_listening',
1272 635 => 'wfe_startup_events',
1273 636 => 'wfe_static_inputs',
1274 637 => 'wfe_workflows',
1275 638 => 'wiki_page_template',
1276 639 => 'wiki_stat',
1277 640 => 'wiki_stat_page',
1278 641 => 'wiki_stat_page_user',
1279 642 => 'wiki_stat_user',
1280 643 => 'wiki_user_html_export',
1281 644 => 'write_event',
1282 645 => 'xhtml_page',
1283 648 => 'xmlnestedset',
1284 649 => 'xmlnestedsettmp',
1285 650 => 'xmlparam',
1286 651 => 'xmltags',
1287 652 => 'xmlvalue',
1288 );
1289 }
◆ getNativeTableIndices()
| ilDatabaseCommonTestsDataOutputs::getNativeTableIndices | ( | $table_name = '', |
|
$fulltext = false |
|||
| ) |
- Parameters
-
string $table_name
- Returns
- array
Reimplemented in ilDatabasePostgresTestsDataOutputs.
Definition at line 593 of file class.ilDatabaseCommonTestsDataOutputs.php.
594 {
595 if ($fulltext) {
596 return array(
597 0 => 'i1',
598 1 => 'i2',
599 );
600 }
601
602 return array(
603 0 => 'i1',
604 );
605 }
◆ getPrimaryInfo()
| ilDatabaseCommonTestsDataOutputs::getPrimaryInfo | ( | $table_name = '' | ) |
- Returns
- array
Reimplemented in ilDatabasePostgresTestsDataOutputs.
Definition at line 61 of file class.ilDatabaseCommonTestsDataOutputs.php.
62 {
63 return array(
64 'name' => 'primary',
65 'fields' => array(
66 'id' => array(
67 'position' => 1,
68 'sorting' => 'ascending',
69 ),
70 ),
71 );
72 }
◆ getTableConstraints()
| ilDatabaseCommonTestsDataOutputs::getTableConstraints | ( | $table_name = '' | ) |
- Returns
- array
Reimplemented in ilDatabasePostgresTestsDataOutputs.
Definition at line 611 of file class.ilDatabaseCommonTestsDataOutputs.php.
612 {
613 return array(
614 0 => 'primary',
615 );
616 }
◆ getTableFieldDefinition()
| ilDatabaseCommonTestsDataOutputs::getTableFieldDefinition | ( | ) |
- Returns
- array
Reimplemented in ilDatabasePostgresTestsDataOutputs.
Definition at line 284 of file class.ilDatabaseCommonTestsDataOutputs.php.
285 {
286 return array(
287 0 => array(
288 'notnull' => false,
289 'nativetype' => 'int',
290 'length' => 4,
291 'unsigned' => 0,
292 'default' => null,
293 'type' => 'integer',
294 'mdb2type' => 'integer',
295 ),
296 );
297 }
◆ getTableFields()
| ilDatabaseCommonTestsDataOutputs::getTableFields | ( | ) |
- Returns
- array
Definition at line 622 of file class.ilDatabaseCommonTestsDataOutputs.php.
623 {
624 return array(
625 0 => 'id',
626 1 => 'is_online',
627 2 => 'is_default',
628 3 => 'latitude',
629 4 => 'longitude',
630 5 => 'elevation',
631 6 => 'address',
632 7 => 'init_mob_id',
633 8 => 'comment_mob_id',
634 9 => 'container_id',
635 10 => 'big_data',
636 );
637 }
◆ getTableSequences()
| ilDatabaseCommonTestsDataOutputs::getTableSequences | ( | $table_name | ) |
- Parameters
-
$table_name
- Returns
- array
Reimplemented in ilDatabasePostgresTestsDataOutputs.
Definition at line 329 of file class.ilDatabaseCommonTestsDataOutputs.php.
330 {
331 $array = array(
332 0 => 'addressbook_mlist_ass',
333 1 => 'addressbook_mlist',
334 2 => 'adm_settings_template',
335 3 => 'adv_md_record',
336 4 => 'adv_mdf_definition',
337 5 => 'aicc_object',
338 6 => 'aicc_units',
339 7 => 'ass_log',
340 8 => 'benchmark',
341 9 => 'booking_entry',
342 10 => 'booking_object',
343 11 => 'booking_reservation_group',
344 12 => 'booking_reservation',
345 13 => 'booking_schedule',
346 14 => 'bookmark_data',
347 15 => 'bookmark_social_bm',
348 16 => 'cal_categories',
349 17 => 'cal_ch_group',
350 18 => 'cal_entries',
351 19 => 'cal_notification',
352 20 => 'cal_rec_exclusion',
353 21 => 'cal_recurrence_rules',
354 22 => 'chatroom_admconfig',
355 23 => 'chatroom_history',
356 24 => 'chatroom_prooms',
357 25 => 'chatroom_psessions',
358 26 => 'chatroom_sessions',
359 27 => 'chatroom_settings',
360 28 => 'chatroom_smilies',
361 29 => 'chatroom_uploads',
362 30 => 'cmi_comment',
363 31 => 'cmi_correct_response',
364 32 => 'cmi_interaction',
365 33 => 'cmi_node',
366 34 => 'cmi_objective',
367 35 => 'conditions',
368 36 => 'cp_node',
369 37 => 'crs_archives',
370 38 => 'crs_f_definitions',
371 39 => 'crs_file',
372 40 => 'crs_objective_lm',
373 41 => 'crs_objective_qst',
374 42 => 'crs_objective_tst',
375 43 => 'crs_objectives',
376 44 => 'crs_start',
377 45 => 'didactic_tpl_a',
378 46 => 'didactic_tpl_fp',
379 47 => 'didactic_tpl_settings',
380 48 => 'ecs_cmap_rule',
381 49 => 'ecs_cms_data',
382 50 => 'ecs_container_mapping',
383 51 => 'ecs_course_assignments',
384 52 => 'ecs_crs_mapping_atts',
385 53 => 'ecs_events',
386 54 => 'ecs_remote_user',
387 55 => 'ecs_server',
388 56 => 'event_appointment',
389 57 => 'event_file',
390 58 => 'event',
391 59 => 'exc_assignment',
392 60 => 'exc_crit_cat',
393 61 => 'exc_crit',
394 62 => 'exc_returned',
395 64 => 'frm_data',
396 65 => 'frm_notification',
397 66 => 'frm_posts_deleted',
398 67 => 'frm_posts',
399 68 => 'frm_posts_tree',
400 69 => 'frm_threads',
401 70 => 'glossary_definition',
402 71 => 'glossary_term',
403 72 => 'help_module',
404 73 => 'help_tooltip',
405 74 => 'history',
406 75 => 'il_bibl_attribute',
407 76 => 'il_bibl_entry',
408 77 => 'il_bibl_settings',
409 78 => 'il_blog_posting',
410 79 => 'il_custom_block',
411 80 => 'il_dcl_data',
412 81 => 'il_dcl_field_prop',
413 82 => 'il_dcl_field',
414 83 => 'il_dcl_record_field',
415 84 => 'il_dcl_record',
416 85 => 'il_dcl_stloc1_value',
417 86 => 'il_dcl_stloc2_value',
418 87 => 'il_dcl_stloc3_value',
419 88 => 'il_dcl_table',
420 89 => 'il_dcl_view',
421 90 => 'il_exc_team_log',
422 91 => 'il_exc_team',
423 92 => 'il_external_feed_block',
424 93 => 'il_gc_memcache_server',
425 94 => 'il_md_cpr_selections',
426 95 => 'il_meta_annotation',
427 96 => 'il_meta_classification',
428 97 => 'il_meta_contribute',
429 98 => 'il_meta_description',
430 99 => 'il_meta_educational',
431 100 => 'il_meta_entity',
432 101 => 'il_meta_format',
433 102 => 'il_meta_general',
434 103 => 'il_meta_identifier_',
435 104 => 'il_meta_identifier',
436 105 => 'il_meta_keyword',
437 106 => 'il_meta_language',
438 107 => 'il_meta_lifecycle',
439 108 => 'il_meta_location',
440 109 => 'il_meta_meta_data',
441 110 => 'il_meta_relation',
442 111 => 'il_meta_requirement',
443 112 => 'il_meta_rights',
444 113 => 'il_meta_tar',
445 114 => 'il_meta_taxon_path',
446 115 => 'il_meta_taxon',
447 116 => 'il_meta_technical',
448 117 => 'il_new_item_grp',
449 118 => 'il_news_item',
450 119 => 'il_poll_answer',
451 120 => 'il_qpl_qst_fq_res',
452 121 => 'il_qpl_qst_fq_res_unit',
453 122 => 'il_qpl_qst_fq_ucat',
454 123 => 'il_qpl_qst_fq_unit',
455 124 => 'il_qpl_qst_fq_var',
456 125 => 'il_rating_cat',
457 126 => $table_name,
458 127 => 'il_wiki_page',
459 128 => 'ldap_rg_mapping',
460 129 => 'ldap_role_assignments',
461 130 => 'ldap_server_settings',
462 131 => 'link_check',
463 132 => 'lm_data',
464 133 => 'lm_menu',
465 134 => 'loc_tst_assignments',
466 135 => 'mail_man_tpl',
467 136 => 'mail_obj_data',
468 137 => 'mail',
469 138 => 'media_item',
470 139 => 'mep_item',
471 140 => 'note',
472 141 => 'notification_data',
473 142 => 'notification_osd',
474 143 => 'obj_stat_log',
475 144 => 'object_data',
476 145 => 'object_reference',
477 146 => 'object_reference_ws',
478 147 => 'openid_provider',
479 148 => 'orgu_types',
480 149 => 'page_layout',
481 150 => 'page_style_usage',
482 151 => 'pg_amd_page_list',
483 152 => 'prg_settings',
484 153 => 'prg_translations',
485 154 => 'prg_type_adv_md_rec',
486 155 => 'prg_type',
487 156 => 'prg_usr_assignments',
488 157 => 'prg_usr_progress',
489 158 => 'qpl_a_cloze',
490 159 => 'qpl_a_errortext',
491 160 => 'qpl_a_essay',
492 161 => 'qpl_a_imagemap',
493 162 => 'qpl_a_matching',
494 163 => 'qpl_a_mc',
495 164 => 'qpl_a_mdef',
496 165 => 'qpl_a_mterm',
497 166 => 'qpl_a_ordering',
498 167 => 'qpl_a_sc',
499 168 => 'qpl_a_textsubset',
500 169 => 'qpl_fb_generic',
501 170 => 'qpl_fb_specific',
502 171 => 'qpl_hint_tracking',
503 172 => 'qpl_hints',
504 173 => 'qpl_num_range',
505 174 => 'qpl_questionpool',
506 175 => 'qpl_questions',
507 176 => 'qpl_sol_sug',
508 177 => 'rbac_log',
509 178 => 'rbac_operations',
510 179 => 'reg_er_assignments',
511 180 => 'reg_registration_codes',
512 181 => 'role_desktop_items',
513 182 => 'sahs_sc13_seq_node',
514 183 => 'sahs_sc13_seq',
515 184 => 'sahs_sc13_seq_templts',
516 185 => 'sahs_sc13_tree_node',
517 186 => 'sc_resource_dependen',
518 187 => 'sc_resource_file',
519 188 => 'scorm_object',
520 189 => 'search_data',
521 190 => 'shib_role_assignment',
522 191 => 'skl_level',
523 192 => 'skl_profile',
524 193 => 'skl_self_eval',
525 194 => 'skl_tree_node',
526 195 => 'sty_media_query',
527 196 => 'style_parameter',
528 197 => 'style_template',
529 198 => 'svy_anonymous',
530 199 => 'svy_answer',
531 200 => 'svy_category',
532 201 => 'svy_constraint',
533 202 => 'svy_finished',
534 203 => 'svy_inv_usr',
535 204 => 'svy_material',
536 205 => 'svy_phrase_cat',
537 206 => 'svy_phrase',
538 207 => 'svy_qblk_qst',
539 208 => 'svy_qblk',
540 209 => 'svy_qpl',
541 210 => 'svy_qst_constraint',
542 211 => 'svy_qst_matrixrows',
543 212 => 'svy_qst_oblig',
544 213 => 'svy_qtype',
545 214 => 'svy_question',
546 215 => 'svy_relation',
547 216 => 'svy_settings',
548 217 => 'svy_svy_qst',
549 218 => 'svy_svy',
550 219 => 'svy_times',
551 220 => 'svy_variable',
552 221 => 'sysc_groups',
553 222 => 'sysc_tasks',
554 223 => 'tax_node',
555 224 => 'tos_acceptance_track',
556 225 => 'tos_versions',
557 226 => 'tst_active',
558 227 => 'tst_manual_fb',
559 228 => 'tst_mark',
560 229 => 'tst_rnd_cpy',
561 230 => 'tst_rnd_qpl_title',
562 231 => 'tst_rnd_quest_set_qpls',
563 232 => 'tst_solutions',
564 233 => 'tst_test_defaults',
565 234 => 'tst_test_question',
566 235 => 'tst_test_result',
567 236 => 'tst_test_rnd_qst',
568 237 => 'tst_tests',
569 238 => 'tst_times',
570 239 => 'udf_definition',
571 240 => 'usr_account_codes',
572 241 => 'usr_data_multi',
573 242 => 'usr_ext_profile_page',
574 243 => 'usr_portfolio_page',
575 244 => 'webr_items',
576 245 => 'webr_params',
577 246 => 'write_event',
578 247 => 'xhtml_page',
579 248 => 'xmlnestedset',
580 249 => 'xmlnestedsettmp',
581 250 => 'xmltags',
582 251 => 'xmlvalue',
583 );
584
585 return array_values($array);
586 }
Field Documentation
◆ $analyzer_field_info
|
static |
Definition at line 78 of file class.ilDatabaseCommonTestsDataOutputs.php.
◆ $insert_sql_output
|
static |
Initial value:
= array(
'id' => '58',
'is_online' => '1',
'is_default' => '0',
'latitude' => '47.05983',
'longitude' => '7.624028',
'elevation' => '2.56',
'address' => 'Farbweg 9, 3400 Burgdorf',
'init_mob_id' => '78',
'comment_mob_id' => '69',
'container_id' => '456',
'big_data' => null,
)
Definition at line 204 of file class.ilDatabaseCommonTestsDataOutputs.php.
Referenced by ilDatabaseImplementationBaseTest\testInsertSQL().
◆ $output_after_native_input
|
static |
Initial value:
= array(
'id' => '56',
'is_online' => '1',
'is_default' => '0',
'latitude' => '47.05983',
'longitude' => '7.624028',
'elevation' => '2.56',
'address' => 'Farbweg 9, 3400 Burgdorf',
'init_mob_id' => '78',
'comment_mob_id' => '69',
'container_id' => '456',
'big_data' => 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.',
)
Definition at line 259 of file class.ilDatabaseCommonTestsDataOutputs.php.
Referenced by ilDatabaseImplementationBaseTest\testInsertNative().
◆ $output_after_native_update
|
static |
Initial value:
= array(
'id' => '56',
'is_online' => '1',
'is_default' => '0',
'latitude' => '47.05983',
'longitude' => '7.624028',
'elevation' => '2.56',
'address' => 'Farbweg 9, 3400 Burgdorf',
'init_mob_id' => '2222',
'comment_mob_id' => '69',
'container_id' => '456',
'big_data' => null,
)
Definition at line 243 of file class.ilDatabaseCommonTestsDataOutputs.php.
Referenced by ilDatabaseImplementationBaseTest\testUpdateNative().
◆ $select_usr_data_2_output
|
static |
Initial value:
= array(
array(
'usr_id' => '6',
'login' => 'root',
'is_self_registered' => '0',
),
array(
'usr_id' => '13',
'login' => 'anonymous',
'is_self_registered' => '0',
),
)
Definition at line 228 of file class.ilDatabaseCommonTestsDataOutputs.php.
Referenced by ilDatabaseImplementationBaseTest\testSelectUsrData().
◆ $select_usr_data_output
|
static |
Initial value:
= array(
'usr_id' => '6',
'login' => 'root',
'is_self_registered' => '0',
)
Definition at line 220 of file class.ilDatabaseCommonTestsDataOutputs.php.
Referenced by ilDatabaseImplementationBaseTest\testSelectUsrData().
◆ $table_constraint_definition_output
|
static |
Initial value:
= array(
'primary' => true,
'fields' => array(
'id' => array(
'position' => 1,
'sorting' => 'ascending',
),
),
)
Definition at line 314 of file class.ilDatabaseCommonTestsDataOutputs.php.
◆ $table_index_definition_output
|
static |
Initial value:
= array(
'fields' => array(
'init_mob_id' => array(
'position' => 1,
'sorting' => 'ascending',
),
),
)
Definition at line 303 of file class.ilDatabaseCommonTestsDataOutputs.php.
The documentation for this class was generated from the following file:
- Services/Database/test/Implementations/data/class.ilDatabaseCommonTestsDataOutputs.php
