Docs For Class MDB2_Driver_Manager

alterTable [line 525]

mixed alterTable(
string
$name, array
$changes, boolean
$check)

alter an existing table

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

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.

[ Top ]

checkSupportedChanges [line 312]

mixed checkSupportedChanges(

&$changes, string
$name)

Check if planned changes are supported

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

string	`$name`	—	name of the database that should be dropped
	`&$changes`	—

[ Top ]

createConstraint [line 955]

mixed createConstraint(
string
$table, string
$name, array
$definition)

create a constraint on a table

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

string $table — name of the table on which the constraint is to be created

string $name — name of the constraint to be created

array

$definition

—

associative array that defines properties of the constraint to be created. Currently, only one property named FIELDS is supported. This property is also an associative with the names of the constraint fields as array constraints. Each entry of this array is set to another type of associative array that specifies properties of the constraint that are specific to each field.

Example array( 'fields' => array( 'user_name' => array(), 'last_login' => array(), ) )

[ Top ]

createDatabase [line 69]

mixed createDatabase(
string
$name, [array
$options = array()])

create a new database

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

string	`$name`	—	name of the database that should be created
array	`$options`	—	array with charset info

[ Top ]

createIndex [line 849]

mixed createIndex(
string
$table, string
$name, array
$definition)

Get the stucture of a field into an array

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

string $table — name of the table on which the index is to be created

string $name — name of the index to be created

array

$definition

—

associative array that defines properties of the index to be created. Currently, only one property named FIELDS is supported. This property is also an associative with the names of the index fields as array indexes. Each entry of this array is set to another type of associative array that specifies properties of the index that are specific to each field.

Currently, only the sorting property is supported. It should be used to define the sorting direction of the index. It may be set to either ascending or descending.

Not all DBMS support index sorting direction configuration. The DBMS drivers of those that do not support it ignore this property. Use the function support() to determine whether the DBMS driver can manage indexes. Example array( 'fields' => array( 'user_name' => array( 'sorting' => 'ascending' ), 'last_login' => array() ) )

[ Top ]

createSequence [line 1057]

mixed createSequence(
string
$seq_name, [string
$start = 1])

create sequence

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

string	`$seq_name`	—	name of the sequence to be created
string	`$start`	—	start value of the sequence; default is 1

[ Top ]

createTable [line 255]

mixed createTable(
string
$name, array
$fields, [array
$options = array()])

create a new table

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

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, ), 'description' => array( 'type' => 'text', 'length' => 12, ) );

array $options — An associative array of table options: array( 'comment' => 'Foo', 'temporary' => true|false, );

[ Top ]

dropDatabase [line 92]

mixed dropDatabase(
string
$name)

drop an existing database

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

string $name — name of the database that should be dropped

[ Top ]

dropSequence [line 1088]

mixed dropSequence(
string
$seq_name)

drop existing sequence

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

string $seq_name — name of the sequence to be dropped

[ Top ]

dropTable [line 395]

mixed dropTable(
string
$name)

drop an existing table

Return: MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

string $name — name of the table that should be dropped

[ Top ]

listFunctions [line 757]

mixed listFunctions(
)

list all functions (and stored procedures) in the current database

Return: array of function names on success, a MDB2 error on failure
Access: public

[ Top ]

listSequences [line 1114]

mixed listSequences(
)

list all sequences in the current database

Return: array of sequence names on success, a MDB2 error on failure
Access: public

[ Top ]

listTableConstraints [line 1012]

mixed listTableConstraints(
string
$table)

list all constraints in a table

Return: array of constraint names on success, a MDB2 error on failure
Access: public

Parameters:

string $table — name of table that should be used in method

[ Top ]

listTableFields [line 652]

mixed listTableFields(
string
$table)

list all fields in a table in the current database

Return: array of field names on success, a MDB2 error on failure
Access: public

Parameters:

string $table — name of table that should be used in method

[ Top ]

listTableIndexes [line 897]

mixed listTableIndexes(
string
$table)

list all indexes in a table

Return: array of index names on success, a MDB2 error on failure
Access: public

Parameters:

string $table — name of table that should be used in method

[ Top ]

listTables [line 620]

mixed listTables(
)

list all tables in the current database

Return: array of table names on success, a MDB2 error on failure
Access: public

[ Top ]

listTableTriggers [line 788]

mixed listTableTriggers(
[string
$table = null])

list all triggers in the database that reference a given table

Return: array of trigger names on success, a MDB2 error on failure
Access: public

Parameters:

string $table — table for which all referenced triggers should be found

[ Top ]

listTableViews [line 728]

mixed listTableViews(
string
$table)

list the views in the database that reference a given table

Return: array of view names on success, a MDB2 error on failure
Access: public

Parameters:

string $table — table for which all referenced views should be found

[ Top ]

listUsers [line 682]

mixed listUsers(
)

list all users

Return: array of user names on success, a MDB2 error on failure
Access: public

[ Top ]

listViews [line 700]

mixed listViews(
)

list all views in the current database

Return: array of view names on success, a MDB2 error on failure
Access: public

[ Top ]

vacuum [line 426]

mixed vacuum(
[string
$table = null], [array
$options = array()])

Optimize (vacuum) all the tables in the db (or only the specified table) and optionally run ANALYZE.

Return: MDB2_OK success, a MDB2 error on failure
Access: public

Parameters:

string	`$table`	—	table name (all the tables if empty)
array	`$options`	—	an array with driver-specific options: timeout [int] (in seconds) [mssql-only] analyze [boolean] [pgsql and mysql] full [boolean] [pgsql-only] freeze [boolean] [pgsql-only]

[ Top ]

_getAdvancedFKOptions [line 372]

string _getAdvancedFKOptions(
array
$definition)

Return the FOREIGN KEY query section dealing with non-standard options as MATCH, INITIALLY DEFERRED, ON UPDATE, ...

Access: protected

Parameters:

array $definition —

[ Top ]

Class: MDB2_Driver_Manager_ibase

Class Overview

Author(s):

Methods

Inherited Variables

Inherited Methods

Class Details

Method Detail

alterTable [line 525]

Parameters:

checkSupportedChanges [line 312]

Parameters:

createConstraint [line 955]

Parameters:

createDatabase [line 69]

Parameters:

createIndex [line 849]

Parameters:

createSequence [line 1057]

Parameters:

createTable [line 255]

Parameters:

dropDatabase [line 92]

Parameters:

dropSequence [line 1088]

Parameters:

dropTable [line 395]

Parameters:

listFunctions [line 757]

listSequences [line 1114]

listTableConstraints [line 1012]

Parameters:

listTableFields [line 652]

Parameters:

listTableIndexes [line 897]

Parameters:

listTables [line 620]

listTableTriggers [line 788]

Parameters:

listTableViews [line 728]

Parameters:

listUsers [line 682]

listViews [line 700]

vacuum [line 426]

Parameters:

_getAdvancedFKOptions [line 372]

Parameters: