Ejemplo n.º 1
0
 private function triggerEndingTest($triggerAction)
 {
     $audit_columns = new TableColumnsMetadata();
     $table_columns = new TableColumnsMetadata([['column_name' => 'x', 'column_type' => 'int(11)', 'is_nullable' => 'YES', 'character_set_name' => null, 'collation_name' => null]]);
     $helper = new CreateAuditTrigger('test_data', 'test_audit', 'MY_TABLE', 'my_trigger', $triggerAction, $audit_columns, $table_columns, null, []);
     $sql = $helper->buildStatement();
     // Code must have one EOL at the end.
     $this->assertRegExp('/\\r?\\n$/', $sql, sprintf('Single EOL: %s', $triggerAction));
     // Code must have one and only EOL at the end.
     $this->assertNotRegExp('/\\r?\\n\\r?\\n$/', $sql, sprintf('Double EOL: %s', $triggerAction));
     // Code must not have a semicolon at the end.
     $this->assertNotRegExp('/;$/', trim($sql), sprintf('Semicolon: %s', $triggerAction));
 }
Ejemplo n.º 2
0
 /**
  * Creates a trigger on a table.
  *
  * @param string               $dataSchemaName  The name of the data schema.
  * @param string               $auditSchemaName The name of the audit schema.
  * @param string               $tableName       The name of the table.
  * @param string               $triggerAction   The trigger action (i.e. INSERT, UPDATE, or DELETE).
  * @param string               $triggerName     The name of the trigger.
  * @param TableColumnsMetadata $auditColumns    The audit table columns.
  * @param TableColumnsMetadata $tableColumns    The data table columns.
  * @param string               $skipVariable    The skip variable.
  * @param string[]             $additionSql     Additional SQL statements.
  */
 public static function createAuditTrigger($dataSchemaName, $auditSchemaName, $tableName, $triggerAction, $triggerName, $auditColumns, $tableColumns, $skipVariable, $additionSql)
 {
     $helper = new CreateAuditTrigger($dataSchemaName, $auditSchemaName, $tableName, $triggerAction, $triggerName, $auditColumns, $tableColumns, $skipVariable, $additionSql);
     $sql = $helper->buildStatement();
     self::executeNone($sql);
 }