Symfony 1.0.0 : Vue détaillée de OCI8Connection.php

[Code source] [Imprimer] [Statistiques]

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES ( INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION ) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT ( INCLUDING NEGLIGENCE OR OTHERWISE ) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. This software consists of voluntary contributions made by many individuals and is licensed under the LGPL. For more information please see <http://creole.phpdb.org>.

Poids:	398 lignes (10 kb)
Inclus ou requis:	0 fois
Référencé:	0 fois
Nécessite:	0 fichiers

Définit 1 class

OCI8Connection:: (15 méthodes):
  connect()
  close()
  executeQuery()
  executeUpdate()
  beginTrans()
  commitTrans()
  rollbackTrans()
  getUpdateCount()
  applyLimit()
  nativeError()
  getDatabaseInfo()
  getIdGenerator()
  prepareStatement()
  prepareCall()
  createStatement()

Classe: OCI8Connection - X-Ref

Oracle implementation of Connection.

connect( $dsninfo, $flags = 0 ) X-Ref

Connect to a database and log in as the specified user.

param: array $dsn The data source hash.
param: int $flags Any connection flags.
return: void

close() X-Ref

executeQuery( $sql, $fetchmode = null ) X-Ref

executeUpdate( $sql ) X-Ref

beginTrans() X-Ref

Start a database transaction.

return: void

commitTrans() X-Ref

Commit the current transaction.

return: void

rollbackTrans() X-Ref

Roll back ( undo ) the current transaction.

return: void

getUpdateCount() X-Ref

Gets the number of rows affected by the data manipulation
query.

return: int Number of rows affected by the last query.

applyLimit( &$sql, $offset, $limit ) X-Ref

Build Oracle-style query with limit or offset.
If the original SQL is in variable: query then the requlting
SQL looks like this:
<pre>
SELECT B.* FROM (
SELECT A.*, rownum as TORQUE$ROWNUM FROM (
query
) A
) B WHERE B.TORQUE$ROWNUM > offset AND B.TORQUE$ROWNUM
<= offset + limit
</pre>

param: string &$sql the query
param: int $offset
param: int $limit
return: void ( $sql parameter is currently manipulated directly )

nativeError( $result = null ) X-Ref

Get the native Oracle Error Message as a string.

param: string $msg The Internal Error Message
param: mixed $errno The Oracle Error resource

getDatabaseInfo() X-Ref

getIdGenerator() X-Ref

prepareStatement( $sql ) X-Ref

Oracle supports native prepared statements, but the oci_parse call
is actually called by the OCI8PreparedStatement class because
some additional SQL processing may be necessary ( e.g. to apply limit ).

prepareCall( $sql ) X-Ref

createStatement() X-Ref

Code source de Symfony 1.0.0

/lib/vendor/creole/drivers/oracle/ -> OCI8Connection.php (sommaire)

Définit 1 class