API17:JDatabaseMySQLImporter

This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

Defined in

libraries/joomla/database/database/mysqlimporter.php

• see source code in BitBucket

Subpackage

Database

Methods

Method name	Description
__construct	Constructor.
asXml	Set the output option for the exporter to XML format.
check	Checks if all data and options are in order prior to exporting.
from	Specifies the data source to import.
setDbo	Sets the database connector to use for exporting structure and/or data from MySQL.
withStructure	Sets an internal option to merge the structure based on the input data.
getAddColumnSQL	Get the SQL syntax to add a column.
getAddKeySQL	Get the SQL syntax to add a key.
getAlterTableSQL	Get alters for table if there is a difference.
getChangeColumnSQL	Get the syntax to alter a column.
getColumns	Get the details list of columns for a table.
getColumnSQL	Get the SQL syntax for a single column that would be included in a table create or alter statement.
getDropColumnSQL	Get the SQL syntax to drop a column.
getDropKeySQL	Get the SQL syntax to drop a key.
getDropPrimaryKeySQL	Get the SQL syntax to drop a key.
getKeyLookup	Get the details list of keys for a table.
getKeys	Get the details list of keys for a table.
getKeySQL	Get the SQL syntax for a key.
getRealTableName	Get the real name of the table, converting the prefix wildcard string if present.
mergeStructure	Merges the incoming structure definition with the existing structure.

Importing

jimport( 'joomla.database.database.mysqlimporter' );

See also

• JDatabaseMySQLImporter source code in BitBucket
• Other versions of this class

Examples

<CodeExamplesForm />