Doctrine\DBAL\Schema\DB2SchemaManager
IBM Db2 Schema Manager
- Author: Benjamin Eberlei <kontakt@beberlei.de>
- License: http://www.opensource.org/licenses/lgpl-license.php LGPL
Synopsis
class DB2SchemaManager
extends AbstractSchemaManager
{
- // Inherited members from AbstractSchemaManager
- protected Connection $_conn;
- protected AbstractPlatform $_platform;
- // methods
- public array listTableNames()
- protected Column _getPortableTableColumnDefinition()
- protected void _getPortableTablesList()
- protected void _getPortableTableIndexesList()
- protected void _getPortableTableForeignKeyDefinition()
- protected void _getPortableForeignKeyRuleDef()
- protected void _getPortableViewDefinition()
- // Inherited methods from AbstractSchemaManager
- public void __construct()
- public AbstractPlatform getDatabasePlatform()
- public mixed tryMethod()
- public array listDatabases()
- public array listSequences()
- public array listTableColumns()
- public array listTableIndexes()
- public bool tablesExist()
- public array listTableNames()
- protected array filterAssetNames()
- protected void getFilterSchemaAssetsExpression()
- public array listTables()
- public Table listTableDetails()
- public array listViews()
- public array listTableForeignKeys()
- public void dropDatabase()
- public void dropTable()
- public void dropIndex()
- public void dropConstraint()
- public boolean dropForeignKey()
- public void dropSequence()
- public boolean dropView()
- public void createDatabase()
- public void createTable()
- public void createSequence()
- public void createConstraint()
- public void createIndex()
- public void createForeignKey()
- public void createView()
- public void dropAndCreateConstraint()
- public void dropAndCreateIndex()
- public void dropAndCreateForeignKey()
- public void dropAndCreateSequence()
- public void dropAndCreateTable()
- public void dropAndCreateDatabase()
- public void dropAndCreateView()
- public void alterTable()
- public void renameTable()
- protected void _getPortableDatabasesList()
- protected void _getPortableDatabaseDefinition()
- protected void _getPortableFunctionsList()
- protected void _getPortableFunctionDefinition()
- protected void _getPortableTriggersList()
- protected void _getPortableTriggerDefinition()
- protected void _getPortableSequencesList()
- protected Sequence _getPortableSequenceDefinition()
- protected array _getPortableTableColumnList()
- protected abstract Column _getPortableTableColumnDefinition()
- protected array _getPortableTableIndexesList()
- protected void _getPortableTablesList()
- protected void _getPortableTableDefinition()
- protected void _getPortableUsersList()
- protected void _getPortableUserDefinition()
- protected void _getPortableViewsList()
- protected void _getPortableViewDefinition()
- protected void _getPortableTableForeignKeysList()
- protected void _getPortableTableForeignKeyDefinition()
- protected void _execSql()
- public Schema createSchema()
- public SchemaConfig createSchemaConfig()
- public array getSchemaSearchPaths()
- public string extractDoctrineTypeFromComment()
- public void removeDoctrineTypeFromComment()
Hierarchy
Members
protected
- $_conn
—
\Doctrine\DBAL\Connection
Holds instance of the Doctrine connection for this schema manager - $_platform
—
\Doctrine\DBAL\Platforms\AbstractPlatform
Holds instance of the database platform used for this schema manager
Methods
protected
- _getPortableForeignKeyRuleDef()
- _getPortableTableColumnDefinition() — Get Table Column Definition
- _getPortableTableForeignKeyDefinition()
- _getPortableTableIndexesList()
- _getPortableTablesList()
- _getPortableViewDefinition()
public
- listTableNames() — Return a list of all tables in the current database
Inherited from Doctrine\DBAL\Schema\AbstractSchemaManager
protected
- _execSql()
- _getPortableDatabaseDefinition()
- _getPortableDatabasesList() — Methods for filtering return values of list*() methods to convert the native DBMS data definition to a portable Doctrine definition
- _getPortableFunctionDefinition()
- _getPortableFunctionsList()
- _getPortableSequenceDefinition()
- _getPortableSequencesList()
- _getPortableTableColumnDefinition() — Get Table Column Definition
- _getPortableTableColumnList() — Independent of the database the keys of the column list result are lowercased.
- _getPortableTableDefinition()
- _getPortableTableForeignKeyDefinition()
- _getPortableTableForeignKeysList()
- _getPortableTableIndexesList() — Aggregate and group the index results according to the required data result.
- _getPortableTablesList()
- _getPortableTriggerDefinition()
- _getPortableTriggersList()
- _getPortableUserDefinition()
- _getPortableUsersList()
- _getPortableViewDefinition()
- _getPortableViewsList()
- filterAssetNames() — Filter asset names if they are configured to return only a subset of all the found elements.
- getFilterSchemaAssetsExpression()
public
- alterTable() — Alter an existing tables schema
- createConstraint() — Create a constraint on a table
- createDatabase() — Creates a new database.
- createForeignKey() — Create a new foreign key
- createIndex() — Create a new index on a table
- createSchema() — Create a schema instance for the current database.
- createSchemaConfig() — Create the configuration for this schema.
- createSequence() — Create a new sequence
- createTable() — Create a new table.
- createView() — Create a new view
- dropAndCreateConstraint() — Drop and create a constraint
- dropAndCreateDatabase() — Drop and creates a new database.
- dropAndCreateForeignKey() — Drop and create a new foreign key
- dropAndCreateIndex() — Drop and create a new index on a table
- dropAndCreateSequence() — Drop and create a new sequence
- dropAndCreateTable() — Drop and create a new table.
- dropAndCreateView() — Drop and create a new view
- dropConstraint() — Drop the constraint from the given table
- dropDatabase() — Drops a database.
- dropForeignKey() — Drops a foreign key from a table.
- dropIndex() — Drop the index from the given table
- dropSequence() — Drops a sequence with a given name.
- dropTable() — Drop the given table
- dropView() — Drop a view
- extractDoctrineTypeFromComment() — Given a table comment this method tries to extract a typehint for Doctrine Type, or returns the type given as default.
- getDatabasePlatform() — Return associated platform.
- getSchemaSearchPaths() — The search path for namespaces in the currently connected database.
- listDatabases() — List the available databases for this connection
- listSequences() — List the available sequences for this connection
- listTableColumns() — List the columns for a given table.
- listTableDetails()
- listTableForeignKeys() — List the foreign keys for the given table
- listTableIndexes() — List the indexes for a given table returning an array of Index instances.
- listTableNames() — Return a list of all tables in the current database
- listTables() — List the tables for this connection
- listViews() — List the views this connection has
- removeDoctrineTypeFromComment()
- renameTable() — Rename a given table to another name
- tablesExist() — Return true if all the given tables exist.
- tryMethod() — Try any method on the schema manager. Normally a method throws an exception when your DBMS doesn't support it or if an error occurs.