gorg/trigger-bundle

一个用于监听事件并将其序列化为其他数据库的Bundle(用于复制用途)

安装: 90

依赖项: 0

建议者: 0

安全: 0

星标: 0

观察者: 3

分支: 1

开放问题: 0

类型:symfony-bundle

dev-master 2014-02-05 12:38 UTC

This package is not auto-updated.

Last update: 2024-09-14 13:28:30 UTC


README

配置Bundle以监听如下事件

创建一个继承自Event/TriggerEvent的事件

gorg_replication_trigger: pdo_connections: platal: dsn: %g6dat_db_dsn% user: %g6dat_db_user% password: %g6dat_db_password% trigger: pla_accounts: entityManager: platal type: pdoSingleRaw event: "gram.account.change" config: new: "INSERT INTO accounts (hruid, type, is_admin, state, full_name, directory_name, display_name, lastname, firstname, sex, password, email, registration_date) VALUES (:hruid, 'gadz', 0, :enable, CONCAT_WS(' ',:firstname, :lastname), CONCAT_WS(' ', :lastname, :firstname), :firstname, :lastname, :firstname, 'male', :password, :email, NOW())" update: "UPDATE accounts SET state=:enable, full_name=CONCAT_WS(' ',:firstname, :lastname), directory_name=CONCAT_WS(' ', :lastname, :firstname), firstname=firstname, lastname=:lastname, password=:password, email=:email WHERE hruid=:hruid" remove: "DELETE FROM accounts WHERE hruid=:hruid" mapping: hruid: hruid password: password firstname: firstname lastname: lastname enable: enable email: email