DboFirebird Class Reference

Inheritance diagram for DboFirebird:

DboSource DataSource Object List of all members.

Public Member Functions

 _execute ($sql)
 column ($real)
 connect ()
 describe (&$model)
 disconnect ()
 fetchResult ()
 fetchRow ()
 lastAffected ()
 lastError ()
 lastInsertId ($source=null, $field= 'id')
 lastNumRows ()
 limit ($limit, $offset=null)
 listSources ()
 name ($data)
 renderStatement ($type, $data)
 resultSet (&$results)
 update (&$model, $fields=array(), $values=array())
 value ($data, $column=null, $safe=false)

Public Attributes

 $__fieldMappings = array()
 $_baseConfig
 $_commands
 $alias = ' '
 $columns
 $description = "Firebird/Interbase DBO Driver"
 $endQuote = "\'"
 $goofyLimit = true
 $modeltmp = array()
 $startQuote = "\'"

Detailed Description

Definition at line 35 of file dbo_firebird.php.

Member Function Documentation

DboFirebird::_execute ( $  sql  ) 

Executes given SQL statement.

Parameters:
string $sql SQL statement
Returns:
resource Result resource identifier protected

Definition at line 149 of file dbo_firebird.php.

DboFirebird::column ( $  real  ) 

Converts database-layer column types to basic types

Parameters:
string $real Real database-layer column type (i.e. "varchar(255)")
Returns:
string Abstract column type (i.e. "string")

Reimplemented from DataSource.

Definition at line 395 of file dbo_firebird.php.

References limit(), and name().

Referenced by describe().

DboFirebird::connect (  ) 

Connects to the database using options in the given configuration array.

Returns:
boolean True if the database could be connected, else false

Definition at line 125 of file dbo_firebird.php.

References DataSource::$config, and config().

DboFirebird::describe ( &$  model  ) 

Returns an array of the fields in given table name.

Parameters:
Model $model Model object to describe
Returns:
array Fields in table. Keys are name and type

Definition at line 195 of file dbo_firebird.php.

References DataSource::__cacheDescription(), column(), DboSource::fullTableName(), DboSource::length(), and name().

DboFirebird::disconnect (  ) 

Disconnects from database.

Returns:
boolean True if the database could be disconnected, else false

Definition at line 138 of file dbo_firebird.php.

DboFirebird::fetchResult (  ) 

Fetches the next row from the current result set

Returns:
unknown

Definition at line 492 of file dbo_firebird.php.

References DboSource::$index.

Referenced by fetchRow().

DboFirebird::fetchRow (  ) 

Returns a row from given resultset as an array .

Returns:
array The fetched row as an array

Definition at line 157 of file dbo_firebird.php.

References fetchResult(), DboSource::hasResult(), and resultSet().

Referenced by lastInsertId().

DboFirebird::lastAffected (  ) 

Returns number of affected rows in previous database operation. If no previous operation exists, this returns false.

Returns:
integer Number of affected rows

Definition at line 313 of file dbo_firebird.php.

DboFirebird::lastError (  ) 

Returns a formatted error message from previous database operation.

Returns:
string Error message with error number

Definition at line 299 of file dbo_firebird.php.

References DataSource::$error.

DboFirebird::lastInsertId ( $  source = null,
$  field = 'id' 
)

Returns the ID generated from the previous INSERT operation.

Parameters:
unknown_type $source
Returns:
in

Definition at line 334 of file dbo_firebird.php.

References $res, fetchRow(), and DboSource::rawQuery().

DboFirebird::lastNumRows (  ) 

Returns number of rows in previous resultset. If no previous resultset exists, this returns false.

Returns:
integer Number of rows in resultset

Definition at line 325 of file dbo_firebird.php.

DboFirebird::limit ( $  limit,
$  offset = null 
)

Returns a limit statement in the correct format for the particular database.

Parameters:
integer $limit Limit of results returned
integer $offset Offset from which to start results
Returns:
string SQL limit/offset statement

Reimplemented from DboSource.

Definition at line 373 of file dbo_firebird.php.

Referenced by column().

DboFirebird::listSources (  ) 

Returns an array of sources (tables) in the database.

Returns:
array Array of tablenames in the database

Definition at line 171 of file dbo_firebird.php.

DboFirebird::name ( $  data  ) 

Returns a quoted name of $data for use in an SQL statement.

Parameters:
string $data Name (table.field) to be prepared for use in an SQL statement
Returns:
string Quoted for Firebird

Reimplemented from DboSource.

Definition at line 225 of file dbo_firebird.php.

Referenced by column(), and describe().

DboFirebird::renderStatement ( $  type,
$  data 
)

Builds final SQL statement

Parameters:
string $type Query type
array $data Query data
Returns:
string

Reimplemented from DboSource.

Definition at line 469 of file dbo_firebird.php.

References offset().

DboFirebird::resultSet ( &$  results  ) 

Enter description here...

Parameters:
unknown_type $results

Definition at line 445 of file dbo_firebird.php.

References DboSource::$index.

Referenced by fetchRow().

DboFirebird::update ( &$  model,
$  fields = array(),
$  values = array() 
)

Removes Identity (primary key) column from update data before returning to parent

Parameters:
Model $model
array $fields
array $values
Returns:
array

Reimplemented from DataSource.

Definition at line 284 of file dbo_firebird.php.

DboFirebird::value ( $  data,
$  column = null,
$  safe = false 
)

Returns a quoted and escaped string of $data for use in an SQL statement.

Parameters:
string $data String to be prepared for use in an SQL statement
string $column The column into which this data will be inserted
boolean $safe Whether or not numeric data should be handled automagically if no column data is provided
Returns:
string Quoted and escaped data

Reimplemented from DboSource.

Definition at line 249 of file dbo_firebird.php.

References DboSource::boolean().

Member Data Documentation

DboFirebird::$__fieldMappings = array()

Definition at line 77 of file dbo_firebird.php.

DboFirebird::$_baseConfig

Initial value:

 array(
        'persistent' => true,
        'host' => 'localhost',
        'login' => 'SYSDBA',
        'password' => 'masterkey',
        'database' => 'c:\\CAKE.FDB',
        'port' => '3050',
        'connect' => 'ibase_connect'
    )

Reimplemented from DataSource.

Definition at line 83 of file dbo_firebird.php.

DboFirebird::$_commands

Initial value:

 array(
        'begin'    => 'SET TRANSACTION',
        'commit'   => 'COMMIT',
        'rollback' => 'ROLLBACK'
    )

Reimplemented from DboSource.

Definition at line 115 of file dbo_firebird.php.

DboFirebird::$alias = ' '

Reimplemented from DboSource.

Definition at line 65 of file dbo_firebird.php.

DboFirebird::$columns

Initial value:

 array(
        'primary_key' => array('name' => 'IDENTITY (1, 1) NOT NULL'),
        'string'    => array('name'  => 'varchar', 'limit' => '255'),
        'text'      => array('name' => 'BLOB SUB_TYPE 1 SEGMENT SIZE 100 CHARACTER SET NONE'),
        'integer'   => array('name' => 'integer'),
        'float'     => array('name' => 'float', 'formatter' => 'floatval'),
        'datetime'  => array('name' => 'timestamp', 'format'    => 'd.m.Y H:i:s', 'formatter' => 'date'),
        'timestamp' => array('name' => 'timestamp', 'format'     => 'd.m.Y H:i:s', 'formatter' => 'date'),
        'time'      => array('name' => 'time', 'format'    => 'H:i:s', 'formatter' => 'date'),
        'date'      => array('name' => 'date', 'format'    => 'd.m.Y', 'formatter' => 'date'),
        'binary'    => array('name' => 'blob'),
        'boolean'   => array('name' => 'smallint')
    )

Definition at line 97 of file dbo_firebird.php.

DboFirebird::$description = "Firebird/Interbase DBO Driver"

Reimplemented from DboSource.

Definition at line 41 of file dbo_firebird.php.

DboFirebird::$endQuote = "\'"

Reimplemented from DataSource.

Definition at line 59 of file dbo_firebird.php.

DboFirebird::$goofyLimit = true

Definition at line 71 of file dbo_firebird.php.

DboFirebird::$modeltmp = array()

Definition at line 47 of file dbo_firebird.php.

DboFirebird::$startQuote = "\'"

Reimplemented from DataSource.

Definition at line 53 of file dbo_firebird.php.

The documentation for this class was generated from the following file:
Generated on Sun Nov 22 00:30:55 2009 for CakePHP 1.2.x.x (v1.2.4.8284) by doxygen 1.4.7