darlane/oracle-laravel-vendor

Vendor for oracle at laravel

oracle-laravel-vendor

Vendor for oracle at laravel, _(*1)

Add to app.php at 'providers' block:, _(*2)

\OracleLib\Providers\OracleServiceProvider::class

Next:, _(*3)

php artisan vendor:publish --provider="\OracleLib\Providers\OracleServiceProvider" --tag="config"

Create trait, like at example:, _(*4)

trait OracleRepositoryList
{

}

Next all new repository add at this trait and AppServiceProvider, _(*5)

/**
 * @return FooRepository
 */
public function fooRepository()
{
    return app(FooRepository::class);
}

At AppServiceProvider, _(*6)

public function boot()
{
    $this->app->singleton(FooRepository::class, function () {
        return new FooRepository(app('oracle'));
    }); 
}

At class, where you wanna use this repo add trait and use it like this:, _(*7)

class FooClass
{
   use OracleRepositoryList;

   public function method()
   {
       $this->testRepository()->test()
   }
}

Example call function with cursor:, _(*8)

$result = $this->execute(
        [
            'function'    => 'devdb.get_stat',
            'return_type' => 'cursor',
        ],
        [
            'p_id_user' => 1,
        ]);

$stats  = array_keys_rename($result['cursor'], [
    'EXPERIENCE'     => 'experience',
    'STATUS'         => 'status',
    'DT              => 'date',
]);
$stats  = array_keys_set_type($stats, [
    'experience'                => 'integer',
    'status'                    => 'integer',
    'credit_date'               => 'date',
]);