WebinoDbDump\Db\Dump\Platform\Mysql\Table\Triggers

Complexity

Total Complexity

3

Size/Duplication

Total Lines	39
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	show()	0	5	1
B	write()	0	24	2

<?php
/**
 * Webino (http://webino.sk)
 *
 * @link        https://github.com/webino/WebinoDbDump/ for the canonical source repository
 * @copyright   Copyright (c) 2014-2017 Webino, s. r. o. (http://webino.sk)
 * @license     BSD-3-Clause
 */

namespace WebinoDbDump\Db\Dump\Platform\Mysql\Table;

use SplFileObject as File;
use WebinoDbDump\Db\Dump\Table\AbstractExtra;
use Zend\Db\ResultSet\ResultSet;

/**
 * Mysql database dump utility platform triggers
 *
 * @author Peter Bačinský <peter@bacinsky.sk>
 */
class Triggers extends AbstractExtra
{
    /**
     *
     */
    protected function show()
    {
        $name = $this->getPlatform()->quoteValue($this->tableName);
        return $this->adapter->executeQuery('SHOW TRIGGERS LIKE ' . $name);
    }

    /**
     *
     */
    protected function write(File $file, ResultSet $triggers)
    {
        $file->fwrite('DELIMITER ;;' . PHP_EOL . PHP_EOL);

        $platform = $this->getPlatform();
        foreach ($triggers as $trigger) {

            $file->fwrite(
                sprintf(
                    'CREATE TRIGGER %s %s %s ON %s FOR EACH ROW '
                    . PHP_EOL . ' %s;;',
                    $platform->quoteIdentifier($trigger['Trigger']),
                    $trigger['Timing'],
                    $trigger['Event'],
                    $platform->quoteIdentifier($this->tableName),
                    $trigger['Statement']
                )
                . PHP_EOL . PHP_EOL
            );
        }

        $file->fwrite('DELIMITER ;' . PHP_EOL . PHP_EOL);
        return $this;
    }
}