API17

JDatabaseImporterMySQL: Difference between revisions

From Joomla! Documentation

Doxiki2 (talk | contribs)
Bots
18,905 edits
Updated to r1448:247ba8d88526
 
m preparing for archive only
 
(5 intermediate revisions by the same user not shown)
Line 2: Line 2:
=={{JVer|11.1}} JDatabaseImporterMySQL==
=={{JVer|11.1}} JDatabaseImporterMySQL==
===Description===
===Description===
{{Description:JDatabaseImporterMySQL}}
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[Description:JDatabaseImporterMySQL|Edit Descripton]]<nowiki>]</nowiki>
</span>
===Methods===
===Methods===
{| class="wikitable sortable"
{| class="wikitable sortable"
Line 14: Line 12:
|-
|-
|public  
|public  
|[[JDatabaseImporterMySQL::__construct/11.1|__construct]]
|[[API17:JDatabaseImporterMySQL::__construct|__construct]]
|Constructor.  
|Constructor.  
|-
|-
|public  
|public  
|[[JDatabaseImporterMySQL::asXml/11.1|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/11.1|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/11.1|from]]
|[[API17:JDatabaseImporterMySQL::from|from]]
|Specifies the data source to import.  
|Specifies the data source to import.  
|-
|-
|public  
|public  
|[[JDatabaseImporterMySQL::setDbo/11.1|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/11.1|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/11.1|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/11.1|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/11.1|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/11.1|getChangeColumnSQL]]
|[[API17:JDatabaseImporterMySQL::getChangeColumnSQL|getChangeColumnSQL]]
|Get the syntax to alter a column.  
|Get the syntax to alter a column.  
|-
|-
|protected  
|protected  
|[[JDatabaseImporterMySQL::getColumns/11.1|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/11.1|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/11.1|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/11.1|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/11.1|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/11.1|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/11.1|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/11.1|getKeySQL]]
|[[API17:JDatabaseImporterMySQL::getKeySQL|getKeySQL]]
|Get the SQL syntax for a key.  
|Get the SQL syntax for a key.  
|-
|-
|protected  
|protected  
|[[JDatabaseImporterMySQL::getRealTableName/11.1|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/11.1|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 97:
===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/11.1|Database]]
* {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]]
* [[JDatabaseImporterMySQL|Other versions of JDatabaseImporterMySQL]]
* [[API17:JDatabaseImporterMySQL|Other versions of JDatabaseImporterMySQL]]
{{SeeAlso:JDatabaseImporterMySQL}}
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[SeeAlso:JDatabaseImporterMySQL|Edit See Also]]<nowiki>]</nowiki>
</span>
===User contributed notes===
===User contributed notes===
<CodeExamplesForm />
=== Code Examples ===
<dpl>
<dpl>
noresultsheader=\n
noresultsheader=\n
category=JDatabaseImporterMySQL
category=JDatabaseImporterMySQL
category=CodeExample
namespace=CodeExample
category=ClassExample
category=ClassExample
include=*
include=*
Line 116: Line 112:
format= ,,,
format= ,,,
</dpl>
</dpl>
<noinclude>[[Category:Platform]][[Category:Platform 11.1]][[Category:JDatabaseImporterMySQL]]</noinclude>
<noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude>

Latest revision as of 02:36, 25 March 2017

Joomla 11.1 JDatabaseImporterMySQL

Description

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


User contributed notes

Code Examples


Retrieved from "https://docs.sandbox.joomla.org/index.php?title=API17:JDatabaseImporterMySQL&oldid=384380"