Class: MDB2_Driver_querysim

Source Location: /MDB2-2.0.0beta4/MDB2/Driver/querysim.php

Class Overview

PEAR
   |
   --MDB2_Driver_Common
      |
      --MDB2_Driver_querysim

MDB2 QuerySim driver

Author(s):

Alan Richmond <mailto:arichmond at bigfoot.com>

Variables

$escape_quotes

Methods

Inherited Variables

Class: MDB2_Driver_Common

MDB2_Driver_Common::$blobs
MDB2_Driver_Common::$clobs
MDB2_Driver_Common::$connected_database_name
MDB2_Driver_Common::$connected_dsn
MDB2_Driver_Common::$connection
MDB2_Driver_Common::$database_name
MDB2_Driver_Common::$dbsyntax
MDB2_Driver_Common::$db_index
MDB2_Driver_Common::$debug_output
MDB2_Driver_Common::$destructor_registered
MDB2_Driver_Common::$dsn
MDB2_Driver_Common::$fetchmode
MDB2_Driver_Common::$in_transaction
MDB2_Driver_Common::$last_query
MDB2_Driver_Common::$lobs
MDB2_Driver_Common::$modules
MDB2_Driver_Common::$opened_persistent
MDB2_Driver_Common::$options
MDB2_Driver_Common::$phptype
MDB2_Driver_Common::$row_limit
MDB2_Driver_Common::$row_offset
MDB2_Driver_Common::$supported
MDB2_Driver_Common::$warnings

Inherited Methods

Class: MDB2_Driver_Common

MDB2_Driver_Common::MDB2_Driver_Common(): PHP 4 Constructor
MDB2_Driver_Common::beginTransaction(): Start a transaction.
MDB2_Driver_Common::commit(): 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.
MDB2_Driver_Common::compareDefinition(): Obtain an array of changes that may need to applied
MDB2_Driver_Common::currID(): returns the current id of a sequence
MDB2_Driver_Common::debug(): set a debug message
MDB2_Driver_Common::debugOutput(): output debug info
MDB2_Driver_Common::disconnect(): Log out and disconnect from the database.
MDB2_Driver_Common::errorInfo(): This method is used to collect information about an error
MDB2_Driver_Common::errorNative(): returns an errormessage, provides by the database
MDB2_Driver_Common::escape(): Quotes a string so it can be safely used in a query. It will quote the text so it can safely be used within a query.
MDB2_Driver_Common::getAfterID(): returns the autoincrement ID if supported or $id
MDB2_Driver_Common::getBeforeID(): returns the next free id of a sequence if the RDBMS does not support auto increment
MDB2_Driver_Common::getDatabase(): get the current database
MDB2_Driver_Common::getDeclaration(): Obtain DBMS specific SQL code portion needed to declare of the given type
MDB2_Driver_Common::getDSN(): return the DSN as a string
MDB2_Driver_Common::getOption(): returns the value of an option
MDB2_Driver_Common::getSequenceName(): adds sequence name formating to a sequence name
MDB2_Driver_Common::getWarnings(): get all warnings in reverse order.
MDB2_Driver_Common::loadModule(): loads a module
MDB2_Driver_Common::nextID(): returns the next free id of a sequence
MDB2_Driver_Common::prepare(): Prepares a query for multiple execution with execute().
MDB2_Driver_Common::query(): Send a query to the database and return any results
MDB2_Driver_Common::queryAll(): Execute the specified query, fetch all the rows of the result set into a two dimensional array and then frees the result set.
MDB2_Driver_Common::queryCol(): Execute the specified query, fetch the value from the first column of each row of the result set into an array and then frees the result set.
MDB2_Driver_Common::queryOne(): Execute the specified query, fetch the value from the first column of the first row of the result set and then frees the result set.
MDB2_Driver_Common::queryRow(): Execute the specified query, fetch the values from the first row of the result set into an array and then frees the result set.
MDB2_Driver_Common::quote(): Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB2_Driver_Common::quoteIdentifier(): Quote a string so it can be safely used as a table or column name
MDB2_Driver_Common::raiseError(): This method is used to communicate an error and invoke error callbacks etc. Basically a wrapper for PEAR::raiseError without the message string.
MDB2_Driver_Common::replace(): Execute a SQL REPLACE query. A REPLACE query is identical to a INSERT query, except that if there is already a row in the table with the same key field values, the REPLACE query just updates its values instead of inserting a new row.
MDB2_Driver_Common::resetWarnings(): reset the warning array
MDB2_Driver_Common::rollback(): 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.
MDB2_Driver_Common::setDatabase(): Select a different database
MDB2_Driver_Common::setDSN(): set the DSN
MDB2_Driver_Common::setFetchMode(): Sets which fetch mode should be used by default on queries on this connection
MDB2_Driver_Common::setLimit(): set the range of the next query
MDB2_Driver_Common::setOption(): set the option for the db class
MDB2_Driver_Common::standaloneQuery(): execute a query as database administrator
MDB2_Driver_Common::subSelect(): simple subselect emulation: leaves the query untouched for all RDBMS that support subselects
MDB2_Driver_Common::supports(): Tell whether a DB implementation or its backend extension supports a given feature.
MDB2_Driver_Common::_convertEmptyArrayValuesToNull(): Convert all empty values in an array to null strings
MDB2_Driver_Common::_doQuery(): Execute a query
MDB2_Driver_Common::_modifyQuery(): Changes a query string for various DBMS specific reasons
MDB2_Driver_Common::_rtrimArrayValues(): Right trim all strings in an array
MDB2_Driver_Common::_wrapResult(): wrap a result set into the correct class
MDB2_Driver_Common::__toString(): String conversation

Class Details

[line 216]
MDB2 QuerySim driver

Author: Alan Richmond <mailto:arichmond@bigfoot.com>

[ Top ]

Class Variables

$escape_quotes = "\\"

[line 219]

Type:	mixed
Overrides:	Array

[ Top ]

Method Detail

connect [line 264]

mixed connect(
)

Open a file or simulate a successful database connect

Return: MDB2_OK string on success, a MDB2 error object on failure
Access: public

[ Top ]

disconnect [line 315]

mixed disconnect(
)

Log out and disconnect from the database.

Return: true on success, false if not connected and error object on error
Access: public

Overrides MDB2_Driver_Common::disconnect() (Log out and disconnect from the database.)

[ Top ]

_buildResult [line 405]

multi-dimensional _buildResult(
string
$query)

Convert QuerySim text into an array

Return: array containing the column names and data from the QuerySim
Access: protected

Parameters:

string $query — Text of simulated query

[ Top ]

_doQuery [line 340]

result _doQuery(
string
$query, [boolean
$isManip = false], [resource
$connection = null], [string
$database_name = null])

Execute a query

Return: or error object
Access: protected

Overrides MDB2_Driver_Common::_doQuery() (Execute a query)

Parameters:

string	`$query`	—	query
boolean	`$isManip`	—	if the query is a manipulation query
resource	`$connection`	—
string	`$database_name`	—

[ Top ]

_parseOnDelim [line 483]

array _parseOnDelim(
string
$thisLine, string
$delim)

Split QuerySim string into an array on a delimiter

Return: containing parsed string
Access: protected

Parameters:

string	`$thisLine`	—	Text of simulated query
string	`$delim`	—	The delimiter to split on

[ Top ]

_readFile [line 375]

string _readFile(
string
0)

Read an external file

Return: the contents of a file
Access: protected

Parameters:

string 0 — filepath/filename

[ Top ]