0.11 Doctrine_Export_Sqlite
Doctrine Export Sqlite
Inheritence
Doctrine_Export_Sqlite < Doctrine_Export < Doctrine_Connection_Module
Method Summary
- createIndexSql
- createTableSql
- string getAdvancedForeignKeyOptions
- dropDatabase
- string dropSequenceSql
- alterTableSql
- boolean createSequence
- createDatabase
- string createForeignKey
- string getIndexFieldDeclarationList
Methods inherited from Doctrine_Export
exportSchema , dropDatabaseSql , exportGeneratorsSql , createConstraintSql , dropSequence , createIndexSql , getDeclaration , createTableSql , getDefaultFieldDeclaration , getAdvancedForeignKeyOptions , dropDatabase , exportClassesSql , getCharsetFieldDeclaration , getCollationFieldDeclaration , dropIndex , dropSequenceSql , createConstraint , alterTableSql , exportTable , getForeignKeyBaseDeclaration , createForeignKeySql , getCheckDeclaration , exportClasses , dropTable , exportSql , getForeignKeyReferentialAction , alterTable , dropIndexSql , dropTableSql , dropConstraint , createSequence , createIndex , getUniqueFieldDeclaration , getForeignKeyDeclaration , getTemporaryTableQuery , dropForeignKey , createSequenceSql , getIndexDeclaration , getAllGenerators , createDatabase , createForeignKey , getFieldDeclarationList , createTable , createDatabaseSql , getIndexFieldDeclarationListMethod Details
-
$table name of the table on which the index is to be created $name name of the index to be created $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 i
createIndexSql($table, $name, $definition)
Get the stucture of a field into an array
throws PDOException
-
$name Name of the database that should be created $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 associ $options An associative array of table options: createTableSql($name, $fields, $options = array())
create a new table
-
$definition foreign key definition (string) getAdvancedForeignKeyOptions($definition)
getAdvancedForeignKeyOptions Return the FOREIGN KEY query section dealing with non-standard options as MATCH, INITIALLY DEFERRED, ON UPDATE, ...
-
$databaseFile Path of the database that should be dropped dropDatabase($databaseFile)
drop an existing database
throws Doctrine_Export_Exception if something failed during the removal of the database file
-
$sequenceName name of the sequence to be dropped (string) dropSequenceSql($sequenceName)
drop existing sequence
-
alterTableSql($name, $changes, $check = false)
-
$seqName name of the sequence to be created $start start value of the sequence; default is 1 $options An associative array of table options: array( 'comment' => 'Foo', 'charset' => 'utf8', 'collate' => 'utf8_unicode_ci', ); (boolean) createSequence($seqName, $start = 1, $options = array())
create sequence
-
$databaseFile Path of the database that should be dropped createDatabase($databaseFile)
Create sqlite database file
-
$table name of the table on which the foreign key is to be created $definition associative array that defines properties of the foreign key to be created. (string) createForeignKey($table, $definition)
Sqlite does not support foreign keys so we are not even going to do anything if this function is called to avoid any sql errors if a user tries to use this on sqlite
-
(string) getIndexFieldDeclarationList($fields)
getIndexFieldDeclarationList Obtain DBMS specific SQL code portion needed to set an index declaration to be used in statements like CREATE TABLE.
Comments (0) [ add comment ]
No Comments
Add Comment