Triggers::write() - Code Metrics - webino/WebinoDbDump - Measure and Improve Code Quality continuously with Scrutinizer

Triggers::write() B
last analyzed 2017-12-02 07:22 UTC

↳ Parent: Triggers

Complexity

Conditions	2
Paths	2

Size

Total Lines	24
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	16
nc	2
nop	2
dl	0
loc	24
rs	8.9713
c	0
b	0
f	0

<?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ý <[email protected]>
 */
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;
    }
}


1			<?php
2			/**
3			* Webino (http://webino.sk)
4			*
5			* @link https://github.com/webino/WebinoDbDump/ for the canonical source repository
6			* @copyright Copyright (c) 2014-2017 Webino, s. r. o. (http://webino.sk)
7			* @license BSD-3-Clause
8			*/
9
10			namespace WebinoDbDump\Db\Dump\Platform\Mysql\Table;
11
12			use SplFileObject as File;
13			use WebinoDbDump\Db\Dump\Table\AbstractExtra;
14			use Zend\Db\ResultSet\ResultSet;
15
16			/**
17			* Mysql database dump utility platform triggers
18			*
19			* @author Peter Bačinský <[email protected]>
20			*/
21			class Triggers extends AbstractExtra
22			{
23			/**
24			*
25			*/
26			protected function show()
27			{
28			$name = $this->getPlatform()->quoteValue($this->tableName);
29			return $this->adapter->executeQuery('SHOW TRIGGERS LIKE ' . $name);
30			}
31
32			/**
33			*
34			*/
35			protected function write(File $file, ResultSet $triggers)
36			{
37			$file->fwrite('DELIMITER ;;' . PHP_EOL . PHP_EOL);
38
39			$platform = $this->getPlatform();
40			foreach ($triggers as $trigger) {
41
42			$file->fwrite(
43			sprintf(
44			'CREATE TRIGGER %s %s %s ON %s FOR EACH ROW '
45			. PHP_EOL . ' %s;;',
46			$platform->quoteIdentifier($trigger['Trigger']),
47			$trigger['Timing'],
48			$trigger['Event'],
49			$platform->quoteIdentifier($this->tableName),
50			$trigger['Statement']
51			)
52			. PHP_EOL . PHP_EOL
53			);
54			}
55
56			$file->fwrite('DELIMITER ;' . PHP_EOL . PHP_EOL);
57			return $this;
58			}
59			}
60

webino / WebinoDbDump

Triggers::write() B last analyzed 2017-12-02 07:22 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Triggers::write() B
last analyzed 2017-12-02 07:22 UTC