mathsgod / r-db-eventlog
Installs: 5
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 2
Forks: 0
Open Issues: 0
pkg:composer/mathsgod/r-db-eventlog
Requires
- league/event: ^3.0
Requires (Dev)
- mathsgod/r-db: ^4.16
README
Auto generated event log when a database record is created, inserted and deleted.
setup
Create database table EventLog
CREATE TABLE `EventLog` ( `eventlog_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `class` varchar(64) DEFAULT NULL, `id` int(10) unsigned NOT NULL, `action` varchar(64) DEFAULT NULL, `source` json DEFAULT NULL, `target` json DEFAULT NULL, `remark` text, `user_id` int(10) unsigned NOT NULL, `created_time` datetime NOT NULL, `status` int(10) unsigned DEFAULT '0', `different` json DEFAULT NULL, PRIMARY KEY (`eventlog_id`), KEY `class` (`class`), KEY `user_id` (`user_id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
Register listeners
$schema = \R\DB\Model::GetSchema(); $subscriber = new ListenerSubscriber(); $subscriber->setUserId(1); $schema->eventDispatcher()->subscribeListenersFrom($subscriber);