[ Index ]

PHP Cross Reference of Joomla 4.2.2 documentation

title

Body

[close]

/libraries/vendor/joomla/database/src/Pgsql/ -> PgsqlImporter.php (summary)

Part of the Joomla Framework Database Package

Copyright: Copyright (C) 2005 - 2021 Open Source Matters, Inc. All rights reserved.
License: GNU General Public License version 2 or later; see LICENSE
File Size: 623 lines (16 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

PgsqlImporter:: (16 methods):
  check()
  getAddIndexSql()
  getAlterTableSql()
  getDropSequenceSql()
  getAddSequenceSql()
  getChangeSequenceSql()
  getSetvalSequenceSql()
  getChangeColumnSql()
  getAlterColumnSql()
  getColumnSql()
  getDropIndexSql()
  getDropPrimaryKeySql()
  getKeyLookup()
  getAddUniqueSql()
  getSeqLookup()
  xmlToCreate()


Class: PgsqlImporter  - X-Ref

PDO PostgreSQL Database Importer.

check()   X-Ref
Checks if all data and options are in order prior to exporting.

return: $this

getAddIndexSql(\SimpleXMLElement $field)   X-Ref
Get the SQL syntax to add an index.

param: \SimpleXMLElement  $field  The XML index definition.
return: string

getAlterTableSql(\SimpleXMLElement $structure)   X-Ref
Get alters for table if there is a difference.

param: \SimpleXMLElement  $structure  The XML structure of the table.
return: array

getDropSequenceSql($name)   X-Ref
Get the SQL syntax to drop a sequence.

param: string  $name  The name of the sequence to drop.
return: string

getAddSequenceSql(\SimpleXMLElement $field)   X-Ref
Get the syntax to add a sequence.

param: \SimpleXMLElement  $field  The XML definition for the sequence.
return: string

getChangeSequenceSql(\SimpleXMLElement $field)   X-Ref
Get the syntax to alter a sequence.

param: \SimpleXMLElement  $field  The XML definition for the sequence.
return: string

getSetvalSequenceSql($field)   X-Ref
Get the syntax to setval a sequence.

param: \SimpleXMLElement  $field  The XML definition for the sequence.
return: string

getChangeColumnSql($table, \SimpleXMLElement $field)   X-Ref
Get the syntax to alter a column.

param: string             $table  The name of the database table to alter.
param: \SimpleXMLElement  $field  The XML definition for the field.
return: string

getAlterColumnSql($table, \SimpleXMLElement $field)   X-Ref
Get the SQL syntax for a single column that would be included in a table create statement.

param: string             $table  The name of the database table to alter.
param: \SimpleXMLElement  $field  The XML field definition.
return: string

getColumnSql(\SimpleXMLElement $field)   X-Ref
Get the SQL syntax for a single column that would be included in a table create statement.

param: \SimpleXMLElement  $field  The XML field definition.
return: string

getDropIndexSql($name)   X-Ref
Get the SQL syntax to drop an index.

param: string  $name  The name of the key to drop.
return: string

getDropPrimaryKeySql($table, $name)   X-Ref
Get the SQL syntax to drop a key.

param: string  $table  The table name.
param: string  $name   The constraint name.
return: string

getKeyLookup($keys)   X-Ref
Get the details list of keys for a table.

param: array  $keys  An array of objects that comprise the keys for the table.
return: array  The lookup array. array({key name} => array(object, ...))

getAddUniqueSql($table, $key)   X-Ref
Get the SQL syntax to add a unique constraint for a table key.

param: string  $table  The table name.
param: array   $key    The key.
return: string

getSeqLookup($sequences)   X-Ref
Get the details list of sequences for a table.

param: array  $sequences  An array of objects that comprise the sequences for the table.
return: array  The lookup array. array({key name} => array(object, ...))

xmlToCreate(\SimpleXMLElement $table)   X-Ref
Get the SQL syntax to add a table.

param: \SimpleXMLElement  $table  The table information.
return: string



Generated: Wed Sep 7 05:41:13 2022 Chilli.vc Blog - For Webmaster,Blog-Writer,System Admin and Domainer