marcuoli/oracledb

Oracle DB driver for Laravel 4+

Laravel 4.1 Oracle Database Package

OracleDB

OracleDB is an Oracle Database Driver package for Laravel 4.1. OracleDB is an extension of Illuminate/Database that uses the (Thanks to @taylorotwell), _(*1)

Please report any bugs you may find., _(*2)

• Installation
• Basic Usage
• Query Builder
• Eloquent
• Schema
• Migrations
• License

Installation

Add marcuoli/oracledb as a requirement to composer.json:, _(*3)

{
    "require": {
        "marcuoli/oracledb": "*"
    }
}

And then run composer update, _(*4)

Once Composer has installed or updated your packages you need to register OracleDB. Open up app/config/app.php and find the providers key and add:, _(*5)

'Jfelder\OracleDB\OracleDBServiceProvider'

Finally you need to publish a configuration file by running the following Artisan command., _(*6)

$ php artisan config:publish marcuoli/oracledb

This will copy the configuration file to app/config/packages/jfelder/oracledb/database.php, _(*7)

Basic Usage

The configuration file for this package is located at 'app/config/packages/jfelder/oracledb/database.php'. In this file you may define all of your oracle database connections. If you want to make one of these connections the default connection, enter the name you gave the connection into the "Default Database Connection Name" section in 'app/config/database.php'., _(*8)

Once you have configured the OracleDB database connection(s), you may run queries using the 'DB' class as normal., _(*9)

$results = DB::select('select * from users where id = ?', array(1));

The above statement assumes you have set the default connection to be the oracle connection you setup in OracleDB's config file and will always return an 'array' of results., _(*10)

$results = DB::connection('oracle')->select('select * from users where id = ?', array(1));

Just like the built-in database drivers, you can use the connection method to access the oracle database(s) you setup in OracleDB's config file., _(*11)

See Laravel 4 Database Basic Docs for more information., _(*12)

Query Builder

You can use the Query Builder functionality exactly the same as you would with the default DB class in Laravel 4. Every query on Laravel 4 Database Query Builder Docs has been tested to ensure that it works., _(*13)

Offset & Limit, _(*14)

$users = DB::table('users')->skip(10)->take(5)->get();

See Laravel 4 Database Query Builder Docs for more information., _(*15)

Eloquent

See Laravel 4 Eloquent Docs for more information., _(*16)

Schema (WIP)

See Laravel 4 Schema Docs for more information., _(*17)

Migrations (WIP)

See Laravel 4 Migrations Docs for more information., _(*18)

License

Licensed under the MIT License., _(*19)