ILIAS
release_5-3 Revision v5.3.23-19-g915713cf615
|
Class ilDBLegacyInterface. More...
Public Member Functions | |
getDBType () | |
initConnection () | |
supportsFulltext () | |
getStorageEngine () | |
supportsSlave () | |
setDBSlaveActive ($a_val) | |
getDBSlaveActive () | |
setDBSlaveUser ($a_user) | |
getDBSlaveUser () | |
setDBSlavePort ($a_port) | |
getDBSlavePort () | |
setDBSlaveHost ($a_host) | |
getDBSlaveHost () | |
setDBSlavePassword ($a_password) | |
getDBSlavePassword () | |
setDBSlaveName ($a_name) | |
getDBSlaveName () | |
getDSN () | |
getSlaveDSN () | |
getHostDSN () | |
setStorageEngine ($a_storage_engine) | |
getReservedWords () | |
initFromIniFile ($tmpClientIniFile=null) | |
doConnect () | |
now () | |
getDBVersion () | |
isMysql4_0OrHigher () | |
isMysql4_1 () | |
isMysql4_1OrHigher () | |
isMysql5_6OrHigher () | |
checkQuerySize ($a_query) | |
addFulltextIndex ($a_table, $a_fields, $a_name='in') | |
dropFulltextIndex ($a_table, $a_name) | |
isFulltextIndex ($a_table, $a_name) | |
lockTables ($a_tables) | |
unlockTables () | |
getErrorNo () | |
getLastError () | |
query ($sql, $a_handle_error=true) | |
loadModule ($module) | |
setDBUser ($a_user) | |
getDBUser () | |
setDBPort ($a_port) | |
getDBPort () | |
setDBHost ($a_host) | |
getDBHost () | |
setDBPassword ($a_password) | |
getDBPassword () | |
setDBName ($a_name) | |
getDBName () | |
enableResultBuffering ($a_status) | |
connect ($a_return_false_for_error=false) | |
disconnect () | |
connectHost () | |
supports ($feature) | |
supportsTransactions () | |
useSlave ($a_val=true) | |
handleError ($a_res, $a_info='', $a_level='') | |
raisePearError ($a_message, $a_level='') | |
isDbError ($a_res) | |
createDatabase ($a_name, $a_charset='utf8', $a_collation='') | |
createTable ($a_name, $a_definition_array, $a_drop_table=false, $a_ignore_erros=false) | |
dropTable ($a_name, $a_error_if_not_existing=true) | |
alterTable ($a_name, $a_changes) | |
addTableColumn ($a_table, $a_column, $a_attributes) | |
dropTableColumn ($a_table, $a_column) | |
modifyTableColumn ($a_table, $a_column, $a_attributes) | |
renameTableColumn ($a_table, $a_column, $a_new_column) | |
renameTable ($a_name, $a_new_name) | |
addPrimaryKey ($a_table, $a_fields) | |
getPrimaryKeyIdentifier () | |
dropPrimaryKey ($a_table) | |
addIndex ($a_table, $a_fields, $a_name='in', $a_fulltext=false) | |
indexExistsByFields ($a_table, $a_fields) | |
dropIndexByFields ($a_table, $a_fields) | |
dropIndex ($a_table, $a_name='in') | |
addUniqueConstraint ($a_table, $a_fields, $a_name='con') | |
dropUniqueConstraint ($a_table, $a_name='con') | |
dropUniqueConstraintByFields ($a_table, $a_fields) | |
createSequence ($a_table_name, $a_start=1) | |
dropSequence ($a_table_name) | |
checkTableName ($a_name) | |
checkTableColumns ($a_cols) | |
checkColumn ($a_col, $a_def) | |
checkColumnDefinition ($a_def, $a_modify_mode=false) | |
checkColumnName ($a_name) | |
checkIndexName ($a_name) | |
getAllowedAttributes () | |
constraintName ($a_table, $a_constraint) | |
isReservedWord ($a_word) | |
queryF ($a_query, $a_types, $a_values) | |
manipulateF ($a_query, $a_types, $a_values) | |
logStatement ($sql) | |
setLimit ($a_limit, $a_offset=0) | |
nextId ($a_table_name) | |
manipulate ($sql) | |
prepare ($a_query, $a_types=null, $a_result_types=null) | |
prepareManip ($a_query, $a_types=null) | |
execute ($a_stmt, $a_data=null) | |
executeMultiple ($a_stmt, $a_data) | |
insert ($a_table, $a_columns) | |
update ($a_table, $a_columns, $a_where) | |
replace ($a_table, $a_pk_columns, $a_other_columns) | |
fetchAssoc ($a_set) | |
free ($a_st) | |
fetchObject ($a_set) | |
numRows ($a_set) | |
in ($a_field, $a_values, $negate=false, $a_type='') | |
addTypesToArray ($a_arr, $a_type, $a_cnt) | |
concat ($a_values, $a_allow_null=true) | |
substr ($a_exp, $a_pos=1, $a_len=-1) | |
upper ($a_exp) | |
lower ($a_exp) | |
locate ($a_needle, $a_string, $a_start_pos=1) | |
like ($a_col, $a_type, $a_value='?', $case_insensitive=true) | |
equals ($a_col, $a_value, $a_type, $a_empty_or_null=false) | |
equalsNot ($a_col, $a_value, $a_type, $a_empty_or_null=false) | |
fromUnixtime ($a_expr, $a_to_text=true) | |
unixTimestamp () | |
tableExists ($a_table) | |
tableColumnExists ($a_table, $a_column_name) | |
uniqueConstraintExists ($a_table, $a_fields) | |
listTables () | |
sequenceExists ($a_sequence) | |
listSequences () | |
quote ($a_query, $a_type=null) | |
quoteIdentifier ($a_identifier, $check_option=false) | |
beginTransaction () | |
commit () | |
rollback () | |
autoExecute ($a_tablename, $a_fields, $a_mode='MDB2_AUTOQUERY_INSERT', $a_where=false) | |
getLastInsertId () | |
getOne ($sql) | |
getRow ($sql, $mode=3) | |
fetchAll ($query_result, $fetch_mode=2) | |
setSubType ($a_value) | |
getSubType () | |
migrateAllTablesToEngine ($engine='InnoDB') | |
supportsEngineMigration () | |
getSequenceName ($table_name) | |
buildAtomQuery () | |
PEAR ($error_class=null) | |
_PEAR () | |
getStaticProperty ($class, $var) | |
registerShutdownFunc ($func, $args=array()) | |
isError ($data, $code=null) | |
setErrorHandling ($mode=null, $options=null) | |
expectError ($code=' *') | |
popExpect () | |
_checkDelExpect ($error_code) | |
delExpect ($error_code) | |
raiseError ($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false) | |
throwError ($message=null, $code=null, $userinfo=null) | |
staticPushErrorHandling ($mode, $options=null) | |
staticPopErrorHandling () | |
pushErrorHandling ($mode, $options=null) | |
popErrorHandling () | |
loadExtension ($ext) | |
Class ilDBLegacyInterface.
These are all public methods from ilDBInnoDB
Currently unused, will be used to find missing methods in PDO and to discuss if they are still needed
Definition at line 12 of file interface.ilDBLegacyInterface.php.
ilDBLegacyInterface::_checkDelExpect | ( | $error_code | ) |
error_code |
ilDBLegacyInterface::_PEAR | ( | ) |
ilDBLegacyInterface::addFulltextIndex | ( | $a_table, | |
$a_fields, | |||
$a_name = 'in' |
|||
) |
a_table | |
a_fields | |
a_name |
ilDBLegacyInterface::addIndex | ( | $a_table, | |
$a_fields, | |||
$a_name = 'in' , |
|||
$a_fulltext = false |
|||
) |
a_table | |
a_fields | |
a_name | |
a_fulltext |
ilDBLegacyInterface::addPrimaryKey | ( | $a_table, | |
$a_fields | |||
) |
a_table | |
a_fields |
ilDBLegacyInterface::addTableColumn | ( | $a_table, | |
$a_column, | |||
$a_attributes | |||
) |
a_table | |
a_column | |
a_attributes |
ilDBLegacyInterface::addTypesToArray | ( | $a_arr, | |
$a_type, | |||
$a_cnt | |||
) |
a_arr | |
a_type | |
a_cnt |
ilDBLegacyInterface::addUniqueConstraint | ( | $a_table, | |
$a_fields, | |||
$a_name = 'con' |
|||
) |
a_table | |
a_fields | |
a_name |
ilDBLegacyInterface::alterTable | ( | $a_name, | |
$a_changes | |||
) |
a_name | |
a_changes |
ilDBLegacyInterface::autoExecute | ( | $a_tablename, | |
$a_fields, | |||
$a_mode = 'MDB2_AUTOQUERY_INSERT' , |
|||
$a_where = false |
|||
) |
a_tablename | |
a_fields | |
a_mode | |
a_where |
ilDBLegacyInterface::beginTransaction | ( | ) |
ilDBLegacyInterface::buildAtomQuery | ( | ) |
ilDBLegacyInterface::checkColumn | ( | $a_col, | |
$a_def | |||
) |
a_col | |
a_def |
ilDBLegacyInterface::checkColumnDefinition | ( | $a_def, | |
$a_modify_mode = false |
|||
) |
a_def | |
a_modify_mode |
ilDBLegacyInterface::checkColumnName | ( | $a_name | ) |
a_name |
ilDBLegacyInterface::checkIndexName | ( | $a_name | ) |
a_name |
ilDBLegacyInterface::checkQuerySize | ( | $a_query | ) |
a_query |
ilDBLegacyInterface::checkTableColumns | ( | $a_cols | ) |
a_cols |
ilDBLegacyInterface::checkTableName | ( | $a_name | ) |
a_name |
ilDBLegacyInterface::commit | ( | ) |
ilDBLegacyInterface::concat | ( | $a_values, | |
$a_allow_null = true |
|||
) |
a_values | |
a_allow_null |
ilDBLegacyInterface::connect | ( | $a_return_false_for_error = false | ) |
a_return_false_for_error |
ilDBLegacyInterface::connectHost | ( | ) |
ilDBLegacyInterface::constraintName | ( | $a_table, | |
$a_constraint | |||
) |
a_table | |
a_constraint |
ilDBLegacyInterface::createDatabase | ( | $a_name, | |
$a_charset = 'utf8' , |
|||
$a_collation = '' |
|||
) |
a_name | |
a_charset | |
a_collation |
ilDBLegacyInterface::createSequence | ( | $a_table_name, | |
$a_start = 1 |
|||
) |
a_table_name | |
a_start |
ilDBLegacyInterface::createTable | ( | $a_name, | |
$a_definition_array, | |||
$a_drop_table = false , |
|||
$a_ignore_erros = false |
|||
) |
a_name | |
a_definition_array | |
a_drop_table | |
a_ignore_erros |
ilDBLegacyInterface::delExpect | ( | $error_code | ) |
error_code |
ilDBLegacyInterface::disconnect | ( | ) |
ilDBLegacyInterface::doConnect | ( | ) |
ilDBLegacyInterface::dropFulltextIndex | ( | $a_table, | |
$a_name | |||
) |
a_table | |
a_name |
ilDBLegacyInterface::dropIndex | ( | $a_table, | |
$a_name = 'in' |
|||
) |
a_table | |
a_name |
ilDBLegacyInterface::dropIndexByFields | ( | $a_table, | |
$a_fields | |||
) |
a_table | |
a_fields |
ilDBLegacyInterface::dropPrimaryKey | ( | $a_table | ) |
a_table |
ilDBLegacyInterface::dropSequence | ( | $a_table_name | ) |
a_table_name |
ilDBLegacyInterface::dropTable | ( | $a_name, | |
$a_error_if_not_existing = true |
|||
) |
a_name | |
a_error_if_not_existing |
ilDBLegacyInterface::dropTableColumn | ( | $a_table, | |
$a_column | |||
) |
a_table | |
a_column |
ilDBLegacyInterface::dropUniqueConstraint | ( | $a_table, | |
$a_name = 'con' |
|||
) |
a_table | |
a_name |
ilDBLegacyInterface::dropUniqueConstraintByFields | ( | $a_table, | |
$a_fields | |||
) |
a_table | |
a_fields |
ilDBLegacyInterface::enableResultBuffering | ( | $a_status | ) |
a_status |
ilDBLegacyInterface::equals | ( | $a_col, | |
$a_value, | |||
$a_type, | |||
$a_empty_or_null = false |
|||
) |
a_col | |
a_value | |
a_type | |
a_empty_or_null |
ilDBLegacyInterface::equalsNot | ( | $a_col, | |
$a_value, | |||
$a_type, | |||
$a_empty_or_null = false |
|||
) |
a_col | |
a_value | |
a_type | |
a_empty_or_null |
ilDBLegacyInterface::execute | ( | $a_stmt, | |
$a_data = null |
|||
) |
a_stmt | |
a_data |
ilDBLegacyInterface::executeMultiple | ( | $a_stmt, | |
$a_data | |||
) |
a_stmt | |
a_data |
ilDBLegacyInterface::expectError | ( | $code = ' *' | ) |
code |
ilDBLegacyInterface::fetchAll | ( | $query_result, | |
$fetch_mode = 2 |
|||
) |
query_result | |
fetch_mode |
ilDBLegacyInterface::fetchAssoc | ( | $a_set | ) |
a_set |
ilDBLegacyInterface::fetchObject | ( | $a_set | ) |
a_set |
ilDBLegacyInterface::free | ( | $a_st | ) |
a_st |
ilDBLegacyInterface::fromUnixtime | ( | $a_expr, | |
$a_to_text = true |
|||
) |
a_expr | |
a_to_text |
ilDBLegacyInterface::getAllowedAttributes | ( | ) |
ilDBLegacyInterface::getDBHost | ( | ) |
ilDBLegacyInterface::getDBName | ( | ) |
ilDBLegacyInterface::getDBPassword | ( | ) |
ilDBLegacyInterface::getDBPort | ( | ) |
ilDBLegacyInterface::getDBSlaveActive | ( | ) |
ilDBLegacyInterface::getDBSlaveHost | ( | ) |
ilDBLegacyInterface::getDBSlaveName | ( | ) |
ilDBLegacyInterface::getDBSlavePassword | ( | ) |
ilDBLegacyInterface::getDBSlavePort | ( | ) |
ilDBLegacyInterface::getDBSlaveUser | ( | ) |
ilDBLegacyInterface::getDBType | ( | ) |
ilDBLegacyInterface::getDBUser | ( | ) |
ilDBLegacyInterface::getDBVersion | ( | ) |
ilDBLegacyInterface::getDSN | ( | ) |
ilDBLegacyInterface::getErrorNo | ( | ) |
ilDBLegacyInterface::getHostDSN | ( | ) |
ilDBLegacyInterface::getLastError | ( | ) |
ilDBLegacyInterface::getLastInsertId | ( | ) |
ilDBLegacyInterface::getOne | ( | $sql | ) |
sql |
ilDBLegacyInterface::getPrimaryKeyIdentifier | ( | ) |
ilDBLegacyInterface::getReservedWords | ( | ) |
ilDBLegacyInterface::getRow | ( | $sql, | |
$mode = 3 |
|||
) |
sql | |
mode |
ilDBLegacyInterface::getSequenceName | ( | $table_name | ) |
table_name |
ilDBLegacyInterface::getSlaveDSN | ( | ) |
ilDBLegacyInterface::getStaticProperty | ( | $class, | |
$var | |||
) |
class | |
var |
ilDBLegacyInterface::getStorageEngine | ( | ) |
ilDBLegacyInterface::getSubType | ( | ) |
ilDBLegacyInterface::handleError | ( | $a_res, | |
$a_info = '' , |
|||
$a_level = '' |
|||
) |
a_res | |
a_info | |
a_level |
ilDBLegacyInterface::in | ( | $a_field, | |
$a_values, | |||
$negate = false , |
|||
$a_type = '' |
|||
) |
a_field | |
a_values | |
negate | |
a_type |
ilDBLegacyInterface::indexExistsByFields | ( | $a_table, | |
$a_fields | |||
) |
a_table | |
a_fields |
ilDBLegacyInterface::initConnection | ( | ) |
ilDBLegacyInterface::initFromIniFile | ( | $tmpClientIniFile = null | ) |
tmpClientIniFile |
ilDBLegacyInterface::insert | ( | $a_table, | |
$a_columns | |||
) |
a_table | |
a_columns |
ilDBLegacyInterface::isDbError | ( | $a_res | ) |
a_res |
ilDBLegacyInterface::isError | ( | $data, | |
$code = null |
|||
) |
data | |
code |
ilDBLegacyInterface::isFulltextIndex | ( | $a_table, | |
$a_name | |||
) |
a_table | |
a_name |
ilDBLegacyInterface::isMysql4_0OrHigher | ( | ) |
ilDBLegacyInterface::isMysql4_1 | ( | ) |
ilDBLegacyInterface::isMysql4_1OrHigher | ( | ) |
ilDBLegacyInterface::isMysql5_6OrHigher | ( | ) |
ilDBLegacyInterface::isReservedWord | ( | $a_word | ) |
a_word |
ilDBLegacyInterface::like | ( | $a_col, | |
$a_type, | |||
$a_value = '?' , |
|||
$case_insensitive = true |
|||
) |
a_col | |
a_type | |
a_value | |
case_insensitive |
ilDBLegacyInterface::listSequences | ( | ) |
ilDBLegacyInterface::listTables | ( | ) |
ilDBLegacyInterface::loadExtension | ( | $ext | ) |
ext |
ilDBLegacyInterface::loadModule | ( | $module | ) |
module |
ilDBLegacyInterface::locate | ( | $a_needle, | |
$a_string, | |||
$a_start_pos = 1 |
|||
) |
a_needle | |
a_string | |
a_start_pos |
ilDBLegacyInterface::lockTables | ( | $a_tables | ) |
a_tables |
ilDBLegacyInterface::logStatement | ( | $sql | ) |
sql |
ilDBLegacyInterface::lower | ( | $a_exp | ) |
a_exp |
ilDBLegacyInterface::manipulate | ( | $sql | ) |
sql |
ilDBLegacyInterface::manipulateF | ( | $a_query, | |
$a_types, | |||
$a_values | |||
) |
a_query | |
a_types | |
a_values |
ilDBLegacyInterface::migrateAllTablesToEngine | ( | $engine = 'InnoDB' | ) |
engine |
ilDBLegacyInterface::modifyTableColumn | ( | $a_table, | |
$a_column, | |||
$a_attributes | |||
) |
a_table | |
a_column | |
a_attributes |
ilDBLegacyInterface::nextId | ( | $a_table_name | ) |
a_table_name |
ilDBLegacyInterface::now | ( | ) |
ilDBLegacyInterface::numRows | ( | $a_set | ) |
a_set |
ilDBLegacyInterface::PEAR | ( | $error_class = null | ) |
error_class |
ilDBLegacyInterface::popErrorHandling | ( | ) |
ilDBLegacyInterface::popExpect | ( | ) |
ilDBLegacyInterface::prepare | ( | $a_query, | |
$a_types = null , |
|||
$a_result_types = null |
|||
) |
a_query | |
a_types | |
a_result_types |
ilDBLegacyInterface::prepareManip | ( | $a_query, | |
$a_types = null |
|||
) |
a_query | |
a_types |
ilDBLegacyInterface::pushErrorHandling | ( | $mode, | |
$options = null |
|||
) |
mode | |
options |
ilDBLegacyInterface::query | ( | $sql, | |
$a_handle_error = true |
|||
) |
sql | |
a_handle_error |
ilDBLegacyInterface::queryF | ( | $a_query, | |
$a_types, | |||
$a_values | |||
) |
a_query | |
a_types | |
a_values |
ilDBLegacyInterface::quote | ( | $a_query, | |
$a_type = null |
|||
) |
a_query | |
a_type |
ilDBLegacyInterface::quoteIdentifier | ( | $a_identifier, | |
$check_option = false |
|||
) |
a_identifier | |
check_option |
ilDBLegacyInterface::raiseError | ( | $message = null , |
|
$code = null , |
|||
$mode = null , |
|||
$options = null , |
|||
$userinfo = null , |
|||
$error_class = null , |
|||
$skipmsg = false |
|||
) |
message | |
code | |
mode | |
options | |
userinfo | |
error_class | |
skipmsg |
ilDBLegacyInterface::raisePearError | ( | $a_message, | |
$a_level = '' |
|||
) |
a_message | |
a_level |
ilDBLegacyInterface::registerShutdownFunc | ( | $func, | |
$args = array() |
|||
) |
func | |
args |
ilDBLegacyInterface::renameTable | ( | $a_name, | |
$a_new_name | |||
) |
a_name | |
a_new_name |
ilDBLegacyInterface::renameTableColumn | ( | $a_table, | |
$a_column, | |||
$a_new_column | |||
) |
a_table | |
a_column | |
a_new_column |
ilDBLegacyInterface::replace | ( | $a_table, | |
$a_pk_columns, | |||
$a_other_columns | |||
) |
a_table | |
a_pk_columns | |
a_other_columns |
ilDBLegacyInterface::rollback | ( | ) |
ilDBLegacyInterface::sequenceExists | ( | $a_sequence | ) |
a_sequence |
ilDBLegacyInterface::setDBHost | ( | $a_host | ) |
a_host |
ilDBLegacyInterface::setDBName | ( | $a_name | ) |
a_name |
ilDBLegacyInterface::setDBPassword | ( | $a_password | ) |
a_password |
ilDBLegacyInterface::setDBPort | ( | $a_port | ) |
a_port |
ilDBLegacyInterface::setDBSlaveActive | ( | $a_val | ) |
a_val |
ilDBLegacyInterface::setDBSlaveHost | ( | $a_host | ) |
a_host |
ilDBLegacyInterface::setDBSlaveName | ( | $a_name | ) |
a_name |
ilDBLegacyInterface::setDBSlavePassword | ( | $a_password | ) |
a_password |
ilDBLegacyInterface::setDBSlavePort | ( | $a_port | ) |
a_port |
ilDBLegacyInterface::setDBSlaveUser | ( | $a_user | ) |
a_user |
ilDBLegacyInterface::setDBUser | ( | $a_user | ) |
a_user |
ilDBLegacyInterface::setErrorHandling | ( | $mode = null , |
|
$options = null |
|||
) |
mode | |
options |
ilDBLegacyInterface::setLimit | ( | $a_limit, | |
$a_offset = 0 |
|||
) |
a_limit | |
a_offset |
ilDBLegacyInterface::setStorageEngine | ( | $a_storage_engine | ) |
a_storage_engine |
ilDBLegacyInterface::setSubType | ( | $a_value | ) |
a_value |
ilDBLegacyInterface::staticPopErrorHandling | ( | ) |
ilDBLegacyInterface::staticPushErrorHandling | ( | $mode, | |
$options = null |
|||
) |
mode | |
options |
ilDBLegacyInterface::substr | ( | $a_exp, | |
$a_pos = 1 , |
|||
$a_len = -1 |
|||
) |
a_exp | |
a_pos | |
a_len |
ilDBLegacyInterface::supports | ( | $feature | ) |
feature |
ilDBLegacyInterface::supportsEngineMigration | ( | ) |
ilDBLegacyInterface::supportsFulltext | ( | ) |
ilDBLegacyInterface::supportsSlave | ( | ) |
ilDBLegacyInterface::supportsTransactions | ( | ) |
ilDBLegacyInterface::tableColumnExists | ( | $a_table, | |
$a_column_name | |||
) |
a_table | |
a_column_name |
ilDBLegacyInterface::tableExists | ( | $a_table | ) |
a_table |
ilDBLegacyInterface::throwError | ( | $message = null , |
|
$code = null , |
|||
$userinfo = null |
|||
) |
message | |
code | |
userinfo |
ilDBLegacyInterface::uniqueConstraintExists | ( | $a_table, | |
$a_fields | |||
) |
a_table | |
a_fields |
ilDBLegacyInterface::unixTimestamp | ( | ) |
ilDBLegacyInterface::unlockTables | ( | ) |
ilDBLegacyInterface::update | ( | $a_table, | |
$a_columns, | |||
$a_where | |||
) |
a_table | |
a_columns | |
a_where |
ilDBLegacyInterface::upper | ( | $a_exp | ) |
a_exp |
ilDBLegacyInterface::useSlave | ( | $a_val = true | ) |
a_val |