ecphp / doctrine-oci8
Doctrine's OCI8 (Oracle) driver with cursor support.
Installs: 5 167
Dependents: 1
Suggesters: 0
Security: 0
Stars: 0
Watchers: 2
Forks: 1
Open Issues: 3
Requires
- php: >= 7.4
- ext-oci8: *
- doctrine/dbal: ^2.6
Requires (Dev)
- drupol/php-conventions: ^3.0
- phpunit/phpunit: ^9
- symfony/dotenv: ^5
This package is auto-updated.
Last update: 2024-10-21 13:55:15 UTC
README
Doctrine OCI8 Driver
The Doctrine OCI8 driver with cursor support, for PHP >= 7.4.
This is a fork of the original package develpup/doctrine-oci8-extended from Jason Hofer.
Installation
composer require ecphp/doctrine-oci8
Configuration
Symfony 5
Use the ecphp/doctrine-oci8-bundle to automatically configure the parameters.
If you prefer modifying the configuration, edit the doctrine.yaml
as such:
doctrine: dbal: driver_class: EcPhp\DoctrineOci8\Doctrine\DBAL\Driver\OCI8\Driver types: cursor: EcPhp\DoctrineOci8\Doctrine\DBAL\Types\CursorType
Usage
<?php namespace App; use Doctrine\DBAL\Types\Type; use EcPhp\DoctrineOci8\Doctrine\DBAL\Types\CursorType; use EcPhp\DoctrineOci8\Doctrine\DBAL\Driver\OCI8\Driver; include __DIR__ .'/vendor/autoload.php'; // Register the custom type. if (false === Type::hasType('cursor')) { Type::addType('cursor', CursorType::class); } $config = new Doctrine\DBAL\Configuration(); $params = [ 'dbname' => 'database_sid', 'user' => 'database_username', 'password' => 'database_password', 'host' => 'database.host', 'port' => 1521, 'persistent' => true, 'driverClass' => Driver::class, // This is where we load the driver. ]; $conn = Doctrine\DBAL\DriverManager::getConnection($params, $config); $stmt = $conn->prepare('BEGIN MY_STORED_PROCEDURE(:user_id, :cursor); END;'); $stmt->bindValue('user_id', 42); $stmt->bindParam('cursor', $cursor, \PDO::PARAM_STMT); $stmt->execute(); /** @var $cursor EcPhp\DoctrineOci8\Doctrine\DBAL\Driver\OCI8\OCI8Cursor */ $cursor->execute(); while ($row = $cursor->fetch()) { print_r($row); echo PHP_EOL; } $cursor->closeCursor(); $stmt->closeCursor();
Types
For OCI8
types that are not represented by PDO::PARAM_
constants, pass
OCI8::PARAM_
constants as the type
argument of bindValue()
and
bindParam()
.
Cursors
Cursors can be specified as PDO::PARAM_STMT
, OCI8::PARAM_CURSOR
, or just
'cursor'
. Only the bindParam()
method can be used to bind a cursor to
a statement.
Sub-Cursors
Cursor resources returned in a column of a result set are automatically fetched. You can change this behavior by passing in one of these fetch mode flags:
OCI8::RETURN_RESOURCES
to return the raw PHP resources.OCI8::RETURN_CURSORS
to return theOCI8Cursor
objects that have not yet been executed.
use Doctrine\DBAL\Driver\OCI8\OCI8; $rows = $stmt->fetchAll(\PDO::FETCH_ASSOC+OCI8::RETURN_CURSORS); $rows = $stmt->fetchAll(\PDO::FETCH_BOTH+OCI8::RETURN_RESOURCES);
Special thanks to Michal Tichý for his patch.
Tests
In order to have a working development environment, tests are Docker based.
To run the tests, do the following steps
cp .env.example .env
docker-compose up -d
docker-compose exec php ./vendor/bin/phpunit
CTRL+C
docker-compose down