Class: Doctrine_DataDict_Pgsql

Source Location: /Doctrine/DataDict/Pgsql.php

Class Doctrine_DataDict_Pgsql

Class Overview

Located in /Doctrine/DataDict/Pgsql.php [line 34]

Doctrine_Connection_Module
   |
   --Doctrine_DataDict
      |
      --Doctrine_DataDict_Pgsql
Author(s): Information Tags:
Version:  $Revision: 2033 $
Link:  www.phpdoctrine.com
Since:  1.0
License:  LGPL

Properties

Methods

[ Top ]
Inherited Properties, Constants, and Methods
Inherited Properties Inherited Methods Inherited Constants

Inherited From Doctrine_Connection_Module

Doctrine_Connection_Module::$conn
Doctrine_Connection_Module::$moduleName

Inherited From Doctrine_DataDict

Doctrine_DataDict::compareDefinition()
Obtain an array of changes that may need to applied
Doctrine_DataDict::parseBoolean()
parseBoolean parses a literal boolean value and returns proper sql equivalent

Inherited From Doctrine_Connection_Module

Doctrine_Connection_Module::__construct()
Doctrine_Connection_Module::getConnection()
getConnection returns the connection object this module uses
Doctrine_Connection_Module::getModuleName()
getModuleName returns the name of this module

[ Top ]
Property Summary
static mixed   $reservedKeyWords  

[ Top ]
Method Summary
string   getIntegerDeclaration()   Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.
string   getNativeDeclaration()   Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.
array   getPortableDeclaration()   Maps a native array description of a field to a portable Doctrine datatype and length
string   parseBoolean()   parseBoolean parses a literal boolean value and returns proper sql equivalent

[ Top ]
Properties
static mixed   $reservedKeyWords = array(
'abort',
'absolute',
'access',
'action',
'add',
'after',
'aggregate',
'all',
'alter',
'analyse',
'analyze',
'and',
'any',
'as',
'asc',
'assertion',
'assignment',
'at',
'authorization',
'backward',
'before',
'begin',
'between',
'bigint',
'binary',
'bit',
'boolean',
'both',
'by',
'cache',
'called',
'cascade',
'case',
'cast',
'chain',
'char',
'character',
'characteristics',
'check',
'checkpoint',
'class',
'close',
'cluster',
'coalesce',
'collate',
'column',
'comment',
'commit',
'committed',
'constraint',
'constraints',
'conversion',
'convert',
'copy',
'create',
'createdb',
'createuser',
'cross',
'current_date',
'current_time',
'current_timestamp',
'current_user',
'cursor',
'cycle',
'database',
'day',
'deallocate',
'dec',
'decimal',
'declare',
'default',
'deferrable',
'deferred',
'definer',
'delete',
'delimiter',
'delimiters',
'desc',
'distinct',
'do',
'domain',
'double',
'drop',
'each',
'else',
'encoding',
'encrypted',
'end',
'escape',
'except',
'exclusive',
'execute',
'exists',
'explain',
'external',
'extract',
'false',
'fetch',
'float',
'for',
'force',
'foreign',
'forward',
'freeze',
'from',
'full',
'function',
'get',
'global',
'grant',
'group',
'handler',
'having',
'hour',
'ilike',
'immediate',
'immutable',
'implicit',
'in',
'increment',
'index',
'inherits',
'initially',
'inner',
'inout',
'input',
'insensitive',
'insert',
'instead',
'int',
'integer',
'intersect',
'interval',
'into',
'invoker',
'is',
'isnull',
'isolation',
'join',
'key',
'lancompiler',
'language',
'leading',
'left',
'level',
'like',
'limit',
'listen',
'load',
'local',
'localtime',
'localtimestamp',
'location',
'lock',
'match',
'maxvalue',
'minute',
'minvalue',
'mode',
'month',
'move',
'names',
'national',
'natural',
'nchar',
'new',
'next',
'no',
'nocreatedb',
'nocreateuser',
'none',
'not',
'nothing',
'notify',
'notnull',
'null',
'nullif',
'numeric',
'of',
'off',
'offset',
'oids',
'old',
'on',
'only',
'operator',
'option',
'or',
'order',
'out',
'outer',
'overlaps',
'overlay',
'owner',
'partial',
'password',
'path',
'pendant',
'placing',
'position',
'precision',
'prepare',
'primary',
'prior',
'privileges',
'procedural',
'procedure',
'read',
'real',
'recheck',
'references',
'reindex',
'relative',
'rename',
'replace',
'reset',
'restrict',
'returns',
'revoke',
'right',
'rollback',
'row',
'rule',
'schema',
'scroll',
'second',
'security',
'select',
'sequence',
'serializable',
'session',
'session_user',
'set',
'setof',
'share',
'show',
'similar',
'simple',
'smallint',
'some',
'stable',
'start',
'statement',
'statistics',
'stdin',
'stdout',
'storage',
'strict',
'substring',
'sysid',
'table',
'temp',
'template',
'temporary',
'then',
'time',
'timestamp',
'to',
'toast',
'trailing',
'transaction',
'treat',
'trigger',
'trim',
'true',
'truncate',
'trusted',
'type',
'unencrypted',
'union',
'unique',
'unknown',
'unlisten',
'until',
'update',
'usage',
'user',
'using',
'vacuum',
'valid',
'validator',
'values',
'varchar',
'varying',
'verbose',
'version',
'view',
'volatile',
'when',
'where',
'with',
'without',
'work',
'write',
'year',
'zone'
)
[line 39]
API Tags:
Access:  protected


[ Top ]
Methods
getIntegerDeclaration  [line 578]

  string getIntegerDeclaration( string $name, array $field  )

Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.

Parameters:
string   $name:  name the field to be declared.
array   $field: 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

unsigned Boolean flag that indicates whether the field should be declared as unsigned integer if possible.

default Integer value to be used as default for this field.

notnull Boolean flag that indicates whether this field is constrained to not be set to null.


API Tags:
Return:  DBMS specific SQL code portion that should be used to declare the specified field.
Access:  public


[ Top ]
getNativeDeclaration  [line 361]

  string getNativeDeclaration( $field  )

Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.

Parameters:
array   $field: 

associative array with the name of the properties of the field being declared as array indexes. Currently, the types of supported field properties are as follows:

length Integer value that determines the maximum length of the text field. If this argument is missing the field should be declared to have the longest length allowed by the DBMS.

default Text value to be used as default for this field.

notnull Boolean flag that indicates whether this field is constrained to not be set to null.


API Tags:
Return:  DBMS specific SQL code portion that should be used to declare the specified field.
Access:  public


[ Top ]
getPortableDeclaration  [line 433]

  array getPortableDeclaration( $field  )

Maps a native array description of a field to a portable Doctrine datatype and length

Parameters:
array   $field:  native field description

API Tags:
Return:  containing the various possible types, length, sign, fixed
Access:  public


[ Top ]
parseBoolean  [line 617]

  string parseBoolean( string $value  )

parseBoolean parses a literal boolean value and returns proper sql equivalent

Parameters:
string   $value:  boolean value to be parsed

API Tags:
Return:  parsed boolean value
Access:  public


Redefinition of:
Doctrine_DataDict::parseBoolean()
parseBoolean parses a literal boolean value and returns proper sql equivalent

[ Top ]