Skip to content

bartko-s/stefano-db

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

90 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

[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.

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