Difference between revisions of "JDatabaseImporterMySQLi"
From Joomla! Documentation
m (→User contributed notes: bad link repair) |
m (preparing for archive only) |
||
(4 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
=={{JVer|11.1}} JDatabaseImporterMySQLi== | =={{JVer|11.1}} JDatabaseImporterMySQLi== | ||
===Description=== | ===Description=== | ||
− | + | ||
− | + | ||
− | |||
− | |||
===Methods=== | ===Methods=== | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
Line 14: | Line 12: | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQLi::__construct | + | |[[API17:JDatabaseImporterMySQLi::__construct|__construct]] |
|Constructor. | |Constructor. | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQLi::asXml | + | |[[API17:JDatabaseImporterMySQLi::asXml|asXml]] |
|Set the output option for the exporter to XML format. | |Set the output option for the exporter to XML format. | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQLi::check | + | |[[API17:JDatabaseImporterMySQLi::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 | ||
− | |[[JDatabaseImporterMySQLi::from | + | |[[API17:JDatabaseImporterMySQLi::from|from]] |
|Specifies the data source to import. | |Specifies the data source to import. | ||
|- | |- | ||
|public | |public | ||
− | |[[JDatabaseImporterMySQLi::setDbo | + | |[[API17:JDatabaseImporterMySQLi::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 | ||
− | |[[JDatabaseImporterMySQLi::withStructure | + | |[[API17:JDatabaseImporterMySQLi::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 | ||
− | |[[JDatabaseImporterMySQLi::getAddColumnSQL | + | |[[API17:JDatabaseImporterMySQLi::getAddColumnSQL|getAddColumnSQL]] |
|Get the SQL syntax to add a column. | |Get the SQL syntax to add a column. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getAddKeySQL | + | |[[API17:JDatabaseImporterMySQLi::getAddKeySQL|getAddKeySQL]] |
|Get the SQL syntax to add a key. | |Get the SQL syntax to add a key. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getAlterTableSQL | + | |[[API17:JDatabaseImporterMySQLi::getAlterTableSQL|getAlterTableSQL]] |
|Get alters for table if there is a difference. | |Get alters for table if there is a difference. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getChangeColumnSQL | + | |[[API17:JDatabaseImporterMySQLi::getChangeColumnSQL|getChangeColumnSQL]] |
|Get the syntax to alter a column. | |Get the syntax to alter a column. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getColumns | + | |[[API17:JDatabaseImporterMySQLi::getColumns|getColumns]] |
|Get the details list of columns for a table. | |Get the details list of columns for a table. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getColumnSQL | + | |[[API17:JDatabaseImporterMySQLi::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 | ||
− | |[[JDatabaseImporterMySQLi::getDropColumnSQL | + | |[[API17:JDatabaseImporterMySQLi::getDropColumnSQL|getDropColumnSQL]] |
|Get the SQL syntax to drop a column. | |Get the SQL syntax to drop a column. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getDropKeySQL | + | |[[API17:JDatabaseImporterMySQLi::getDropKeySQL|getDropKeySQL]] |
|Get the SQL syntax to drop a key. | |Get the SQL syntax to drop a key. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getDropPrimaryKeySQL | + | |[[API17:JDatabaseImporterMySQLi::getDropPrimaryKeySQL|getDropPrimaryKeySQL]] |
|Get the SQL syntax to drop a key. | |Get the SQL syntax to drop a key. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getKeyLookup | + | |[[API17:JDatabaseImporterMySQLi::getKeyLookup|getKeyLookup]] |
|Get the details list of keys for a table. | |Get the details list of keys for a table. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getKeys | + | |[[API17:JDatabaseImporterMySQLi::getKeys|getKeys]] |
|Get the details list of keys for a table. | |Get the details list of keys for a table. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getKeySQL | + | |[[API17:JDatabaseImporterMySQLi::getKeySQL|getKeySQL]] |
|Get the SQL syntax for a key. | |Get the SQL syntax for a key. | ||
|- | |- | ||
|protected | |protected | ||
− | |[[JDatabaseImporterMySQLi::getRealTableName | + | |[[API17:JDatabaseImporterMySQLi::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 | ||
− | |[[JDatabaseImporterMySQLi::mergeStructure | + | |[[API17:JDatabaseImporterMySQLi::mergeStructure|mergeStructure]] |
|Merges the incoming structure definition with the existing structure. | |Merges the incoming structure definition with the existing structure. | ||
|- | |- | ||
Line 99: | Line 97: | ||
===See also=== | ===See also=== | ||
* {{JVer|11.1}} '''JDatabaseImporterMySQLi source code''' on [[jplatform:database/database/mysqliimporter.php|BitBucket]] | * {{JVer|11.1}} '''JDatabaseImporterMySQLi source code''' on [[jplatform:database/database/mysqliimporter.php|BitBucket]] | ||
− | * {{JVer|11.1}} Subpackage [[Subpackage Database | + | * {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]] |
− | * [[JDatabaseImporterMySQLi|Other versions of JDatabaseImporterMySQLi]] | + | * [[API17:JDatabaseImporterMySQLi|Other versions of JDatabaseImporterMySQLi]] |
− | + | ||
− | + | ||
− | |||
− | |||
===User contributed notes=== | ===User contributed notes=== | ||
− | + | === Code Examples === | |
<dpl> | <dpl> | ||
noresultsheader=\n | noresultsheader=\n | ||
category=JDatabaseImporterMySQLi | category=JDatabaseImporterMySQLi | ||
− | + | namespace=CodeExample | |
category=ClassExample | category=ClassExample | ||
include=* | include=* | ||
Line 116: | Line 112: | ||
format= ,,, | format= ,,, | ||
</dpl> | </dpl> | ||
− | <noinclude> | + | <noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude> |
Latest revision as of 21:36, 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.
JDatabaseImporterMySQLi[edit]
Description[edit]
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/mysqliimporter.php
Importing[edit]
jimport( 'joomla.database.database.mysqliimporter' );
See also[edit]
- JDatabaseImporterMySQLi source code on BitBucket
- Subpackage Database
- Other versions of JDatabaseImporterMySQLi
User contributed notes[edit]
Code Examples[edit]