ILIAS
Release_4_0_x_branch Revision 61816
|
Public Member Functions | |
createDatabase ($name) | |
create a new database | |
dropDatabase ($name) | |
drop an existing database | |
_makeAutoincrement ($name, $table, $start=1) | |
add an autoincrement sequence + trigger | |
_dropAutoincrement ($table) | |
drop an existing autoincrement sequence + trigger | |
_getTemporaryTableQuery () | |
A method to return the required SQL string that fits between CREATE ... | |
createTable ($name, $fields, $options=array()) | |
create a new table | |
dropTable ($name) | |
drop an existing table | |
alterTable ($name, $changes, $check) | |
alter an existing table | |
listDatabases () | |
list all databases | |
listUsers () | |
list all users | |
listViews () | |
list all views in the current database | |
listFunctions () | |
list all functions in the current database | |
listTables () | |
list all tables in the current database | |
listTableFields ($table) | |
list all fields in a table in the current database | |
listTableIndexes ($table) | |
list all indexes in a table | |
listTableConstraints ($table) | |
list all constraints in a table | |
createSequence ($seq_name, $start=1) | |
create sequence | |
dropSequence ($seq_name) | |
drop existing sequence | |
listSequences () | |
list all sequences in the current database | |
Public Member Functions inherited from MDB2_Driver_Manager_Common | |
getFieldDeclarationList ($fields) | |
Get declaration of a number of field in bulk. | |
_fixSequenceName ($sqn, $check=false) | |
Removes any formatting in an sequence name using the 'seqname_format' option. | |
_fixIndexName ($idx) | |
Removes any formatting in an index name using the 'idxname_format' option. | |
_getCreateTableQuery ($name, $fields, $options=array()) | |
Create a basic SQL query for a new table creation. | |
listViews ($database=null) | |
list all views in the current database | |
listTableViews ($table) | |
list the views in the database that reference a given table | |
listTableTriggers ($table=null) | |
list all triggers in the database that reference a given table | |
listTables ($database=null) | |
list all tables in the current database | |
createIndex ($table, $name, $definition) | |
Get the stucture of a field into an array. | |
dropIndex ($table, $name) | |
drop existing index | |
createConstraint ($table, $name, $definition) | |
create a constraint on a table | |
dropConstraint ($table, $name, $primary=false) | |
drop existing constraint | |
listSequences ($database=null) | |
list all sequences in the current database | |
Public Member Functions inherited from MDB2_Module_Common | |
__construct ($db_index) | |
Constructor. | |
MDB2_Module_Common ($db_index) | |
PHP 4 Constructor. | |
& | getDBInstance () |
Get the instance of MDB2 associated with the module instance. |
Additional Inherited Members | |
Data Fields inherited from MDB2_Module_Common | |
$db_index |
MDB2_Driver_Manager_oci8::_dropAutoincrement | ( | $table | ) |
drop an existing autoincrement sequence + trigger
string | $table | name of the table |
Definition at line 220 of file oci8.php.
MDB2_Driver_Manager_oci8::_getTemporaryTableQuery | ( | ) |
A method to return the required SQL string that fits between CREATE ...
TABLE to create the table as a temporary table.
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 273 of file oci8.php.
MDB2_Driver_Manager_oci8::_makeAutoincrement | ( | $name, | |
$table, | |||
$start = 1 |
|||
) |
add an autoincrement sequence + trigger
string | $name | name of the PK field |
string | $table | name of the table |
string | $start | start value for the sequence |
Definition at line 144 of file oci8.php.
References $name, $query, $result, $start, MDB2_Driver_Manager_Common\createConstraint(), createSequence(), MDB2_Module_Common\getDBInstance(), and PEAR\isError().
MDB2_Driver_Manager_oci8::alterTable | ( | $name, | |
$changes, | |||
$check | |||
) |
alter an existing table
string | $name | name of the table that is intended to be changed. |
array | $changes | associative array that contains the details of each type of change that is intended to be performed. The types of changes that are currently supported are defined as follows: |
name
New name for the table.
add
Associative array with the names of fields to be added as indexes of the array. The value of each entry of the array should be set to another associative array with the properties of the fields to be added. The properties of the fields should be the same as defined by the MDB2 parser.
remove
Associative array with the names of fields to be removed as indexes of the array. Currently the values assigned to each entry are ignored. An empty array should be used for future compatibility.
rename
Associative array with the names of fields to be renamed as indexes of the array. The value of each entry of the array should be set to another associative array with the entry named name with the new field name and the entry named Declaration that is expected to contain the portion of the field declaration already in DBMS specific SQL code as it is used in the CREATE TABLE statement.
change
Associative array with the names of the fields to be changed as indexes of the array. Keep in mind that if it is intended to change either the name of a field and any other properties, the change array entries should have the new names of the fields as array indexes. The value of each entry of the array should be set to another associative array with the properties of the fields to that are meant to be changed as array entries. These entries should be assigned to the new values of the respective properties. The properties of the fields should be the same as defined by the MDB2 parser.
Example array( 'name' => 'userlist', 'add' => array( 'quota' => array( 'type' => 'integer', 'unsigned' => 1 ) ), 'remove' => array( 'file_limit' => array(), 'time_limit' => array() ), 'change' => array( 'name' => array( 'length' => '20', 'definition' => array( 'type' => 'text', 'length' => 20, ), ) ), 'rename' => array( 'sex' => array( 'name' => 'gender', 'definition' => array( 'type' => 'text', 'length' => 1, 'default' => 'M', ), ) ) )
boolean | $check | indicates whether the function should just check if the DBMS driver can perform the requested table alterations if the value is true or actually perform them otherwise. public |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 453 of file oci8.php.
MDB2_Driver_Manager_oci8::createDatabase | ( | $name | ) |
create a new database
object | $db | database object that is extended by this class |
string | $name | name of the database that should be created |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 68 of file oci8.php.
References $name, $password, $query, $result, MDB2_Module_Common\getDBInstance(), PEAR\isError(), MDB2_ERROR_UNSUPPORTED, and MDB2_OK.
MDB2_Driver_Manager_oci8::createSequence | ( | $seq_name, | |
$start = 1 |
|||
) |
create sequence
object | $db | database object that is extended by this class |
string | $seq_name | name of the sequence to be created |
string | $start | start value of the sequence; default is 1 |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 824 of file oci8.php.
Referenced by _makeAutoincrement().
MDB2_Driver_Manager_oci8::createTable | ( | $name, | |
$fields, | |||
$options = array() |
|||
) |
create a new table
string | $name | Name of the database that should be created |
array | $fields | Associative array that contains the definition of each field of the new table The indexes of the array entries are the names of the fields of the table an the array entry values are associative arrays like those that are meant to be passed with the field definitions to get[Type]Declaration() functions. |
Example array(
'id' => array( 'type' => 'integer', 'unsigned' => 1 'notnull' => 1 'default' => 0 ), 'name' => array( 'type' => 'text', 'length' => 12 ), 'password' => array( 'type' => 'text', 'length' => 12 )
);
array | $options | An associative array of table options: array( 'comment' => 'Foo', 'temporary' => true|false, ); |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 316 of file oci8.php.
MDB2_Driver_Manager_oci8::dropDatabase | ( | $name | ) |
drop an existing database
object | $db | database object that is extended by this class |
string | $name | name of the database that should be dropped |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 115 of file oci8.php.
References MDB2_Module_Common\getDBInstance(), PEAR\isError(), and MDB2_ERROR_UNSUPPORTED.
MDB2_Driver_Manager_oci8::dropSequence | ( | $seq_name | ) |
drop existing sequence
object | $db | database object that is extended by this class |
string | $seq_name | name of the sequence to be dropped |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 848 of file oci8.php.
MDB2_Driver_Manager_oci8::dropTable | ( | $name | ) |
drop an existing table
string | $name | name of the table that should be dropped |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 345 of file oci8.php.
MDB2_Driver_Manager_oci8::listDatabases | ( | ) |
list all databases
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 546 of file oci8.php.
MDB2_Driver_Manager_oci8::listFunctions | ( | ) |
list all functions in the current database
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 648 of file oci8.php.
MDB2_Driver_Manager_oci8::listSequences | ( | ) |
list all sequences in the current database
Definition at line 868 of file oci8.php.
MDB2_Driver_Manager_oci8::listTableConstraints | ( | $table | ) |
list all constraints in a table
string | $table | name of table that should be used in method |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 781 of file oci8.php.
MDB2_Driver_Manager_oci8::listTableFields | ( | $table | ) |
list all fields in a table in the current database
string | $table | name of table that should be used in method |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 707 of file oci8.php.
MDB2_Driver_Manager_oci8::listTableIndexes | ( | $table | ) |
list all indexes in a table
string | $table | name of table that should be used in method |
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 739 of file oci8.php.
MDB2_Driver_Manager_oci8::listTables | ( | ) |
list all tables in the current database
Definition at line 677 of file oci8.php.
MDB2_Driver_Manager_oci8::listUsers | ( | ) |
list all users
Reimplemented from MDB2_Driver_Manager_Common.
Definition at line 592 of file oci8.php.
MDB2_Driver_Manager_oci8::listViews | ( | ) |
list all views in the current database
Definition at line 619 of file oci8.php.