edgardmessias/yii2-informix

Informix Driver for Yii2 Framework.

1.1.1 2016-05-04 20:24 UTC

README

Latest Stable Version Total Downloads Latest Unstable Version License

This extension adds Informix database engine extension for the Yii framework 2.0.

Yii2 Build Status Total Downloads Dependency Status Reference Status

Requirements

  • Informix Client SDK installed
  • PHP module pdo_informix
  • Informix Database Server 11.50 or greater

Unsupported

  • Enable/Disable checkIntegrity (Bug with PHP)

Functions not supported by the Informix database:

  • INSERT, UPDATE, DELETE with READ UNCOMMITTED transaction
  • Batch Insert with TEXT, BLOB or CLOB data type

Installation

The preferred way to install this extension is through composer.

Either run

php composer.phar require --prefer-dist "edgardmessias/yii2-informix:*"

or add

"edgardmessias/yii2-informix": "*"

to the require section of your composer.json.

Configuration

To use this extension, simply add the following code in your application configuration:

return [
    //....
    'components' => [
        'db' => [
            'class'    => 'edgardmessias\db\informix\Connection',
            'dsn'      => 'informix:host=127.0.0.1;service=9088;database=test;server=dev;protocol=onsoctcp;CLIENT_LOCALE=en_US.utf8;DB_LOCALE=en_US.utf8;EnableScrollableCursors=1',
            'username' => 'username',
            'password' => 'password',
        ],
    ],
];

To use CamelCase column names or aliases, enable the DELIMIDENT:

Example:

    //....
    'db' => [
        'class'    => 'edgardmessias\db\informix\Connection',
        'dsn'      => 'informix:host=127.0.0.1;service=9088;database=test;server=dev;protocol=onsoctcp;CLIENT_LOCALE=en_US.utf8;DB_LOCALE=en_US.utf8;EnableScrollableCursors=1;DELIMIDENT=y',
        'username' => 'username',
        'password' => 'password',
    ],

Or:

    //....
    'db' => [
        'class'        => 'edgardmessias\db\informix\Connection',
        'dsn'          => 'informix:DSN_NAME', //WITH DELIMIDENT ENABLED
        'isDelimident' => true,
        'username'     => 'username',
        'password'     => 'password',
    ],