Docs For Class MDB2_Tools

alterDatabase [line 1519]

mixed alterDatabase(
array
$changes, [array
$current_definition = null])

Execute the necessary actions to implement the requested changes in a database structure.

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

array	`$changes`	—	an associative array that contains the definition of the changes that are meant to be applied to the database structure.
array	`$current_definition`	—	multi dimensional array that contains the current definition

[ Top ]

alterDatabaseIndexes [line 1382]

mixed alterDatabaseIndexes(
string
$table_name, array
$changes, array
$current_definition)

Execute the necessary actions to implement the requested changes in the indexes inside a database structure.

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

array	`$changes`	—	an associative array that contains the definition of the changes that are meant to be applied to the database structure.
string	`$table_name`	—	name of the table
array	`$current_definition`	—	multi dimensional array that contains the current definition

[ Top ]

alterDatabaseSequences [line 1472]

mixed alterDatabaseSequences(
array
$changes, array
$current_definition)

Execute the necessary actions to implement the requested changes in the sequences inside a database structure.

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

array	`$changes`	—	an associative array that contains the definition of the changes that are meant to be applied to the database structure.
array	`$current_definition`	—	multi dimensional array that contains the current definition

[ Top ]

alterDatabaseTables [line 1423]

mixed alterDatabaseTables(
array
$changes, array
$current_definition)

Execute the necessary actions to implement the requested changes in the tables inside a database structure.

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

array	`$changes`	—	an associative array that contains the definition of the changes that are meant to be applied to the database structure.
array	`$current_definition`	—	multi dimensional array that contains the current definition

[ Top ]

compareDefinitions [line 862]

mixed compareDefinitions(
array
$previous_definition, [array
$current_definition = null])

compare a previous definition with the currenlty parsed definition

Return: array of changes on success, or a MDB2 error object
Access: public

Parameters:

array	`$previous_definition`	—	multi dimensional array that contains the previous definition
array	`$current_definition`	—	multi dimensional array that contains the current definition

[ Top ]

compareSequenceDefinitions [line 1249]

mixed compareSequenceDefinitions(
array
$sequence_name, array
$previous_definition, 
$current_definition, 
&$defined_sequences)

compare a previous definition with the currenlty parsed definition

Return: array of changes on success, or a MDB2 error object
Access: public

Parameters:

array	`$sequence_name`	—	multi dimensional array that contains the previous definition
array	`$previous_definition`	—	multi dimensional array that contains the current definition
	`$current_definition`	—
	`&$defined_sequences`	—

[ Top ]

compareTableDefinitions [line 1167]

mixed compareTableDefinitions(
string
$table_name, array
$previous_definition, array
$current_definition, 
&$defined_tables)

compare a previous definition with the currenlty parsed definition

Return: array of changes on success, or a MDB2 error object
Access: public

Parameters:

string	`$table_name`	—	name of the table
array	`$previous_definition`	—	multi dimensional array that contains the previous definition
array	`$current_definition`	—	multi dimensional array that contains the current definition
	`&$defined_tables`	—

[ Top ]

compareTableFieldsDefinitions [line 929]

mixed compareTableFieldsDefinitions(
string
$table_name, array
$previous_definition, array
$current_definition, 
&$defined_fields)

compare a previous definition with the currenlty parsed definition

Return: array of changes on success, or a MDB2 error object
Access: public

Parameters:

string	`$table_name`	—	name of the table
array	`$previous_definition`	—	multi dimensional array that contains the previous definition
array	`$current_definition`	—	multi dimensional array that contains the current definition
	`&$defined_fields`	—

[ Top ]

compareTableIndexesDefinitions [line 1071]

mixed compareTableIndexesDefinitions(
string
$table_name, array
$previous_definition, array
$current_definition, 
&$defined_indexes)

compare a previous definition with the currenlty parsed definition

Return: array of changes on success, or a MDB2 error object
Access: public

Parameters:

string	`$table_name`	—	name of the table
array	`$previous_definition`	—	multi dimensional array that contains the previous definition
array	`$current_definition`	—	multi dimensional array that contains the current definition
	`&$defined_indexes`	—

[ Top ]

connect [line 245]

mixed connect(

&$dbinfo, [mixed
$options = false], mixed
$dbinfo)

Create a new MDB2 connection object and connect to the specified database

Return: MDB2_OK on success, or a MDB2 error object
See: MDB2::parseDSN
Access: public

Parameters:

mixed	`$dbinfo`	—	'data source name', see the MDB2::parseDSN method for a description of the dsn format. Can also be specified as an array of the format returned by MDB2::parseDSN. Finally you can also pass an existing db object to be used.
mixed	`$options`	—	An associative array of option names and their values.
	`&$dbinfo`	—

[ Top ]

createDatabase [line 746]

mixed createDatabase(
)

Create a database space within which may be created database objects

like tables, indexes and sequences. The implementation of this function is highly DBMS specific and may require special permissions to run successfully. Consult the documentation or the DBMS drivers that you use to be aware of eventual configuration requirements.

Return: MDB2_OK on success, or a MDB2 error object
Access: public

[ Top ]

createTable [line 539]

mixed createTable(
string
$table_name, array
$table, [boolean
$overwrite = false])

create a table and inititialize the table if data is available

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

string	`$table_name`	—	name of the table to be created
array	`$table`	—	multi dimensional array that containts the structure and optional data of the table
boolean	`$overwrite`	—	determine if the table/index should be

[ Top ]

createTableIndexes [line 492]

mixed createTableIndexes(
string
$table_name, array
$indexes, boolean
$overwrite)

create a indexes om a table

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

string	`$table_name`	—	name of the table
array	`$indexes`	—	indexes to be created
boolean	`$overwrite`	—	determine if the table/index should be

[ Top ]

debugOutput [line 148]

string debugOutput(
)

output debug info

Return: content of the debug_output class variable
Access: public

[ Top ]

disconnect [line 273]

void disconnect(
)

Log out and disconnect from the database.

Access: public

[ Top ]

dropSequence [line 719]

mixed dropSequence(
string
$sequence_name)

drop a table

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

string $sequence_name — name of the sequence to be dropped

[ Top ]

dropTable [line 635]

mixed dropTable(
string
$table_name)

drop a table

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

string $table_name — name of the table to be dropped

[ Top ]

dumpDatabase [line 1745]

mixed dumpDatabase(
array
$arguments, [integer
$dump = MDB2_MANAGER_DUMP_ALL])

Dump a previously parsed database structure in the Metabase schema XML based format suitable for the Metabase parser. This function may optionally dump the database definition with initialization commands that specify the data that is currently present in the tables.

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

array	`$arguments`	—	an associative array that takes pairs of tag names and values that define dump options. array ( 'definition' => Boolean true : dump currently parsed definition default: dump currently connected database 'output_mode' => String 'file' : dump into a file default: dump using a function 'output' => String depending on the 'Output_Mode' name of the file name of the function 'end_of_line' => String end of line delimiter that should be used default: "\n" );
integer	`$dump`	—	constant that determines what data to dump MDB2_MANAGER_DUMP_ALL : the entire db MDB2_MANAGER_DUMP_STRUCTURE : only the structure of the db MDB2_MANAGER_DUMP_CONTENT : only the content of the db

[ Top ]

dumpDatabaseChanges [line 1588]

mixed dumpDatabaseChanges(
array
$changes)

Dump the changes between two database definitions.

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

array $changes — an associative array that specifies the list of database definitions changes as returned by the _compareDefinitions manager class function.

[ Top ]

getDefinitionFromDatabase [line 340]

mixed getDefinitionFromDatabase(
)

Attempt to reverse engineer a schema structure from an existing MDB2 This method can be used if no xml schema file exists yet.

The resulting xml schema file may need some manual adjustments.

Return: MDB2_OK or array with all ambiguities on success, or a MDB2 error object
Access: public

[ Top ]

getOption [line 217]

mixed getOption(
string
$option)

returns the value of an option

Return: the option value or error object
Access: public

Parameters:

string $option — option name

[ Top ]

getWarnings [line 177]

array getWarnings(
)

get all warnings in reverse order.

This means that the last warning is the first element in the array

Return: with warnings
See: MDB2_Tools_Manager::resetWarnings()
Access: public

[ Top ]

initializeTable [line 592]

mixed initializeTable(
string
$table_name, array
$table)

inititialize the table with data

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

string	`$table_name`	—	name of the table
array	`$table`	—	multi dimensional array that containts the structure and optional data of the table

[ Top ]

parseDatabaseDefinitionFile [line 312]

mixed parseDatabaseDefinitionFile(
string
$input_file, array
$variables, [bool
$fail_on_invalid_names = true])

Parse a database definition file by creating a Metabase schema format parser object and passing the file contents as parser input data stream.

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

string	`$input_file`	—	the path of the database schema file.
array	`$variables`	—	an associative array that the defines the text string values that are meant to be used to replace the variables that are used in the schema description.
bool	`$fail_on_invalid_names`	—	(optional) make function fail on invalid names

[ Top ]

raiseError [line 134]

object a &raiseError(
[mixed
$code = null], [int
$mode = null], [mixed
$options = null], [string
$userinfo = null], mixed
$nativecode)

This method is used to communicate an error and invoke error callbacks etc. Basically a wrapper for PEAR::raiseError without the message string.

Return: PEAR error object
See: PEAR_Error
Access: public

Parameters:

mixed	`$code`	—	integer error code, or a PEAR error object (all other parameters are ignored if this parameter is an object
int	`$mode`	—	error mode, see PEAR_Error docs
mixed	`$options`	—	If error mode is PEAR_ERROR_TRIGGER, this is the error level (E_USER_NOTICE etc). If error mode is PEAR_ERROR_CALLBACK, this is the callback function, either as a function name, or as an array of an object and method name. For other error modes this parameter is ignored.
string	`$userinfo`	—	Extra debug information. Defaults to the last query and native error code.
mixed	`$nativecode`	—	Native error code, integer or string depending the backend.

[ Top ]

resetWarnings [line 161]

void resetWarnings(
)

reset the warning array

Access: public

[ Top ]

setDatabase [line 291]

string setDatabase(
string
$name)

Select a different database

Return: name of the database previously connected to
Access: public

Parameters:

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

[ Top ]

setOption [line 193]

mixed setOption(
string
$option, mixed
$value)

set the option for the db class

Return: MDB2_OK or MDB2 Error Object
Access: public

Parameters:

string	`$option`	—	option name
mixed	`$value`	—	value for the option

[ Top ]

updateDatabase [line 1826]

mixed updateDatabase(
string
$current_schema_file, [string
$previous_schema_file = false], [array
$variables = array()])

Compare the correspondent files of two versions of a database schema definition: the previously installed and the one that defines the schema that is meant to update the database.

If the specified previous definition file does not exist, this function will create the database from the definition specified in the current schema file. If both files exist, the function assumes that the database was previously installed based on the previous schema file and will update it by just applying the changes. If this function succeeds, the contents of the current schema file are copied to replace the previous schema file contents. Any subsequent schema changes should only be done on the file specified by the $current_schema_file to let this function make a consistent evaluation of the exact changes that need to be applied.

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

string	`$current_schema_file`	—	name of the updated database schema definition file.
string	`$previous_schema_file`	—	name the previously installed database schema definition file.
array	`$variables`	—	an associative array that is passed to the argument of the same name to the parseDatabaseDefinitionFile function. (there third param)

[ Top ]

verifyAlterDatabase [line 1317]

mixed verifyAlterDatabase(
array
$changes)

verify that the changes requested are supported

Return: MDB2_OK on success, or a MDB2 error object
Access: public

Parameters:

array $changes — an associative array that contains the definition of the changes that are meant to be applied to the database structure.

[ Top ]

Class: MDB2_Tools_Manager

Class Overview

Author(s):

Variables

Methods

Inherited Variables

Inherited Methods

Class Details

Class Variables

$database_definition = array( 'name' => '', 'create' => 0, 'tables' => array())

$db =

$default_values = array( 'integer' => 0, 'float' => 0, 'decimal' => 0, 'text' => '', 'timestamp' => '0001-01-01 00:00:00', 'date' => '0001-01-01', 'time' => '00:00:00' )

$invalid_names = array( 'user' => array(),'is'=>array(),'file'=>array('oci'=>array(),'oracle'=>array()),'notify'=>array('pgsql'=>array()),'restrict'=>array('mysql'=>array()),'password'=>array('ibase'=>array()))

$options = array( 'fail_on_invalid_names' => true, )

$warnings = array()

Method Detail

alterDatabase [line 1519]

Parameters:

alterDatabaseIndexes [line 1382]

Parameters:

alterDatabaseSequences [line 1472]

Parameters:

alterDatabaseTables [line 1423]

Parameters:

compareDefinitions [line 862]

Parameters:

compareSequenceDefinitions [line 1249]

Parameters:

compareTableDefinitions [line 1167]

Parameters:

compareTableFieldsDefinitions [line 929]

Parameters:

compareTableIndexesDefinitions [line 1071]

Parameters:

connect [line 245]

Parameters:

createDatabase [line 746]

createTable [line 539]

Parameters:

createTableIndexes [line 492]

Parameters:

debugOutput [line 148]

disconnect [line 273]

dropSequence [line 719]

Parameters:

dropTable [line 635]

Parameters:

dumpDatabase [line 1745]

Parameters:

dumpDatabaseChanges [line 1588]

Parameters:

getDefinitionFromDatabase [line 340]

getOption [line 217]

Parameters:

getWarnings [line 177]

initializeTable [line 592]

Parameters:

parseDatabaseDefinitionFile [line 312]

Parameters:

raiseError [line 134]

Parameters:

resetWarnings [line 161]

setDatabase [line 291]

Parameters:

setOption [line 193]

Parameters:

updateDatabase [line 1826]

Parameters:

verifyAlterDatabase [line 1317]

Parameters:

$database_definition = array(
'name' => '',
'create' => 0,
'tables' => array())

$default_values = array(
'integer' => 0,
'float' => 0,
'decimal' => 0,
'text' => '',
'timestamp' => '0001-01-01 00:00:00',
'date' => '0001-01-01',
'time' => '00:00:00'
)

$invalid_names = array(
'user' => array(),'is'=>array(),'file'=>array('oci'=>array(),'oracle'=>array()),'notify'=>array('pgsql'=>array()),'restrict'=>array('mysql'=>array()),'password'=>array('ibase'=>array()))

$options = array(
'fail_on_invalid_names' => true,
)