sozinov/laravel-6-firebird-role

A Firebird database driver for Laravel 6 with role in dsn

dev-master 2020-06-23 17:41 UTC

Requires

• php: ^7.2
• ext-pdo: *
• illuminate/database: ^6.0|^7.0
• illuminate/support: ^6.0|^7.0

MIT

• Sozinov Evgeniy
• Kuba Szymanowski
• Jacques van Zuydam

README

Based on Package KKSzymanowski/laravel-6-firebird but simplified, modernized and made compatible with Laravel 6.

Installation

composer require "sozinov/laravel-6-firebird-role:*"

Add you database configuration in config/database.php

'connections' => [
    'myFirebirdConnection' => [
        'driver'=> 'firebird',
        'host'=> env('DB_FIREBIRD_HOST', 'localhost'),
        'database' => env('DB_FIREBIRD_DATABASE', '/path_to/database.fdb'),
        'username' => env('DB_FIREBIRD_USERNAME', 'SYSDBA'),
        'password' => env('DB_FIREBIRD_PASSWORD', 'masterkey'),
        'charset'  => env('DB_FIREBIRD_CHARSET', 'UTF8'),
		'role'     => env('DB_FIREBIRD_ROLE', ''), 
    ],

    // ...
],

Add the DB_FIREBIRD_* environment variables to you .env file, for example:

DB_FIREBIRD_HOST=192.168.0.1
DB_FIREBIRD_DATABASE=C:/DB.FDB
DB_FIREBIRD_USERNAME=user
DB_FIREBIRD_PASSWORD=password
DB_FIREBIRD_CHARSET=ISO-8859-2
DB_FIREBIRD_ROLE='' 

Usage

Eloquent as model

To override your default database connection define $connection name in your Eloquent Model

/**
 * The connection name for the model.
 *
 * @var string
 */
protected $connection = 'myFirebirdConnection';

After defining connection name you can use it in normal way as you use Eloquent:

$user = User::where('id', 1)->get();

$users = User::all();

DB Query

Each time you have to define connecion name (if it isn't your default one), for example:

$sql = 'SELECT * FROM USERS WHERE id = :id';
$bindings = ['id' => 1];
$user = DB::connection('myFirebirdConnection')->select($sql, $bindings);

$users = DB::connection('myFirebirdConnection')->table('USERS')->select('*')->get();