Download the PHP package ioigoume/cakephp5-oracle-driver without Composer
On this page you can find all versions of the php package ioigoume/cakephp5-oracle-driver. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package cakephp5-oracle-driver
CakePHP 5 Driver for Oracle Database
Installation
You can install this plugin into your CakePHP application using Composer.
The recommended way to install Composer packages is:
Ensure the Oracle Plugin is loaded in your src/Application.php file
Requirements
- CakePHP 5.2+
- an Oracle PHP extension
- OCI8 (PHP extension built with PHP)
- PDO_OCI (PHP extension built with PHP)
Notes on extensions
For full support, it is recommended to run the OCI8 extension if possible.
While PDO_OCI might be simpler to set up, there are some limitations (e.g.
it doesn't support the stored code layer, so only the SQL layer will be
available.)
Datasource configuration
Here is an example datasource configuration:
For oracle 12g should be used config settings server_version with value 12. If version is greater or equals to 12 the plugin uses new oracle pagination features.
Additional if autoincrement is set to true, then for primary keys in fixtures used new orale autoincreament feature.
As you can see, the className and driver need switched to Oracle-specific
classes. The driver will depend on whether you want to use PDO or not. The
database name "XE" in this case, is defined as the SERVICE_NAME in Oracle's
system-wide tnsnames.ora file.
The above array format is translated into Oracle's
Easy Connection Naming. You can find the logic for this in
\Ioigoume\OracleDriver\Database\Driver\OracleBase::getDSN().
Case handling
Semantic option
Use the semantic case option to control how column names are cased in fetched rows.
case => 'lower' | 'upper' | 'natural'
Raw flags
Alternatively, set the PDO flag directly.
flags => [PDO::ATTR_CASE => PDO::CASE_LOWER]
Documentation
For documentation, as well as tutorials, see the docs directory of this repository.
Roadmap
- Provide full compatibility with Phinx based migrations
- Provide compatibility with Oracle database version 12
- Transform data types into native PHP types when returned form the database @todo copy todos to the roadmap
Support
For bugs and feature requests, please use the issues section of this repository.
License
Copyright 2024 - Cake Development Corporation (CakeDC). All rights reserved.
Licensed under the MIT License. Redistributions of the source code included in this repository must retain the copyright notice found in each file.
All versions of cakephp5-oracle-driver with dependencies
cakephp/cakephp Version ^5.2
cakephp/chronos Version ^3.1
ext-pdo Version *