doctrs/stored-procedure-bundle

用于与 red-defender/pgfunc 共同工作的 Symfony 扩展包

维护者

详细信息

github.com/Doctrs/StoredProcedureBundle

主页

源代码

问题

安装: 43

依赖项: 0

建议者: 0

安全: 0

星标: 1

关注者: 2

分支: 0

公开问题: 0

类型:symfony-bundle

1.0.0 2018-06-07 18:58 UTC

Requires

MIT c25331a2f8827147ad5d7b97f73a0a56e5e77e73

  • DOC_tr <CrimSoN_AL.woop@mail.ru>

symfonyred-defenderpgfunc

This package is not auto-updated.

Last update: 2024-09-21 03:22:24 UTC

README

用于 pgfunc 库的 Symfony 扩展包

Build Status Code Intelligence Status SensioLabsInsight

通过 https://github.com/red-defender/pgfunc 与存储过程一起工作的扩展包

您可以通过其中一个连接创建多个连接并执行存储过程

安装

composer require doctrs/stored-procedure-bundle

配置

创建文件 config/packages/stored_procedure.yaml 并配置连接

stored_procedure:
    connections:
        api_master:
            dbname: '%env(API_DB_MASTER_DBNAME)%'
            host: '%env(API_DB_MASTER_HOST)%'
            port: '%env(API_DB_MASTER_PORT)%'
            user: '%env(API_DB_MASTER_USER)%'
        admin_master:
            dbname: '%env(ADMIN_DB_MASTER_DBNAME)%'
            host: '%env(ADMIN_DB_MASTER_HOST)%'
            port: '%env(ADMIN_DB_MASTER_PORT)%'
            user: '%env(ADMIN_DB_MASTER_USER)%'
        any_connection: ~
        any_second_connection: ~

所有配置变量的列表

application_name
client_encoding
connect_timeout
dbname
fallback_application_name
gsslib
host
hostaddr
keepalives
keepalives_count
keepalives_idle
keepalives_interval
krbsrvname
options
passfile
port
requirepeer
requiressl
service
sslcert
sslcompression
sslcrl
sslkey
sslmode
sslrootcert
target_session_attrs
tty

执行程序

Procedure::execute(string $connectionName, \PgFunc\Procedure $procedure);

...

$procedure = new Procedure('any_procedure_name');
$procedure->addParameters(...$parameters);
...
return $container->get('doctrs.stored_procedure')->execute('api_master', $procedure);

事件

  • stored_procedure.connection_name - 更改连接名称。
  • stored_procedure.connection - 更改连接类，并更改存储过程类
  • stored_procedure.result - 更改结果