stefano/stefano-db

Db Modul extend Zend Framework 2

Installs: 895

Dependents: 1

Stars: 1

Watchers: 1

Language: PHP

1.4.0 2014-07-25 13:20 UTC

README

Test Status Code Coverage Dependencies Test Status Code Coverege Dependencies

Instalation using Composer

  1. Add following line to composer.json "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',
        ),
    ),
);