pan-roman/ifx4dd-plus

Informix Platform for Doctrine DBAL

Informix Platform for Doctrine DBAL

The Informix Platform for Doctrine DBAL gives support for Informix to Doctrine\DBAL the database abstraction layer of the Doctrine project., _(*1)

DBAL versions supported

DBAL	ifx4dd
master	master
2.6	1.1
2.5	1.0

Informix versions supported

Tested on Informix Dynamic Server versions 11.70 and 12.10 (right now it's not tested on 11.50 but should work anyway)., _(*2)

INSTALL

If you don't already have the PDO_INFORMIX extension for PHP you need install it (see PDO_INFORMIX), make sure that the extension works correctly before continue, you can do a quick connection test to your Informix server using the next example, _(*3)

    <?php

    $dsn = 'informix:'
        . 'host=hosttest1;'
        . 'server=test1tcp;'
        . 'database=test_database;'
        . 'protocol=onsoctcp;'
        . 'service=50000;';

    $user = 'your_user';
    $password = 'your_password';

    $con = new PDO($dsn, $user, $password);

    if ($con) {
      echo "The connection was successfully established\n";
    }

You also will need composer in order to install all the dependencies, if you don't have it install it first., _(*4)

Install from the repository

Download the code of the Informix Platform for Doctrine DBAL or clone it with git git clone https://github.com/josemalonsom/Ifx4dd.git. Move to the directory where you have the sources and install dependencies with composer, _(*5)

    $ cd Ifx4dd/
    $ composer install

it will install Doctrine\DBAL under the vendor directory and will create an autoloader class that you can find in the vendor/autoload.php file. The autoloader will add the Informix Platform directories in first place so that you can use the Informix Platform specific versions of some of the DBAL classes., _(*6)

Install with composer

Simply execute:, _(*7)

    composer require "josemalonsom/ifx4dd:dev-master"

it will install the libraries under the vendor directory., _(*8)

Getting a connection with Informix

If you don't have experience with DBAL please read first its documentation Doctrine\DBAL documentation, _(*9)

To create a connection you can use the modified version of the DriverManager of Doctrine\DBAL with comes with the Informix Platform or you can use the original DriverManager class of Doctrine\DBAL, in this last case you will need to specify the driver class to use., _(*10)

Creating a connection with the modified version of the DriverManager

Ifx4dd comes with a modified version of the DriverManager class that adds pdo_informix as one of the possible drivers to use., _(*11)

In this case, you need tell to composer that load the classes from the ifx4dd directory tree in first place (if you have installed ifx4dd from the composer.json what comes with ifx4dd it is not needed since the ifx4dd directory is added in first place to the autoloader)., _(*12)

    <?php

    // Gets the autoloader
    $classLoader = require_once 'vendor/autoload.php';

    // Adds the ifx4dd directory in first place to the
    // Doctrine\DBAL namespace
    $classLoader->add(
        'Doctrine\\DBAL\\',
        'vendor/josemalonsom/ifx4dd/lib',
        true
    );

    use Doctrine\DBAL\DriverManager;

    $connectionParams = array(
        'driver'       => 'pdo_informix',
        'host'         => 'hosttest1',
        'port'         => '50000',
        'protocol'     => 'onsoctcp',
        'server'       => 'test1tcp',
        'dbname'       => 'test_database',
        'user'         => 'user',
        'password'     => 'password',
        'db_locale'     => 'ru_RU.1251', // optional
        'client_locale'     => 'ru_RU.1251', // optional
    );

    $connection = DriverManager::getConnection($connectionParams);

Creating a connection with the original DriverManager of DBAL

If you want to use the 'Doctrine\DBAL\DriverManager' class what comes with DBAL you need to specify the driver class to use in the connection params as in the next example:, _(*13)

    <?php

    require_once 'vendor/autoload.php';

    use Doctrine\DBAL\DriverManager;

    $connectionParams = array(
        'driverClass'  => '\Doctrine\DBAL\Driver\PDOInformix\Driver',
        'host'         => 'hosttest1',
        'port'         => '50000',
        'protocol'     => 'onsoctcp',
        'server'       => 'test1tcp',
        'dbname'       => 'test_database',
        'user'         => 'user',
        'password'     => 'password',
        'db_locale'     => 'ru_RU.1251', // optional
        'client_locale'     => 'ru_RU.1251', // optional
    );

    $connection = DriverManager::getConnection($connectionParams);

Creating a connection with a URL

Since DBAL 2.5 it is possible to use a URL to create the connection (note that in this case you must use the ifx4dd DriverManager version)., _(*14)

    <?php

    $classLoader = require_once 'vendor/autoload.php';

    $classLoader->add(
        'Doctrine\\DBAL\\',
        'vendor/josemalonsom/ifx4dd/lib',
        true
    );

    use Doctrine\DBAL\DriverManager;

    $connection = DriverManager::getConnection(array(
        'url' => 'informix://user:password@hosttest1:50000/test_database?protocol=onsoctcp&server=test1tcp'
    ));

Please, refer to the DBAL documentation for more information: https://github.com/doctrine/dbal/blob/2.5/docs/en/reference/configuration.rst, _(*15)

Delimited identifiers

DBAL uses delimited identifiers so you need to enable it in your Informix environment, see enabling delimited identifiers., _(*16)

Other documentation

• Data type mapping