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

Complexity

Total Complexity

12

Size/Duplication

Total Lines	112
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	7

Importance

Changes

0

10 Methods

Rating	Name	Duplication	Size	Complexity
A	setName()	0	7	1
A	showCreate()	0	4	1
A	showColumns()	0	4	1
A	select()	0	4	1
A	createColumns()	0	4	1
A	createExtras()	0	7	1
A	create()	0	21	3
A	startInsert()	0	5	1
A	continueInsert()	0	4	1
A	finishInsert()	0	4	1

<?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 WebinoDbDump\Db\Dump\Platform\Mysql\Routine\Procedure;
use WebinoDbDump\Db\Dump\Table\AbstractTable;

/**
 * Mysql database dump utility platform table
 *
 * @author Peter Bačinský <peter@bacinsky.sk>
 */
class Table extends AbstractTable
{
    /**
     * @var string
     */
    protected $rawName;

    /**
     * @param string $name
     * @return $this
     */
    protected function setName($name)
    {
        $this->rawName = $name;
        $this->name    = $this->getPlatform()->quoteIdentifier($this->rawName);

        return $this;
    }

    /**
     * @return \Zend\Db\ResultSet\ResultSet
     */
    protected function showCreate()
    {
        return $this->adapter->executeQuery('SHOW CREATE TABLE ' . $this->name);
    }

    /**
     * @return \Zend\Db\ResultSet\ResultSet
     */
    protected function showColumns()
    {
        return $this->adapter->executeQuery('SHOW COLUMNS FROM ' . $this->name);
    }

    /**
     * @return \Zend\Db\ResultSet\ResultSet
     */
    protected function select()
    {
        return $this->adapter->executeQuery('SELECT * FROM ' . $this->name);
    }

    /**
     * @return Columns
     */
    protected function createColumns()
    {
        return new Columns($this->getPlatform());
    }

    /**
     * @return array[Triggers, Procedure]

The doc-type array[Triggers, could not be parsed: Expected "]" at position 2, but found "Triggers". (view supported doc-types)

     */
    protected function createExtras()
    {
        return [
            new Triggers($this->rawName, $this->adapter),
            new Procedure($this->rawName, $this->adapter),
        ];
    }

    /**
     * @return string
     */
    protected function create()
    {
        $row = $this->showCreate()->current();

        $isView = isset($row['Create View']);
        $this->setView($isView);

        $dump = '';

        // drop
        $dump .= sprintf(
            'DROP %s IF EXISTS %s;' . PHP_EOL,
            $isView ? 'VIEW' : 'TABLE',
            $this->name
        );

        // create
        $dump .= $row[$isView ? 'Create View' : 'Create Table'] . ';' . PHP_EOL . PHP_EOL;

        return $dump;
    }

    /**
     * @return string
     */
    protected function startInsert()
    {
        return 'LOCK TABLES ' . $this->name . ' WRITE;' . PHP_EOL
               .'INSERT INTO ' . $this->name . ' VALUES' . PHP_EOL;
    }

    /**
     * @return string
     */
    protected function continueInsert()
    {
        return ',';
    }

    /**
     * @return string
     */
    protected function finishInsert()
    {
        return ';' . PHP_EOL . 'UNLOCK TABLES;' . PHP_EOL;
    }
}