JDatabaseImporterMySQL: Difference between revisions
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 01:05, 12 May 2013
JDatabaseImporterMySQL
Description
Template:Description:JDatabaseImporterMySQL [Edit Descripton]
Methods
| 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
jimport( 'joomla.database.database.mysqlimporter' );
See also
JDatabaseImporterMySQL source code on BitBucket
Subpackage Database- Other versions of JDatabaseImporterMySQL
Template:SeeAlso:JDatabaseImporterMySQL [Edit See Also]
User contributed notes
<CodeExamplesForm />