stefano/stefano-db

This package is abandoned and no longer maintained. The author suggests using the zendframework/zend-db package instead.

Db Modul extend Zend Framework 2

1.5.0 2017-09-21 18:33 UTC

README

Zend DB from v.2.4.0 support nested transactions. Please use Zend Db instead of this library. This library is NOT MAINTAINED anymore.

Test Status Code Coverage Dependencies
Test Status Code Coverege Dependencies

Instalation 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',
        ),
    ),
);