Difference between revisions of "JDatabaseMySQLImporter"
From Joomla! Documentation
(Bulk upload by Doxiki2) |
m (preparing for archive only) |
||
(6 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
− | + | ||
− | + | ||
− | |||
− | |||
===Defined in=== | ===Defined in=== | ||
libraries/joomla/database/database/mysqlimporter.php | libraries/joomla/database/database/mysqlimporter.php | ||
+ | * see source code in [[jplatform:database/database/mysqlimporter.php|BitBucket]] | ||
===Subpackage=== | ===Subpackage=== | ||
− | [[Subpackage Database | + | [[API17:Subpackage Database|Database]] |
===Extends=== | ===Extends=== | ||
===Extended by=== | ===Extended by=== | ||
Line 16: | Line 15: | ||
!Description | !Description | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::__construct | + | |[[API17:JDatabaseMySQLImporter::__construct|__construct]] |
|Constructor. | |Constructor. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::asXml | + | |[[API17:JDatabaseMySQLImporter::asXml|asXml]] |
|Set the output option for the exporter to XML format. | |Set the output option for the exporter to XML format. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::check | + | |[[API17:JDatabaseMySQLImporter::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. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::from | + | |[[API17:JDatabaseMySQLImporter::from|from]] |
|Specifies the data source to import. | |Specifies the data source to import. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::setDbo | + | |[[API17:JDatabaseMySQLImporter::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. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::withStructure | + | |[[API17:JDatabaseMySQLImporter::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. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getAddColumnSQL | + | |[[API17:JDatabaseMySQLImporter::getAddColumnSQL|getAddColumnSQL]] |
|Get the SQL syntax to add a column. | |Get the SQL syntax to add a column. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getAddKeySQL | + | |[[API17:JDatabaseMySQLImporter::getAddKeySQL|getAddKeySQL]] |
|Get the SQL syntax to add a key. | |Get the SQL syntax to add a key. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getAlterTableSQL | + | |[[API17:JDatabaseMySQLImporter::getAlterTableSQL|getAlterTableSQL]] |
|Get alters for table if there is a difference. | |Get alters for table if there is a difference. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getChangeColumnSQL | + | |[[API17:JDatabaseMySQLImporter::getChangeColumnSQL|getChangeColumnSQL]] |
|Get the syntax to alter a column. | |Get the syntax to alter a column. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getColumns | + | |[[API17:JDatabaseMySQLImporter::getColumns|getColumns]] |
|Get the details list of columns for a table. | |Get the details list of columns for a table. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getColumnSQL | + | |[[API17:JDatabaseMySQLImporter::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. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getDropColumnSQL | + | |[[API17:JDatabaseMySQLImporter::getDropColumnSQL|getDropColumnSQL]] |
|Get the SQL syntax to drop a column. | |Get the SQL syntax to drop a column. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getDropKeySQL | + | |[[API17:JDatabaseMySQLImporter::getDropKeySQL|getDropKeySQL]] |
|Get the SQL syntax to drop a key. | |Get the SQL syntax to drop a key. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getDropPrimaryKeySQL | + | |[[API17:JDatabaseMySQLImporter::getDropPrimaryKeySQL|getDropPrimaryKeySQL]] |
|Get the SQL syntax to drop a key. | |Get the SQL syntax to drop a key. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getKeyLookup | + | |[[API17:JDatabaseMySQLImporter::getKeyLookup|getKeyLookup]] |
|Get the details list of keys for a table. | |Get the details list of keys for a table. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getKeys | + | |[[API17:JDatabaseMySQLImporter::getKeys|getKeys]] |
|Get the details list of keys for a table. | |Get the details list of keys for a table. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getKeySQL | + | |[[API17:JDatabaseMySQLImporter::getKeySQL|getKeySQL]] |
|Get the SQL syntax for a key. | |Get the SQL syntax for a key. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::getRealTableName | + | |[[API17:JDatabaseMySQLImporter::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. | ||
|- | |- | ||
− | |[[JDatabaseMySQLImporter::mergeStructure | + | |[[API17:JDatabaseMySQLImporter::mergeStructure|mergeStructure]] |
|Merges the incoming structure definition with the existing structure. | |Merges the incoming structure definition with the existing structure. | ||
|- | |- | ||
Line 80: | Line 79: | ||
<source lang="php">jimport( 'joomla.database.database.mysqlimporter' );</source> | <source lang="php">jimport( 'joomla.database.database.mysqlimporter' );</source> | ||
===See also=== | ===See also=== | ||
− | * [[ | + | * JDatabaseMySQLImporter source code in [[jplatform:database/database/mysqlimporter.php|BitBucket]] |
− | + | * [[API17:JDatabaseMySQLImporter|Other versions of this class]] | |
− | + | ||
− | + | ||
− | |||
===Examples=== | ===Examples=== | ||
− | + | === Code Examples === | |
<dpl> | <dpl> | ||
noresultsheader=\n | noresultsheader=\n | ||
category=JDatabaseMySQLImporter | category=JDatabaseMySQLImporter | ||
− | + | namespace=CodeExample | |
category=ClassExample | category=ClassExample | ||
include=* | include=* | ||
format= ,,, | format= ,,, | ||
</dpl> | </dpl> | ||
− | <noinclude> | + | <noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude> |
Latest revision as of 21:39, 24 March 2017
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.
Defined in[edit]
libraries/joomla/database/database/mysqlimporter.php
- see source code in BitBucket
Subpackage[edit]
Extends[edit]
Extended by[edit]
Methods[edit]
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[edit]
jimport( 'joomla.database.database.mysqlimporter' );
See also[edit]
- JDatabaseMySQLImporter source code in BitBucket
- Other versions of this class
Examples[edit]
Code Examples[edit]