lib/ezdbschema/classes/ezpgsqlschema.php

Show:

inherited

Classes
- \eZPgsqlSchema

Table of Contents

File containing the eZPgsqlSchema class.

Copyright: Copyright (C) 1999-2011 eZ Systems AS. All rights reserved.
License: eZ Business Use License Agreement Version 2.0
Package: lib
Version: 4.6.0

\eZPgsqlSchema
jump to top

Package: lib

File containing the eZPgsqlSchema class.

Parent(s): \eZDBSchemaInterface
Copyright: Copyright (C) 1999-2011 eZ Systems AS. All rights reserved.
License: eZ Business Use License Agreement Version 2.0
Version: 4.6.0

Constants

 
                SHOW_TABLES_QUERY
                = '
        SELECT n.nspname as "Schema",
               c.relname as "Name",
               CASE c.relkind
                    WHEN \'r\' THEN \'table\'
                    WHEN \'v\' THEN \'view\'
                    WHEN \'i\' THEN \'index\'
                    WHEN \'S\' THEN \'sequence\'
                    WHEN \'s\' THEN \'special\'
               END as "Type",
               u.usename as "Owner"
        FROM pg_catalog.pg_class c
             LEFT JOIN pg_catalog.pg_user u ON u.usesysid = c.relowner
             LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
        WHERE c.relkind IN (\'r\',\'\')
              AND n.nspname NOT IN (\'pg_catalog\', \'pg_toast\')
              AND pg_catalog.pg_table_is_visible(c.oid)
        ORDER BY 1, 2'

 
                FETCH_TABLE_OID_QUERY
                = '
        SELECT c.oid,
               n.nspname,
               c.relname
        FROM pg_catalog.pg_class c
             LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
        WHERE pg_catalog.pg_table_is_visible(c.oid)
              AND c.relname ~ \'^<<tablename>>$\'
        ORDER BY 2, 3'

 
                FETCH_TABLE_DEF_QUERY
                = '
        SELECT a.attname,
               pg_catalog.format_type(a.atttypid, a.atttypmod),
               (SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
                WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef) as default,
               a.attnotnull, a.attnum
        FROM pg_catalog.pg_attribute a
        WHERE a.attrelid = \'<<oid>>\' AND a.attnum > 0 AND NOT a.attisdropped
        ORDER BY a.attnum'

 
                FETCH_INDEX_DEF_QUERY
                = '
        SELECT c.relname, i.*
        FROM pg_catalog.pg_index i, pg_catalog.pg_class c
        WHERE indrelid = \'<<oid>>\'
              AND i.indexrelid = c.oid'

 
                FETCH_INDEX_COL_NAMES_QUERY
                = '
        SELECT a.attnum, a.attname
        FROM pg_catalog.pg_attribute a
        WHERE a.attrelid = \'<<indexrelid>>\' AND a.attnum IN (<<attids>>) AND NOT a.attisdropped
        ORDER BY a.attnum'

Properties


                 $DBInstance= ''

inheritedInherited from: \eZDBSchemaInterface::$$DBInstance

Details

Type: n/a
Inherited_from: \eZDBSchemaInterface::$$DBInstance


                 $Data= ''

inheritedInherited from: \eZDBSchemaInterface::$$Data

Details

Type: n/a
Inherited_from: \eZDBSchemaInterface::$$Data


                 $Schema= ''

inheritedInherited from: \eZDBSchemaInterface::$$Schema

Details

Type: n/a
Inherited_from: \eZDBSchemaInterface::$$Schema

Methods

appendSQLComments(
           $def,  $sql
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::appendSQLComments()

Parameters

Name	Type	Description
$def
$sql

convertFromStandardType(
           $type,  $length
          )
        
        :
          void

Parameters

Name	Type	Description
$type
$length

convertToStandardType(
           $type,  $length
          )
        
        :
          void

Parameters

Name	Type	Description
$type
$length

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

inherited

Inherited from: \eZDBSchemaInterface::data()

Parameters

Name	Type	Description
$schema
$tableNameList
$params

eZDBSchemaInterface(
           $params
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::eZDBSchemaInterface()

Parameters

Name	Type	Description
$params

eZPgsqlSchema(
           $db
          )
        
        :
          void

Parameters

Name	Type	Description
$db

escapeSQLString(
           $value
          )
        
        :
          void

Parameters

Name	Type	Description
$value

fetchTableData(
           $tableInfo,  $offset
              =
              false,  $limit
              =
              false
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::fetchTableData()

Parameters

Name	Type	Description
$tableInfo
$offset
$limit

fetchTableFields(
           $table,  $params
          )
        
        :
          void

Parameters

Name	Type	Description
$table
$params

fetchTableIndexes(
           $table,  $params
          )
        
        :
          void

Parameters

Name	Type	Description
$table
$params

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

Parameters

Name	Type	Description
$table_name
$field_name
$def
$params

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

Parameters

Name	Type	Description
$table_name
$index_name
$def
$params
$withClosure

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

Parameters

Name	Type	Description
$table_name
$field_name
$def
$params

generateDataFile(
           $schema,  $data,  $params
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::generateDataFile()

Parameters

Name	Type	Description
$schema
$data
$params

generateDataValueTextSQL(
           $fieldDef,  $value
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::generateDataValueTextSQL()

Parameters

Name	Type	Description
$fieldDef
$value

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

Parameters

Name	Type	Description
$table_name
$field_name
$def
$params

generateDropFieldSql(
           $table_name,  $field_name,  $params
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::generateDropFieldSql()

Parameters

Name	Type	Description
$table_name
$field_name
$params

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

Parameters

Name	Type	Description
$table_name
$index_name
$def
$withClosure

generateDropTable(
           $table
          )
        
        :
          void

Parameters

Name	Type	Description
$table

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

Parameters

Name	Type	Description
$table_name
$field_name
$def
$add_default_not_null
$params

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

Parameters

Name	Type	Description
$table_name
$field_name
$def
$params

generateSchemaFile(
           $schema,  $params
              =
              array()
          )
        
        :
          void

Parameters

Name	Type	Description
$schema
$params

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

Parameters

Name	Type	Description
$table
$table_def
$params
$withClosure

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

inherited

Inherited from: \eZDBSchemaInterface::generateTableInsert()

Parameters

Name	Type	Description
$tableName
$tableDef
$dataEntries
$params

generateTableInsertSQLList(
           $tableName,  $tableDef,  $dataEntries,  $params,  $withClosure
              =
              true
          )
        
        :
          void

Parameters

Name	Type	Description
$tableName
$tableDef
$dataEntries
$params
$withClosure

generateTableSQLList(
           $table,  $table_def,  $params,  $separateTypes
          )
        
        :
          void

Parameters

Name	Type	Description
$table
$table_def
$params
$separateTypes

generateTableSchema(
           $table,  $table_def,  $params
          )
        
        :
          void

Parameters

Name	Type	Description
$table
$table_def
$params

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

inherited

Inherited from: \eZDBSchemaInterface::generateUpgradeFile()

Parameters

Name	Type	Description
$differences
$params

insertSchema(
           $params
              =
              array()
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::insertSchema()

Parameters

Name	Type	Description
$params

isMultiInsertSupported(
          
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::isMultiInsertSupported()

isTypeLengthSupported(
           $pgType
          )
        
        :
          void

Parameters

Name	Type	Description
$pgType

loadSchemaTransformationRules(
           $schemaType
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::loadSchemaTransformationRules()

Parameters

Name	Type	Description
$schemaType

parseDefault(
           $default,  $autoinc
          )
        
        :
          void

Parameters

Name	Type	Description
$default
$autoinc

parseType(
           $type_info,  $length_info
          )
        
        :
          void

Parameters

Name	Type	Description
$type_info
$length_info

primaryKeyIndexName(
           $tableName,  $indexName,  $fields
          )
        
        :
          void

Parameters

Name	Type	Description
$tableName
$indexName
$fields

reservedKeywordList(
          
          )
        
        :
          void

schema(
           $params
              =
              array()
          )
        
        :
          void

Parameters

Name	Type	Description
$params

schemaName(
          
          )
        
        :
          void

schemaType(
          
          )
        
        :
          void

transformData(
           $data,  $toLocal
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::transformData()

Parameters

Name	Type	Description
$data
$toLocal

transformSchema(
           $schema,  $toLocal
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::transformSchema()

Parameters

Name	Type	Description
$schema
$toLocal

validate(
          
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::validate()

writeArraySchemaFile(
           $filename,  $params
              =
              array()
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::writeArraySchemaFile()

Parameters

Name	Type	Description
$filename
$params

writeSQLSchemaFile(
           $filename,  $params
              =
              array()
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::writeSQLSchemaFile()

Parameters

Name	Type	Description
$filename
$params

writeSerializedSchemaFile(
           $filename,  $params
              =
              array()
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::writeSerializedSchemaFile()

Parameters

Name	Type	Description
$filename
$params

writeUpgradeFile(
           $differences,  $filename,  $params
              =
              array()
          )
        
        :
          void

inherited

Inherited from: \eZDBSchemaInterface::writeUpgradeFile()

Parameters

Name	Type	Description
$differences
$filename
$params

lib/ezdbschema/classes/ezpgsqlschema.php

\eZPgsqlSchemajump to top

Constants

Properties

Methods

\eZPgsqlSchema
jump to top