Class: Doctrine_DataDict_Pgsql
Source Location: /Doctrine/DataDict/Pgsql.phpClass Doctrine_DataDict_Pgsql
Located in /Doctrine/DataDict/Pgsql.php [line 34] Doctrine_Connection_Module | --Doctrine_DataDict | --Doctrine_DataDict_PgsqlAuthor(s):
|
Inherited Properties | Inherited Methods | Inherited Constants |
---|---|---|
Inherited From Doctrine_Connection_Module |
Inherited From Doctrine_DataDict
Inherited From Doctrine_Connection_Module
|
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 |
'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]
Access: | protected |
|
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 |
|
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 |
|
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 |
|
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 |
- Doctrine_DataDict::parseBoolean()
- parseBoolean parses a literal boolean value and returns proper sql equivalent