Class

eZPgsqlSchema

class eZPgsqlSchema extends eZDBSchemaInterface

Constants

SHOW_TABLES_QUERY

FETCH_TABLE_OID_QUERY

FETCH_TABLE_DEF_QUERY

FETCH_INDEX_DEF_QUERY

FETCH_INDEX_COL_NAMES_QUERY

Properties

$DBInstance
$Schema
$Data

Methods

__construct(array $params)

Constructor

from eZDBSchemaInterface
schema($params = array())

data($schema = false, $tableNameList = false, $params = array())

from eZDBSchemaInterface
validate()

from eZDBSchemaInterface
fetchTableData($tableInfo, $offset = false, $limit = false)

from eZDBSchemaInterface
writeUpgradeFile($differences, $filename, $params = array())

from eZDBSchemaInterface
writeSQLSchemaFile($filename, $params = array())

from eZDBSchemaInterface
writeSerializedSchemaFile($filename, $params = array())

from eZDBSchemaInterface
writeArraySchemaFile($filename, $params = array())

from eZDBSchemaInterface
insertSchema($params = array())

from eZDBSchemaInterface
generateDataFile($schema, $data, $params)

from eZDBSchemaInterface
generateSchemaFile($schema, $params = array())

generateUpgradeFile($differences, $params = array())

from eZDBSchemaInterface
generateTableSQLList($table, $table_def, $params, $separateTypes)

generateTableSchema($table, $table_def, $params)

generateTableInsert($tableName, $tableDef, $dataEntries, $params)

from eZDBSchemaInterface
generateTableInsertSQLList($tableName, $tableDef, $dataEntries, $params, $withClosure = true)

generateDataValueTextSQL($fieldDef, $value)

from eZDBSchemaInterface
escapeSQLString($value)

generateAlterFieldSql($table_name, $field_name, $def, $params)

generateAddFieldSql($table_name, $field_name, $def, $params)

generateDropFieldSql($table_name, $field_name, $params)

appendSQLComments($def, $sql)

from eZDBSchemaInterface
isMultiInsertSupported()

from eZDBSchemaInterface
schemaType()

schemaName()

loadSchemaTransformationRules($schemaType)

from eZDBSchemaInterface
transformSchema($schema, $toLocal)

from eZDBSchemaInterface
transformData($data, $toLocal)

from eZDBSchemaInterface
fetchTableFields($table, $params)

fetchTableIndexes($table, $params)

parseType($type_info, $length_info)

isTypeLengthSupported($pgType)

convertFromStandardType($type, $length)

primaryKeyIndexName($tableName, $indexName, $fields)

convertToStandardType($type, $length)

parseDefault($default, $autoinc)

generateAddIndexSql($table_name, $index_name, $def, $params, $withClosure = true)

generateDropIndexSql($table_name, $index_name, $def, $withClosure = true)

generateFieldDef($table_name, $field_name, $def, $add_default_not_null = true, $params)

generateDefaultDef($table_name, $field_name, $def, $params)

generateNullDef($table_name, $field_name, $def, $params)

generateTableArrays($table, $table_def, $params, $withClosure = true)

generateDropTable($table)

reservedKeywordList()

Details

in eZDBSchemaInterface at line 68
public __construct(array $params)

Constructor

Parameters

array $params

at line 71
public schema($params = array())

Parameters

$params

in eZDBSchemaInterface at line 107
public data($schema = false, $tableNameList = false, $params = array())

Parameters

$schema
$tableNameList
$params

in eZDBSchemaInterface at line 159
public validate()

in eZDBSchemaInterface at line 179
public fetchTableData($tableInfo, $offset = false, $limit = false)

Parameters

$tableInfo
$offset
$limit

in eZDBSchemaInterface at line 217
public writeUpgradeFile($differences, $filename, $params = array())

Parameters

$differences
$filename
$params

in eZDBSchemaInterface at line 243
public writeSQLSchemaFile($filename, $params = array())

Parameters

$filename
$params

in eZDBSchemaInterface at line 283
public writeSerializedSchemaFile($filename, $params = array())

Parameters

$filename
$params

in eZDBSchemaInterface at line 323
public writeArraySchemaFile($filename, $params = array())

Parameters

$filename
$params

in eZDBSchemaInterface at line 380
public insertSchema($params = array())

Parameters

$params

in eZDBSchemaInterface at line 466
public generateDataFile($schema, $data, $params)

Parameters

$schema
$data
$params

at line 832
public generateSchemaFile($schema, $params = array())

Parameters

$schema
$params

in eZDBSchemaInterface at line 520
public generateUpgradeFile($differences, $params = array())

Parameters

$differences
$params

at line 732
public generateTableSQLList($table, $table_def, $params, $separateTypes)

Parameters

$table
$table_def
$params
$separateTypes

at line 723
public generateTableSchema($table, $table_def, $params)

Parameters

$table
$table_def
$params

in eZDBSchemaInterface at line 661
public generateTableInsert($tableName, $tableDef, $dataEntries, $params)

Parameters

$tableName
$tableDef
$dataEntries
$params

at line 815
public generateTableInsertSQLList($tableName, $tableDef, $dataEntries, $params, $withClosure = true)

Parameters

$tableName
$tableDef
$dataEntries
$params
$withClosure

in eZDBSchemaInterface at line 792
public generateDataValueTextSQL($fieldDef, $value)

Parameters

$fieldDef
$value

at line 894
public escapeSQLString($value)

Parameters

$value

at line 707
public generateAlterFieldSql($table_name, $field_name, $def, $params)

Parameters

$table_name
$field_name
$def
$params

at line 675
public generateAddFieldSql($table_name, $field_name, $def, $params)

Parameters

$table_name
$field_name
$def
$params

at line 692
public generateDropFieldSql($table_name, $field_name, $params)

Parameters

$table_name
$field_name
$params

in eZDBSchemaInterface at line 858
public appendSQLComments($def, $sql)

Parameters

$def
$sql

in eZDBSchemaInterface at line 882
public isMultiInsertSupported()

at line 899
public schemaType()

at line 904
public schemaName()

in eZDBSchemaInterface at line 914
public loadSchemaTransformationRules($schemaType)

Parameters

$schemaType

in eZDBSchemaInterface at line 1046
public transformSchema($schema, $toLocal)

Parameters

$schema
$toLocal

in eZDBSchemaInterface at line 1317
public transformData($data, $toLocal)

Parameters

$data
$toLocal

at line 113
public fetchTableFields($table, $params)

Parameters

$table
$params

at line 224
public fetchTableIndexes($table, $params)

Parameters

$table
$params

at line 299
public parseType($type_info, $length_info)

Parameters

$type_info
$length_info

at line 312
public isTypeLengthSupported($pgType)

Parameters

$pgType

at line 327
public convertFromStandardType($type, $length)

Parameters

$type
$length

at line 373
public primaryKeyIndexName($tableName, $indexName, $fields)

Parameters

$tableName
$indexName
$fields

at line 378
public convertToStandardType($type, $length)

Parameters

$type
$length

at line 413
public parseDefault($default, $autoinc)

Parameters

$default
$autoinc

at line 464
public generateAddIndexSql($table_name, $index_name, $def, $params, $withClosure = true)

Parameters

$table_name
$index_name
$def
$params
$withClosure

at line 528
public generateDropIndexSql($table_name, $index_name, $def, $withClosure = true)

Parameters

$table_name
$index_name
$def
$withClosure

at line 545
public generateFieldDef($table_name, $field_name, $def, $add_default_not_null = true, $params)

Parameters

$table_name
$field_name
$def
$add_default_not_null
$params

at line 600
public generateDefaultDef($table_name, $field_name, $def, $params)

Parameters

$table_name
$field_name
$def
$params

at line 654
public generateNullDef($table_name, $field_name, $def, $params)

Parameters

$table_name
$field_name
$def
$params

at line 752
public generateTableArrays($table, $table_def, $params, $withClosure = true)

Parameters

$table
$table_def
$params
$withClosure

at line 889
public generateDropTable($table)

Parameters

$table

at line 912
public reservedKeywordList()