Oracle Database Wrapper. More...

Inheritance diagram for ilDBOracle:

Collaboration diagram for ilDBOracle:

Public Member Functions

loadModule ($module)

getDSN ()

Get DSN. More...

getDBType ()

Get DB Type. More...

getDBVersion ()

doConnect ()

Standard way to connect to db. More...

initConnection ()

Initialize the database connection. More...

now ()

now() More...

fromUnixtime ($a_expr, $a_to_text=true)

fromUnixtime (makes timestamp out of unix timestamp) More...

unixTimestamp ()

Unix timestamp. More...

constraintName ($a_table, $a_constraint)

Constraint names must be "globally" unique in oracle. More...

getPrimaryKeyIdentifier ()

Primary key identifier. More...

supportsFulltext ()

Is fulltext index supported? More...

replace ($a_table, $a_pk_columns, $a_other_columns)

Replace into method. More...

locate ($a_needle, $a_string, $a_start_pos=1)

Create locate string. More...

like ($a_col, $a_type, $a_value="?", $case_insensitive=true)

Provisional LIKE support for oracle CLOB's Uses SUBSTR to reduce the length. More...

concat (array $a_values, $a_allow_null=true)

CONCAT for oracle allows only the concatenation of two values. More...

in ($a_field, $a_values, $negate=false, $a_type="")

Overwritten implementation of $ilDB->in to avoid ORA-01795 (maximum number of expressions in a list is 1000) More...

lockTables ($a_tables)

Lock table. More...

unlockTables ()

Unlock tables. More...

dropPrimaryKey ($a_table)

Drop a primary key from a table. More...

setStorageEngine ($storage_engine)

getStorageEngine ()

dropFulltextIndex ($a_table, $a_name)

Public Member Functions inherited from ilDB

setDBUser ($a_user)

Set database user. More...

getDBUser ()

Get database user. More...

setDBPort ($a_port)

Set database port. More...

getDBPort ()

Get database port. More...

setDBHost ($a_host)

Set database host. More...

getDBHost ()

Get database host. More...

setDBPassword ($a_password)

Set database password. More...

getDBPassword ()

Get database password. More...

setDBName ($a_name)

Set database name. More...

getDBName ()

Get database name. More...

getDSN ()

Get DSN. More...

getDBVersion ()

Get DB version. More...

getDBType ()

Get DSN. More...

enableResultBuffering ($a_status)

En/disable result buffering. More...

initFromIniFile ($tmpClientIniFile=null)

Init db parameters from ini file. More...

connect ($a_return_false_for_error=false)

Open the connection. More...

doConnect ()

Standard way to connect to db. More...

disconnect ()

Disconnect. More...

getHostDSN ()

Should return a valid value, if host connections are possible (connectHost) to create a new database from scratch. More...

connectHost ()

Sets up a host connection only (no specific database used). More...

supportsFulltext ()

supportsSlave ()

Supports slave. More...

supports ($feature)

supportsTransactions ()

useSlave ($a_val=true)

Use slave. More...

handleError ($a_res, $a_info="", $a_level="")

Handle MDB2 Errors. More...

raisePearError ($a_message, $a_level="")

Raise an error. More...

createDatabase ($a_name, $a_charset="utf8", $a_collation="")

Create database. More...

createTable ( $a_name, $a_definition_array, $a_drop_table=false, $a_ignore_erros=false)

Create a new table in the database. More...

dropTable ($a_name, $a_error_if_not_existing=true)

Drop a table. More...

alterTable ($a_name, $a_changes)

Alter a table in the database This method is DEPRECATED, see http://www.ilias.de/docu/goto.php?target=pg_25354_42&client_id=docu PLEASE USE THE SPECIALIZED METHODS OF THIS CLASS TO CHANGE THE DB SCHEMA. More...

addTableColumn ($a_table, $a_column, $a_attributes)

Add table column Use this only on aleady "abstracted" tables. More...

dropTableColumn ($a_table, $a_column)

Drop table column Use this only on aleady "abstracted" tables. More...

modifyTableColumn ($a_table, $a_column, $a_attributes)

Modify a table column Use this only on aleady "abstracted" tables. More...

renameTableColumn ($a_table, $a_column, $a_new_column)

Rename a table column Use this only on aleady "abstracted" tables. More...

renameTable ($a_name, $a_new_name)

Rename a table. More...

addPrimaryKey ($a_table, $a_fields)

Add a primary key to a table. More...

getPrimaryKeyIdentifier ()

Primary key identifier. More...

dropPrimaryKey ($a_table)

Drop a primary key from a table. More...

addFulltextIndex ($a_table, $a_fields, $a_name="in")

Add fulltext index. More...

isFulltextIndex ($a_table, $a_name)

Is index a fulltext index? More...

indexExistsByFields ($a_table, $a_fields)

Check if index exists. More...

dropIndexByFields ($a_table, $a_fields)

Drop index by field(s) More...

dropIndex ($a_table, $a_name="in")

Drop an index from a table. More...

addUniqueConstraint ($a_table, $a_fields, $a_name="con")

Add a unique constraint to a table. More...

dropUniqueConstraint ($a_table, $a_name="con")

Drop a constraint from a table. More...

dropUniqueConstraintByFields ($a_table, $a_fields)

Drop constraint by field(s) More...

createSequence ($a_table_name, $a_start=1)

Create a sequence for a table. More...

dropSequence ($a_table_name)

Drop a sequence for a table. More...

checkTableName ($a_name)

Check whether a table name is valid. More...

checkTableColumns ($a_cols)

Check table columns definition. More...

checkColumn ($a_col, $a_def)

Check column definition. More...

checkColumnDefinition ($a_def, $a_modify_mode=false)

Check whether a column definition is valid. More...

checkColumnName ($a_name)

Check whether a column name is valid. More...

checkIndexName ($a_name)

Check whether an index name is valid. More...

getAllowedAttributes ()

constraintName ($a_table, $a_constraint)

Determine contraint name by table name and constraint name. More...

query ($sql, $a_handle_error=true)

Query. More...

queryF ($a_query, $a_types, $a_values)

Formatted query (for SELECTS). More...

manipulateF ($a_query, $a_types, $a_values)

Formatted manupulate (for DELETE, UPDATE, INSERT). More...

logStatement ($sql)

Helper function, should usually not be called. More...

setLimit ($a_limit, $a_offset=0)

Set limit and offset for a query. More...

nextId ($a_table_name)

Get next ID for an index. More...

manipulate ($sql)

Data manipulation. More...

prepare ($a_query, $a_types=null, $a_result_types=null)

Prepare a query (SELECT) statement to be used with execute. More...

prepareManip ($a_query, $a_types=null)

Prepare a data manipulation statement to be used with execute. More...

execute ($a_stmt, $a_data=null)

Execute a query statement prepared by either prepare() or prepareManip() More...

executeMultiple ($a_stmt, $a_data)

Execute a query statement prepared by either prepare() or prepareManip() with multiple data arrays. More...

insert ($a_table, $a_columns)

Convenient method for standard insert statements, example field array: More...

update ($a_table, $a_columns, $a_where)

Convenient method for standard update statements, example field array: More...

replace ($a_table, $a_pk_columns, $a_other_columns)

Replace into method. More...

fetchAssoc ($a_set)

Fetch row as associative array from result set. More...

free ($a_st)

Free a statement / result set. More...

fetchObject ($a_set)

Fetch row as object from result set. More...

numRows ($a_set)

Fetch row as associative array from result set. More...

in ($a_field, $a_values, $negate=false, $a_type="")

Get abstract in-clause for given array. More...

addTypesToArray ($a_arr, $a_type, $a_cnt)

Adds a type x times to an array. More...

now ()

now() More...

concat (array $a_values, $a_allow_null=true)

Abstraction of SQL function CONCAT. More...

substr ($a_exp, $a_pos=1, $a_len=-1)

Substring. More...

upper ($a_exp)

Upper. More...

lower ($a_exp)

Upper. More...

locate ($a_needle, $a_string, $a_start_pos=1)

Create locate string. More...

like ($a_col, $a_type, $a_value="?", $case_insensitive=true)

Like. More...

equals ($a_col, $a_value, $a_type, $a_empty_or_null=false)

Use this only on text fields. More...

equalsNot ($a_col, $a_value, $a_type, $a_empty_or_null=false)

Use this only on text fields. More...

fromUnixtime ($a_expr, $a_to_text=true)

fromUnixtime (makes timestamp out of unix timestamp) More...

unixTimestamp ()

Unix timestamp. More...

tableExists ($a_table)

Check, whether a given table exists. More...

tableColumnExists ($a_table, $a_column_name)

Checks for the existence of a table column. More...

uniqueConstraintExists ($a_table, array $a_fields)

Checks if a unique constraint exists based on the fields of the unique constraint (not the name) More...

listTables ()

Get all tables. More...

sequenceExists ($a_sequence)

Check, whether a given sequence exists. More...

listSequences ()

Get all sequences. More...

quote ($a_query, $a_type=null)

Wrapper for quote method. More...

quoteIdentifier ($a_identifier, $check_option=false)

Quote table and field names. More...

beginTransaction ()

Begin Transaction. More...

commit ()

Commit a transaction. More...

rollback ()

Rollback a transaction. More...

lockTables ($a_tables)

Abstraction of lock table. More...

unlockTables ()

Unlock tables locked by previous lock table calls. More...

autoExecute ($a_tablename, $a_fields, $a_mode=MDB2_AUTOQUERY_INSERT, $a_where=false)

Wrapper for Pear autoExecute. More...

getLastInsertId ()

Get last insert id. More...

getOne ($sql)

getOne. More...

getRow ($sql, $mode=ilDBConstants::FETCHMODE_OBJECT)

getRow. More...

setSubType ($a_value)

Set sub type. More...

getSubType ()

Get sub type. More...

migrateAllTablesToEngine ($engine=ilDBConstants::MYSQL_ENGINE_INNODB)

supportsEngineMigration ()

getSequenceName ($table_name)

buildAtomQuery ()

sanitizeMB4StringIfNotSupported ($query)

Parameters

$query string to sanitize, all MB4-Characters like emojis will re replaced with ???

Returns: string sanitized query

More...

doesCollationSupportMB4Strings ()

cast ($a_field_name, $a_dest_type)

Public Member Functions inherited from PEAR

__construct ($error_class=null)

Constructor. More...

_PEAR ()

Destructor (the emulated type of...). More...

registerShutdownFunc ($func, $args=array())

Use this function to register a shutdown method for static classes. More...

isError ($data, $code=null)

Tell whether a value is a PEAR error. More...

expectError ($code=' *')

This method is used to tell which errors you expect to get. More...

popExpect ()

This method pops one element off the expected error codes stack. More...

_checkDelExpect ($error_code)

This method checks unsets an error code if available. More...

delExpect ($error_code)

This method deletes all occurences of the specified element from the expected error codes stack. More...

& raiseError ($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false)

This method is a wrapper that returns an instance of the configured error class with this object's default error handling applied. More...

& throwError ($message=null, $code=null, $userinfo=null)

Simpler form of raiseError with fewer options. More...

staticPushErrorHandling ($mode, $options=null)

staticPopErrorHandling ()

pushErrorHandling ($mode, $options=null)

Push a new error handler on top of the error handler options stack. More...

popErrorHandling ()

Pop the last error handler used. More...

loadExtension ($ext)

OS independant PHP extension load. More...

Public Member Functions inherited from ilDBInterface

query ($query)

Run a (read-only) Query on the database. More...

fetchAll ($query_result, $fetch_mode=ilDBConstants::FETCHMODE_ASSOC)

addIndex ($table_name, $fields, $index_name='', $fulltext=false)

substr ($a_exp)

groupConcat ($a_field_name, $a_seperator=",", $a_order=null)

Static Public Member Functions
static	getReservedWords ()
	Get reserved words. More...

Static Public Member Functions inherited from ilDB
static	getReservedWords ()
	Get reserved words. More...

static	isDbError ($a_res)
	Check error. More...

static	isReservedWord ($a_word)
	Checks whether a word is a reserved word in one of the supported databases. More...

Static Public Member Functions inherited from PEAR
static &	getStaticProperty ($class, $var)
	If you have a class that's mostly/entirely static, and you need static properties, you can use this method to simulate them. More...

static	setErrorHandling ($mode=null, $options=null)
	Sets how errors generated by this object should be handled. More...

Data Fields
const	CLOB_BUFFER_SIZE = 2000

const	LIMIT_EXPRESSIONS_IN_LIST = 1000

Data Fields inherited from ilDB
const	LOCK_WRITE = 1

const	LOCK_READ = 2

	$error_class

	$db

	$result

	$allowed_attributes

	$sub_type

Data Fields inherited from PEAR
	$_debug = false

	$_default_error_mode = null

	$_default_error_options = null

	$_default_error_handler = ''

	$_error_class = 'PEAR_Error'

	$_expected_errors = array()

Additional Inherited Members
Protected Member Functions inherited from ilDB
	initConnection ()
	Initialize the database connection. More...

	initHostConnection ()
	Initialize the host connection (no specific database) More...

	loadMDB2Extensions ()
	load additional mdb2 extensions and set their constants More...

	getCreateTableOptions ()
	Get options for the create table statement. More...

Detailed Description

Oracle Database Wrapper.

This class extends the main ILIAS database wrapper ilDB. Only a few methods should be overwritten, that contain Oracle specific statements and methods.

Author: Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version

Id: class.ilDB.php 18989 2009-02-15 12:57:19Z akill

Definition at line 18 of file class.ilDBOracle.php.

Member Function Documentation

◆ concat()

ilDBOracle::concat	(	array	$a_values,
			$a_allow_null = `true`
	)

CONCAT for oracle allows only the concatenation of two values.

Parameters

object	$a_values
object	$a_allow_null	[optional]

Returns

Implements ilDBInterface.

Definition at line 323 of file class.ilDBOracle.php.

References array.

     {
         if (count($a_values) <= 2) {
             return parent::concat($a_values, false);
         }
         
         $first = true;
         foreach ($a_values as $field_info) {
             if (!$first) {
                 $concat_value = parent::concat(
                     array(
                         array($concat_value,$concat_type),
                         array($field_info[0],$field_info[1])),
                     false
                 );
             } else {
                 $first = false;
                 $concat_value = $field_info[0];
                 $concat_type = $field_info[1];
             }
         }
         return $concat_value;
     }

◆ constraintName()

ilDBOracle::constraintName	(	$a_table,
		$a_constraint
	)

Constraint names must be "globally" unique in oracle.

Implements ilDBInterface.

Definition at line 167 of file class.ilDBOracle.php.

     {
         return $a_table . "_" . $a_constraint;
     }

◆ doConnect()

ilDBOracle::doConnect ( )

Standard way to connect to db.

Definition at line 102 of file class.ilDBOracle.php.

References array, MDB2\connect(), and getDSN().

     {
         $this->db = MDB2::connect(
             $this->getDSN(),
             array("use_transactions" => true)
         );
     }

Here is the call graph for this function:

◆ dropFulltextIndex()

ilDBOracle::dropFulltextIndex	(	$a_table,
		$a_name
	)

Parameters

$a_table
$a_name

Returns: bool

Implements ilDBInterface.

Definition at line 467 of file class.ilDBOracle.php.

     {
         return false;
     }

◆ dropPrimaryKey()

ilDBOracle::dropPrimaryKey ( $a_table )

Drop a primary key from a table.

Parameters

string table name

Definition at line 443 of file class.ilDBOracle.php.

References $query, $res, and ilDB\handleError().

     {
         // oracle 10: dropping constraint may not drop attached index
         // http://www.orafaq.com/forum/t/59807/0/
         
         $query = "ALTER TABLE " . $a_table . " DROP PRIMARY KEY DROP INDEX";
         $res = $this->db->query($query);
         
         return $this->handleError($res, "dropPrimaryKey(" . $a_table . ")");
     }

Here is the call graph for this function:

◆ fromUnixtime()

ilDBOracle::fromUnixtime	(	$a_expr,
		$a_to_text = `true`
	)

fromUnixtime (makes timestamp out of unix timestamp)

Definition at line 143 of file class.ilDBOracle.php.

     {
         if (!$a_to_text) {
             return "TO_DATE('19700101000000','YYYYMMDDHH24MISS') " .
                 "+ NUMTODSINTERVAL(" . $a_expr . ", 'SECOND')";
         } else {
             return "to_char(TO_DATE('19700101000000','YYYYMMDDHH24MISS') " .
                 "+ NUMTODSINTERVAL(" . $a_expr . ", 'SECOND'), 'yyyy-mm-dd hh24:mi:ss')";
         }
     }

◆ getDBType()

ilDBOracle::getDBType ( )

Get DB Type.

Implements ilDBInterface.

Definition at line 57 of file class.ilDBOracle.php.

     {
         return "oracle";
     }

◆ getDBVersion()

ilDBOracle::getDBVersion ( )

Definition at line 62 of file class.ilDBOracle.php.

References $query, $res, $row, ilDBConstants\FETCHMODE_ASSOC, and MDB2\isError().

     {
         $query = 'SELECT * FROM v$version';
         $res = $this->db->query($query);
         
         if (MDB2::isError($res)) {
             return parent::getDBVersion();
         }
         $row = $res->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
         return isset($row['banner']) ? $row['banner'] : parent::getDBVersion();
     }

Here is the call graph for this function:

◆ getDSN()

ilDBOracle::getDSN ( )

Get DSN.

Implements ilDBInterface.

Definition at line 33 of file class.ilDBOracle.php.

References $GLOBALS, array, ilDB\getDBHost(), ilDB\getDBName(), ilDB\getDBPassword(), ilDB\getDBPort(), and ilDB\getDBUser().

Referenced by doConnect().

     {
         // TODO: check if there is another solution.
         // This works with 11g
         if (!isset($GLOBALS['_MDB2_dsninfo_default']['charset']) or
             $GLOBALS['_MDB2_dsninfo_default']['charset'] != 'utf8') {
             $GLOBALS['_MDB2_dsninfo_default']['charset'] = 'utf8';
         }
 
         return array('phptype' => 'oci8',
                         'hostspec' => $this->getDBHost(),
                         'username' => $this->getDBUser(),
                         'password' => $this->getDBPassword(),
                         'port' => $this->getDBPort(),
                         'service' => $this->getDBName()
                         );
         
         //return "oci8://".$this->getDBUser().":".$this->getDBPassword()."@".
         //      $this->getDBHost()."/?service=".$this->getDBName();
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getPrimaryKeyIdentifier()

ilDBOracle::getPrimaryKeyIdentifier ( )

Primary key identifier.

Implements ilDBInterface.

Definition at line 175 of file class.ilDBOracle.php.

     {
         return "pk";
     }

◆ getReservedWords()

static ilDBOracle::getReservedWords ( )

static

Get reserved words.

Implements ilDBInterface.

Definition at line 77 of file class.ilDBOracle.php.

References array.

     {
         // version: 10g
         // url: http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/ap_keywd.htm#g691972
         return array(
             "ACCESS", "ADD", "ALL", "ALTER", "AND", "ANY", "AS", "ASC",
             "AUDIT", "BETWEEN", "BY", "CHAR", "CHECK", "CLUSTER", "COLUMN",
             "COMMENT", "COMPRESS", "CONNECT", "CREATE", "CURRENT", "DATE",
             "DECIMAL", "DEFAULT", "DELETE", "DESC", "DISTINCT", "DROP", "ELSE",
             "EXCLUSIVE", "EXISTS", "FILE", "FLOAT", "FOR", "FROM", "GRANT", "GROUP",
             "HAVING", "IDENTIFIED", "IMMEDIATE", "IN", "INCREMENT", "INDEX", "INITIAL",
             "INSERT", "INTEGER", "INTERSECT", "INTO", "IS", "LEVEL", "LIKE", "LOCK", "LONG",
             "MAXEXTENTS", "MINUS", "MLSLABEL", "MODE", "MODIFY", "NOAUDIT", "NOCOMPRESS", "NOT",
             "NOWAIT", "NULL", "NUMBER", "OF", "OFFLINE", "ON", "ONLINE","OPTION",
             "OR", "ORDER", "PCTFREE", "PRIOR", "PRIVILEGES", "PUBLIC", "RAW", "RENAME",
             "RESOURCE", "REVOKE", "ROW", "ROWID", "ROWNUM", "ROWS", "SELECT", "SESSION", "SET",
             "SHARE", "SIZE", "SMALLINT", "START", "SUCCESSFUL", "SYNONYM", "SYSDATE","TABLE",
             "THEN", "TO", "TRIGGER", "UID", "UNION", "UNIQUE", "UPDATE", "USER","VALIDATE",
             "VALUES", "VARCHAR", "VARCHAR2", "VIEW", "WHENEVER", "WHERE", "WITH"
         );
     }

◆ getStorageEngine()

ilDBOracle::getStorageEngine ( )

Returns: string

Implements ilDBInterface.

Definition at line 461 of file class.ilDBOracle.php.

     {
         return null;
     }

◆ in()

ilDBOracle::in	(	$a_field,
		$a_values,
		$negate = `false`,
		$a_type = `""`
	)

Overwritten implementation of $ilDB->in to avoid ORA-01795 (maximum number of expressions in a list is 1000)

This implementation rewrites the in clause to field IN (1,2,3,...,1000) OR field IN (1000,1001,...,2000)

Example: $ids = array(10,12,18); $st = $ilDB->prepare("SELECT * FROM table ". "WHERE ".$ilDB->in("id", $ids), $ilDB->addTypesToArray($types, "integer", count($ids))); $set = $ilDB->execute($st, $ids);

Implements ilDBInterface.

Definition at line 361 of file class.ilDBOracle.php.

References $a_type, and $in.

     {
         if (count($a_values) <= self::LIMIT_EXPRESSIONS_IN_LIST) {
             return parent::in($a_field, $a_values, $negate, $a_type);
         }
         
         $first = true;
         $concat = $negate ? ' AND ' : ' OR ';
         $in = '(';
         do {
             if (!$first) {
                 $in .= $concat;
             }
             $first = false;
             
             $spliced = array_splice($a_values, 0, self::LIMIT_EXPRESSIONS_IN_LIST);
             $in .= parent::in($a_field, $spliced, $negate, $a_type);
         } while ($a_values);
 
         return $in . " ) ";
     }

◆ initConnection()

ilDBOracle::initConnection ( )

Initialize the database connection.

Definition at line 113 of file class.ilDBOracle.php.

References $GLOBALS, and ilDB\query().

     {
         $GLOBALS['_MDB2_dsninfo_default']['charset'] = 'utf8';
         $this->query("ALTER SESSION SET nls_length_semantics='CHAR'");
         $this->query("ALTER SESSION SET NLS_SORT = binary_ci");
     }

Here is the call graph for this function:

◆ like()

ilDBOracle::like	(	$a_col,
		$a_type,
		$a_value = `"?"`,
		$case_insensitive = `true`
	)

Provisional LIKE support for oracle CLOB's Uses SUBSTR to reduce the length.

TODO: we can use self::CLOB_BUFFER_SIZE = 4000 since since the maximum buffer is 4000 byte and not 4000 chars

Parameters

object	$a_col
object	$a_type
object	$a_value	[optional]
object	$case_insensitive	[optional]

Returns

Implements ilDBInterface.

Definition at line 293 of file class.ilDBOracle.php.

References $a_type, array, ilDB\quote(), and ilDB\raisePearError().

     {
         if ($a_type == 'text') {
             return parent::like($a_col, $a_type, $a_value, $case_insensitive);
         }
 
         if (!in_array($a_type, array("text", "clob", "blob"))) {
             $this->raisePearError("Like: Invalid column type '" . $a_type . "'.", $this->error_class->FATAL);
         }
         if ($a_value == "?") {
             if ($case_insensitive) {
                 return "UPPER(SUBSTR(" . $a_col . ",0," . self::CLOB_BUFFER_SIZE . ")) LIKE(UPPER(?))";
             } else {
                 return "SUBSTR(" . $a_col . ",0," . self::CLOB_BUFFER_SIZE . ") LIKE(?)";
             }
         } else {
             if ($case_insensitive) {
                 return " UPPER(SUBSTR(" . $a_col . ",0," . self::CLOB_BUFFER_SIZE . ")) LIKE(UPPER(" . $this->quote($a_value, 'text') . "))";
             } else {
                 return " SUBSTR(" . $a_col . ",0," . self::CLOB_BUFFER_SIZE . ") LIKE(" . $this->quote($a_value, 'text') . ")";
             }
         }
     }

Here is the call graph for this function:

◆ loadModule()

ilDBOracle::loadModule ( $module )

Parameters

string $module Manager|Reverse

Returns: ilDBReverse|ilDBManager

Implements ilDBInterface.

Definition at line 24 of file class.ilDBOracle.php.

     {
         // TODO: Implement loadModule() method.
     }

◆ locate()

ilDBOracle::locate	(	$a_needle,
		$a_string,
		$a_start_pos = `1`
	)

Create locate string.

Parameters

string	$a_needle
string	$a_string
int	$a_start_pos	[optional]

Returns

Implements ilDBInterface.

Definition at line 270 of file class.ilDBOracle.php.

     {
         $locate = ' INSTR( ';
         $locate .= ('SUBSTR(' . $a_string . ',0,' . self::CLOB_BUFFER_SIZE . ')');
         $locate .= ',';
         $locate .= $a_needle;
         $locate .= ',';
         $locate .= $a_start_pos;
         $locate .= ') ';
         return $locate;
     }

◆ lockTables()

ilDBOracle::lockTables ( $a_tables )

Lock table.

E.g $ilDB->lockTable('tree',ilDBConstants::LOCK_WRITE,'t1')

Parameters

string	$a_name
int	$a_mode
string	$a_alias

Deprecated:: Use ilAtomQuery instead

Returns

Implements ilDBInterface.

Definition at line 394 of file class.ilDBOracle.php.

References $counter, $ilLog, $table, array, ilDBConstants\LOCK_READ, and ilDBConstants\LOCK_WRITE.

     {
         global $ilLog;
         
         $locks = array();
 
         $counter = 0;
         foreach ($a_tables as $table) {
             $lock = 'LOCK TABLE ';
 
             $lock .= ($table['name'] . ' ');
 
             switch ($table['type']) {
                 case ilDBConstants::LOCK_READ:
                     $lock .= ' IN SHARE MODE ';
                     break;
                 
                 case ilDBConstants::LOCK_WRITE:
                     $lock .= ' IN EXCLUSIVE MODE ';
                     break;
             }
             
             $locks[] = $lock;
         }
 
         // @TODO use and store a unique identifier to allow nested lock/unlocks
         $this->db->beginTransaction();
         foreach ($locks as $lock) {
             $this->db->query($lock);
             $ilLog->write(__METHOD__ . ': ' . $lock);
         }
         return true;
     }

◆ now()

ilDBOracle::now ( )

now()

Todo:: fix this

Implements ilDBInterface.

Definition at line 135 of file class.ilDBOracle.php.

     {
         return "LOCALTIMESTAMP";
     }

◆ replace()

ilDBOracle::replace	(	$a_table,
		$a_pk_columns,
		$a_other_columns
	)

Replace into method.

Parameters

string	table name
array	primary key values: array("field1" => array("text", $name), "field2" => ...)
array	other values: array("field1" => array("text", $name), "field2" => ...)

Implements ilDBInterface.

Definition at line 195 of file class.ilDBOracle.php.

References $r, array, ilDB\handleError(), ilDB\insert(), ilDB\manipulate(), and ilDB\quote().

     {
         $a_columns = array_merge($a_pk_columns, $a_other_columns);
         $fields = array();
         $field_values = array();
         $placeholders = array();
         $types = array();
         $values = array();
         $lobs = false;
         $lob = array();
         $val_field = array();
         $a = array();
         $b = array();
         foreach ($a_columns as $k => $col) {
             if ($col[0] == 'clob' or $col[0] == 'blob') {
                 $val_field[] = $this->quote($col[1], 'text') . " " . $k;
             } else {
                 $val_field[] = $this->quote($col[1], $col[0]) . " " . $k;
             }
             $fields[] = $k;
             $placeholders[] = "%s";
             $placeholders2[] = ":$k";
             $types[] = $col[0];
             
             // integer auto-typecast (this casts bool values to integer)
             if ($col[0] == 'integer' && !is_null($col[1])) {
                 $col[1] = (int) $col[1];
             }
 
             $values[] = $col[1];
             $field_values[$k] = $col[1];
             if ($col[0] == "blob" || $col[0] == "clob") {
                 $lobs = true;
                 $lob[$k] = $k;
             }
             $a[] = "a." . $k;
             $b[] = "b." . $k;
         }
         $abpk = array();
         $aboc = array();
         $delwhere = array();
         foreach ($a_pk_columns as $k => $col) {
             $abpk[] = "a." . $k . " = b." . $k;
             $delwhere[] = $k . " = " . $this->quote($col[1], $col[0]);
         }
         foreach ($a_other_columns as $k => $col) {
             $aboc[] = "a." . $k . " = b." . $k;
         }
         if ($lobs) {    // delete/insert
             $this->manipulate(
                 "DELETE FROM " . $a_table . " WHERE " .
                 implode($delwhere, " AND ")
             );
             $this->insert($a_table, $a_columns);
             
             //$r = $this->db->extended->autoExecute($a_table, $field_values, MDB2_AUTOQUERY_INSERT, null, $types);
             $this->handleError($r, "replace, delete/insert(" . $a_table . ")");
         } else {        // if no lobs are used, use manipulate
             $q = "MERGE INTO " . $a_table . " a " .
                 "USING (SELECT " . implode($val_field, ", ") . " " .
                 "FROM DUAL) b ON (" . implode($abpk, " AND ") . ") " .
                 "WHEN MATCHED THEN UPDATE SET " . implode($aboc, ", ") . " " .
                 "WHEN NOT MATCHED THEN INSERT (" . implode($a, ",") . ") VALUES (" . implode($b, ",") . ")";
             $r = $this->manipulate($q);
         }
         return $r;
     }

Here is the call graph for this function:

◆ setStorageEngine()

ilDBOracle::setStorageEngine ( $storage_engine )

Parameters

$storage_engine

Implements ilDBInterface.

Definition at line 455 of file class.ilDBOracle.php.

     {
         unset($storage_engine);
     }

◆ supportsFulltext()

ilDBOracle::supportsFulltext ( )

Is fulltext index supported?

Implements ilDBInterface.

Definition at line 183 of file class.ilDBOracle.php.

     {
         return false;
     }

◆ unixTimestamp()

ilDBOracle::unixTimestamp ( )

Unix timestamp.

Definition at line 157 of file class.ilDBOracle.php.

     {
         // sysdate should respect database time zone
         // current_date would respect session time zone
         return "ROUND((sysdate - to_date('01-JAN-1970','DD-MON-YYYY')) * (86400))";
     }

◆ unlockTables()

ilDBOracle::unlockTables ( )

Unlock tables.

Deprecated:: Use ilAtomQuery instead

Returns

Implements ilDBInterface.

Definition at line 433 of file class.ilDBOracle.php.

     {
         $this->db->commit();
     }

Field Documentation

◆ CLOB_BUFFER_SIZE

const ilDBOracle::CLOB_BUFFER_SIZE = 2000

Definition at line 20 of file class.ilDBOracle.php.

◆ LIMIT_EXPRESSIONS_IN_LIST

const ilDBOracle::LIMIT_EXPRESSIONS_IN_LIST = 1000

Definition at line 21 of file class.ilDBOracle.php.

The documentation for this class was generated from the following file:

Services/Database/classes/MDB2/class.ilDBOracle.php

Public Member Functions

Static Public Member Functions

Data Fields

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ concat()

◆ constraintName()

◆ doConnect()

◆ dropFulltextIndex()

◆ dropPrimaryKey()

◆ fromUnixtime()

◆ getDBType()

◆ getDBVersion()

◆ getDSN()

◆ getPrimaryKeyIdentifier()

◆ getReservedWords()

◆ getStorageEngine()

◆ in()

◆ initConnection()

◆ like()

◆ loadModule()

◆ locate()

◆ lockTables()

◆ now()

◆ replace()

◆ setStorageEngine()

◆ supportsFulltext()

◆ unixTimestamp()

◆ unlockTables()

Field Documentation

◆ CLOB_BUFFER_SIZE

◆ LIMIT_EXPRESSIONS_IN_LIST