stefano/stefano-db

Db Modul extend Zend Framework 2

[DEPRECATED] Stefano Db

Zend DB from v.2.4.0 support nested transactions. Please use Zend Db instead of this library. This library is NOT MAINTAINED anymore., _(*1)

, _(*2)

Installation using Composer

1. Run command composer require stefano/stefano-db

Features

• extend Zend Framework 2 Database adapter. For more info see Zend Db
• nested transaction. For more info see Stefano nested transaction
• execute defined queries after db connection will be created

Db Adapter Configuration

//$option for more info see Zend Framework 2 Db documentation
$adapter = new \StefanoDb\Adapter\Adapter($options);

Nested transaction API

$adapter->begin();
$adapter->commit();
$adapter->rollback();

Usage with Zend Framework 2 MVC

• single DB connection configuration

return array(
    //single DB connection
    'db' => array(
        'driver' => '',
        'database' => '',
        'username' => '',
        'password' => '',
        'sqls' => array(
            "SET time_zone='+0:00'",
            "....."
        ),
    ),
    'service_manager' => array(
        'factories' => array(
            'Zend\Db\Adapter\Adapter'
                => '\StefanoDb\Adapter\Service\AdapterServiceFactory',
        ),
    ),
);

• multiple DB connection configuration

return array(
    'db' => array(
        'adapters' => array(
            'Db/Write' => array(
                'driver' => '',
                'database' => '',
                'username' => '',
                'password' => '',
                'sqls' => array(
                    "SET time_zone='+0:00'",
                    "....."
                ),
            ),
            'Db/Read' => array(
                'driver' => '',
                'database' => '',
                'username' => '',
                'password' => '',
                'sqls' => array(
                    "SET time_zone='+0:00'",
                    "....."
                ),
            ),
        ),
    ),
    'service_manager' => array(
        'abstract_factories' => array(
            '\StefanoDb\Adapter\Service\AdapterAbstractServiceFactory',
        ),
    ),
);