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 }
like($a_col, $a_type, $a_value='?', $case_insensitive=true)
raiseError($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false)
checkIndexName($a_name)
dropTable($a_name, $a_error_if_not_existing=true)
fromUnixtime($a_expr, $a_to_text=true)
modifyTableColumn($a_table, $a_column, $a_attributes)
dropUniqueConstraintByFields($a_table, $a_fields)
setStorageEngine($a_storage_engine)
setDBSlaveActive($a_val)
sequenceExists($a_sequence)
setDBSlaveName($a_name)
getSequenceName($table_name)
isReservedWord($a_word)
isFulltextIndex($a_table, $a_name)
addTypesToArray($a_arr, $a_type, $a_cnt)
$code
Definition: example_050.php:99
setDBSlavePassword($a_password)
renameTableColumn($a_table, $a_column, $a_new_column)
quoteIdentifier($a_identifier, $check_option=false)
addUniqueConstraint($a_table, $a_fields, $a_name='con')
alterTable($a_name, $a_changes)
addTableColumn($a_table, $a_column, $a_attributes)
staticPushErrorHandling($mode, $options=null)
$engine
Definition: workflow.php:89
enableResultBuffering($a_status)
getRow($sql, $mode=3)
indexExistsByFields($a_table, $a_fields)
isError($data, $code=null)
setDBSlaveUser($a_user)
migrateAllTablesToEngine($engine='InnoDB')
dropIndexByFields($a_table, $a_fields)
replace($a_table, $a_pk_columns, $a_other_columns)
initFromIniFile($tmpClientIniFile=null)
createSequence($a_table_name, $a_start=1)
quote($a_query, $a_type=null)
createTable($a_name, $a_definition_array, $a_drop_table=false, $a_ignore_erros=false)
dropIndex($a_table, $a_name='in')
PEAR($error_class=null)
setErrorHandling($mode=null, $options=null)
if($modEnd===false) $module
Definition: module.php:59
dropFulltextIndex($a_table, $a_name)
Class ilDBLegacyInterface.
in($a_field, $a_values, $negate=false, $a_type='')
executeMultiple($a_stmt, $a_data)
$a_type
Definition: workflow.php:92
useSlave($a_val=true)
catch(Exception $e) $message
checkColumnName($a_name)
uniqueConstraintExists($a_table, $a_fields)
raisePearError($a_message, $a_level='')
query($sql, $a_handle_error=true)
connect($a_return_false_for_error=false)
pushErrorHandling($mode, $options=null)
autoExecute($a_tablename, $a_fields, $a_mode='MDB2_AUTOQUERY_INSERT', $a_where=false)
registerShutdownFunc($func, $args=array())
addPrimaryKey($a_table, $a_fields)
concat($a_values, $a_allow_null=true)
throwError($message=null, $code=null, $userinfo=null)
dropUniqueConstraint($a_table, $a_name='con')
dropSequence($a_table_name)
setDBSlavePort($a_port)
equals($a_col, $a_value, $a_type, $a_empty_or_null=false)
expectError($code=' *')
update($a_table, $a_columns, $a_where)
createDatabase($a_name, $a_charset='utf8', $a_collation='')
equalsNot($a_col, $a_value, $a_type, $a_empty_or_null=false)
substr($a_exp, $a_pos=1, $a_len=-1)
Create styles array
The data for the language used.
queryF($a_query, $a_types, $a_values)
setLimit($a_limit, $a_offset=0)
checkQuerySize($a_query)
setDBSlaveHost($a_host)
tableExists($a_table)
addFulltextIndex($a_table, $a_fields, $a_name='in')
addIndex($a_table, $a_fields, $a_name='in', $a_fulltext=false)
locate($a_needle, $a_string, $a_start_pos=1)
checkColumn($a_col, $a_def)
handleError($a_res, $a_info='', $a_level='')
fetchAll($query_result, $fetch_mode=2)
dropTableColumn($a_table, $a_column)
nextId($a_table_name)
tableColumnExists($a_table, $a_column_name)
getStaticProperty($class, $var)
dropPrimaryKey($a_table)
lockTables($a_tables)
manipulateF($a_query, $a_types, $a_values)
prepare($a_query, $a_types=null, $a_result_types=null)
setSubType($a_value)
_checkDelExpect($error_code)
setDBPassword($a_password)
delExpect($error_code)
checkColumnDefinition($a_def, $a_modify_mode=false)
checkTableName($a_name)
renameTable($a_name, $a_new_name)
constraintName($a_table, $a_constraint)
checkTableColumns($a_cols)
prepareManip($a_query, $a_types=null)
insert($a_table, $a_columns)
if(!isset($_REQUEST['ReturnTo'])) if(!isset($_REQUEST['AuthId'])) $options
Definition: as_login.php:20
execute($a_stmt, $a_data=null)