HosipLan

Untitled

May 14th, 2012
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.58 KB | None | 0 0
  1. $triggers[] = Trigger::afterInsert($class->getTableName(), 'audit')
  2.     ->declare('audit_revision', 'BIGINT')
  3.     ->insert('db_audit_revisions', array(
  4.         'type' => 'INS',
  5.         'className' => $class->name,
  6.         'entityId%sql' => 'NEW.' . $class->getSingleIdentifierColumnName(),
  7.         'createdAt%sql' => 'NOW()',
  8.         'author%sql' => '@kdyby_current_user'
  9.     ))
  10.     ->set('audit_revision', 'LAST_INSERT_ID()')
  11.     ->insert($auditTable, "SELECT * FROM `{$entityTable}`")
  12.     ->update($auditTable, array('_revision%sql' => '@audit_revision'))
  13.     ->update($entityTable, array('_revision%sql' => '@audit_revision'));
Advertisement
Add Comment
Please, Sign In to add comment