Class JDatabaseImporterPostgresql

Description
Description | Vars | Methods (details)

PostgreSQL import driver.

  • since: 12.1

Located in /libraries/joomla/database/importer/postgresql.php (line 19) 

JDatabaseImporter
   |
   --JDatabaseImporterPostgresql
Method Summary
Description | Vars | Methods (details)
JDatabaseImporterPostgresql check ()
string getAddColumnSQL (string $table, SimpleXMLElement $field)
string getAddIndexSQL (SimpleXMLElement $field)
string getAddSequenceSQL (SimpleXMLElement $field)
string getAlterColumnSQL (string $table, SimpleXMLElement $field)
array getAlterTableSQL (SimpleXMLElement $structure)
string getChangeColumnSQL (string $table, SimpleXMLElement $field)
string getChangeSequenceSQL (SimpleXMLElement $field)
string getColumnSQL (SimpleXMLElement $field)
string getDropIndexSQL (string $name)
string getDropPrimaryKeySQL (string $table, string $name)
string getDropSequenceSQL (string $name)
array getIdxLookup (array $keys)
array getSeqLookup (array $sequences)
Variables
Description | Vars (details) | Methods (details)

Inherited Variables

Inherited from JDatabaseImporter

JDatabaseImporter::$asFormat
 JDatabaseImporter::$cache
 JDatabaseImporter::$db
 JDatabaseImporter::$from
 JDatabaseImporter::$options
Methods
Description | Vars Methods (details)
check (line 29)

Checks if all data and options are in order prior to exporting.

  • return: Method supports chaining.
  • since: 12.1
  • throws: Exception if an error is encountered.
  • access: public
JDatabaseImporterPostgresql check ()
Redefinition of:
JDatabaseImporter::check()
Checks if all data and options are in order prior to exporting.
getAddColumnSQL (line 56)

Get the SQL syntax to add a column.

  • since: 12.1
  • access: protected
string getAddColumnSQL (string $table, SimpleXMLElement $field)
  • string $table: The table name.
  • SimpleXMLElement $field: The XML field definition.
getAddIndexSQL (line 70)

Get the SQL syntax to add an index.

  • since: 12.1
  • access: protected
string getAddIndexSQL (SimpleXMLElement $field)
  • SimpleXMLElement $field: The XML index definition.
getAddSequenceSQL (line 275)

Get the syntax to add a sequence.

  • since: 12.1
  • access: protected
string getAddSequenceSQL (SimpleXMLElement $field)
  • SimpleXMLElement $field: The XML definition for the sequence.
getAlterColumnSQL (line 347)

Get the SQL syntax for a single column that would be included in a table create statement.

  • since: 12.1
  • access: protected
string getAlterColumnSQL (string $table, SimpleXMLElement $field)
  • string $table: The name of the database table to alter.
  • SimpleXMLElement $field: The XML field definition.
getAlterTableSQL (line 84)

Get alters for table if there is a difference.

  • since: 12.1
  • access: protected
array getAlterTableSQL (SimpleXMLElement $structure)
  • SimpleXMLElement $structure: The XML structure of the table.
getChangeColumnSQL (line 331)

Get the syntax to alter a column.

  • since: 12.1
  • access: protected
string getChangeColumnSQL (string $table, SimpleXMLElement $field)
  • string $table: The name of the database table to alter.
  • SimpleXMLElement $field: The XML definition for the field.
getChangeSequenceSQL (line 303)

Get the syntax to alter a sequence.

  • since: 12.1
  • access: protected
string getChangeSequenceSQL (SimpleXMLElement $field)
  • SimpleXMLElement $field: The XML definition for the sequence.
getColumnSQL (line 401)

Get the SQL syntax for a single column that would be included in a table create statement.

  • since: 12.1
  • access: protected
string getColumnSQL (SimpleXMLElement $field)
  • SimpleXMLElement $field: The XML field definition.
getDropIndexSQL (line 454)

Get the SQL syntax to drop an index.

  • since: 12.1
  • access: protected
string getDropIndexSQL (string $name)
  • string $name: The name of the key to drop.
getDropPrimaryKeySQL (line 469)

Get the SQL syntax to drop a key.

  • since: 12.1
  • access: protected
string getDropPrimaryKeySQL (string $table, string $name)
  • string $table: The table name.
  • string $name: The constraint name.
getDropSequenceSQL (line 261)

Get the SQL syntax to drop a sequence.

  • since: 12.1
  • access: protected
string getDropSequenceSQL (string $name)
  • string $name: The name of the sequence to drop.
getIdxLookup (line 484)

Get the details list of keys for a table.

  • return: The lookup array. array({key name} => array(object, ...))
  • since: 12.1
  • throws: Exception
  • access: protected
array getIdxLookup (array $keys)
  • array $keys: An array of objects that comprise the keys for the table.
getSeqLookup (line 521)

Get the details list of sequences for a table.

  • return: The lookup array. array({key name} => array(object, ...))
  • since: 12.1
  • throws: Exception
  • access: protected
array getSeqLookup (array $sequences)
  • array $sequences: An array of objects that comprise the sequences for the table.

Inherited Methods

Inherited From JDatabaseImporter

JDatabaseImporter::__construct()
JDatabaseImporter::asXml()
JDatabaseImporter::check()
JDatabaseImporter::from()
JDatabaseImporter::getDropColumnSQL()
JDatabaseImporter::getRealTableName()
JDatabaseImporter::mergeStructure()
JDatabaseImporter::setDbo()
JDatabaseImporter::withStructure()

Documentation generated on Tue, 19 Nov 2013 15:11:12 +0100 by phpDocumentor 1.4.3