Difference between revisions of "JDatabaseImporterMySQL"
From Joomla! Documentation
m (→User contributed notes: moving preparation) |
m (moving preparation) |
||
Line 14: | Line 14: | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQL::__construct | + | |[[API17:JDatabaseImporterMySQL::__construct|__construct]] |
|Constructor. | |Constructor. | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQL::asXml | + | |[[API17:JDatabaseImporterMySQL::asXml|asXml]] |
|Set the output option for the exporter to XML format. | |Set the output option for the exporter to XML format. | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQL::check | + | |[[API17:JDatabaseImporterMySQL::check|check]] |
|Checks if all data and options are in order prior to exporting. | |Checks if all data and options are in order prior to exporting. | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQL::from | + | |[[API17:JDatabaseImporterMySQL::from|from]] |
|Specifies the data source to import. | |Specifies the data source to import. | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQL::setDbo | + | |[[API17:JDatabaseImporterMySQL::setDbo|setDbo]] |
|Sets the database connector to use for exporting structure and/or data from MySQL. | |Sets the database connector to use for exporting structure and/or data from MySQL. | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQL::withStructure | + | |[[API17:JDatabaseImporterMySQL::withStructure|withStructure]] |
|Sets an internal option to merge the structure based on the input data. | |Sets an internal option to merge the structure based on the input data. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getAddColumnSQL | + | |[[API17:JDatabaseImporterMySQL::getAddColumnSQL|getAddColumnSQL]] |
|Get the SQL syntax to add a column. | |Get the SQL syntax to add a column. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getAddKeySQL | + | |[[API17:JDatabaseImporterMySQL::getAddKeySQL|getAddKeySQL]] |
|Get the SQL syntax to add a key. | |Get the SQL syntax to add a key. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getAlterTableSQL | + | |[[API17:JDatabaseImporterMySQL::getAlterTableSQL|getAlterTableSQL]] |
|Get alters for table if there is a difference. | |Get alters for table if there is a difference. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getChangeColumnSQL | + | |[[API17:JDatabaseImporterMySQL::getChangeColumnSQL|getChangeColumnSQL]] |
|Get the syntax to alter a column. | |Get the syntax to alter a column. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getColumns | + | |[[API17:JDatabaseImporterMySQL::getColumns|getColumns]] |
|Get the details list of columns for a table. | |Get the details list of columns for a table. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getColumnSQL | + | |[[API17:JDatabaseImporterMySQL::getColumnSQL|getColumnSQL]] |
|Get the SQL syntax for a single column that would be included in a table create or alter statement. | |Get the SQL syntax for a single column that would be included in a table create or alter statement. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getDropColumnSQL | + | |[[API17:JDatabaseImporterMySQL::getDropColumnSQL|getDropColumnSQL]] |
|Get the SQL syntax to drop a column. | |Get the SQL syntax to drop a column. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getDropKeySQL | + | |[[API17:JDatabaseImporterMySQL::getDropKeySQL|getDropKeySQL]] |
|Get the SQL syntax to drop a key. | |Get the SQL syntax to drop a key. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getDropPrimaryKeySQL | + | |[[API17:JDatabaseImporterMySQL::getDropPrimaryKeySQL|getDropPrimaryKeySQL]] |
|Get the SQL syntax to drop a key. | |Get the SQL syntax to drop a key. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getKeyLookup | + | |[[API17:JDatabaseImporterMySQL::getKeyLookup|getKeyLookup]] |
|Get the details list of keys for a table. | |Get the details list of keys for a table. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getKeys | + | |[[API17:JDatabaseImporterMySQL::getKeys|getKeys]] |
|Get the details list of keys for a table. | |Get the details list of keys for a table. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getKeySQL | + | |[[API17:JDatabaseImporterMySQL::getKeySQL|getKeySQL]] |
|Get the SQL syntax for a key. | |Get the SQL syntax for a key. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::getRealTableName | + | |[[API17:JDatabaseImporterMySQL::getRealTableName|getRealTableName]] |
|Get the real name of the table, converting the prefix wildcard string if present. | |Get the real name of the table, converting the prefix wildcard string if present. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQL::mergeStructure | + | |[[API17:JDatabaseImporterMySQL::mergeStructure|mergeStructure]] |
|Merges the incoming structure definition with the existing structure. | |Merges the incoming structure definition with the existing structure. | ||
|- | |- | ||
Line 99: | Line 99: | ||
===See also=== | ===See also=== | ||
* {{JVer|11.1}} '''JDatabaseImporterMySQL source code''' on [[jplatform:database/database/mysqlimporter.php|BitBucket]] | * {{JVer|11.1}} '''JDatabaseImporterMySQL source code''' on [[jplatform:database/database/mysqlimporter.php|BitBucket]] | ||
− | * {{JVer|11.1}} Subpackage [[Subpackage Database | + | * {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]] |
− | * [[JDatabaseImporterMySQL|Other versions of JDatabaseImporterMySQL]] | + | * [[API17:JDatabaseImporterMySQL|Other versions of JDatabaseImporterMySQL]] |
{{SeeAlso:JDatabaseImporterMySQL}} | {{SeeAlso:JDatabaseImporterMySQL}} | ||
<span class="editsection" style="font-size:76%;"> | <span class="editsection" style="font-size:76%;"> |
Revision as of 20:05, 11 May 2013
The "API17" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.
JDatabaseImporterMySQL[edit]
Description[edit]
Template:Description:JDatabaseImporterMySQL [Edit Descripton]
Methods[edit]
Visibility | Method name | Description |
---|---|---|
public | __construct | Constructor. |
public | asXml | Set the output option for the exporter to XML format. |
public | check | Checks if all data and options are in order prior to exporting. |
public | from | Specifies the data source to import. |
public | setDbo | Sets the database connector to use for exporting structure and/or data from MySQL. |
public | withStructure | Sets an internal option to merge the structure based on the input data. |
protected | getAddColumnSQL | Get the SQL syntax to add a column. |
protected | getAddKeySQL | Get the SQL syntax to add a key. |
protected | getAlterTableSQL | Get alters for table if there is a difference. |
protected | getChangeColumnSQL | Get the syntax to alter a column. |
protected | getColumns | Get the details list of columns for a table. |
protected | getColumnSQL | Get the SQL syntax for a single column that would be included in a table create or alter statement. |
protected | getDropColumnSQL | Get the SQL syntax to drop a column. |
protected | getDropKeySQL | Get the SQL syntax to drop a key. |
protected | getDropPrimaryKeySQL | Get the SQL syntax to drop a key. |
protected | getKeyLookup | Get the details list of keys for a table. |
protected | getKeys | Get the details list of keys for a table. |
protected | getKeySQL | Get the SQL syntax for a key. |
protected | getRealTableName | Get the real name of the table, converting the prefix wildcard string if present. |
protected | mergeStructure | Merges the incoming structure definition with the existing structure. |
- Defined in libraries/joomla/database/database/mysqlimporter.php
Importing[edit]
jimport( 'joomla.database.database.mysqlimporter' );
See also[edit]
- JDatabaseImporterMySQL source code on BitBucket
- Subpackage Database
- Other versions of JDatabaseImporterMySQL
Template:SeeAlso:JDatabaseImporterMySQL [Edit See Also]
User contributed notes[edit]
<CodeExamplesForm />