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

This package is auto-updated.

Last update: 2022-10-01 10:11:34 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.

Build Status Code Coverege

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