README

从 v.2.4.0 版本的 Zend DB 支持嵌套事务。请使用 Zend Db 而不是此库。此库已不再维护。

使用 Composer 安装

1. 运行命令 composer require stefano/stefano-db

功能

• 扩展 Zend Framework 2 数据库适配器。更多信息请参阅 Zend Db
• 嵌套事务。更多信息请参阅 Stefano nested transaction
• 在创建数据库连接后执行定义的查询

数据库适配器配置

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

嵌套事务 API

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

与 Zend Framework 2 MVC 的使用

• 单个数据库连接配置

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

• 多个数据库连接配置

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