[ Index ]
 

Code source de PHP PEAR 1.4.5

Accédez au Source d'autres logiciels libresSoutenez Angelica Josefina !

title

Body

[fermer]

/MDB/ -> ibase.php (sommaire)

(pas de description)

Poids: 1856 lignes (69 kb)
Inclus ou requis:0 fois
Référencé: 1 fois
Nécessite: 1 fichier
 MDB/Common.php

Définit 1 class

MDB_ibase:: (52 méthodes):
  MDB_ibase()
  errorCode()
  ibaseRaiseError()
  errorNative()
  autoCommit()
  commit()
  rollback()
  getDatabaseFile()
  _doConnect()
  connect()
  _close()
  _doQuery()
  query()
  _executePreparedQuery()
  _skipLimitOffset()
  getColumnNames()
  numCols()
  endOfResult()
  fetch()
  fetchInto()
  _retrieveLob()
  endOfResultLob()
  _readResultLob()
  _destroyResultLob()
  fetchClob()
  fetchBlob()
  convertResult()
  resultIsNull()
  numRows()
  freeResult()
  getTypeDeclaration()
  getTextDeclaration()
  getClobDeclaration()
  getBlobDeclaration()
  getDateDeclaration()
  getTimeDeclaration()
  getFloatDeclaration()
  getDecimalDeclaration()
  _getLobValue()
  getClobValue()
  freeLobValue()
  freeClobValue()
  getBlobValue()
  freeBlobValue()
  getFloatValue()
  getDecimalValue()
  affectedRows()
  nextId()
  currId()
  nextResult()
  tableInfo()
  _ibaseFieldFlags()


Classe: MDB_ibase  - X-Ref

MDB FireBird/InterBase driver

Notes:
- when fetching in associative mode all keys are lowercased.

- Currently, the driver relies on the Interbase server to use SQL dialect 3
that was introduced with Interbase 6. Some versions of Interbase server,
like the Super Server, do not seem to work by default with dialect 3.
This may lead to errors when trying to create tables using Interbase SQL
data types that are only available when using this dialect version.

- Interbase does not support per field index sorting support. Indexes are
either ascending, descending or both even when they are defined from more
than one field. Currently Metabase Interbase driver uses the index sorting
type given by the first field of the index for which it is specified the
sorting type.

- The numRows method is emulated by fetching all the rows into memory.
Avoid using it if for queries with large result sets.

- Interbase does not provide direct support for returning result sets

- Current Interbase versions do not support altering table field DEFAULT
values and NOT NULL constraint. Text fields' length may only be raised in
increments defined by Interbase, so the Metabase Interbase does not support
altering text field length yet.

- createDatabase and dropDatabase are not supported

- MDB creates Interbase blobs before executing a prepared queries to insert
or update large object fields. If such queries fail to execute, MDB
Interbase driver class is not able to reclaim the database space allocated
for the large object values because there is currently no PHP function to do so.

MDB_ibase()   X-Ref
Constructor


errorCode($errormsg)   X-Ref
Map native error codes to DB's portable ones.  Requires that
the DB implementation's constructor fills in the $errorcode_map
property.

param: $nativecode the native error code, as returned by the backend
return: int a portable MDB error code, or FALSE if this DB

ibaseRaiseError($errno = NULL, $message = NULL)   X-Ref
This method is used to communicate an error and invoke error
callbacks etc.  Basically a wrapper for MDB::raiseError
that checks for native error msgs.

param: integer $errno error code
param: string  $message userinfo message
return: object a PEAR error object

errorNative()   X-Ref
Get the native error code of the last error (if any) that
occured on the current connection.

return: int native ibase error code

autoCommit($auto_commit)   X-Ref
Define whether database changes done on the database be automatically
committed. This function may also implicitly start or end a transaction.

param: boolean $auto_commit flag that indicates whether the database
return: mixed MDB_OK on success, a MDB error on failure

commit()   X-Ref
Commit the database changes done during a transaction that is in
progress. This function may only be called when auto-committing is
disabled, otherwise it will fail. Therefore, a new transaction is
implicitly started after committing the pending changes.

return: mixed MDB_OK on success, a MDB error on failure

rollback()   X-Ref
Cancel any database changes done during a transaction that is in
progress. This function may only be called when auto-committing is
disabled, otherwise it will fail. Therefore, a new transaction is
implicitly started after canceling the pending changes.

return: mixed MDB_OK on success, a MDB error on failure

getDatabaseFile($database_name)   X-Ref
Pas de description

_doConnect($database_name, $persistent)   X-Ref
Does the grunt work of connecting to the database

return: mixed connection resource on success, MDB_Error on failure

connect()   X-Ref
Connect to the database

return: TRUE on success, MDB_Error on failure

_close()   X-Ref
Close the database connection

return: boolean

_doQuery($query, $first=0, $limit=0, $prepared_query=0)   X-Ref
Execute a query

param: string $query the SQL query
return: mixed result identifier if query executed, else MDB_error

query($query, $types = NULL)   X-Ref
Send a query to the database and return any results

param: string $query the SQL query
param: array $types array that contains the types of the columns in
return: mixed result identifier if query executed, else MDB_error

_executePreparedQuery($prepared_query, $query)   X-Ref
Execute a prepared query statement.

param: int $prepared_query argument is a handle that was returned by
param: string $query query to be executed
param: array $types array that contains the types of the columns in
return: mixed a result handle or MDB_OK on success, a MDB error on failure

_skipLimitOffset($result)   X-Ref
Skip the first row of a result set.

param: resource $result
return: mixed a result handle or MDB_OK on success, a MDB error on failure

getColumnNames($result)   X-Ref
Retrieve the names of columns returned by the DBMS in a query result.

param: resource $result  result identifier
return: mixed an associative array variable

numCols($result)   X-Ref
Count the number of columns returned by the DBMS in a query result.

param: resource $result result identifier
return: mixed integer value with the number of columns, a MDB error

endOfResult($result)   X-Ref
check if the end of the result set has been reached

param: resource    $result result identifier
return: mixed TRUE or FALSE on sucess, a MDB error on failure

fetch($result, $rownum, $field)   X-Ref
fetch value from a result set

param: resource $result result identifier
param: int $rownum number of the row where the data can be found
param: int $field field number where the data can be found
return: mixed string on success, a MDB error on failure

fetchInto($result, $fetchmode=MDB_FETCHMODE_DEFAULT, $rownum=null)   X-Ref
Fetch a row and return data in an array.

param: resource $result result identifier
param: int $fetchmode how the array data should be indexed
param: int $rownum the row number to fetch
return: mixed data array or NULL on success, a MDB error on failure

_retrieveLob($lob)   X-Ref
fetch a lob value from a result set

param: int $lob handle to a lob created by the createLob() function
return: mixed MDB_OK on success, a MDB error on failure

endOfResultLob($lob)   X-Ref
Determine whether it was reached the end of the large object and
therefore there is no more data to be read for the its input stream.

param: int    $lob handle to a lob created by the createLob() function
return: mixed TRUE or FALSE on success, a MDB error on failure

_readResultLob($lob, &$data, $length)   X-Ref
Read data from large object input stream.

param: int $lob handle to a lob created by the createLob() function
param: blob $data reference to a variable that will hold data to be
param: int $length integer value that indicates the largest ammount of
return: mixed length on success, a MDB error on failure

_destroyResultLob($lob)   X-Ref
Free any resources allocated during the lifetime of the large object
handler object.

param: int $lob handle to a lob created by the createLob() function

fetchClob($result, $row, $field)   X-Ref
fetch a clob value from a result set

param: resource $result result identifier
param: int $row number of the row where the data can be found
param: int $field field number where the data can be found
return: mixed content of the specified data cell, a MDB error on failure,

fetchBlob($result, $row, $field)   X-Ref
fetch a blob value from a result set

param: resource $result result identifier
param: int $row number of the row where the data can be found
param: int $field field number where the data can be found
return: mixed content of the specified data cell, a MDB error on failure

convertResult($value, $type)   X-Ref
convert a value to a RDBMS indepdenant MDB type

param: mixed $value value to be converted
param: int $type constant that specifies which type to convert to
return: mixed converted value or a MDB error on failure

resultIsNull($result, $rownum, $field)   X-Ref
Determine whether the value of a query result located in given row and
field is a NULL.

param: resource $result result identifier
param: int $rownum number of the row where the data can be found
param: int $field field number where the data can be found
return: mixed TRUE or FALSE on success, a MDB error on failure

numRows($result)   X-Ref
returns the number of rows in a result object

param: ressource $result a valid result ressouce pointer
return: mixed MDB_Error or the number of rows

freeResult($result)   X-Ref
Free the internal resources associated with $result.

param: $result result identifier
return: boolean TRUE on success, FALSE if $result is invalid

getTypeDeclaration($field)   X-Ref
Obtain DBMS specific SQL code portion needed to declare an text type
field to be used in statements like CREATE TABLE.

param: string $field  associative array with the name of the properties
return: string  DBMS specific SQL code portion that should be used to

getTextDeclaration($name, $field)   X-Ref
Obtain DBMS specific SQL code portion needed to declare an text type
field to be used in statements like CREATE TABLE.

param: string $name   name the field to be declared.
param: string $field  associative array with the name of the properties
return: string  DBMS specific SQL code portion that should be used to

getClobDeclaration($name, $field)   X-Ref
Obtain DBMS specific SQL code portion needed to declare an character
large object type field to be used in statements like CREATE TABLE.

param: string $name   name the field to be declared.
param: string $field  associative array with the name of the properties
return: string  DBMS specific SQL code portion that should be used to

getBlobDeclaration($name, $field)   X-Ref
Obtain DBMS specific SQL code portion needed to declare an binary large
object type field to be used in statements like CREATE TABLE.

param: string $name   name the field to be declared.
param: string $field  associative array with the name of the properties
return: string  DBMS specific SQL code portion that should be used to

getDateDeclaration($name, $field)   X-Ref
Obtain DBMS specific SQL code portion needed to declare a date type
field to be used in statements like CREATE TABLE.

param: string $name   name the field to be declared.
param: string $field  associative array with the name of the properties
return: string  DBMS specific SQL code portion that should be used to

getTimeDeclaration($name, $field)   X-Ref
Obtain DBMS specific SQL code portion needed to declare a time
field to be used in statements like CREATE TABLE.

param: string $name   name the field to be declared.
param: string $field  associative array with the name of the properties
return: string  DBMS specific SQL code portion that should be used to

getFloatDeclaration($name, $field)   X-Ref
Obtain DBMS specific SQL code portion needed to declare a float type
field to be used in statements like CREATE TABLE.

param: string $name   name the field to be declared.
param: string $field  associative array with the name of the properties
return: string  DBMS specific SQL code portion that should be used to

getDecimalDeclaration($name, $field)   X-Ref
Obtain DBMS specific SQL code portion needed to declare a decimal type
field to be used in statements like CREATE TABLE.

param: string $name   name the field to be declared.
param: string $field  associative array with the name of the properties
return: string  DBMS specific SQL code portion that should be used to

_getLobValue($prepared_query, $parameter, $lob)   X-Ref
Convert a text value into a DBMS specific format that is suitable to
compose query statements.

param: resource  $prepared_query query handle from prepare()
param: $parameter
param: $lob
return: string text string that represents the given argument value in

getClobValue($prepared_query, $parameter, $clob)   X-Ref
Convert a text value into a DBMS specific format that is suitable to
compose query statements.

param: resource  $prepared_query query handle from prepare()
param: $parameter
param: $clob
return: string text string that represents the given argument value in

freeLobValue($prepared_query, $lob, &$value)   X-Ref
free a large object

param: resource  $prepared_query query handle from prepare()
param: string    $lob
param: string    $value
return: MDB_OK

freeClobValue($prepared_query, $clob, &$value)   X-Ref
free a character large object

param: resource  $prepared_query query handle from prepare()
param: string    $clob
param: string    $value
return: MDB_OK

getBlobValue($prepared_query, $parameter, $blob)   X-Ref
Convert a text value into a DBMS specific format that is suitable to
compose query statements.

param: resource  $prepared_query query handle from prepare()
param: $parameter
param: $blob
return: string text string that represents the given argument value in

freeBlobValue($prepared_query, $blob, &$value)   X-Ref
free a binary large object

param: resource  $prepared_query query handle from prepare()
param: string    $blob
param: string    $value
return: MDB_OK

getFloatValue($value)   X-Ref
Convert a text value into a DBMS specific format that is suitable to
compose query statements.

param: string $value text string value that is intended to be converted.
return: string text string that represents the given argument value in

getDecimalValue($value)   X-Ref
Convert a text value into a DBMS specific format that is suitable to
compose query statements.

param: string $value text string value that is intended to be converted.
return: string text string that represents the given argument value in

affectedRows()   X-Ref
returns the affected rows of a query

return: mixed MDB Error Object or number of rows

nextId($seq_name, $ondemand = true)   X-Ref
returns the next free id of a sequence

param: string  $seq_name name of the sequence
param: boolean $ondemand when TRUE the seqence is
return: mixed MDB_Error or id

currId($seq_name)   X-Ref
returns the current id of a sequence

param: string  $seq_name name of the sequence
return: mixed MDB_Error or id

nextResult($result)   X-Ref
Move the internal ibase result pointer to the next available result

param: $result a valid ibase result resource
return: TRUE if a result is available otherwise return FALSE

tableInfo($result, $mode = NULL)   X-Ref
returns meta data about the result set

param: mixed $resource FireBird/InterBase result identifier or table name
param: mixed $mode depends on implementation
return: array an nested array, or a MDB error

_ibaseFieldFlags($resource, $num_field, $table_name)   X-Ref
get the Flags of a Field

param: int $resource FireBird/InterBase result identifier
param: int $num_field the field number
return: string The flags of the field ('not_null', 'default_xx', 'primary_key',



Généré le : Sun Feb 25 14:08:00 2007 par Balluche grâce à PHPXref 0.7