2017 © Pedro Peláez
 

library db2-laravelumen

db2-laravelumen is a simple DB2 service provider for Laravel or Lumen v5.2. It provides a DB2 Connection by extending the Illuminate Database component working with both query builder and eloquent.

image

geiger-it/db2-laravelumen

db2-laravelumen is a simple DB2 service provider for Laravel or Lumen v5.2. It provides a DB2 Connection by extending the Illuminate Database component working with both query builder and eloquent.

  • Friday, August 26, 2016
  • by esmith.geiger
  • Repository
  • 1 Watchers
  • 0 Stars
  • 16 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 20 Forks
  • 0 Open issues
  • 11 Versions
  • 0 % Grown

The README.md

db2-laravelumen

db2-laravelumen is a fork of Cooperl22/laravel-db2 in order to support Laravel and Lumen v5.2. It provides a DB2 Connection by extending the Illuminate Database component working with both Fluent (query builder) and Eloquent., (*1)


Installation

Ensure you have the proper drivers installed. For our AS400 system, I installed iSeriesAccess-7.1.0-1.0.x86_64.rpm from ibm using alien for our debian distribution and configuring the /etc/odbc.ini and /etc/odbcinst.ini., (*2)

Add db2-laravelumen to your composer.json file:, (*3)

"require": {
    "geiger-it/db2-laravelumen": "~3.0"
}

Use composer to install this package., (*4)

$ composer update

Registering the Package

Add the db2-laravelumen Service Provider to your bootstrap/app.php:, (*5)

$app->register(geiger-it\Database\DB2\DB2ServiceProvider::class);

Configuration

Put your DB2 connection and credential information into your config/database.php file. You'll notice Lumen does not have a config directory, but will read from it when you create it., (*6)


'ibmi' => [ 'driver' => 'odbc' / 'ibm', 'driverName' => '{IBM i Access ODBC Driver}' / '{iSeries Access ODBC Driver}', // General settings 'host' => 'server', 'username' => '', 'password' => '', //Server settings 'database' => 'WRKRDBDIRE entry', 'prefix' => '', 'schema' => 'default schema', 'signon' => 3, 'ssl' => 0, 'commitMode' => 2, 'connectionType' => 0, 'defaultLibraries' => '', 'naming' => 0, 'unicodeSql' => 0, // Format settings 'dateFormat' => 5, 'dateSeperator' => 0, 'decimal' => 0, 'timeFormat' => 0, 'timeSeparator' => 0, // Performances settings 'blockFetch' => 1, 'blockSizeKB' => 32, 'allowDataCompression' => 1, 'concurrency' => 0, 'lazyClose' => 0, 'maxFieldLength' => 15360, 'prefetch' => 0, 'queryTimeout' => 1, // Modules settings 'defaultPkgLibrary' => 'QGPL', 'defaultPackage' => 'A/DEFAULT(IBM),2,0,1,0', 'extendedDynamic' => 1, // Diagnostic settings 'QAQQINILibrary' => '', 'sqDiagCode' => '', // Sort settings 'languageId' => 'ENU', 'sortTable' => '', 'sortSequence' => 0, 'sortWeight' => 0, 'jobSort' => 0, // Conversion settings 'allowUnsupportedChar' => 0, 'ccsid' => 1208, 'graphic' => 0, 'forceTranslation' => 0, // Other settings 'allowProcCalls' => 0, 'DB2SqlStates' => 0, 'debug' => 0, 'trueAutoCommit' => 0, 'catalogOptions' => 3, 'libraryView' => 0, 'ODBCRemarks' => 0, 'searchPattern' => 1, 'translationDLL' => '', 'translationOption' => 0, 'maxTraceSize' => 0, 'multipleTraceFiles' => 1, 'trace' => 0, 'traceFilename' => '', 'extendedColInfo' => 0, 'options' => [ PDO::ATTR_CASE => PDO::CASE_LOWER, PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_PERSISTENT => false ] ],

driver setting is either 'odbc' for ODBC connection or 'ibm' for pdo_ibm connection Then if driver is 'odbc', database must be set to ODBC connection name. if driver is 'ibm', database must be set to IBMi database name (WRKRDBDIRE)., (*7)

Usage

Consult the Laravel framework documentation., (*8)

The Versions

26/08 2016

dev-master

9999999-dev

db2-laravelumen is a simple DB2 service provider for Laravel or Lumen v5.2. It provides a DB2 Connection by extending the Illuminate Database component working with both query builder and eloquent.

  Sources   Download

MIT

The Requires

 

by Maxime Rault
by Evan Smith

database laravel lumen pdo odbc db2

10/05 2016

2.3.2

2.3.2.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2

09/05 2016

2.3.1

2.3.1.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2

04/05 2016

2.3

2.3.0.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2

05/02 2016

2.2

2.2.0.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2

30/07 2015

2.1.1

2.1.1.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2

23/07 2015

2.1

2.1.0.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2

12/06 2015

2.0.2

2.0.2.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2

04/06 2015

2.0.1

2.0.1.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2

06/05 2015

2.0

2.0.0.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2

22/04 2015

1.0

1.0.0.0

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

  Sources   Download

MIT

The Requires

 

by Maxime Rault

database laravel pdo odbc db2