Home | Classes | Modules | Annotated | Hierarchy | Functions | Files

CreoleTypes Class Reference

Inherited by MSSQLTypes, MySQLTypes, OCI8Types, PgSQLTypes, and SQLiteTypes.

List of all members.

Static Public Member Functions

Public Attributes

Static Protected Attributes

Member Function Documentation

int CreoleTypes::getType ( $ nativeType ) [static, pure virtual]

 

This method returns the generic Creole (JDBC-like) type when given the native db type.
Parameters
string $nativeType DB native type (e.g. 'TEXT', 'byetea', etc.).

Returns int Creole native type (e.g. Types::LONGVARCHAR, Types::BINARY, etc.).

Implemented in MSSQLTypes, MySQLTypes, OCI8Types, PgSQLTypes, and SQLiteTypes.

string CreoleTypes::getNativeType ( $ creoleType ) [static, pure virtual]

 

This method will return a native type that corresponds to the specified Creole (JDBC-like) type. If there is more than one matching native type, then the LAST defined native type will be returned.
Returns string Native type string.

Implemented in MSSQLTypes, MySQLTypes, OCI8Types, PgSQLTypes, and SQLiteTypes.

string CreoleTypes::getAffix ( $creoleType ) [static]

 

Gets the "affix" to use for ResultSet::get*() and PreparedStatement::set*() methods. $setter = 'set' . CreoleTypes::getAffix(CreoleTypes::INTEGER); $stmt->$setter(1, $intval); // or $getter = 'get' . CreoleTypes::getAffix(CreoleTypes::TIMESTAMP); $timestamp = $rs->$getter();
Parameters
int $creoleType The Creole types.

Returns string The default affix for getting/setting cols of this type.
Exceptions
SQLException if $creoleType does not correspond to an affix

string CreoleTypes::getCreoleName ( $creoleType ) [static]

 

Given the integer type, this method will return the corresponding type name.
Parameters
int $creoleType the integer Creole type.

Returns string The name of the Creole type (e.g. 'VARCHAR').

int CreoleTypes::getCreoleCode ( $creoleTypeName ) [static]

 

Given the name of a type (e.g. 'VARCHAR') this method will return the corresponding integer.
Parameters
string $creoleTypeName The case-sensisive (must be uppercase) name of the Creole type (e.g. 'VARCHAR').

Returns int the Creole type.

Member Data Documentation

const CreoleTypes::BOOLEAN = 1

 

const CreoleTypes::BIGINT = 2

 

const CreoleTypes::SMALLINT = 3

 

const CreoleTypes::TINYINT = 4

 

const CreoleTypes::INTEGER = 5

 

const CreoleTypes::CHAR = 6

 

const CreoleTypes::VARCHAR = 7

 

const CreoleTypes::TEXT = 17

 

const CreoleTypes::FLOAT = 8

 

const CreoleTypes::DOUBLE = 9

 

const CreoleTypes::DATE = 10

 

const CreoleTypes::TIME = 11

 

const CreoleTypes::TIMESTAMP = 12

 

const CreoleTypes::VARBINARY = 13

 

const CreoleTypes::NUMERIC = 14

 

const CreoleTypes::BLOB = 15

 

const CreoleTypes::CLOB = 16

 

const CreoleTypes::LONGVARCHAR = 17

 

const CreoleTypes::DECIMAL = 18

 

const CreoleTypes::REAL = 19

 

const CreoleTypes::BINARY = 20

 

const CreoleTypes::LONGVARBINARY = 21

 

const CreoleTypes::YEAR = 22

 

const CreoleTypes::ARR = 23

 

this is "ARRAY" from JDBC types

const CreoleTypes::OTHER = -1

 

CreoleTypes::$affixMap [static, protected]

 

Initial value:

 array(
                self::BOOLEAN => Boolean,
                self::BIGINT => 'Int',
                self::CHAR => String,
                self::DATE => 'Date',
                self::DOUBLE => Float,
                self::FLOAT => Float,
                self::INTEGER => 'Int',
                self::SMALLINT => 'Int',
                self::TINYINT => 'Int',
                self::TIME => 'Time',
                self::TIMESTAMP => Timestamp,
                self::VARCHAR => String,                
                self::VARBINARY => 'Blob',
                self::NUMERIC => Float,
                self::BLOB => 'Blob',
                self::CLOB => 'Clob',
                self::LONGVARCHAR => String,
                self::DECIMAL => Float,
                self::REAL => Float,
                self::BINARY => 'Blob',
                self::LONGVARBINARY => 'Blob',
                self::YEAR => 'Int',
                self::ARR => Array,
                self::OTHER => , // get() and set() for unknown
                )
Map of Creole type integers to the setter/getter affix.

CreoleTypes::$creoleTypeMap [static, protected]

 

Initial value:

 array(
                self::BOOLEAN => BOOLEAN,
                self::BIGINT => BIGINT,
                self::SMALLINT => SMALLINT,
                self::TINYINT => TINYINT,
                self::INTEGER => INTEGER,
                self::NUMERIC => NUMERIC,
                self::DECIMAL => DECIMAL,
                self::REAL => 'REAL',
                self::FLOAT => FLOAT,
                self::DOUBLE => DOUBLE,
                self::CHAR => 'CHAR',
                self::VARCHAR => VARCHAR,
                self::TEXT => 'TEXT',
                self::TIME => 'TIME',
                self::TIMESTAMP => TIMESTAMP,
                self::DATE => 'DATE',
                self::YEAR => 'YEAR',
                self::VARBINARY => VARBINARY,                
                self::BLOB => 'BLOB',
                self::CLOB => 'CLOB',
                self::LONGVARCHAR => LONGVARCHAR,
                self::BINARY => BINARY,
                self::LONGVARBINARY => LONGVARBINARY,                
                self::ARR => 'ARR',
                self::OTHER => OTHER, // string is "raw" return
                )
Map of Creole type integers to their textual name.

This file is part of the Creole[php5] library.

Copyright © 2004 Hans Lellelid  
Creole[php5] CVS