ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
interface.ilDBLegacyInterface.php
Go to the documentation of this file.
1<?php
2
13{
14 public function getDBType();
15
16
17 public function initConnection();
18
19
20 public function supportsFulltext();
21
22
23 public function getStorageEngine();
24
25
26 public function supportsSlave();
27
28
32 public function setDBSlaveActive($a_val);
33
34
35 public function getDBSlaveActive();
36
37
41 public function setDBSlaveUser($a_user);
42
43
44 public function getDBSlaveUser();
45
46
50 public function setDBSlavePort($a_port);
51
52
53 public function getDBSlavePort();
54
55
59 public function setDBSlaveHost($a_host);
60
61
62 public function getDBSlaveHost();
63
64
68 public function setDBSlavePassword($a_password);
69
70
71 public function getDBSlavePassword();
72
73
77 public function setDBSlaveName($a_name);
78
79
80 public function getDBSlaveName();
81
82
83 public function getDSN();
84
85
86 public function getSlaveDSN();
87
88
89 public function getHostDSN();
90
91
95 public function setStorageEngine($a_storage_engine);
96
97
98 public function getReservedWords();
99
100
104 public function initFromIniFile($tmpClientIniFile = null);
105
106
107 public function doConnect();
108
109
110 public function now();
111
112
113 public function getDBVersion();
114
115
116 public function isMysql4_0OrHigher();
117
118
119 public function isMysql4_1();
120
121
122 public function isMysql4_1OrHigher();
123
124
125 public function isMysql5_6OrHigher();
126
127
131 public function checkQuerySize($a_query);
132
133
139 public function addFulltextIndex($a_table, $a_fields, $a_name = 'in');
140
141
146 public function dropFulltextIndex($a_table, $a_name);
147
148
153 public function isFulltextIndex($a_table, $a_name);
154
155
159 public function lockTables($a_tables);
160
161
162 public function unlockTables();
163
164
165 public function getErrorNo();
166
167
168 public function getLastError();
169
170
175 public function query($sql, $a_handle_error = true);
176
177
181 public function loadModule($module);
182
183
187 public function setDBUser($a_user);
188
189
190 public function getDBUser();
191
192
196 public function setDBPort($a_port);
197
198
199 public function getDBPort();
200
201
205 public function setDBHost($a_host);
206
207
208 public function getDBHost();
209
210
214 public function setDBPassword($a_password);
215
216
217 public function getDBPassword();
218
219
223 public function setDBName($a_name);
224
225
226 public function getDBName();
227
228
232 public function enableResultBuffering($a_status);
233
234
238 public function connect($a_return_false_for_error = false);
239
240
241 public function disconnect();
242
243
244 public function connectHost();
245
246
250 public function supports($feature);
251
252
253 public function supportsTransactions();
254
255
259 public function useSlave($a_val = true);
260
261
267 public function handleError($a_res, $a_info = '', $a_level = '');
268
269
274 public function raisePearError($a_message, $a_level = '');
275
276
280 public function isDbError($a_res);
281
282
288 public function createDatabase($a_name, $a_charset = 'utf8', $a_collation = '');
289
290
297 public function createTable($a_name, $a_definition_array, $a_drop_table = false, $a_ignore_erros = false);
298
299
304 public function dropTable($a_name, $a_error_if_not_existing = true);
305
306
311 public function alterTable($a_name, $a_changes);
312
313
319 public function addTableColumn($a_table, $a_column, $a_attributes);
320
321
326 public function dropTableColumn($a_table, $a_column);
327
328
334 public function modifyTableColumn($a_table, $a_column, $a_attributes);
335
336
342 public function renameTableColumn($a_table, $a_column, $a_new_column);
343
344
349 public function renameTable($a_name, $a_new_name);
350
351
356 public function addPrimaryKey($a_table, $a_fields);
357
358
359 public function getPrimaryKeyIdentifier();
360
361
365 public function dropPrimaryKey($a_table);
366
367
374 public function addIndex($a_table, $a_fields, $a_name = 'in', $a_fulltext = false);
375
376
381 public function indexExistsByFields($a_table, $a_fields);
382
383
388 public function dropIndexByFields($a_table, $a_fields);
389
390
395 public function dropIndex($a_table, $a_name = 'in');
396
397
403 public function addUniqueConstraint($a_table, $a_fields, $a_name = 'con');
404
405
410 public function dropUniqueConstraint($a_table, $a_name = 'con');
411
412
417 public function dropUniqueConstraintByFields($a_table, $a_fields);
418
419
424 public function createSequence($a_table_name, $a_start = 1);
425
426
430 public function dropSequence($a_table_name);
431
432
436 public function checkTableName($a_name);
437
438
442 public function checkTableColumns($a_cols);
443
444
449 public function checkColumn($a_col, $a_def);
450
451
456 public function checkColumnDefinition($a_def, $a_modify_mode = false);
457
458
462 public function checkColumnName($a_name);
463
464
468 public function checkIndexName($a_name);
469
470
471 public function getAllowedAttributes();
472
473
478 public function constraintName($a_table, $a_constraint);
479
480
484 public function isReservedWord($a_word);
485
486
492 public function queryF($a_query, $a_types, $a_values);
493
494
500 public function manipulateF($a_query, $a_types, $a_values);
501
502
506 public function logStatement($sql);
507
508
513 public function setLimit($a_limit, $a_offset = 0);
514
515
519 public function nextId($a_table_name);
520
521
525 public function manipulate($sql);
526
527
533 public function prepare($a_query, $a_types = null, $a_result_types = null);
534
535
540 public function prepareManip($a_query, $a_types = null);
541
542
547 public function execute($a_stmt, $a_data = null);
548
549
554 public function executeMultiple($a_stmt, $a_data);
555
556
561 public function insert($a_table, $a_columns);
562
563
569 public function update($a_table, $a_columns, $a_where);
570
571
577 public function replace($a_table, $a_pk_columns, $a_other_columns);
578
579
583 public function fetchAssoc($a_set);
584
585
589 public function free($a_st);
590
591
595 public function fetchObject($a_set);
596
597
601 public function numRows($a_set);
602
603
610 public function in($a_field, $a_values, $negate = false, $a_type = '');
611
612
618 public function addTypesToArray($a_arr, $a_type, $a_cnt);
619
620
625 public function concat($a_values, $a_allow_null = true);
626
627
633 public function substr($a_exp, $a_pos = 1, $a_len = -1);
634
635
639 public function upper($a_exp);
640
641
645 public function lower($a_exp);
646
647
653 public function locate($a_needle, $a_string, $a_start_pos = 1);
654
655
662 public function like($a_col, $a_type, $a_value = '?', $case_insensitive = true);
663
664
671 public function equals($a_col, $a_value, $a_type, $a_empty_or_null = false);
672
673
680 public function equalsNot($a_col, $a_value, $a_type, $a_empty_or_null = false);
681
682
687 public function fromUnixtime($a_expr, $a_to_text = true);
688
689
690 public function unixTimestamp();
691
692
696 public function tableExists($a_table);
697
698
703 public function tableColumnExists($a_table, $a_column_name);
704
705
710 public function uniqueConstraintExists($a_table, $a_fields);
711
712
713 public function listTables();
714
715
719 public function sequenceExists($a_sequence);
720
721
722 public function listSequences();
723
724
729 public function quote($a_query, $a_type = null);
730
731
736 public function quoteIdentifier($a_identifier, $check_option = false);
737
738
739 public function beginTransaction();
740
741
742 public function commit();
743
744
745 public function rollback();
746
747
754 public function autoExecute($a_tablename, $a_fields, $a_mode = 'MDB2_AUTOQUERY_INSERT', $a_where = false);
755
756
757 public function getLastInsertId();
758
759
763 public function getOne($sql);
764
765
770 public function getRow($sql, $mode = 3);
771
772
777 public function fetchAll($query_result, $fetch_mode = 2);
778
779
783 public function setSubType($a_value);
784
785
786 public function getSubType();
787
788
792 public function migrateAllTablesToEngine($engine = 'InnoDB');
793
794
795 public function supportsEngineMigration();
796
797
801 public function getSequenceName($table_name);
802
803
804 public function buildAtomQuery();
805
806
810 public function PEAR($error_class = null);
811
812
813 public function _PEAR();
814
815
820 public function getStaticProperty($class, $var);
821
822
827 public function registerShutdownFunc($func, $args = array());
828
829
834 public function isError($data, $code = null);
835
836
841 public function setErrorHandling($mode = null, $options = null);
842
843
847 public function expectError($code = '*');
848
849
850 public function popExpect();
851
852
856 public function _checkDelExpect($error_code);
857
858
862 public function delExpect($error_code);
863
864
874 public function raiseError($message = null, $code = null, $mode = null, $options = null, $userinfo = null, $error_class = null, $skipmsg = false);
875
876
882 public function throwError($message = null, $code = null, $userinfo = null);
883
884
889 public function staticPushErrorHandling($mode, $options = null);
890
891
892 public function staticPopErrorHandling();
893
894
899 public function pushErrorHandling($mode, $options = null);
900
901
902 public function popErrorHandling();
903
904
908 public function loadExtension($ext);
909}
if(!isset( $_REQUEST[ 'ReturnTo'])) if(!isset($_REQUEST['AuthId'])) $options
Definition: as_login.php:20
An exception for terminatinating execution or to throw for unit testing.
$code
Definition: example_050.php:99
Class ilDBLegacyInterface.
query($sql, $a_handle_error=true)
dropFulltextIndex($a_table, $a_name)
renameTableColumn($a_table, $a_column, $a_new_column)
checkColumn($a_col, $a_def)
checkColumnDefinition($a_def, $a_modify_mode=false)
pushErrorHandling($mode, $options=null)
addPrimaryKey($a_table, $a_fields)
insert($a_table, $a_columns)
quote($a_query, $a_type=null)
dropIndexByFields($a_table, $a_fields)
setDBSlavePassword($a_password)
alterTable($a_name, $a_changes)
lockTables($a_tables)
equalsNot($a_col, $a_value, $a_type, $a_empty_or_null=false)
createTable($a_name, $a_definition_array, $a_drop_table=false, $a_ignore_erros=false)
quoteIdentifier($a_identifier, $check_option=false)
getSequenceName($table_name)
handleError($a_res, $a_info='', $a_level='')
modifyTableColumn($a_table, $a_column, $a_attributes)
tableColumnExists($a_table, $a_column_name)
dropPrimaryKey($a_table)
isError($data, $code=null)
renameTable($a_name, $a_new_name)
isReservedWord($a_word)
addIndex($a_table, $a_fields, $a_name='in', $a_fulltext=false)
throwError($message=null, $code=null, $userinfo=null)
executeMultiple($a_stmt, $a_data)
dropUniqueConstraint($a_table, $a_name='con')
getRow($sql, $mode=3)
raisePearError($a_message, $a_level='')
expectError($code=' *')
addUniqueConstraint($a_table, $a_fields, $a_name='con')
indexExistsByFields($a_table, $a_fields)
setDBSlaveActive($a_val)
PEAR($error_class=null)
in($a_field, $a_values, $negate=false, $a_type='')
execute($a_stmt, $a_data=null)
useSlave($a_val=true)
prepareManip($a_query, $a_types=null)
replace($a_table, $a_pk_columns, $a_other_columns)
prepare($a_query, $a_types=null, $a_result_types=null)
createSequence($a_table_name, $a_start=1)
setDBSlaveHost($a_host)
migrateAllTablesToEngine($engine='InnoDB')
setStorageEngine($a_storage_engine)
like($a_col, $a_type, $a_value='?', $case_insensitive=true)
dropSequence($a_table_name)
fetchAll($query_result, $fetch_mode=2)
checkIndexName($a_name)
dropTable($a_name, $a_error_if_not_existing=true)
substr($a_exp, $a_pos=1, $a_len=-1)
connect($a_return_false_for_error=false)
dropIndex($a_table, $a_name='in')
enableResultBuffering($a_status)
queryF($a_query, $a_types, $a_values)
uniqueConstraintExists($a_table, $a_fields)
setDBSlaveName($a_name)
locate($a_needle, $a_string, $a_start_pos=1)
setDBPassword($a_password)
delExpect($error_code)
isFulltextIndex($a_table, $a_name)
checkTableColumns($a_cols)
addFulltextIndex($a_table, $a_fields, $a_name='in')
addTableColumn($a_table, $a_column, $a_attributes)
tableExists($a_table)
createDatabase($a_name, $a_charset='utf8', $a_collation='')
dropTableColumn($a_table, $a_column)
equals($a_col, $a_value, $a_type, $a_empty_or_null=false)
update($a_table, $a_columns, $a_where)
checkQuerySize($a_query)
getStaticProperty($class, $var)
setErrorHandling($mode=null, $options=null)
fromUnixtime($a_expr, $a_to_text=true)
setDBSlaveUser($a_user)
dropUniqueConstraintByFields($a_table, $a_fields)
registerShutdownFunc($func, $args=array())
setDBSlavePort($a_port)
nextId($a_table_name)
checkTableName($a_name)
constraintName($a_table, $a_constraint)
initFromIniFile($tmpClientIniFile=null)
addTypesToArray($a_arr, $a_type, $a_cnt)
manipulateF($a_query, $a_types, $a_values)
autoExecute($a_tablename, $a_fields, $a_mode='MDB2_AUTOQUERY_INSERT', $a_where=false)
staticPushErrorHandling($mode, $options=null)
setSubType($a_value)
raiseError($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false)
_checkDelExpect($error_code)
checkColumnName($a_name)
concat($a_values, $a_allow_null=true)
sequenceExists($a_sequence)
setLimit($a_limit, $a_offset=0)
catch(Exception $e) $message
if($modEnd===false) $module
Definition: module.php:59
$engine
Definition: workflow.php:89
$a_type
Definition: workflow.php:92