Properties

Properties existing in the Solar_Sql_Adapter class.

Public

None.

Protected

$_Solar_Sql_Adapter

(array) Default configuration values.

$_cache

(Solar_Cache_Adapter) A cache object for keeping query results.

$_cache_key_prefix

(string) Prefix all cache keys with this string.

$_config

(array) Collection point for configuration values.

Inherited from Solar_Base.

Note that you do not define config defaults in $_config directly.

<?php
// DO NOT DO THIS
protected $_config = array(
    'foo' => 'bar',
    'baz' => 'dib',
);

Instead, define config defaults in a protected property named for the class, withan underscore prefix.

For exmple, a "Vendor_Class_Name" class would define the default config array in "$_Vendor_Class_Name". This convention lets child classes inherit parent config keys and values.

<?php
// DO THIS INSTEAD
protected $_Vendor_Class_Name = array(
    'foo' => 'bar',
    'baz' => 'dib',
);

$_dsn

(string) A PDO-style DSN, for example, "mysql:host=127.0.0.1;dbname=test".

$_ident_quote_prefix

(string) The quote character before an identifier name (table, index, etc).

$_ident_quote_suffix

(string) The quote character after an identifier name (table, index, etc).

$_maxlen

(array) Max identifier lengths for table, column, and index names used when creating portable tables.

We use 30 characters to comply with Oracle maximums.

$_native_solar

(array) Map of native RDBMS types to Solar generic types used when reading table column information.

See the individual adapters for specific mappings.

$_pdo

(object) A PDO object for accessing the RDBMS.

$_pdo_type

(string) The PDO adapter DSN type.

This might not be the same as the Solar adapter type.

$_profile

(array) A quick-and-dirty query profile array.

Each element is an array, where the first value is the query execution time in microseconds, and the second value is the query string.

Only populated when the profiling config key is true.

$_profiling

(bool) Whether or not profiling is turned on.

$_solar_native

(array) Map of Solar generic types to RDBMS native types used when creating portable tables.

See the individual adapters for specific mappings.

The available generic column types are ...

char

A fixed-length string of 1-255 characters.

varchar

A variable-length string of 1-255 characters.

bool

A true/false boolean, generally stored as an integer 1 or 0. May also be stored as null, allowing for ternary logic.

smallint

A 2-byte integer in the range of -32767 ... +32768.

int

A 4-byte integer in the range of -2,147,483,648 ... +2,147,483,647.

bigint

An 8-byte integer, value range roughly (-9,223,372,036,854,780,000 ... +9,223,372,036,854,779,999).

numeric

A fixed-point decimal number of a specific size (total number of digits) and scope (the number of those digits to the right of the decimal point).

float

A double-precision floating-point decimal number.

clob

A character large object with a size of up to 2,147,483,647 bytes (about 2 GB).

date

An ISO 8601 date; for example, '1979-11-07'.

time

An ISO 8601 time; for example, '12:34:56'.

timestamp

An ISO 8601 timestamp without a timezone offset; for example, '1979-11-07 12:34:56'.

Private

None.



Local