Ifsnop\Mysqldump\Mysqldump

Complexity

Total Complexity

185

Size/Duplication

Total Lines	1315
Duplicated Lines	0 %

Importance

Changes	87
Bugs	15	Features	9

45 Methods

Rating	Name	Duplication	Size	Complexity
A	getFunctionStructure()	0	14	3
A	prepareColumnValues()	0	18	4
A	setTransformTableRowHook()	0	3	1
A	getTriggerStructure()	0	13	3
A	getProcedureStructure()	0	14	3
A	getEventStructure()	0	14	3
A	setInfoHook()	0	3	1
B	escape()	0	15	7
A	createStandInTable()	0	12	2
A	getViewStructureView()	0	21	3
A	getViewStructureTable()	0	22	4
A	setTransformColumnValueHook()	0	3	1
B	parseDsn()	0	34	9
A	exportProcedures()	0	5	2
A	getDatabaseStructureProcedures()	0	9	3
A	exportTriggers()	0	5	2
A	getDatabaseStructureFunctions()	0	9	3
A	exportEvents()	0	5	2
B	connect()	0	40	8
A	setTableLimits()	0	3	1
A	__destruct()	0	3	1
A	getTableStructure()	0	25	5
B	__construct()	0	84	7
A	exportFunctions()	0	5	2
A	exportViews()	0	16	6
B	start()	0	73	6
A	matches()	0	14	5
A	setTableWheres()	0	3	1
A	getDatabaseStructureTriggers()	0	9	3
A	getDumpFileFooter()	0	12	3
A	getTableLimit()	0	12	3
A	getDatabaseStructureEvents()	0	9	3
A	getDatabaseStructureTables()	0	22	5
A	getDatabaseStructureViews()	0	22	5
A	getDumpFileHeader()	0	19	4
A	getTableWhere()	0	9	3
A	exportTables()	0	15	6
A	getTableColumnTypes()	0	21	2
A	getHasPrimaryKey()	0	8	3
A	getUpdateColumnsOnDuplicate()	0	9	3
F	listValues()	0	76	18
A	getColumnNames()	0	12	3
B	prepareListValues()	0	39	8
B	getColumnStmt()	0	17	7
B	endListValues()	0	39	8

<?php

There must be no blank lines before the file comment

The PHP open tag does not have a corresponding PHP close tag

Filename "Mysqldump.php" doesn't match the expected filename "mysqldump.php"

/**
 * PHP version of mysqldump cli that comes with MySQL.
 *
 * Tags: mysql mysqldump pdo php7 php5 database php sql hhvm mariadb mysql-backup.
 *
 * @category Library

The tag in position 1 should be the @package tag

 * @package  Ifsnop\Mysqldump

The tag in position 2 should be the @subpackage tag

 * @author   Diego Torres <ifsnop@github.com>

Expected "Squiz Pty Ltd <products@squiz.net>" for author tag

 * @license  http://www.gnu.org/copyleft/gpl.html GNU General Public License

The tag in position 4 should be the @copyright tag

 * @link     https://github.com/ifsnop/mysqldump-php
 *
 */

Missing @subpackage tag in file comment

Missing @copyright tag in file comment

Additional blank lines found at end of doc comment

namespace Ifsnop\Mysqldump;

use Exception;
use PDO;
use PDOException;

/**
 * Class Mysqldump.
 *
 * @category Library

@category tag is not allowed in class comment

 * @author   Diego Torres <ifsnop@github.com>

@author tag is not allowed in class comment

 * @license  http://www.gnu.org/copyleft/gpl.html GNU General Public License

@license tag is not allowed in class comment

 * @link     https://github.com/ifsnop/mysqldump-php

@link tag is not allowed in class comment

 *
 */

Additional blank lines found at end of doc comment

Missing @package tag in class comment

class Mysqldump
{

Opening brace should be on the same line as the declaration for class Mysqldump

    // Same as mysqldump.
    const MAXLINESIZE = 1000000;

    // List of available compression methods as constants.
    const GZIP  = 'Gzip';

Equals sign not aligned with surrounding assignments; expected 7 spaces but found 2 spaces

    const BZIP2 = 'Bzip2';

Equals sign not aligned with surrounding assignments; expected 6 spaces but found 1 space

    const NONE  = 'None';

Equals sign not aligned with surrounding assignments; expected 7 spaces but found 2 spaces

    const GZIPSTREAM = 'Gzipstream';

    // List of available connection strings.
    const UTF8    = 'utf8';
    const UTF8MB4 = 'utf8mb4';
    const BINARY = 'binary';

Equals sign not aligned with surrounding assignments; expected 2 spaces but found 1 space

    
    /**
     * Database username.
     * @var string

There must be exactly one blank line before the tags in a doc comment

     */
    public $user;

    /**
     * Database password.
     * @var string

There must be exactly one blank line before the tags in a doc comment

     */
    public $pass;

    /**
     * Connection string for PDO.
     * @var string

There must be exactly one blank line before the tags in a doc comment

     */
    public $dsn;

    /**
     * Destination filename, defaults to stdout.
     * @var string

There must be exactly one blank line before the tags in a doc comment

     */
    public $fileName = 'php://stdout';

    // Internal stuff.
    private $tables = array();

Private member variable "tables" must contain a leading underscore

You must use "/**" style comments for a member variable comment

Private member variable "tables" must be prefixed with an underscore

Equals sign not aligned with surrounding assignments; expected 5 spaces but found 1 space

Short array syntax must be used to define arrays

    private $views = array();

Private member variable "views" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "views" must be prefixed with an underscore

Equals sign not aligned with surrounding assignments; expected 6 spaces but found 1 space

Short array syntax must be used to define arrays

    private $triggers = array();

Private member variable "triggers" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "triggers" must be prefixed with an underscore

Equals sign not aligned with surrounding assignments; expected 3 spaces but found 1 space

Short array syntax must be used to define arrays

    private $procedures = array();

Private member variable "procedures" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "procedures" must be prefixed with an underscore

Short array syntax must be used to define arrays

    private $functions = array();

Private member variable "functions" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "functions" must be prefixed with an underscore

Equals sign not aligned with surrounding assignments; expected 2 spaces but found 1 space

Short array syntax must be used to define arrays

    private $events = array();

Private member variable "events" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "events" must be prefixed with an underscore

Equals sign not aligned with surrounding assignments; expected 5 spaces but found 1 space

Short array syntax must be used to define arrays

    private $dbHandler = null;

Private member variable "dbHandler" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "dbHandler" must be prefixed with an underscore

Equals sign not aligned with surrounding assignments; expected 2 spaces but found 1 space

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

    private $dbType = "";

Private member variable "dbType" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "dbType" must be prefixed with an underscore

Equals sign not aligned with surrounding assignments; expected 5 spaces but found 1 space

The string literal does not require double quotes, as per coding-style, please use single quotes.

    private $compressManager;

Private member variable "compressManager" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "compressManager" must be prefixed with an underscore

    private $typeAdapter;

Private member variable "typeAdapter" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "typeAdapter" must be prefixed with an underscore

    private $dumpSettings = array();

Private member variable "dumpSettings" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "dumpSettings" must be prefixed with an underscore

Short array syntax must be used to define arrays

    private $pdoSettings = array();

Private member variable "pdoSettings" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "pdoSettings" must be prefixed with an underscore

Equals sign not aligned with surrounding assignments; expected 2 spaces but found 1 space

Short array syntax must be used to define arrays

    private $version;

Private member variable "version" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "version" must be prefixed with an underscore

    private $tableColumnTypes = array();

Private member variable "tableColumnTypes" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "tableColumnTypes" must be prefixed with an underscore

Short array syntax must be used to define arrays

    private $transformTableRowCallable;

Private member variable "transformTableRowCallable" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "transformTableRowCallable" must be prefixed with an underscore

    private $transformColumnValueCallable;

Private member variable "transformColumnValueCallable" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "transformColumnValueCallable" must be prefixed with an underscore

    private $infoCallable;

Private member variable "infoCallable" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "infoCallable" must be prefixed with an underscore

    /**
     * Database name, parsed from dsn.
     * @var string

There must be exactly one blank line before the tags in a doc comment

     */
    private $dbName;

Private member variable "dbName" must contain a leading underscore

Private member variable "dbName" must be prefixed with an underscore

    /**
     * Host name, parsed from dsn.
     * @var string

There must be exactly one blank line before the tags in a doc comment

     */
    private $host;

Private member variable "host" must contain a leading underscore

Private member variable "host" must be prefixed with an underscore

    /**
     * Dsn string parsed as an array.
     * @var array

There must be exactly one blank line before the tags in a doc comment

     */
    private $dsnArray = array();

Private member variable "dsnArray" must contain a leading underscore

Private member variable "dsnArray" must be prefixed with an underscore

Short array syntax must be used to define arrays

    /**
     * Keyed on table name, with the value as the conditions.
     * e.g. - 'users' => 'date_registered > NOW() - INTERVAL 6 MONTH'
     *
     * @var array
     */
    private $tableWheres = array();

Private member variable "tableWheres" must contain a leading underscore

Private member variable "tableWheres" must be prefixed with an underscore

Short array syntax must be used to define arrays

    private $tableLimits = array();

Private member variable "tableLimits" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "tableLimits" must be prefixed with an underscore

Short array syntax must be used to define arrays

    /**
     * Constructor of Mysqldump. Note that in the case of an SQLite database
     * connection, the filename must be in the $db parameter.
     *
     * @param string $dsn        PDO DSN connection string

Expected 10 spaces after parameter name; 8 found

Parameter comment must end with a full stop

     * @param string $user       SQL account username

Expected 9 spaces after parameter name; 7 found

Parameter comment must end with a full stop

     * @param string $pass       SQL account password

Expected 9 spaces after parameter name; 7 found

Parameter comment must end with a full stop

     * @param array  $dumpSettings SQL database settings

Parameter comment must end with a full stop

     * @param array  $pdoSettings  PDO configured attributes

Parameter comment must end with a full stop

     */

Missing @throws tag in function comment

    public function __construct(

Type hint "array" missing for $dumpSettings

Type hint "array" missing for $pdoSettings

        $dsn = '',
        $user = '',
        $pass = '',
        $dumpSettings = array(),

Short array syntax must be used to define arrays

        $pdoSettings = array()

Short array syntax must be used to define arrays

    ) {

Opening brace should be on a new line

        $dumpSettingsDefault = array(

Short array syntax must be used to define arrays

            'include-tables' => array(),

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

Short array syntax must be used to define arrays

            'exclude-tables' => array(),

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

Short array syntax must be used to define arrays

            'include-views' => array(),

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

Short array syntax must be used to define arrays

            'compress' => Mysqldump::NONE,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

As per coding style, self should be used for accessing local static members.

            'init_commands' => array(),

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

Short array syntax must be used to define arrays

            'no-data' => array(),

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

Short array syntax must be used to define arrays

            'if-not-exists' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'reset-auto-increment' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'add-drop-database' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'add-drop-table' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'add-drop-trigger' => true,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            'add-locks' => true,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            'complete-insert' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'databases' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'default-character-set' => Mysqldump::UTF8,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

As per coding style, self should be used for accessing local static members.

            'disable-keys' => true,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            'extended-insert' => true,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            'events' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'hex-blob' => true, /* faster than escaped content */

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

Single line block comment not allowed; use inline ("// text") comment instead

            'insert-ignore' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'net_buffer_length' => self::MAXLINESIZE,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

            'no-autocommit' => true,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            'no-create-info' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'lock-tables' => true,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            'replace' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'routines' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'single-transaction' => true,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            'skip-triggers' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'skip-tz-utc' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'skip-comments' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'skip-dump-date' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'skip-definer' => false,

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            'where' => '',

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

            /* deprecated */

Single line block comment not allowed; use inline ("// text") comment instead

            'disable-foreign-keys-check' => true

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

This array key does not seem to be aligned correctly; expected 32 spaces, but found 12.

        );

The closing parenthesis does not seem to be aligned correctly; expected 31 space(s), but found 8.

        $pdoSettingsDefault = array(

Short array syntax must be used to define arrays

            PDO::ATTR_PERSISTENT => true,

This array key does not seem to be aligned correctly; expected 31 spaces, but found 12.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,

This array key does not seem to be aligned correctly; expected 31 spaces, but found 12.

        );

The closing parenthesis does not seem to be aligned correctly; expected 30 space(s), but found 8.

        $this->user = $user;
        $this->pass = $pass;
        $this->parseDsn($dsn);

        // This drops MYSQL dependency, only use the constant if it's defined.
        if ("mysql" === $this->dbType) {

The condition 'mysql' === $this->dbType is always false.

The string literal mysql does not require double quotes, as per coding-style, please use single quotes.

            $pdoSettingsDefault[PDO::MYSQL_ATTR_USE_BUFFERED_QUERY] = false;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

        }

        $this->pdoSettings = array_replace_recursive($pdoSettingsDefault, $pdoSettings);

Equals sign not aligned with surrounding assignments; expected 21 spaces but found 1 space

        $this->dumpSettings = array_replace_recursive($dumpSettingsDefault, $dumpSettings);

Equals sign not aligned with surrounding assignments; expected 20 spaces but found 1 space

        $this->dumpSettings['init_commands'][] = "SET NAMES ".$this->dumpSettings['default-character-set'];

The string literal SET NAMES does not require double quotes, as per coding-style, please use single quotes.

This line exceeds maximum limit of 100 characters; contains 107 characters

        if (false === $this->dumpSettings['skip-tz-utc']) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            $this->dumpSettings['init_commands'][] = "SET TIME_ZONE='+00:00'";
        }

        $diff = array_diff(array_keys($this->dumpSettings), array_keys($dumpSettingsDefault));
        if (count($diff) > 0) {
            throw new Exception("Unexpected value in dumpSettings: (".implode(",", $diff).")");

The string literal Unexpected value in dumpSettings: ( does not require double quotes, as per coding-style, please use single quotes.

The string literal , does not require double quotes, as per coding-style, please use single quotes.

The string literal ) does not require double quotes, as per coding-style, please use single quotes.

        }

        if (!is_array($this->dumpSettings['include-tables']) ||

There must be a single space after a NOT operator; 0 found

            !is_array($this->dumpSettings['exclude-tables'])) {

Each line in a multi-line IF statement must begin with a boolean operator

There must be a single space after a NOT operator; 0 found

Closing parenthesis of a multi-line IF statement must be on a new line

            throw new Exception("Include-tables and exclude-tables should be arrays");

The string literal Include-tables and exclude-tables should be arrays does not require double quotes, as per coding-style, please use single quotes.

        }

        // If no include-views is passed in, dump the same views as tables, mimic mysqldump behaviour.

This line exceeds maximum limit of 100 characters; contains 102 characters

        if (!isset($dumpSettings['include-views'])) {

There must be a single space after a NOT operator; 0 found

            $this->dumpSettings['include-views'] = $this->dumpSettings['include-tables'];
        }

        // Create a new compressManager to manage compressed output

Inline comments must end in full-stops, exclamation marks, or question marks

        $this->compressManager = CompressManagerFactory::create($this->dumpSettings['compress']);
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end __construct()

Expected 2 blank lines after function; 1 found

    /**
     * Destructor of Mysqldump. Unsets dbHandlers and database objects.
     */
    public function __destruct()
    {

Opening brace should be on the same line as the declaration

        $this->dbHandler = null;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

    }

Expected //end __destruct()

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

    /**
     * Keyed by table name, with the value as the conditions:
     * e.g. 'users' => 'date_registered > NOW() - INTERVAL 6 MONTH AND deleted=0'
     *
     * @param array $tableWheres

Missing parameter comment

     */

Missing @return tag in function comment

    public function setTableWheres(array $tableWheres)
    {

Opening brace should be on the same line as the declaration

        $this->tableWheres = $tableWheres;
    }

Expected //end setTableWheres()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    /**

Parameter $tableName should have a doc-comment as per coding-style.

Missing short description in doc comment

     * @param $tableName

Missing parameter name

     *
     * @return boolean|mixed
     */
    public function getTableWhere($tableName)

Type hint "tableName" missing for

    {

Opening brace should be on the same line as the declaration

        if (!empty($this->tableWheres[$tableName])) {

There must be a single space after a NOT operator; 0 found

            return $this->tableWheres[$tableName];
        } elseif ($this->dumpSettings['where']) {

Usage of ELSEIF not allowed; use ELSE IF instead

            return $this->dumpSettings['where'];
        }

        return false;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getTableWhere()

    /**
     * Keyed by table name, with the value as the numeric limit:
     * e.g. 'users' => 3000
     *
     * @param array $tableLimits

Missing parameter comment

     */

Missing @return tag in function comment

    public function setTableLimits(array $tableLimits)
    {

Opening brace should be on the same line as the declaration

        $this->tableLimits = $tableLimits;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end setTableLimits()

    /**

Parameter $tableName should have a doc-comment as per coding-style.

     * Returns the LIMIT for the table.  Must be numeric to be returned.
     * @param $tableName

There must be exactly one blank line before the tags in a doc comment

Missing parameter name

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return boolean

Tag cannot be grouped with parameter tags in a doc comment

     */
    public function getTableLimit($tableName)

Type hint "tableName" missing for

    {

Opening brace should be on the same line as the declaration

        if (!isset($this->tableLimits[$tableName])) {

There must be a single space after a NOT operator; 0 found

            return false;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

        }

        $limit = $this->tableLimits[$tableName];
        if (!is_numeric($limit)) {

There must be a single space after a NOT operator; 0 found

            return false;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

        }

        return $limit;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getTableLimit()

    /**
     * Parse DSN string and extract dbname value
     * Several examples of a DSN string
     *   mysql:host=localhost;dbname=testdb
     *   mysql:host=localhost;port=3307;dbname=testdb
     *   mysql:unix_socket=/tmp/mysql.sock;dbname=testdb
     *
     * @param string $dsn dsn string to parse

Parameter comment must start with a capital letter

Parameter comment must end with a full stop

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return boolean

Tag cannot be grouped with parameter tags in a doc comment

     */

Missing @throws tag in function comment

    private function parseDsn($dsn)

Private method name "Mysqldump::parseDsn" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        if (empty($dsn) || (false === ($pos = strpos($dsn, ":")))) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

Assignments must be the first block of code on a line

The string literal : does not require double quotes, as per coding-style, please use single quotes.

            throw new Exception("Empty DSN string");

The string literal Empty DSN string does not require double quotes, as per coding-style, please use single quotes.

        }

        $this->dsn = $dsn;

Equals sign not aligned with surrounding assignments; expected 4 spaces but found 1 space

        $this->dbType = strtolower(substr($dsn, 0, $pos)); // always returns a string

Inline comments must end in full-stops, exclamation marks, or question marks

Comments may not appear after statements

Inline comments must start with a capital letter

        if (empty($this->dbType)) {
            throw new Exception("Missing database type from DSN string");

The string literal Missing database type from DSN string does not require double quotes, as per coding-style, please use single quotes.

        }

        $dsn = substr($dsn, $pos + 1);

Arithmetic operation must be bracketed

        foreach (explode(";", $dsn) as $kvp) {

The string literal ; does not require double quotes, as per coding-style, please use single quotes.

            $kvpArr = explode("=", $kvp);

Equals sign not aligned with surrounding assignments; expected 33 spaces but found 1 space

The string literal = does not require double quotes, as per coding-style, please use single quotes.

            $this->dsnArray[strtolower($kvpArr[0])] = $kvpArr[1];
        }

        if (empty($this->dsnArray['host']) &&
            empty($this->dsnArray['unix_socket'])) {

Each line in a multi-line IF statement must begin with a boolean operator

Closing parenthesis of a multi-line IF statement must be on a new line

            throw new Exception("Missing host from DSN string");

The string literal Missing host from DSN string does not require double quotes, as per coding-style, please use single quotes.

        }

No blank line found after control structure

        $this->host = (!empty($this->dsnArray['host'])) ?

The value of a boolean operation must not be assigned to a variable

There must be a single space after a NOT operator; 0 found

Expected 1 space after "?"; newline found

Inline IF statements are not allowed

Inline shorthand IF statement must be declared on a single line

            $this->dsnArray['host'] : $this->dsnArray['unix_socket'];

        if (empty($this->dsnArray['dbname'])) {
            throw new Exception("Missing database name from DSN string");

The string literal Missing database name from DSN string does not require double quotes, as per coding-style, please use single quotes.

        }

        $this->dbName = $this->dsnArray['dbname'];

        return true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end parseDsn()

    /**
     * Connect with PDO.
     *
     * @return null

Function return type is not void, but function has no return statement

     */

Missing @throws tag in function comment

    private function connect()

Private method name "Mysqldump::connect" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Connecting with PDO.
        try {
            switch ($this->dbType) {
                case 'sqlite':

Line indented incorrectly; expected 12 spaces, found 16

                    $this->dbHandler = @new PDO("sqlite:".$this->dbName, null, null, $this->pdoSettings);

This line exceeds maximum limit of 100 characters; contains 105 characters

Silencing errors is discouraged

The string literal sqlite: does not require double quotes, as per coding-style, please use single quotes.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

                    break;

Case breaking statement must be indented 4 spaces from SWITCH keyword

Case breaking statements must be followed by a single blank line

                case 'mysql':

Line indented incorrectly; expected 12 spaces, found 16

                case 'pgsql':

Line indented incorrectly; expected 12 spaces, found 16

                case 'dblib':

Line indented incorrectly; expected 12 spaces, found 16

                    $this->dbHandler = @new PDO(

Silencing errors is discouraged

                        $this->dsn,
                        $this->user,
                        $this->pass,
                        $this->pdoSettings
                    );
                    // Execute init commands once connected

Inline comments must end in full-stops, exclamation marks, or question marks

                    foreach ($this->dumpSettings['init_commands'] as $stmt) {

Line indented incorrectly; expected 12 spaces, found 20

                        $this->dbHandler->exec($stmt);
                    }

No blank line found after control structure

Line indented incorrectly; expected 12 spaces, found 20

                    // Store server version

Inline comments must end in full-stops, exclamation marks, or question marks

                    $this->version = $this->dbHandler->getAttribute(PDO::ATTR_SERVER_VERSION);
                    break;

Case breaking statements must be followed by a single blank line

Case breaking statement must be indented 4 spaces from SWITCH keyword

                default:

Line indented incorrectly; expected 12 spaces, found 16

                    throw new Exception("Unsupported database type (".$this->dbType.")");

Are you sure $this->dbType of type mixed can be used in concatenation?

Case breaking statement must be indented 4 spaces from SWITCH keyword

The string literal Unsupported database type ( does not require double quotes, as per coding-style, please use single quotes.

The string literal ) does not require double quotes, as per coding-style, please use single quotes.

            }

End comment for long condition not found; expected "//end switch"

        } catch (PDOException $e) {
            throw new Exception(
                "Connection to ".$this->dbType." failed with message: ".

Concat operator must not be surrounded by spaces

The string literal Connection to does not require double quotes, as per coding-style, please use single quotes.

The string literal failed with message: does not require double quotes, as per coding-style, please use single quotes.

                $e->getMessage()
            );
        }

End comment for long condition not found; expected "//end try"

        if (is_null($this->dbHandler)) {
            throw new Exception("Connection to ".$this->dbType."failed");

The string literal Connection to does not require double quotes, as per coding-style, please use single quotes.

The string literal failed does not require double quotes, as per coding-style, please use single quotes.

        }

        $this->dbHandler->setAttribute(PDO::ATTR_ORACLE_NULLS, PDO::NULL_NATURAL);
        $this->typeAdapter = TypeAdapterFactory::create($this->dbType, $this->dbHandler, $this->dumpSettings);

This line exceeds maximum limit of 100 characters; contains 110 characters

    }

Expected 1 blank line before closing function brace; 0 found

Expected //end connect()

Expected 2 blank lines after function; 1 found

    /**
     * Primary function, triggers dumping.
     *
     * @param string $filename  Name of file to write sql dump to

Parameter comment must end with a full stop

Tag value indented incorrectly; expected 2 spaces but found 1

Expected 1 spaces after parameter name; 2 found

     * @return null

Tag cannot be grouped with parameter tags in a doc comment

     * @throws \Exception

Tag cannot be grouped with parameter tags in a doc comment

Comment missing for @throws tag in function comment

     */

Missing @throws tag for "Exception" exception

    public function start($filename = '')
    {

Opening brace should be on the same line as the declaration

        // Output file can be redefined here

Inline comments must end in full-stops, exclamation marks, or question marks

        if (!empty($filename)) {

There must be a single space after a NOT operator; 0 found

            $this->fileName = $filename;
        }

        // Connect to database

Inline comments must end in full-stops, exclamation marks, or question marks

        $this->connect();

        // Create output file

Inline comments must end in full-stops, exclamation marks, or question marks

        $this->compressManager->open($this->fileName);

        // Write some basic info to output file

Inline comments must end in full-stops, exclamation marks, or question marks

        $this->compressManager->write($this->getDumpFileHeader());

        // Store server settings and use sanner defaults to dump

Inline comments must end in full-stops, exclamation marks, or question marks

        $this->compressManager->write(
            $this->typeAdapter->backup_parameters()
        );

        if ($this->dumpSettings['databases']) {
            $this->compressManager->write(
                $this->typeAdapter->getDatabaseHeader($this->dbName)
            );
            if ($this->dumpSettings['add-drop-database']) {
                $this->compressManager->write(
                    $this->typeAdapter->add_drop_database($this->dbName)
                );
            }
        }

        // Get table, view, trigger, procedures, functions and events structures from
        // database.
        $this->getDatabaseStructureTables();
        $this->getDatabaseStructureViews();
        $this->getDatabaseStructureTriggers();
        $this->getDatabaseStructureProcedures();
        $this->getDatabaseStructureFunctions();
        $this->getDatabaseStructureEvents();

        if ($this->dumpSettings['databases']) {
            $this->compressManager->write(
                $this->typeAdapter->databases($this->dbName)
            );
        }

        // If there still are some tables/views in include-tables array,
        // that means that some tables or views weren't found.
        // Give proper error and exit.
        // This check will be removed once include-tables supports regexps.
        if (0 < count($this->dumpSettings['include-tables'])) {
            $name = implode(",", $this->dumpSettings['include-tables']);

The string literal , does not require double quotes, as per coding-style, please use single quotes.

            throw new Exception("Table (".$name.") not found in database");

The string literal ) not found in database does not require double quotes, as per coding-style, please use single quotes.

The string literal Table ( does not require double quotes, as per coding-style, please use single quotes.

        }

        $this->exportTables();
        $this->exportTriggers();
        $this->exportFunctions();
        $this->exportProcedures();
        $this->exportViews();
        $this->exportEvents();

        // Restore saved parameters.
        $this->compressManager->write(
            $this->typeAdapter->restore_parameters()
        );
        // Write some stats to output file.
        $this->compressManager->write($this->getDumpFileFooter());
        // Close output file.
        $this->compressManager->close();

        return;

Empty return statement not required here

Function return type is not void, but function is returning void here

    }

Expected //end start()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    /**
     * Returns header for dump file.
     *
     * @return string
     */
    private function getDumpFileHeader()

Private method name "Mysqldump::getDumpFileHeader" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        $header = '';
        if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

            // Some info about software, source and time

Inline comments must end in full-stops, exclamation marks, or question marks

            $header = "-- mysqldump-php https://github.com/ifsnop/mysqldump-php".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal -- mysqldump-php https://github.com/ifsnop/mysqldump-php does not require double quotes, as per coding-style, please use single quotes.

                    "--".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

                    "-- Host: {$this->host}\tDatabase: {$this->dbName}".PHP_EOL.

As per coding-style, please use concatenation or sprintf for the variable $this instead of interpolation.

Concat operator must not be surrounded by spaces

                    "-- ------------------------------------------------------".PHP_EOL;

The string literal -- ------------------------------------------------------ does not require double quotes, as per coding-style, please use single quotes.

            if (!empty($this->version)) {

There must be a single space after a NOT operator; 0 found

                $header .= "-- Server version \t".$this->version.PHP_EOL;
            }

            if (!$this->dumpSettings['skip-dump-date']) {

There must be a single space after a NOT operator; 0 found

                $header .= "-- Date: ".date('r').PHP_EOL.PHP_EOL;

The string literal -- Date: does not require double quotes, as per coding-style, please use single quotes.

            }
        }

No blank line found after control structure

        return $header;
    }

Expected //end getDumpFileHeader()

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

    /**
     * Returns footer for dump file.
     *
     * @return string
     */
    private function getDumpFileFooter()

Private method name "Mysqldump::getDumpFileFooter" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        $footer = '';
        if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

            $footer .= '-- Dump completed';
            if (!$this->dumpSettings['skip-dump-date']) {

There must be a single space after a NOT operator; 0 found

                $footer .= ' on: '.date('r');
            }

No blank line found after control structure

            $footer .= PHP_EOL;
        }

        return $footer;
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end getDumpFileFooter()

Expected 2 blank lines after function; 1 found

    /**
     * Reads table names from database.
     * Fills $this->tables array so they will be dumped later.
     *
     * @return null
     */
    private function getDatabaseStructureTables()

Private method name "Mysqldump::getDatabaseStructureTables" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Listing all tables from database

Inline comments must end in full-stops, exclamation marks, or question marks

        if (empty($this->dumpSettings['include-tables'])) {
            // include all tables for now, blacklisting happens later

Inline comments must start with a capital letter

Inline comments must end in full-stops, exclamation marks, or question marks

            foreach ($this->dbHandler->query($this->typeAdapter->show_tables($this->dbName)) as $row) {

This line exceeds maximum limit of 100 characters; contains 103 characters

                array_push($this->tables, current($row));
            }
        } else {
            // include only the tables mentioned in include-tables

Inline comments must start with a capital letter

Inline comments must end in full-stops, exclamation marks, or question marks

            foreach ($this->dbHandler->query($this->typeAdapter->show_tables($this->dbName)) as $row) {

This line exceeds maximum limit of 100 characters; contains 103 characters

                if (in_array(current($row), $this->dumpSettings['include-tables'], true)) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

                    array_push($this->tables, current($row));
                    $elem = array_search(
                        current($row),
                        $this->dumpSettings['include-tables']
                    );
                    unset($this->dumpSettings['include-tables'][$elem]);
                }
            }
        }

No blank line found after control structure

        return;

Function return type is not void, but function is returning void here

Empty return statement not required here

    }

Expected //end getDatabaseStructureTables()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    /**
     * Reads view names from database.
     * Fills $this->tables array so they will be dumped later.
     *
     * @return null
     */
    private function getDatabaseStructureViews()

Private method name "Mysqldump::getDatabaseStructureViews" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Listing all views from database

Inline comments must end in full-stops, exclamation marks, or question marks

        if (empty($this->dumpSettings['include-views'])) {
            // include all views for now, blacklisting happens later

Inline comments must start with a capital letter

Inline comments must end in full-stops, exclamation marks, or question marks

            foreach ($this->dbHandler->query($this->typeAdapter->show_views($this->dbName)) as $row) {

This line exceeds maximum limit of 100 characters; contains 102 characters

                array_push($this->views, current($row));
            }
        } else {
            // include only the tables mentioned in include-tables

Inline comments must start with a capital letter

Inline comments must end in full-stops, exclamation marks, or question marks

            foreach ($this->dbHandler->query($this->typeAdapter->show_views($this->dbName)) as $row) {

This line exceeds maximum limit of 100 characters; contains 102 characters

                if (in_array(current($row), $this->dumpSettings['include-views'], true)) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

                    array_push($this->views, current($row));
                    $elem = array_search(
                        current($row),
                        $this->dumpSettings['include-views']
                    );
                    unset($this->dumpSettings['include-views'][$elem]);
                }
            }
        }

No blank line found after control structure

        return;

Empty return statement not required here

Function return type is not void, but function is returning void here

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getDatabaseStructureViews()

    /**
     * Reads trigger names from database.
     * Fills $this->tables array so they will be dumped later.
     *
     * @return null
     */
    private function getDatabaseStructureTriggers()

Private method name "Mysqldump::getDatabaseStructureTriggers" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Listing all triggers from database

Inline comments must end in full-stops, exclamation marks, or question marks

        if (false === $this->dumpSettings['skip-triggers']) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            foreach ($this->dbHandler->query($this->typeAdapter->show_triggers($this->dbName)) as $row) {

This line exceeds maximum limit of 100 characters; contains 105 characters

                array_push($this->triggers, $row['Trigger']);
            }
        }

No blank line found after control structure

        return;

Empty return statement not required here

Function return type is not void, but function is returning void here

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getDatabaseStructureTriggers()

    /**
     * Reads procedure names from database.
     * Fills $this->tables array so they will be dumped later.
     *
     * @return null
     */
    private function getDatabaseStructureProcedures()

Private method name "Mysqldump::getDatabaseStructureProcedures" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Listing all procedures from database

Inline comments must end in full-stops, exclamation marks, or question marks

        if ($this->dumpSettings['routines']) {
            foreach ($this->dbHandler->query($this->typeAdapter->show_procedures($this->dbName)) as $row) {

This line exceeds maximum limit of 100 characters; contains 107 characters

                array_push($this->procedures, $row['procedure_name']);
            }
        }

No blank line found after control structure

        return;

Empty return statement not required here

Function return type is not void, but function is returning void here

    }

Expected //end getDatabaseStructureProcedures()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    /**
     * Reads functions names from database.
     * Fills $this->tables array so they will be dumped later.
     *
     * @return null
     */
    private function getDatabaseStructureFunctions()

Private method name "Mysqldump::getDatabaseStructureFunctions" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Listing all functions from database

Inline comments must end in full-stops, exclamation marks, or question marks

        if ($this->dumpSettings['routines']) {
            foreach ($this->dbHandler->query($this->typeAdapter->show_functions($this->dbName)) as $row) {

This line exceeds maximum limit of 100 characters; contains 106 characters

                array_push($this->functions, $row['function_name']);
            }
        }

No blank line found after control structure

        return;

Function return type is not void, but function is returning void here

Empty return statement not required here

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getDatabaseStructureFunctions()

    /**
     * Reads event names from database.
     * Fills $this->tables array so they will be dumped later.
     *
     * @return null
     */
    private function getDatabaseStructureEvents()

Private method name "Mysqldump::getDatabaseStructureEvents" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Listing all events from database

Inline comments must end in full-stops, exclamation marks, or question marks

        if ($this->dumpSettings['events']) {
            foreach ($this->dbHandler->query($this->typeAdapter->show_events($this->dbName)) as $row) {

This line exceeds maximum limit of 100 characters; contains 103 characters

                array_push($this->events, $row['event_name']);
            }
        }

No blank line found after control structure

        return;

Empty return statement not required here

Function return type is not void, but function is returning void here

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getDatabaseStructureEvents()

    /**

Parameter $table should have a doc-comment as per coding-style.

Parameter $arr should have a doc-comment as per coding-style.

     * Compare if $table name matches with a definition inside $arr
     * @param $table string

Missing parameter name

Tag value indented incorrectly; expected 2 spaces but found 1

There must be exactly one blank line before the tags in a doc comment

     * @param $arr array with strings or patterns

Missing parameter name

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return boolean

Tag cannot be grouped with parameter tags in a doc comment

     */
    private function matches($table, $arr)

Private method name "Mysqldump::matches" must be prefixed with an underscore

Type hint "array" missing for

Type hint "table string" missing for

    {

Opening brace should be on the same line as the declaration

        $match = false;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

        foreach ($arr as $pattern) {
            if ('/' != $pattern[0]) {

Operator != prohibited; use !== instead

                continue;
            }

No blank line found after control structure

            if (1 == preg_match($pattern, $table)) {

Operator == prohibited; use === instead

                $match = true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            }
        }

        return in_array($table, $arr) || $match;

Boolean operators are not allowed outside of control structure conditions

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end matches()

    /**
     * Exports all the tables selected from database
     *
     * @return null

Function return type is not void, but function has no return statement

     */
    private function exportTables()

Private method name "Mysqldump::exportTables" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Exporting tables one by one

Inline comments must end in full-stops, exclamation marks, or question marks

        foreach ($this->tables as $table) {
            if ($this->matches($table, $this->dumpSettings['exclude-tables'])) {
                continue;
            }

No blank line found after control structure

            $this->getTableStructure($table);
            if (false === $this->dumpSettings['no-data']) { // don't break compatibility with old trigger

Inline comments must end in full-stops, exclamation marks, or question marks

Inline comments must start with a capital letter

This line exceeds maximum limit of 100 characters; contains 105 characters

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

Comments may not appear after statements

                $this->listValues($table);
            } elseif (true === $this->dumpSettings['no-data']

Usage of ELSEIF not allowed; use ELSE IF instead

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

                 || $this->matches($table, $this->dumpSettings['no-data'])) {

Multi-line IF statement not indented correctly; expected 16 spaces but found 17

Closing parenthesis of a multi-line IF statement must be on a new line

                continue;
            } else {
                $this->listValues($table);
            }
        }
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end exportTables()

Expected 2 blank lines after function; 1 found

    /**
     * Exports all the views found in database
     *
     * @return null

Function return type is not void, but function has no return statement

     */
    private function exportViews()

Private method name "Mysqldump::exportViews" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        if (false === $this->dumpSettings['no-create-info']) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            // Exporting views one by one

Inline comments must end in full-stops, exclamation marks, or question marks

            foreach ($this->views as $view) {
                if ($this->matches($view, $this->dumpSettings['exclude-tables'])) {
                    continue;
                }

No blank line found after control structure

                $this->tableColumnTypes[$view] = $this->getTableColumnTypes($view);
                $this->getViewStructureTable($view);
            }

No blank line found after control structure

            foreach ($this->views as $view) {
                if ($this->matches($view, $this->dumpSettings['exclude-tables'])) {
                    continue;
                }

No blank line found after control structure

                $this->getViewStructureView($view);
            }
        }
    }

Expected //end exportViews()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    /**
     * Exports all the triggers found in database
     *
     * @return null

Function return type is not void, but function has no return statement

     */
    private function exportTriggers()

Private method name "Mysqldump::exportTriggers" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Exporting triggers one by one

Inline comments must end in full-stops, exclamation marks, or question marks

        foreach ($this->triggers as $trigger) {
            $this->getTriggerStructure($trigger);
        }

    }

Function closing brace must go on the next line following the body; found 1 blank lines before brace

Expected 2 blank lines after function; 1 found

Expected //end exportTriggers()

    /**
     * Exports all the procedures found in database
     *
     * @return null

Function return type is not void, but function has no return statement

     */
    private function exportProcedures()

Private method name "Mysqldump::exportProcedures" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Exporting triggers one by one

Inline comments must end in full-stops, exclamation marks, or question marks

        foreach ($this->procedures as $procedure) {
            $this->getProcedureStructure($procedure);
        }
    }

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

Expected //end exportProcedures()

    /**
     * Exports all the functions found in database
     *
     * @return null

Function return type is not void, but function has no return statement

     */
    private function exportFunctions()

Private method name "Mysqldump::exportFunctions" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Exporting triggers one by one

Inline comments must end in full-stops, exclamation marks, or question marks

        foreach ($this->functions as $function) {
            $this->getFunctionStructure($function);
        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end exportFunctions()

    /**
     * Exports all the events found in database
     *
     * @return null

Function return type is not void, but function has no return statement

     */
    private function exportEvents()

Private method name "Mysqldump::exportEvents" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        // Exporting triggers one by one

Inline comments must end in full-stops, exclamation marks, or question marks

        foreach ($this->events as $event) {
            $this->getEventStructure($event);
        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end exportEvents()

    /**
     * Table structure extractor
     *
     * @todo move specific mysql code to typeAdapter

Tag value indented incorrectly; expected 3 spaces but found 1

Comment refers to a TODO task

     * @param string $tableName  Name of table to export

Tag value indented incorrectly; expected 2 spaces but found 1

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

Parameter tags must be grouped together in a doc comment

     * @return null

Tag cannot be grouped with parameter tags in a doc comment

     */
    private function getTableStructure($tableName)

Private method name "Mysqldump::getTableStructure" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        if (!$this->dumpSettings['no-create-info']) {

There must be a single space after a NOT operator; 0 found

            $ret = '';
            if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

                $ret = "--".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

                    "-- Table structure for table `$tableName`".PHP_EOL.

Concat operator must not be surrounded by spaces

As per coding-style, please use concatenation or sprintf for the variable $tableName instead of interpolation.

                    "--".PHP_EOL.PHP_EOL;

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

            }

No blank line found after control structure

            $stmt = $this->typeAdapter->show_create_table($tableName);
            foreach ($this->dbHandler->query($stmt) as $r) {
                $this->compressManager->write($ret);
                if ($this->dumpSettings['add-drop-table']) {
                    $this->compressManager->write(
                        $this->typeAdapter->drop_table($tableName)
                    );
                }

No blank line found after control structure

                $this->compressManager->write(
                    $this->typeAdapter->create_table($r)
                );
                break;
            }
        }

No blank line found after control structure

End comment for long condition not found; expected "//end if"

        $this->tableColumnTypes[$tableName] = $this->getTableColumnTypes($tableName);
        return;

Empty return statement not required here

Function return type is not void, but function is returning void here

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getTableStructure()

    /**
     * Store column types to create data dumps and for Stand-In tables
     *
     * @param string $tableName  Name of table to export

Parameter comment must end with a full stop

Expected 1 spaces after parameter name; 2 found

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return array type column types detailed

Tag cannot be grouped with parameter tags in a doc comment

     */

There must be no blank lines after the function comment

    private function getTableColumnTypes($tableName)

Expected 2 blank lines before function; 1 found

Private method name "Mysqldump::getTableColumnTypes" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        $columnTypes = array();

Short array syntax must be used to define arrays

        $columns = $this->dbHandler->query(

Equals sign not aligned with surrounding assignments; expected 5 spaces but found 1 space

            $this->typeAdapter->show_columns($tableName)
        );
        $columns->setFetchMode(PDO::FETCH_ASSOC);

        foreach ($columns as $key => $col) {
            $types = $this->typeAdapter->parseColumnType($col);

Equals sign not aligned with surrounding assignments; expected 22 spaces but found 1 space

            $columnTypes[$col['Field']] = array(

Short array syntax must be used to define arrays

                'is_numeric'=> $types['is_numeric'],

This array key does not seem to be aligned correctly; expected 43 spaces, but found 16.

Expected 1 space before "=>"; 0 found

                'is_blob' => $types['is_blob'],

This array key does not seem to be aligned correctly; expected 43 spaces, but found 16.

                'type' => $types['type'],

This array key does not seem to be aligned correctly; expected 43 spaces, but found 16.

                'type_sql' => $col['Type'],

This array key does not seem to be aligned correctly; expected 43 spaces, but found 16.

                'is_virtual' => $types['is_virtual'],

This array key does not seem to be aligned correctly; expected 43 spaces, but found 16.

                'key_sql' => $col['Key'],

This array key does not seem to be aligned correctly; expected 43 spaces, but found 16.

            );

The closing parenthesis does not seem to be aligned correctly; expected 42 space(s), but found 12.

        }

        return $columnTypes;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getTableColumnTypes()

    /**
     * View structure extractor, create table (avoids cyclic references)
     *
     * @todo move mysql specific code to typeAdapter

Comment refers to a TODO task

Tag value indented incorrectly; expected 3 spaces but found 1

     * @param string $viewName  Name of view to export

Parameter tags must be grouped together in a doc comment

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return null

Tag cannot be grouped with parameter tags in a doc comment

Function return type is not void, but function has no return statement

     */
    private function getViewStructureTable($viewName)

Private method name "Mysqldump::getViewStructureTable" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

            $ret = "--".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

                "-- Stand-In structure for view `${viewName}`".PHP_EOL.

Concat operator must not be surrounded by spaces

                "--".PHP_EOL.PHP_EOL;

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

            $this->compressManager->write($ret);
        }

No blank line found after control structure

        $stmt = $this->typeAdapter->show_create_view($viewName);

        // create views as tables, to resolve dependencies

Inline comments must start with a capital letter

Inline comments must end in full-stops, exclamation marks, or question marks

        foreach ($this->dbHandler->query($stmt) as $r) {
            if ($this->dumpSettings['add-drop-table']) {
                $this->compressManager->write(
                    $this->typeAdapter->drop_view($viewName)
                );
            }

            $this->compressManager->write(
                $this->createStandInTable($viewName)
            );
            break;
        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getViewStructureTable()

    /**
     * Write a create table statement for the table Stand-In, show create
     * table would return a create algorithm when used on a view
     *
     * @param string $viewName  Name of view to export

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return string create statement

Tag cannot be grouped with parameter tags in a doc comment

     */
    public function createStandInTable($viewName)
    {

Opening brace should be on the same line as the declaration

        $ret = array();

Short array syntax must be used to define arrays

        foreach ($this->tableColumnTypes[$viewName] as $k => $v) {
            $ret[] = "`${k}` ${v['type_sql']}";
        }

No blank line found after control structure

        $ret = implode(PHP_EOL.",", $ret);

The string literal , does not require double quotes, as per coding-style, please use single quotes.

        $ret = "CREATE TABLE IF NOT EXISTS `$viewName` (".

As per coding-style, please use concatenation or sprintf for the variable $viewName instead of interpolation.

Concat operator must not be surrounded by spaces

            PHP_EOL.$ret.PHP_EOL.");".PHP_EOL;

The string literal ); does not require double quotes, as per coding-style, please use single quotes.

        return $ret;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end createStandInTable()

    /**
     * View structure extractor, create view
     *
     * @todo move mysql specific code to typeAdapter

Comment refers to a TODO task

Tag value indented incorrectly; expected 3 spaces but found 1

     * @param string $viewName  Name of view to export

Parameter tags must be grouped together in a doc comment

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return null

Tag cannot be grouped with parameter tags in a doc comment

Function return type is not void, but function has no return statement

     */
    private function getViewStructureView($viewName)

Private method name "Mysqldump::getViewStructureView" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

            $ret = "--".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

                "-- View structure for view `${viewName}`".PHP_EOL.

Concat operator must not be surrounded by spaces

                "--".PHP_EOL.PHP_EOL;

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

            $this->compressManager->write($ret);
        }

No blank line found after control structure

        $stmt = $this->typeAdapter->show_create_view($viewName);

        // create views, to resolve dependencies

Inline comments must start with a capital letter

        // replacing tables with views

Inline comments must end in full-stops, exclamation marks, or question marks

        foreach ($this->dbHandler->query($stmt) as $r) {
            // because we must replace table with view, we should delete it

Inline comments must start with a capital letter

Inline comments must end in full-stops, exclamation marks, or question marks

            $this->compressManager->write(
                $this->typeAdapter->drop_view($viewName)
            );
            $this->compressManager->write(
                $this->typeAdapter->create_view($r)
            );
            break;
        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getViewStructureView()

    /**
     * Trigger structure extractor
     *
     * @param string $triggerName  Name of trigger to export

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return null

Tag cannot be grouped with parameter tags in a doc comment

     */
    private function getTriggerStructure($triggerName)

Private method name "Mysqldump::getTriggerStructure" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        $stmt = $this->typeAdapter->show_create_trigger($triggerName);
        foreach ($this->dbHandler->query($stmt) as $r) {
            if ($this->dumpSettings['add-drop-trigger']) {
                $this->compressManager->write(
                    $this->typeAdapter->add_drop_trigger($triggerName)
                );
            }

No blank line found after control structure

            $this->compressManager->write(
                $this->typeAdapter->create_trigger($r)
            );
            return;

Function return type is not void, but function is returning void here

        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getTriggerStructure()

    /**
     * Procedure structure extractor
     *
     * @param string $procedureName  Name of procedure to export

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return null

Tag cannot be grouped with parameter tags in a doc comment

     */
    private function getProcedureStructure($procedureName)

Private method name "Mysqldump::getProcedureStructure" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

            $ret = "--".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

                "-- Dumping routines for database '".$this->dbName."'".PHP_EOL.

Concat operator must not be surrounded by spaces

                "--".PHP_EOL.PHP_EOL;

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

            $this->compressManager->write($ret);
        }

No blank line found after control structure

        $stmt = $this->typeAdapter->show_create_procedure($procedureName);
        foreach ($this->dbHandler->query($stmt) as $r) {
            $this->compressManager->write(
                $this->typeAdapter->create_procedure($r)
            );
            return;

Function return type is not void, but function is returning void here

        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getProcedureStructure()

    /**
     * Function structure extractor
     *
     * @param string $functionName  Name of function to export

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return null

Tag cannot be grouped with parameter tags in a doc comment

     */
    private function getFunctionStructure($functionName)

Private method name "Mysqldump::getFunctionStructure" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

            $ret = "--".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

                "-- Dumping routines for database '".$this->dbName."'".PHP_EOL.

Concat operator must not be surrounded by spaces

                "--".PHP_EOL.PHP_EOL;

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

            $this->compressManager->write($ret);
        }

No blank line found after control structure

        $stmt = $this->typeAdapter->show_create_function($functionName);
        foreach ($this->dbHandler->query($stmt) as $r) {
            $this->compressManager->write(
                $this->typeAdapter->create_function($r)
            );
            return;

Function return type is not void, but function is returning void here

        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getFunctionStructure()

    /**
     * Event structure extractor
     *
     * @param string $eventName  Name of event to export

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return null

Tag cannot be grouped with parameter tags in a doc comment

     */
    private function getEventStructure($eventName)

Private method name "Mysqldump::getEventStructure" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

            $ret = "--".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

                "-- Dumping events for database '".$this->dbName."'".PHP_EOL.

Concat operator must not be surrounded by spaces

                "--".PHP_EOL.PHP_EOL;

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

            $this->compressManager->write($ret);
        }

No blank line found after control structure

        $stmt = $this->typeAdapter->show_create_event($eventName);
        foreach ($this->dbHandler->query($stmt) as $r) {
            $this->compressManager->write(
                $this->typeAdapter->create_event($r)
            );
            return;

Function return type is not void, but function is returning void here

        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getEventStructure()

    /**
     * Prepare values for output
     *
     * @param string $tableName Name of table which contains rows

Parameter comment must end with a full stop

     * @param array $row Associative array of column names and values to be

Expected 2 spaces after parameter type; 1 found

Expected 7 spaces after parameter name; 1 found

Parameter comment must end with a full stop

     *   quoted

Parameter comment not aligned correctly; expected 19 spaces but found 3

     *
     * @return array
     */
    private function prepareColumnValues($tableName, array $row)

Private method name "Mysqldump::prepareColumnValues" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        $ret = array();

Equals sign not aligned with surrounding assignments; expected 9 spaces but found 1 space

Short array syntax must be used to define arrays

        $columnTypes = $this->tableColumnTypes[$tableName];

        if ($this->transformTableRowCallable) {
            $row = call_user_func($this->transformTableRowCallable, $tableName, $row);
        }

        foreach ($row as $colName => $colValue) {
            if ($this->transformColumnValueCallable) {
                $colValue = call_user_func($this->transformColumnValueCallable, $tableName, $colName, $colValue, $row);

This line exceeds maximum limit of 100 characters; contains 119 characters

            }

            $ret[] = $this->escape($colValue, $columnTypes[$colName]);
        }

        return $ret;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end prepareColumnValues()

    /**

Parameter $colValue should have a doc-comment as per coding-style.

Parameter $colType should have a doc-comment as per coding-style.

     * Escape values with quotes when needed
     *
     * @param string $tableName Name of table which contains rows

Doc comment for parameter $tableName does not match actual variable name $colValue

Parameter comment must end with a full stop

     * @param array $row Associative array of column names and values to be quoted

Expected 2 spaces after parameter type; 1 found

Doc comment for parameter $row does not match actual variable name $colType

Expected 7 spaces after parameter name; 1 found

Parameter comment must end with a full stop

     *
     * @return string
     */
    private function escape($colValue, $colType)

Private method name "Mysqldump::escape" must be prefixed with an underscore

Type hint "array" missing for $row

    {

Opening brace should be on the same line as the declaration

        if (is_null($colValue)) {
            return "NULL";

The string literal NULL does not require double quotes, as per coding-style, please use single quotes.

        } elseif ($this->dumpSettings['hex-blob'] && $colType['is_blob']) {

Usage of ELSEIF not allowed; use ELSE IF instead

            if ($colType['type'] == 'bit' || !empty($colValue)) {

Operator == prohibited; use === instead

There must be a single space after a NOT operator; 0 found

                return "0x${colValue}";
            } else {
                return "''";
            }
        } elseif ($colType['is_numeric']) {

Usage of ELSEIF not allowed; use ELSE IF instead

            return $colValue;
        }

        return $this->dbHandler->quote($colValue);
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end escape()

    /**
     * Set a callable that will be used to transform table rows
     *
     * @param callable $callable

Missing parameter comment

     *
     * @return void
     */
    public function setTransformTableRowHook($callable)

Type hint "callable" missing for $callable

    {

Opening brace should be on the same line as the declaration

        $this->transformTableRowCallable = $callable;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end setTransformTableRowHook()

    /**
     * Set a callable that will be used to transform column values
     *
     * @param callable $callable

Missing parameter comment

     *
     * @return void
     *
     * @deprecated Use setTransformTableRowHook instead for better performance
     */
    public function setTransformColumnValueHook($callable)

Type hint "callable" missing for $callable

    {

Opening brace should be on the same line as the declaration

        $this->transformColumnValueCallable = $callable;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end setTransformColumnValueHook()

    /**
     * Set a callable that will be used to report dump information
     *
     * @param callable $callable

Missing parameter comment

     *
     * @return void
     */
    public function setInfoHook($callable)

Type hint "callable" missing for $callable

    {

Opening brace should be on the same line as the declaration

        $this->infoCallable = $callable;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end setInfoHook()

    /**
     * Table rows extractor
     *
     * @param string $tableName  Name of table to export

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

     *
     * @return null

Function return type is not void, but function has no return statement

     */
    private function listValues($tableName)

Private method name "Mysqldump::listValues" must be prefixed with an underscore

    {

Opening brace should be on the same line as the declaration

        $this->prepareListValues($tableName);

        $onlyOnce = true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

        $lineSize = 0;

        // colStmt is used to form a query to obtain row values

Inline comments must start with a capital letter

Inline comments must end in full-stops, exclamation marks, or question marks

        $colStmt = $this->getColumnStmt($tableName);
        // colNames is used to get the name of the columns when using complete-insert

Inline comments must start with a capital letter

Inline comments must end in full-stops, exclamation marks, or question marks

        if ($this->dumpSettings['complete-insert']) {
            $colNames = $this->getColumnNames($tableName);
        }

        $stmt = "SELECT ".implode(",", $colStmt)." FROM `$tableName`";

The string literal SELECT does not require double quotes, as per coding-style, please use single quotes.

The string literal , does not require double quotes, as per coding-style, please use single quotes.

As per coding-style, please use concatenation or sprintf for the variable $tableName instead of interpolation.

        // Table specific conditions override the default 'where'

Inline comments must end in full-stops, exclamation marks, or question marks

        $condition = $this->getTableWhere($tableName);

        if ($condition) {
            $stmt .= " WHERE {$condition}";

As per coding-style, please use concatenation or sprintf for the variable $condition instead of interpolation.

        }

        $limit = $this->getTableLimit($tableName);

        if ($limit !== false) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            $stmt .= " LIMIT {$limit}";

As per coding-style, please use concatenation or sprintf for the variable $limit instead of interpolation.

        }

        $resultSet = $this->dbHandler->query($stmt);
        $resultSet->setFetchMode(PDO::FETCH_ASSOC);

        $replace = $this->dumpSettings['replace']  && $this->getHasPrimaryKey($tableName);

Equals sign not aligned with surrounding assignments; expected 8 spaces but found 1 space

Boolean operators are not allowed outside of control structure conditions

Expected 1 space before logical operator; 2 found

The value of a boolean operation must not be assigned to a variable

        $strUpdates = $replace ? $this->getUpdateColumnsOnDuplicate($tableName) : '';

The value of a comparison must not be assigned to a variable

Equals sign not aligned with surrounding assignments; expected 5 spaces but found 1 space

Inline IF statements are not allowed

Inline shorthand IF statement requires brackets around comparison

        $extendedInsert = $this->dumpSettings['extended-insert'] && !$replace;

There must be a single space after a NOT operator; 0 found

The value of a boolean operation must not be assigned to a variable

Boolean operators are not allowed outside of control structure conditions

        $ignore = $this->dumpSettings['insert-ignore'] && !$replace ? '  IGNORE' : '';

There must be a single space after a NOT operator; 0 found

Inline IF statements are not allowed

Inline shorthand IF statement requires brackets around comparison

Equals sign not aligned with surrounding assignments; expected 9 spaces but found 1 space

The value of a boolean operation must not be assigned to a variable

Boolean operators are not allowed outside of control structure conditions

Functions must not contain multiple empty lines in a row; found 2 empty lines

        $count = 0;
        foreach ($resultSet as $row) {
            $count++;
            $vals = $this->prepareColumnValues($tableName, $row);
            if ($onlyOnce || !$extendedInsert) {

There must be a single space after a NOT operator; 0 found

                if ($this->dumpSettings['complete-insert']) {
                    $lineSize += $this->compressManager->write(
                        "INSERT$ignore INTO `$tableName` (".

Concat operator must not be surrounded by spaces

As per coding-style, please use concatenation or sprintf for the variable $ignore instead of interpolation.

As per coding-style, please use concatenation or sprintf for the variable $tableName instead of interpolation.

                        implode(", ", $colNames).

The string literal , does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

The variable $colNames does not seem to be defined for all execution paths leading up to this point.

                        ") VALUES (".implode(",", $vals).")"

The string literal ) VALUES ( does not require double quotes, as per coding-style, please use single quotes.

The string literal , does not require double quotes, as per coding-style, please use single quotes.

The string literal ) does not require double quotes, as per coding-style, please use single quotes.

                    );
                } else {
                    $lineSize += $this->compressManager->write(
                        "INSERT$ignore INTO `$tableName` VALUES (".implode(",", $vals).")"

The string literal , does not require double quotes, as per coding-style, please use single quotes.

The string literal ) does not require double quotes, as per coding-style, please use single quotes.

As per coding-style, please use concatenation or sprintf for the variable $ignore instead of interpolation.

As per coding-style, please use concatenation or sprintf for the variable $tableName instead of interpolation.

                    );
                }

No blank line found after control structure

		if ($replace) {

Line indented incorrectly; expected 16 spaces, found 2

                    $lineSize += $this->compressManager->write(" ON DUPLICATE KEY UPDATE {$strUpdates}");

This line exceeds maximum limit of 100 characters; contains 105 characters

As per coding-style, please use concatenation or sprintf for the variable $strUpdates instead of interpolation.

		}

No blank line found after control structure

Line indented incorrectly; expected 16 spaces, found 2

                $onlyOnce = false;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            } else {
                $lineSize += $this->compressManager->write(",(".implode(",", $vals).")");

The string literal ,( does not require double quotes, as per coding-style, please use single quotes.

The string literal , does not require double quotes, as per coding-style, please use single quotes.

The string literal ) does not require double quotes, as per coding-style, please use single quotes.

            }

No blank line found after control structure

            if (($lineSize > $this->dumpSettings['net_buffer_length']) || !$extendedInsert) {

There must be a single space after a NOT operator; 0 found

                $onlyOnce = true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

                $lineSize = $this->compressManager->write(";".PHP_EOL);

The string literal ; does not require double quotes, as per coding-style, please use single quotes.

            }
        }

End comment for long condition not found; expected "//end foreach"

No blank line found after control structure

        $resultSet->closeCursor();

        if (!$onlyOnce) {

There must be a single space after a NOT operator; 0 found

            $this->compressManager->write(";".PHP_EOL);

The string literal ; does not require double quotes, as per coding-style, please use single quotes.

        }

        $this->endListValues($tableName, $count);

        if ($this->infoCallable) {
            call_user_func($this->infoCallable, 'table', array('name' => $tableName, 'rowCount' => $count));

Short array syntax must be used to define arrays

This line exceeds maximum limit of 100 characters; contains 108 characters

        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end listValues()

    /**
     * Does the table have a primary key
     *
     * @param string $tableName Name of table

Parameter comment must end with a full stop

     *
     * @return bool

Expected "boolean" but found "bool" for function return type

     */
   public function getHasPrimaryKey($tableName)

Line indented incorrectly; expected 4 spaces, found 3

   {

Opening brace should be on the same line as the declaration

Line indented incorrectly; expected at least 4 spaces, found 3

        foreach ($this->tableColumnTypes[$tableName] as $colName => $colType) {
            if ($colType['key_sql'] == 'PRI') {

Operator == prohibited; use === instead

                return true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

            }
	}

Closing brace indented incorrectly; expected 8 spaces, found 1

No blank line found after control structure

Line indented incorrectly; expected 8 spaces, found 1

        return false;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Closing brace indented incorrectly; expected 3 spaces, found 4

Expected //end getHasPrimaryKey()

    /**
     * Build SQL List of all non-primary key columns on current table which will be used for update on duplicate key

This line exceeds maximum limit of 100 characters; contains 116 characters

     *
     * @param string $tableName Name of table to get columns

Parameter comment must end with a full stop

     *
     * @return string update columns for sql sentence where update on duplicate key
     */
    public function getUpdateColumnsOnDuplicate($tableName)
    {

Opening brace should be on the same line as the declaration

        $colUpdates = array();

Short array syntax must be used to define arrays

        foreach ($this->tableColumnTypes[$tableName] as $colName => $colType) {
            if ($colType['key_sql'] != 'PRI') {

Operator != prohibited; use !== instead

                $colUpdates[] = "`${colName}`=`${colName}`";
            }
        }

No blank line found after control structure

        return implode(',',$colUpdates);
    }

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

Expected //end getUpdateColumnsOnDuplicate()

    /**
     * Table rows extractor, append information prior to dump
     *
     * @param string $tableName  Name of table to export

Parameter comment must end with a full stop

Expected 1 spaces after parameter name; 2 found

     *
     * @return null
     */
    public function prepareListValues($tableName)
    {

Opening brace should be on the same line as the declaration

        if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

            $this->compressManager->write(
                "--".PHP_EOL.

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

                "-- Dumping data for table `$tableName`".PHP_EOL.

As per coding-style, please use concatenation or sprintf for the variable $tableName instead of interpolation.

Concat operator must not be surrounded by spaces

                "--".PHP_EOL.PHP_EOL

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

            );
        }

        if ($this->dumpSettings['single-transaction']) {
            $this->dbHandler->exec($this->typeAdapter->setup_transaction());
            $this->dbHandler->exec($this->typeAdapter->start_transaction());
        }

        if ($this->dumpSettings['lock-tables'] && !$this->dumpSettings['single-transaction']) {

There must be a single space after a NOT operator; 0 found

            $this->typeAdapter->lock_table($tableName);
        }

        if ($this->dumpSettings['add-locks']) {
            $this->compressManager->write(
                $this->typeAdapter->start_add_lock_table($tableName)
            );
        }

        if ($this->dumpSettings['disable-keys']) {
            $this->compressManager->write(
                $this->typeAdapter->start_add_disable_keys($tableName)
            );
        }

        // Disable autocommit for faster reload

Inline comments must end in full-stops, exclamation marks, or question marks

        if ($this->dumpSettings['no-autocommit']) {
            $this->compressManager->write(
                $this->typeAdapter->start_disable_autocommit()
            );
        }

        return;

Empty return statement not required here

Function return type is not void, but function is returning void here

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end prepareListValues()

    /**
     * Table rows extractor, close locks and commits after dump
     *
     * @param string $tableName Name of table to export.

Expected 2 spaces after parameter type; 1 found

     * @param integer    $count     Number of rows inserted.

Expected 1 spaces after parameter type; 4 found

     *
     * @return void
     */
    public function endListValues($tableName, $count = 0)
    {

Opening brace should be on the same line as the declaration

        if ($this->dumpSettings['disable-keys']) {
            $this->compressManager->write(
                $this->typeAdapter->end_add_disable_keys($tableName)
            );
        }

        if ($this->dumpSettings['add-locks']) {
            $this->compressManager->write(
                $this->typeAdapter->end_add_lock_table($tableName)
            );
        }

        if ($this->dumpSettings['single-transaction']) {
            $this->dbHandler->exec($this->typeAdapter->commit_transaction());
        }

        if ($this->dumpSettings['lock-tables'] && !$this->dumpSettings['single-transaction']) {

There must be a single space after a NOT operator; 0 found

            $this->typeAdapter->unlock_table($tableName);
        }

        // Commit to enable autocommit

Inline comments must end in full-stops, exclamation marks, or question marks

        if ($this->dumpSettings['no-autocommit']) {
            $this->compressManager->write(
                $this->typeAdapter->end_disable_autocommit()
            );
        }

        $this->compressManager->write(PHP_EOL);

        if (!$this->dumpSettings['skip-comments']) {

There must be a single space after a NOT operator; 0 found

            $this->compressManager->write(
                "-- Dumped table `".$tableName."` with $count row(s)".PHP_EOL.

The string literal -- Dumped table ` does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

As per coding-style, please use concatenation or sprintf for the variable $count instead of interpolation.

                '--'.PHP_EOL.PHP_EOL
            );
        }

        return;

Empty return statement not required here

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end endListValues()

    /**
     * Build SQL List of all columns on current table which will be used for selecting
     *
     * @param string $tableName  Name of table to get columns

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

     *
     * @return array SQL sentence with columns for select
     */
    public function getColumnStmt($tableName)
    {

Opening brace should be on the same line as the declaration

        $colStmt = array();

Short array syntax must be used to define arrays

        foreach ($this->tableColumnTypes[$tableName] as $colName => $colType) {
            if ($colType['type'] == 'bit' && $this->dumpSettings['hex-blob']) {

Operator == prohibited; use === instead

                $colStmt[] = "LPAD(HEX(`${colName}`),2,'0') AS `${colName}`";
            } elseif ($colType['is_blob'] && $this->dumpSettings['hex-blob']) {

Usage of ELSEIF not allowed; use ELSE IF instead

                $colStmt[] = "HEX(`${colName}`) AS `${colName}`";
            } elseif ($colType['is_virtual']) {

Usage of ELSEIF not allowed; use ELSE IF instead

                $this->dumpSettings['complete-insert'] = true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

                continue;
            } else {
                $colStmt[] = "`${colName}`";
            }
        }

        return $colStmt;
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end getColumnStmt()

Expected 2 blank lines after function; 1 found

    /**
     * Build SQL List of all columns on current table which will be used for inserting
     *
     * @param string $tableName  Name of table to get columns

Expected 1 spaces after parameter name; 2 found

Parameter comment must end with a full stop

     *
     * @return array columns for sql sentence for insert
     */
    public function getColumnNames($tableName)
    {

Opening brace should be on the same line as the declaration

        $colNames = array();

Short array syntax must be used to define arrays

        foreach ($this->tableColumnTypes[$tableName] as $colName => $colType) {
            if ($colType['is_virtual']) {
                $this->dumpSettings['complete-insert'] = true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

                continue;
            } else {
                $colNames[] = "`${colName}`";
            }
        }

No blank line found after control structure

        return $colNames;
    }

Expected 2 blank lines after function; 0 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getColumnNames()

}

Expected //end class

/**
 * Enum with all available compression methods
 *
 */

Additional blank lines found at end of doc comment

Missing @category tag in class comment

Missing @package tag in class comment

Missing @author tag in class comment

Missing @license tag in class comment

Missing @link tag in class comment

abstract class CompressMethod

Only one interface or class is allowed in a file

Only one class is allowed in a file

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class CompressMethod

    public static $enums = array(

Short array syntax must be used to define arrays

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

        Mysqldump::NONE,

This array value does not seem to be aligned correcty; expected 28 spaces, but found 8.

        Mysqldump::GZIP,

This array value does not seem to be aligned correcty; expected 28 spaces, but found 8.

        Mysqldump::BZIP2,

This array value does not seem to be aligned correcty; expected 28 spaces, but found 8.

        Mysqldump::GZIPSTREAM,

This array value does not seem to be aligned correcty; expected 28 spaces, but found 8.

    );

The closing parenthesis does not seem to be aligned correctly; expected 27 space(s), but found 4.

    /**

Missing short description in doc comment

     * @param string $c

Missing parameter comment

     * @return boolean
     */
    public static function isValid($c)

Expected 2 blank lines before function; 1 found

    {

Opening brace should be on the same line as the declaration

        return in_array($c, self::$enums);
    }

Expected 2 blank lines after function; 0 found

Expected 1 blank line before closing function brace; 0 found

Expected //end isValid()

}

Expected //end class

abstract class CompressManagerFactory

Missing class doc comment

Only one class is allowed in a file

Only one interface or class is allowed in a file

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class CompressManagerFactory

    /**

Missing short description in doc comment

     * @param string $c

Missing parameter comment

     * @return CompressBzip2|CompressGzip|CompressNone
     */

Missing @throws tag in function comment

    public static function create($c)

Expected 2 blank lines before function; 0 found

    {

Opening brace should be on the same line as the declaration

        $c = ucfirst(strtolower($c));
        if (!CompressMethod::isValid($c)) {

There must be a single space after a NOT operator; 0 found

            throw new Exception("Compression method ($c) is not defined yet");

As per coding-style, please use concatenation or sprintf for the variable $c instead of interpolation.

        }

        $method = __NAMESPACE__."\\"."Compress".$c;

The string literal \\ does not require double quotes, as per coding-style, please use single quotes.

The string literal Compress does not require double quotes, as per coding-style, please use single quotes.

        return new $method;
    }

Expected 2 blank lines after function; 0 found

Expected 1 blank line before closing function brace; 0 found

Expected //end create()

}

Expected //end class

class CompressBzip2 extends CompressManagerFactory

Only one interface or class is allowed in a file

Only one class is allowed in a file

Missing class doc comment

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class CompressBzip2

    private $fileHandler = null;

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

Private member variable "fileHandler" must contain a leading underscore

Private member variable "fileHandler" must be prefixed with an underscore

    public function __construct()

Missing function doc comment

Expected 2 blank lines before function; 1 found

    {

Opening brace should be on the same line as the declaration

        if (!function_exists("bzopen")) {

There must be a single space after a NOT operator; 0 found

The string literal bzopen does not require double quotes, as per coding-style, please use single quotes.

            throw new Exception("Compression is enabled, but bzip2 lib is not installed or configured properly");

This line exceeds maximum limit of 100 characters; contains 113 characters

The string literal Compression is enabled, but bzip2 lib is not installed or configured properly does not require double quotes, as per coding-style, please use single quotes.

        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end __construct()

    /**

Missing short description in doc comment

     * @param string $filename

Missing parameter comment

     */

Missing @throws tag in function comment

Missing @return tag in function comment

    public function open($filename)
    {

Opening brace should be on the same line as the declaration

        $this->fileHandler = bzopen($filename, "w");

The string literal w does not require double quotes, as per coding-style, please use single quotes.

        if (false === $this->fileHandler) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            throw new Exception("Output file is not writable");

The string literal Output file is not writable does not require double quotes, as per coding-style, please use single quotes.

        }

        return true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

    }

Expected 1 blank line before closing function brace; 0 found

Expected //end open()

Expected 2 blank lines after function; 1 found

    public function write($str)

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $bytesWritten = bzwrite($this->fileHandler, $str);
        if (false === $bytesWritten) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            throw new Exception("Writting to file failed! Probably, there is no more free space left?");

This line exceeds maximum limit of 100 characters; contains 104 characters

The string literal Writting to file failed! Probably, there is no more free space left? does not require double quotes, as per coding-style, please use single quotes.

        }

No blank line found after control structure

        return $bytesWritten;
    }

Expected //end write()

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

    public function close()

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return bzclose($this->fileHandler);
    }

Expected 2 blank lines after function; 0 found

Expected 1 blank line before closing function brace; 0 found

Expected //end close()

}

Expected //end class

class CompressGzip extends CompressManagerFactory

Class name doesn't match filename; expected "class Mysqldump"

Only one interface or class is allowed in a file

Only one class is allowed in a file

Missing class doc comment

{

Opening brace should be on the same line as the declaration for class CompressGzip

    private $fileHandler = null;

Private member variable "fileHandler" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Private member variable "fileHandler" must be prefixed with an underscore

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

    public function __construct()

Missing function doc comment

Expected 2 blank lines before function; 1 found

    {

Opening brace should be on the same line as the declaration

        if (!function_exists("gzopen")) {

There must be a single space after a NOT operator; 0 found

The string literal gzopen does not require double quotes, as per coding-style, please use single quotes.

            throw new Exception("Compression is enabled, but gzip lib is not installed or configured properly");

The string literal Compression is enabled, but gzip lib is not installed or configured properly does not require double quotes, as per coding-style, please use single quotes.

This line exceeds maximum limit of 100 characters; contains 112 characters

        }
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end __construct()

    /**

Missing short description in doc comment

     * @param string $filename

Missing parameter comment

     */

Missing @return tag in function comment

Missing @throws tag in function comment

    public function open($filename)
    {

Opening brace should be on the same line as the declaration

        $this->fileHandler = gzopen($filename, "wb");

The string literal wb does not require double quotes, as per coding-style, please use single quotes.

        if (false === $this->fileHandler) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            throw new Exception("Output file is not writable");

The string literal Output file is not writable does not require double quotes, as per coding-style, please use single quotes.

        }

        return true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

    }

Expected //end open()

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

    public function write($str)

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $bytesWritten = gzwrite($this->fileHandler, $str);
        if (false === $bytesWritten) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            throw new Exception("Writting to file failed! Probably, there is no more free space left?");

The string literal Writting to file failed! Probably, there is no more free space left? does not require double quotes, as per coding-style, please use single quotes.

This line exceeds maximum limit of 100 characters; contains 104 characters

        }

No blank line found after control structure

        return $bytesWritten;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end write()

    public function close()

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return gzclose($this->fileHandler);
    }

Expected 2 blank lines after function; 0 found

Expected 1 blank line before closing function brace; 0 found

Expected //end close()

}

Expected //end class

class CompressNone extends CompressManagerFactory

Only one interface or class is allowed in a file

Only one class is allowed in a file

Missing class doc comment

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class CompressNone

    private $fileHandler = null;

Missing member variable doc comment

Private member variable "fileHandler" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Private member variable "fileHandler" must be prefixed with an underscore

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

    /**

Missing short description in doc comment

     * @param string $filename

Missing parameter comment

     */

Missing @return tag in function comment

Missing @throws tag in function comment

    public function open($filename)

Expected 2 blank lines before function; 1 found

    {

Opening brace should be on the same line as the declaration

        $this->fileHandler = fopen($filename, "wb");

The string literal wb does not require double quotes, as per coding-style, please use single quotes.

        if (false === $this->fileHandler) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            throw new Exception("Output file is not writable");

The string literal Output file is not writable does not require double quotes, as per coding-style, please use single quotes.

        }

        return true;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

    }

Expected //end open()

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

    public function write($str)

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $bytesWritten = fwrite($this->fileHandler, $str);
        if (false === $bytesWritten) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            throw new Exception("Writting to file failed! Probably, there is no more free space left?");

This line exceeds maximum limit of 100 characters; contains 104 characters

The string literal Writting to file failed! Probably, there is no more free space left? does not require double quotes, as per coding-style, please use single quotes.

        }

No blank line found after control structure

        return $bytesWritten;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end write()

    public function close()

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return fclose($this->fileHandler);
    }

Expected //end close()

Expected 2 blank lines after function; 0 found

Expected 1 blank line before closing function brace; 0 found

}

Expected //end class

class CompressGzipstream extends CompressManagerFactory

Missing class doc comment

Only one interface or class is allowed in a file

Only one class is allowed in a file

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class CompressGzipstream

    private $fileHandler = null;

Missing member variable doc comment

Private member variable "fileHandler" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Private member variable "fileHandler" must be prefixed with an underscore

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

    private $compressContext;

Private member variable "compressContext" must be prefixed with an underscore

Private member variable "compressContext" must contain a leading underscore

Missing member variable doc comment

    /**

Missing short description in doc comment

     * @param string $filename

Missing parameter comment

     */

Missing @return tag in function comment

Missing @throws tag in function comment

    public function open($filename)

Expected 2 blank lines before function; 1 found

    {

Opening brace should be on the same line as the declaration

    $this->fileHandler = fopen($filename, "wb");

Line indented incorrectly; expected at least 8 spaces, found 4

The string literal wb does not require double quotes, as per coding-style, please use single quotes.

    if (false === $this->fileHandler) {

Line indented incorrectly; expected 8 spaces, found 4

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

        throw new Exception("Output file is not writable");

Line indented incorrectly; expected at least 12 spaces, found 8

The string literal Output file is not writable does not require double quotes, as per coding-style, please use single quotes.

    }

Line indented incorrectly; expected 8 spaces, found 4

    $this->compressContext = deflate_init(ZLIB_ENCODING_GZIP, array('level' => 9));

Line indented incorrectly; expected at least 8 spaces, found 4

Short array syntax must be used to define arrays

    return true;

Line indented incorrectly; expected at least 8 spaces, found 4

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of true please use TRUE.

    }

Expected 1 blank line before closing function brace; 0 found

Expected //end open()

Expected 2 blank lines after function; 1 found

    public function write($str)

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

Expected 0 blank lines after opening function brace; 1 found

    $bytesWritten = fwrite($this->fileHandler, deflate_add($this->compressContext, $str, ZLIB_NO_FLUSH));

Line indented incorrectly; expected at least 8 spaces, found 4

This line exceeds maximum limit of 100 characters; contains 105 characters

    if (false === $bytesWritten) {

Line indented incorrectly; expected 8 spaces, found 4

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

        throw new Exception("Writting to file failed! Probably, there is no more free space left?");

Line indented incorrectly; expected at least 12 spaces, found 8

The string literal Writting to file failed! Probably, there is no more free space left? does not require double quotes, as per coding-style, please use single quotes.

    }

No blank line found after control structure

Line indented incorrectly; expected 8 spaces, found 4

    return $bytesWritten;

Line indented incorrectly; expected at least 8 spaces, found 4

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end write()

    public function close()

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

    fwrite($this->fileHandler, deflate_add($this->compressContext, '', ZLIB_FINISH));

Line indented incorrectly; expected at least 8 spaces, found 4

    return fclose($this->fileHandler);

Line indented incorrectly; expected at least 8 spaces, found 4

    }

Expected 1 blank line before closing function brace; 0 found

Expected //end close()

Expected 2 blank lines after function; 0 found

}

Expected //end class

/**
 * Enum with all available TypeAdapter implementations
 *
 */

Additional blank lines found at end of doc comment

Missing @category tag in class comment

Missing @package tag in class comment

Missing @author tag in class comment

Missing @license tag in class comment

Missing @link tag in class comment

abstract class TypeAdapter

Class name doesn't match filename; expected "class Mysqldump"

Only one interface or class is allowed in a file

Only one class is allowed in a file

{

Opening brace should be on the same line as the declaration for class TypeAdapter

    public static $enums = array(

Missing member variable doc comment

Expected 1 blank line before member var; 0 found

Short array syntax must be used to define arrays

        "Sqlite",

This array value does not seem to be aligned correcty; expected 28 spaces, but found 8.

The string literal Sqlite does not require double quotes, as per coding-style, please use single quotes.

        "Mysql"

There should be a trailing comma after the last value of an array declaration.

The string literal Mysql does not require double quotes, as per coding-style, please use single quotes.

    );

The closing parenthesis does not seem to be aligned correctly; expected 27 space(s), but found 4.

    /**

Missing short description in doc comment

     * @param string $c

Missing parameter comment

     * @return boolean
     */
    public static function isValid($c)

Expected 2 blank lines before function; 1 found

    {

Opening brace should be on the same line as the declaration

        return in_array($c, self::$enums);
    }

Expected //end isValid()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 0 found

}

Expected //end class

/**
 * TypeAdapter Factory
 *
 */

Missing @category tag in class comment

Missing @package tag in class comment

Missing @author tag in class comment

Additional blank lines found at end of doc comment

Missing @link tag in class comment

Missing @license tag in class comment

abstract class TypeAdapterFactory

Only one interface or class is allowed in a file

Only one class is allowed in a file

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class TypeAdapterFactory

    protected $dbHandler = null;

Protected member variable "dbHandler" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

Equals sign not aligned with surrounding assignments; expected 4 spaces but found 1 space

    protected $dumpSettings = array();

Protected member variable "dumpSettings" must contain a leading underscore

Expected 1 blank line before member var; 0 found

Missing member variable doc comment

Short array syntax must be used to define arrays

    /**

Missing short description in doc comment

Parameter $dumpSettings should have a doc-comment as per coding-style.

     * @param string $c Type of database factory to create (Mysql, Sqlite,...)

Expected 9 spaces after parameter name; 1 found

Parameter comment must end with a full stop

     * @param PDO $dbHandler

Expected 4 spaces after parameter type; 1 found

Missing parameter comment

     */

Missing @throws tag in function comment

Missing @return tag in function comment

    public static function create($c, $dbHandler = null, $dumpSettings = array())

Expected 2 blank lines before function; 1 found

Type hint "PDO" missing for $dbHandler

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

Short array syntax must be used to define arrays

    {

Opening brace should be on the same line as the declaration

        $c = ucfirst(strtolower($c));
        if (!TypeAdapter::isValid($c)) {

There must be a single space after a NOT operator; 0 found

            throw new Exception("Database type support for ($c) not yet available");

As per coding-style, please use concatenation or sprintf for the variable $c instead of interpolation.

        }

No blank line found after control structure

        $method = __NAMESPACE__."\\"."TypeAdapter".$c;

The string literal \\ does not require double quotes, as per coding-style, please use single quotes.

The string literal TypeAdapter does not require double quotes, as per coding-style, please use single quotes.

        return new $method($dbHandler, $dumpSettings);
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end create()

    public function __construct($dbHandler = null, $dumpSettings = array())

Missing function doc comment

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

Short array syntax must be used to define arrays

    {

Opening brace should be on the same line as the declaration

        $this->dbHandler = $dbHandler;

Equals sign not aligned with surrounding assignments; expected 4 spaces but found 1 space

        $this->dumpSettings = $dumpSettings;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end __construct()

    /**
     * function databases Add sql to create and use database

Doc comment short description must start with a capital letter

     * @todo make it do something with sqlite

Comment refers to a TODO task

There must be exactly one blank line before the tags in a doc comment

     */

Missing @return tag in function comment

    public function databases()
    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end databases()

    public function show_create_table($tableName)

Public method name "TypeAdapterFactory::show_create_table" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "SELECT tbl_name as 'Table', sql as 'Create Table' ".

Concat operator must not be surrounded by spaces

            "FROM sqlite_master ".

The string literal FROM sqlite_master does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "WHERE type='table' AND tbl_name='$tableName'";

As per coding-style, please use concatenation or sprintf for the variable $tableName instead of interpolation.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_create_table()

    /**

Parameter $row should have a doc-comment as per coding-style.

     * function create_table Get table creation code from database

Doc comment short description must start with a capital letter

     * @todo make it do something with sqlite

Comment refers to a TODO task

There must be exactly one blank line before the tags in a doc comment

     */

Missing @return tag in function comment

    public function create_table($row)

Public method name "TypeAdapterFactory::create_table" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end create_table()

    public function show_create_view($viewName)

Public method name "TypeAdapterFactory::show_create_view" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "SELECT tbl_name as 'View', sql as 'Create View' ".

Concat operator must not be surrounded by spaces

            "FROM sqlite_master ".

The string literal FROM sqlite_master does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "WHERE type='view' AND tbl_name='$viewName'";

As per coding-style, please use concatenation or sprintf for the variable $viewName instead of interpolation.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_create_view()

    /**

Parameter $row should have a doc-comment as per coding-style.

     * function create_view Get view creation code from database

Doc comment short description must start with a capital letter

     * @todo make it do something with sqlite

There must be exactly one blank line before the tags in a doc comment

Comment refers to a TODO task

     */

Missing @return tag in function comment

    public function create_view($row)

Public method name "TypeAdapterFactory::create_view" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

Expected //end create_view()

    /**

Parameter $triggerName should have a doc-comment as per coding-style.

     * function show_create_trigger Get trigger creation code from database

Doc comment short description must start with a capital letter

     * @todo make it do something with sqlite

Comment refers to a TODO task

There must be exactly one blank line before the tags in a doc comment

     */

Missing @return tag in function comment

    public function show_create_trigger($triggerName)

Public method name "TypeAdapterFactory::show_create_trigger" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_create_trigger()

    /**

Parameter $triggerName should have a doc-comment as per coding-style.

     * function create_trigger Modify trigger code, add delimiters, etc

Doc comment short description must start with a capital letter

     * @todo make it do something with sqlite

Comment refers to a TODO task

There must be exactly one blank line before the tags in a doc comment

     */

Missing @return tag in function comment

    public function create_trigger($triggerName)

Public method name "TypeAdapterFactory::create_trigger" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected //end create_trigger()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    /**

Parameter $procedureName should have a doc-comment as per coding-style.

     * function create_procedure Modify procedure code, add delimiters, etc

Doc comment short description must start with a capital letter

     * @todo make it do something with sqlite

Comment refers to a TODO task

There must be exactly one blank line before the tags in a doc comment

     */

Missing @return tag in function comment

    public function create_procedure($procedureName)

Public method name "TypeAdapterFactory::create_procedure" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected //end create_procedure()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    /**

Parameter $functionName should have a doc-comment as per coding-style.

     * function create_function Modify function code, add delimiters, etc

Doc comment short description must start with a capital letter

     * @todo make it do something with sqlite

Comment refers to a TODO task

There must be exactly one blank line before the tags in a doc comment

     */

Missing @return tag in function comment

    public function create_function($functionName)

Public method name "TypeAdapterFactory::create_function" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected //end create_function()

Expected 1 blank line before closing function brace; 0 found

    public function show_tables()

Missing function doc comment

Public method name "TypeAdapterFactory::show_tables" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "SELECT tbl_name FROM sqlite_master WHERE type='table'";
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_tables()

    public function show_views()

Public method name "TypeAdapterFactory::show_views" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "SELECT tbl_name FROM sqlite_master WHERE type='view'";
    }

Expected 2 blank lines after function; 1 found

Expected //end show_views()

Expected 1 blank line before closing function brace; 0 found

    public function show_triggers()

Missing function doc comment

Public method name "TypeAdapterFactory::show_triggers" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "SELECT name FROM sqlite_master WHERE type='trigger'";
    }

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

Expected //end show_triggers()

    public function show_columns()

Public method name "TypeAdapterFactory::show_columns" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        if (func_num_args() != 1) {

Operator != prohibited; use !== instead

            return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

        }

        $args = func_get_args();

        return "pragma table_info(${args[0]})";
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_columns()

    public function show_procedures()

Missing function doc comment

Public method name "TypeAdapterFactory::show_procedures" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_procedures()

    public function show_functions()

Public method name "TypeAdapterFactory::show_functions" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected //end show_functions()

Expected 1 blank line before closing function brace; 0 found

    public function show_events()

Public method name "TypeAdapterFactory::show_events" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

Expected //end show_events()

    public function setup_transaction()

Missing function doc comment

Public method name "TypeAdapterFactory::setup_transaction" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end setup_transaction()

    public function start_transaction()

Public method name "TypeAdapterFactory::start_transaction" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "BEGIN EXCLUSIVE";

The string literal BEGIN EXCLUSIVE does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end start_transaction()

    public function commit_transaction()

Missing function doc comment

Public method name "TypeAdapterFactory::commit_transaction" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "COMMIT";

The string literal COMMIT does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end commit_transaction()

    public function lock_table()

Missing function doc comment

Public method name "TypeAdapterFactory::lock_table" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end lock_table()

    public function unlock_table()

Missing function doc comment

Public method name "TypeAdapterFactory::unlock_table" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

    }

Expected //end unlock_table()

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

    public function start_add_lock_table()

Public method name "TypeAdapterFactory::start_add_lock_table" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end start_add_lock_table()

    public function end_add_lock_table()

Public method name "TypeAdapterFactory::end_add_lock_table" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected //end end_add_lock_table()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    public function start_add_disable_keys()

Missing function doc comment

Public method name "TypeAdapterFactory::start_add_disable_keys" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end start_add_disable_keys()

    public function end_add_disable_keys()

Missing function doc comment

Public method name "TypeAdapterFactory::end_add_disable_keys" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end end_add_disable_keys()

    public function start_disable_foreign_keys_check()

Public method name "TypeAdapterFactory::start_disable_foreign_keys_check" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end start_disable_foreign_keys_check()

    public function end_disable_foreign_keys_check()

Missing function doc comment

Public method name "TypeAdapterFactory::end_disable_foreign_keys_check" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected //end end_disable_foreign_keys_check()

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

    public function add_drop_database()

Public method name "TypeAdapterFactory::add_drop_database" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end add_drop_database()

    public function add_drop_trigger()

Public method name "TypeAdapterFactory::add_drop_trigger" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end add_drop_trigger()

    public function drop_table()

Public method name "TypeAdapterFactory::drop_table" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end drop_table()

Expected 2 blank lines after function; 1 found

    public function drop_view()

Missing function doc comment

Public method name "TypeAdapterFactory::drop_view" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end drop_view()

    /**
     * Decode column metadata and fill info structure.
     * type, is_numeric and is_blob will always be available.
     *
     * @param array $colType Array returned from "SHOW COLUMNS FROM tableName"

Tag value indented incorrectly; expected 2 spaces but found 1

Parameter comment must end with a full stop

     * @return array

Tag cannot be grouped with parameter tags in a doc comment

     */
    public function parseColumnType($colType)

The method parameter $colType is never used

Type hint "array" missing for $colType

    {

Opening brace should be on the same line as the declaration

        return array();

Short array syntax must be used to define arrays

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end parseColumnType()

    public function backup_parameters()

Public method name "TypeAdapterFactory::backup_parameters" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end backup_parameters()

Expected 2 blank lines after function; 1 found

    public function restore_parameters()

Public method name "TypeAdapterFactory::restore_parameters" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return PHP_EOL;
    }

Expected 2 blank lines after function; 0 found

Expected 1 blank line before closing function brace; 0 found

Expected //end restore_parameters()

}

Expected //end class

class TypeAdapterPgsql extends TypeAdapterFactory

Only one interface or class is allowed in a file

Only one class is allowed in a file

Missing class doc comment

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class TypeAdapterPgsql

}

Expected //end class

class TypeAdapterDblib extends TypeAdapterFactory

Only one interface or class is allowed in a file

Only one class is allowed in a file

Missing class doc comment

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class TypeAdapterDblib

}

Expected //end class

class TypeAdapterSqlite extends TypeAdapterFactory

Only one interface or class is allowed in a file

Only one class is allowed in a file

Missing class doc comment

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class TypeAdapterSqlite

}

Expected //end class

class TypeAdapterMysql extends TypeAdapterFactory

Only one class is allowed in a file

Only one interface or class is allowed in a file

Missing class doc comment

Class name doesn't match filename; expected "class Mysqldump"

{

Opening brace should be on the same line as the declaration for class TypeAdapterMysql

    const DEFINER_RE = 'DEFINER=`(?:[^`]|``)*`@`(?:[^`]|``)*`';


    // Numerical Mysql types

Inline comments must end in full-stops, exclamation marks, or question marks

    public $mysqlTypes = array(

Expected 1 blank line before member var; 2 found

You must use "/**" style comments for a member variable comment

Short array syntax must be used to define arrays

        'numerical' => array(

Short array syntax must be used to define arrays

This array key does not seem to be aligned correctly; expected 26 spaces, but found 8.

            'bit',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'tinyint',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'smallint',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'mediumint',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'int',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'integer',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'bigint',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'real',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'double',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'float',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'decimal',

This array value does not seem to be aligned correcty; expected 24 spaces, but found 12.

            'numeric'

There should be a trailing comma after the last value of an array declaration.

        ),

The closing parenthesis does not seem to be aligned correctly; expected 23 space(s), but found 8.

        'blob' => array(

This array key does not seem to be aligned correctly; expected 26 spaces, but found 8.

Short array syntax must be used to define arrays

            'tinyblob',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'blob',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'mediumblob',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'longblob',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'binary',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'varbinary',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'bit',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'geometry', /* http://bugs.mysql.com/bug.php?id=43544 */

Single line block comment not allowed; use inline ("// text") comment instead

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'point',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'linestring',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'polygon',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'multipoint',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'multilinestring',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'multipolygon',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

            'geometrycollection',

This array value does not seem to be aligned correcty; expected 19 spaces, but found 12.

        )

The closing parenthesis does not seem to be aligned correctly; expected 18 space(s), but found 8.

    );

The closing parenthesis does not seem to be aligned correctly; expected 25 space(s), but found 4.

    public function databases()

Missing function doc comment

Expected 2 blank lines before function; 1 found

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        $databaseName = $args[0];

Equals sign not aligned with surrounding assignments; expected 47 spaces but found 1 space

        $resultSet = $this->dbHandler->query("SHOW VARIABLES LIKE 'character_set_database';");

Equals sign not aligned with surrounding assignments; expected 4 spaces but found 1 space

        $characterSet = $resultSet->fetchColumn(1);
        $resultSet->closeCursor();

        $resultSet = $this->dbHandler->query("SHOW VARIABLES LIKE 'collation_database';");

Equals sign not aligned with surrounding assignments; expected 3 spaces but found 1 space

        $collationDb = $resultSet->fetchColumn(1);
        $resultSet->closeCursor();
        $ret = "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

        $ret .= "CREATE DATABASE /*!32312 IF NOT EXISTS*/ `${databaseName}`".

Concat operator must not be surrounded by spaces

            " /*!40100 DEFAULT CHARACTER SET ${characterSet} ".

Concat operator must not be surrounded by spaces

            " COLLATE ${collationDb} */;".PHP_EOL.PHP_EOL.

Concat operator must not be surrounded by spaces

            "USE `${databaseName}`;".PHP_EOL.PHP_EOL;

        return $ret;
    }

Expected //end databases()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    public function show_create_table($tableName)

Missing function doc comment

Public method name "TypeAdapterMysql::show_create_table" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "SHOW CREATE TABLE `$tableName`";

As per coding-style, please use concatenation or sprintf for the variable $tableName instead of interpolation.

    }

Expected //end show_create_table()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    public function show_create_view($viewName)

Missing function doc comment

Public method name "TypeAdapterMysql::show_create_view" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "SHOW CREATE VIEW `$viewName`";

As per coding-style, please use concatenation or sprintf for the variable $viewName instead of interpolation.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_create_view()

    public function show_create_trigger($triggerName)

Public method name "TypeAdapterMysql::show_create_trigger" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "SHOW CREATE TRIGGER `$triggerName`";

As per coding-style, please use concatenation or sprintf for the variable $triggerName instead of interpolation.

    }

Expected //end show_create_trigger()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    public function show_create_procedure($procedureName)

Public method name "TypeAdapterMysql::show_create_procedure" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "SHOW CREATE PROCEDURE `$procedureName`";

As per coding-style, please use concatenation or sprintf for the variable $procedureName instead of interpolation.

    }

Expected //end show_create_procedure()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    public function show_create_function($functionName)

Missing function doc comment

Public method name "TypeAdapterMysql::show_create_function" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "SHOW CREATE FUNCTION `$functionName`";

As per coding-style, please use concatenation or sprintf for the variable $functionName instead of interpolation.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_create_function()

    public function show_create_event($eventName)

Public method name "TypeAdapterMysql::show_create_event" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "SHOW CREATE EVENT `$eventName`";

As per coding-style, please use concatenation or sprintf for the variable $eventName instead of interpolation.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_create_event()

    public function create_table($row)

Public method name "TypeAdapterMysql::create_table" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        if (!isset($row['Create Table'])) {

There must be a single space after a NOT operator; 0 found

            throw new Exception("Error getting table code, unknown output");

The string literal Error getting table code, unknown output does not require double quotes, as per coding-style, please use single quotes.

        }

        $createTable = $row['Create Table'];
        if ($this->dumpSettings['reset-auto-increment']) {
            $match = "/AUTO_INCREMENT=[0-9]+/s";

Equals sign not aligned with surrounding assignments; expected 7 spaces but found 1 space

The string literal /AUTO_INCREMENT=[0-9]+/s does not require double quotes, as per coding-style, please use single quotes.

            $replace = "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

Equals sign not aligned with surrounding assignments; expected 5 spaces but found 1 space

            $createTable = preg_replace($match, $replace, $createTable);
        }
        
		if ($this->dumpSettings['if-not-exists'] ) {

Line indented incorrectly; expected 8 spaces, found 2

Expected 0 spaces before closing bracket; 1 found

			$createTable = preg_replace('/^CREATE TABLE/', 'CREATE TABLE IF NOT EXISTS', $createTable);

Line indented incorrectly; expected at least 12 spaces, found 3

        }        

Closing brace indented incorrectly; expected 2 spaces, found 8

        $ret = "/*!40101 SET @saved_cs_client     = @@character_set_client */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40101 SET @saved_cs_client = @@character_set_client */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40101 SET character_set_client = ".$this->dumpSettings['default-character-set']." */;".PHP_EOL.

The string literal /*!40101 SET character_set_client = does not require double quotes, as per coding-style, please use single quotes.

The string literal */; does not require double quotes, as per coding-style, please use single quotes.

This line exceeds maximum limit of 100 characters; contains 111 characters

Concat operator must not be surrounded by spaces

            $createTable.";".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40101 SET character_set_client = @saved_cs_client */;".PHP_EOL.

The string literal /*!40101 SET character_set_client = @saved_cs_client */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            PHP_EOL;
        return $ret;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end create_table()

    public function create_view($row)

Missing function doc comment

Public method name "TypeAdapterMysql::create_view" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        $ret = "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

        if (!isset($row['Create View'])) {

There must be a single space after a NOT operator; 0 found

            throw new Exception("Error getting view structure, unknown output");

The string literal Error getting view structure, unknown output does not require double quotes, as per coding-style, please use single quotes.

        }

        $viewStmt = $row['Create View'];

        $definerStr = $this->dumpSettings['skip-definer'] ? '' : '/*!50013 \2 */'.PHP_EOL;

Inline shorthand IF statement requires brackets around comparison

The value of a comparison must not be assigned to a variable

Inline IF statements are not allowed

        if ($viewStmtReplaced = preg_replace(

Assignments must be the first block of code on a line

            '/^(CREATE(?:\s+ALGORITHM=(?:UNDEFINED|MERGE|TEMPTABLE))?)\s+('
            .self::DEFINER_RE.'(?:\s+SQL SECURITY DEFINER|INVOKER)?)?\s+(VIEW .+)$/',

Concat operator must not be surrounded by spaces

            '/*!50001 \1 */'.PHP_EOL.$definerStr.'/*!50001 \3 */',
            $viewStmt,
            1
        )) {

Closing parenthesis of a multi-line IF statement must be on a new line

            $viewStmt = $viewStmtReplaced;
        };

        $ret .= $viewStmt.';'.PHP_EOL.PHP_EOL;
        return $ret;
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end create_view()

Expected 2 blank lines after function; 1 found

    public function create_trigger($row)

Public method name "TypeAdapterMysql::create_trigger" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $ret = "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

        if (!isset($row['SQL Original Statement'])) {

There must be a single space after a NOT operator; 0 found

            throw new Exception("Error getting trigger code, unknown output");

The string literal Error getting trigger code, unknown output does not require double quotes, as per coding-style, please use single quotes.

        }

        $triggerStmt = $row['SQL Original Statement'];
        $definerStr = $this->dumpSettings['skip-definer'] ? '' : '/*!50017 \2*/ ';

Equals sign not aligned with surrounding assignments; expected 2 spaces but found 1 space

The value of a comparison must not be assigned to a variable

Inline IF statements are not allowed

Inline shorthand IF statement requires brackets around comparison

        if ($triggerStmtReplaced = preg_replace(

Assignments must be the first block of code on a line

            '/^(CREATE)\s+('.self::DEFINER_RE.')?\s+(TRIGGER\s.*)$/s',
            '/*!50003 \1*/ '.$definerStr.'/*!50003 \3 */',
            $triggerStmt,
            1
        )) {

Closing parenthesis of a multi-line IF statement must be on a new line

            $triggerStmt = $triggerStmtReplaced;
        }

        $ret .= "DELIMITER ;;".PHP_EOL.

The string literal DELIMITER ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            $triggerStmt.";;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal ;; does not require double quotes, as per coding-style, please use single quotes.

            "DELIMITER ;".PHP_EOL.PHP_EOL;

The string literal DELIMITER ; does not require double quotes, as per coding-style, please use single quotes.

        return $ret;
    }

Expected 2 blank lines after function; 1 found

Expected //end create_trigger()

Expected 1 blank line before closing function brace; 0 found

    public function create_procedure($row)

Public method name "TypeAdapterMysql::create_procedure" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $ret = "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

        if (!isset($row['Create Procedure'])) {

There must be a single space after a NOT operator; 0 found

            throw new Exception("Error getting procedure code, unknown output. ".

The opening parenthesis of a multi-line function call should be the last content on the line.

The string literal Error getting procedure code, unknown output. does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

                "Please check 'https://bugs.mysql.com/bug.php?id=14564'");

This line of the multi-line function call does not seem to be indented correctly. Expected 12 spaces, but found 16.

For multi-line function calls, the closing parenthesis should be on a new line.

        }

No blank line found after control structure

        $procedureStmt = $row['Create Procedure'];
        if ($this->dumpSettings['skip-definer']) {
            if ($procedureStmtReplaced = preg_replace(

Assignments must be the first block of code on a line

                '/^(CREATE)\s+('.self::DEFINER_RE.')?\s+(PROCEDURE\s.*)$/s',
                '\1 \3',
                $procedureStmt,
                1
            )) {

Closing parenthesis of a multi-line IF statement must be on a new line

                $procedureStmt = $procedureStmtReplaced;
            }
        }

        $ret .= "/*!50003 DROP PROCEDURE IF EXISTS `".

Concat operator must not be surrounded by spaces

The string literal /*!50003 DROP PROCEDURE IF EXISTS ` does not require double quotes, as per coding-style, please use single quotes.

            $row['Procedure']."` */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal ` */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40101 SET @saved_cs_client     = @@character_set_client */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40101 SET @saved_cs_client = @@character_set_client */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40101 SET character_set_client = ".$this->dumpSettings['default-character-set']." */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40101 SET character_set_client = does not require double quotes, as per coding-style, please use single quotes.

The string literal */; does not require double quotes, as per coding-style, please use single quotes.

This line exceeds maximum limit of 100 characters; contains 111 characters

            "DELIMITER ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal DELIMITER ;; does not require double quotes, as per coding-style, please use single quotes.

            $procedureStmt." ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal ;; does not require double quotes, as per coding-style, please use single quotes.

            "DELIMITER ;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal DELIMITER ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40101 SET character_set_client = @saved_cs_client */;".PHP_EOL.PHP_EOL;

The string literal /*!40101 SET character_set_client = @saved_cs_client */; does not require double quotes, as per coding-style, please use single quotes.

        return $ret;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end create_procedure()

    public function create_function($row)

Public method name "TypeAdapterMysql::create_function" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $ret = "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

        if (!isset($row['Create Function'])) {

There must be a single space after a NOT operator; 0 found

            throw new Exception("Error getting function code, unknown output. ".

The string literal Error getting function code, unknown output. does not require double quotes, as per coding-style, please use single quotes.

The opening parenthesis of a multi-line function call should be the last content on the line.

Concat operator must not be surrounded by spaces

                "Please check 'https://bugs.mysql.com/bug.php?id=14564'");

This line of the multi-line function call does not seem to be indented correctly. Expected 12 spaces, but found 16.

For multi-line function calls, the closing parenthesis should be on a new line.

        }

No blank line found after control structure

        $functionStmt = $row['Create Function'];

Equals sign not aligned with surrounding assignments; expected 8 spaces but found 1 space

        $characterSetClient = $row['character_set_client'];

Equals sign not aligned with surrounding assignments; expected 2 spaces but found 1 space

        $collationConnection = $row['collation_connection'];
        $sqlMode = $row['sql_mode'];

Equals sign not aligned with surrounding assignments; expected 13 spaces but found 1 space

        if ( $this->dumpSettings['skip-definer'] ) {

Expected 0 spaces after opening bracket; 1 found

First condition of a multi-line IF statement must directly follow the opening parenthesis

Expected 0 spaces before closing bracket; 1 found

            if ($functionStmtReplaced = preg_replace(

Assignments must be the first block of code on a line

                '/^(CREATE)\s+('.self::DEFINER_RE.')?\s+(FUNCTION\s.*)$/s',
                '\1 \3',
                $functionStmt,
                1
            )) {

Closing parenthesis of a multi-line IF statement must be on a new line

                $functionStmt = $functionStmtReplaced;
            }
        }

        $ret .= "/*!50003 DROP FUNCTION IF EXISTS `".

The string literal /*!50003 DROP FUNCTION IF EXISTS ` does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            $row['Function']."` */;".PHP_EOL.

The string literal ` */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!40101 SET @saved_cs_client     = @@character_set_client */;".PHP_EOL.

The string literal /*!40101 SET @saved_cs_client = @@character_set_client */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET @saved_cs_results     = @@character_set_results */ ;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET @saved_cs_results = @@character_set_results */ ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET @saved_col_connection = @@collation_connection */ ;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET @saved_col_connection = @@collation_connection */ ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40101 SET character_set_client = ".$characterSetClient." */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40101 SET character_set_client = does not require double quotes, as per coding-style, please use single quotes.

The string literal */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40101 SET character_set_results = ".$characterSetClient." */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40101 SET character_set_results = does not require double quotes, as per coding-style, please use single quotes.

The string literal */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET collation_connection  = ".$collationConnection." */ ;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET collation_connection = does not require double quotes, as per coding-style, please use single quotes.

The string literal */ ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET @saved_sql_mode = @@sql_mode */ ;; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET sql_mode              = '".$sqlMode."' */ ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

            "/*!50003 SET @saved_time_zone      = @@time_zone */ ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET @saved_time_zone = @@time_zone */ ;; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET time_zone             = 'SYSTEM' */ ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

            "DELIMITER ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal DELIMITER ;; does not require double quotes, as per coding-style, please use single quotes.

            $functionStmt." ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal ;; does not require double quotes, as per coding-style, please use single quotes.

            "DELIMITER ;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal DELIMITER ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET sql_mode              = @saved_sql_mode */ ;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET sql_mode = @saved_sql_mode */ ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET character_set_client  = @saved_cs_client */ ;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET character_set_client = @saved_cs_client */ ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET character_set_results = @saved_cs_results */ ;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET character_set_results = @saved_cs_results */ ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET collation_connection  = @saved_col_connection */ ;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET collation_connection = @saved_col_connection */ ; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50106 SET TIME_ZONE= @saved_time_zone */ ;".PHP_EOL.PHP_EOL;

The string literal /*!50106 SET TIME_ZONE= @saved_time_zone */ ; does not require double quotes, as per coding-style, please use single quotes.

Functions must not contain multiple empty lines in a row; found 2 empty lines

        return $ret;
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end create_function()

Expected 2 blank lines after function; 1 found

    public function create_event($row)

Missing function doc comment

Public method name "TypeAdapterMysql::create_event" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        $ret = "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

        if (!isset($row['Create Event'])) {

There must be a single space after a NOT operator; 0 found

            throw new Exception("Error getting event code, unknown output. ".

Concat operator must not be surrounded by spaces

The opening parenthesis of a multi-line function call should be the last content on the line.

The string literal Error getting event code, unknown output. does not require double quotes, as per coding-style, please use single quotes.

                "Please check 'http://stackoverflow.com/questions/10853826/mysql-5-5-create-event-gives-syntax-error'");

This line of the multi-line function call does not seem to be indented correctly. Expected 12 spaces, but found 16.

For multi-line function calls, the closing parenthesis should be on a new line.

This line exceeds maximum limit of 100 characters; contains 120 characters

        }

No blank line found after control structure

        $eventName = $row['Event'];

Equals sign not aligned with surrounding assignments; expected 2 spaces but found 1 space

        $eventStmt = $row['Create Event'];

Equals sign not aligned with surrounding assignments; expected 2 spaces but found 1 space

        $sqlMode = $row['sql_mode'];

Equals sign not aligned with surrounding assignments; expected 4 spaces but found 1 space

        $definerStr = $this->dumpSettings['skip-definer'] ? '' : '/*!50117 \2*/ ';

Inline IF statements are not allowed

The value of a comparison must not be assigned to a variable

Inline shorthand IF statement requires brackets around comparison

        if ($eventStmtReplaced = preg_replace(

Assignments must be the first block of code on a line

            '/^(CREATE)\s+('.self::DEFINER_RE.')?\s+(EVENT .*)$/',
            '/*!50106 \1*/ '.$definerStr.'/*!50106 \3 */',
            $eventStmt,
            1
        )) {

Closing parenthesis of a multi-line IF statement must be on a new line

            $eventStmt = $eventStmtReplaced;
        }

        $ret .= "/*!50106 SET @save_time_zone= @@TIME_ZONE */ ;".PHP_EOL.

The string literal /*!50106 SET @save_time_zone= @@TIME_ZONE */ ; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50106 DROP EVENT IF EXISTS `".$eventName."` */;".PHP_EOL.

The string literal ` */; does not require double quotes, as per coding-style, please use single quotes.

The string literal /*!50106 DROP EVENT IF EXISTS ` does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "DELIMITER ;;".PHP_EOL.

The string literal DELIMITER ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET @saved_cs_client      = @@character_set_client */ ;;".PHP_EOL.

The string literal /*!50003 SET @saved_cs_client = @@character_set_client */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET @saved_cs_results     = @@character_set_results */ ;;".PHP_EOL.

The string literal /*!50003 SET @saved_cs_results = @@character_set_results */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET @saved_col_connection = @@collation_connection */ ;;".PHP_EOL.

The string literal /*!50003 SET @saved_col_connection = @@collation_connection */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET character_set_client  = utf8 */ ;;".PHP_EOL.

The string literal /*!50003 SET character_set_client = utf8 */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET character_set_results = utf8 */ ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET character_set_results = utf8 */ ;; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET collation_connection  = utf8_general_ci */ ;;".PHP_EOL.

The string literal /*!50003 SET collation_connection = utf8_general_ci */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;;".PHP_EOL.

The string literal /*!50003 SET @saved_sql_mode = @@sql_mode */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET sql_mode              = '".$sqlMode."' */ ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

            "/*!50003 SET @saved_time_zone      = @@time_zone */ ;;".PHP_EOL.

The string literal /*!50003 SET @saved_time_zone = @@time_zone */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET time_zone             = 'SYSTEM' */ ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

            $eventStmt." ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal ;; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET time_zone             = @saved_time_zone */ ;;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!50003 SET time_zone = @saved_time_zone */ ;; does not require double quotes, as per coding-style, please use single quotes.

            "/*!50003 SET sql_mode              = @saved_sql_mode */ ;;".PHP_EOL.

The string literal /*!50003 SET sql_mode = @saved_sql_mode */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET character_set_client  = @saved_cs_client */ ;;".PHP_EOL.

The string literal /*!50003 SET character_set_client = @saved_cs_client */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET character_set_results = @saved_cs_results */ ;;".PHP_EOL.

The string literal /*!50003 SET character_set_results = @saved_cs_results */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50003 SET collation_connection  = @saved_col_connection */ ;;".PHP_EOL.

The string literal /*!50003 SET collation_connection = @saved_col_connection */ ;; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "DELIMITER ;".PHP_EOL.

The string literal DELIMITER ; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!50106 SET TIME_ZONE= @save_time_zone */ ;".PHP_EOL.PHP_EOL;

The string literal /*!50106 SET TIME_ZONE= @save_time_zone */ ; does not require double quotes, as per coding-style, please use single quotes.

            // Commented because we are doing this in restore_parameters()
            // "/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;" . PHP_EOL . PHP_EOL;

Inline comments must end in full-stops, exclamation marks, or question marks

There should be no blank line after an inline comment.

        return $ret;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end create_event()

    public function show_tables()

Public method name "TypeAdapterMysql::show_tables" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "SELECT TABLE_NAME AS tbl_name ".

Concat operator must not be surrounded by spaces

The string literal SELECT TABLE_NAME AS tbl_name does not require double quotes, as per coding-style, please use single quotes.

            "FROM INFORMATION_SCHEMA.TABLES ".

The string literal FROM INFORMATION_SCHEMA.TABLES does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA='${args[0]}'";
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_tables()

    public function show_views()

Missing function doc comment

Public method name "TypeAdapterMysql::show_views" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Assignments must be the first block of code on a line

Variable "expected_num_args" is not in valid camel caps format

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "SELECT TABLE_NAME AS tbl_name ".

The string literal SELECT TABLE_NAME AS tbl_name does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "FROM INFORMATION_SCHEMA.TABLES ".

The string literal FROM INFORMATION_SCHEMA.TABLES does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "WHERE TABLE_TYPE='VIEW' AND TABLE_SCHEMA='${args[0]}'";
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_views()

    public function show_triggers()

Public method name "TypeAdapterMysql::show_triggers" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "SHOW TRIGGERS FROM `${args[0]}`;";
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_triggers()

    public function show_columns()

Missing function doc comment

Public method name "TypeAdapterMysql::show_columns" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Assignments must be the first block of code on a line

Variable "expected_num_args" is not in valid camel caps format

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "SHOW COLUMNS FROM `${args[0]}`;";
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end show_columns()

Expected 2 blank lines after function; 1 found

    public function show_procedures()

Public method name "TypeAdapterMysql::show_procedures" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Assignments must be the first block of code on a line

Variable "expected_num_args" is not in valid camel caps format

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "SELECT SPECIFIC_NAME AS procedure_name ".

Concat operator must not be surrounded by spaces

The string literal SELECT SPECIFIC_NAME AS procedure_name does not require double quotes, as per coding-style, please use single quotes.

            "FROM INFORMATION_SCHEMA.ROUTINES ".

The string literal FROM INFORMATION_SCHEMA.ROUTINES does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "WHERE ROUTINE_TYPE='PROCEDURE' AND ROUTINE_SCHEMA='${args[0]}'";
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_procedures()

    public function show_functions()

Public method name "TypeAdapterMysql::show_functions" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "SELECT SPECIFIC_NAME AS function_name ".

The string literal SELECT SPECIFIC_NAME AS function_name does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "FROM INFORMATION_SCHEMA.ROUTINES ".

The string literal FROM INFORMATION_SCHEMA.ROUTINES does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "WHERE ROUTINE_TYPE='FUNCTION' AND ROUTINE_SCHEMA='${args[0]}'";
    }

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

Expected //end show_functions()

    /**
     * Get query string to ask for names of events from current database.
     *
     * @param string Name of database

The type Ifsnop\Mysqldump\Name was not found. Maybe you did not declare it correctly or list all dependencies?

Missing parameter name

Tag value indented incorrectly; expected 2 spaces but found 1

     * @return string

Tag cannot be grouped with parameter tags in a doc comment

     */
    public function show_events()

Public method name "TypeAdapterMysql::show_events" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "SELECT EVENT_NAME AS event_name ".

The string literal SELECT EVENT_NAME AS event_name does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "FROM INFORMATION_SCHEMA.EVENTS ".

The string literal FROM INFORMATION_SCHEMA.EVENTS does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "WHERE EVENT_SCHEMA='${args[0]}'";
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end show_events()

    public function setup_transaction()

Missing function doc comment

Public method name "TypeAdapterMysql::setup_transaction" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return "SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ";

The string literal SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

Expected //end setup_transaction()

    public function start_transaction()

Public method name "TypeAdapterMysql::start_transaction" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "START TRANSACTION ".

The string literal START TRANSACTION does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!40100 WITH CONSISTENT SNAPSHOT */";

The string literal /*!40100 WITH CONSISTENT SNAPSHOT */ does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 1 blank line before closing function brace; 0 found

Expected //end start_transaction()

    public function commit_transaction()

Public method name "TypeAdapterMysql::commit_transaction" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "COMMIT";

The string literal COMMIT does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end commit_transaction()

    public function lock_table()

Public method name "TypeAdapterMysql::lock_table" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Assignments must be the first block of code on a line

Variable "expected_num_args" is not in valid camel caps format

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return $this->dbHandler->exec("LOCK TABLES `${args[0]}` READ LOCAL");
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end lock_table()

    public function unlock_table()

Missing function doc comment

Public method name "TypeAdapterMysql::unlock_table" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        return $this->dbHandler->exec("UNLOCK TABLES");

The string literal UNLOCK TABLES does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end unlock_table()

    public function start_add_lock_table()

Missing function doc comment

Public method name "TypeAdapterMysql::start_add_lock_table" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "LOCK TABLES `${args[0]}` WRITE;".PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end start_add_lock_table()

    public function end_add_lock_table()

Public method name "TypeAdapterMysql::end_add_lock_table" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "UNLOCK TABLES;".PHP_EOL;

The string literal UNLOCK TABLES; does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end end_add_lock_table()

    public function start_add_disable_keys()

Public method name "TypeAdapterMysql::start_add_disable_keys" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "/*!40000 ALTER TABLE `${args[0]}` DISABLE KEYS */;".

Concat operator must not be surrounded by spaces

            PHP_EOL;
    }

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

Expected //end start_add_disable_keys()

    public function end_add_disable_keys()

Missing function doc comment

Public method name "TypeAdapterMysql::end_add_disable_keys" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "/*!40000 ALTER TABLE `${args[0]}` ENABLE KEYS */;".

Concat operator must not be surrounded by spaces

            PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end end_add_disable_keys()

    public function start_disable_autocommit()

Public method name "TypeAdapterMysql::start_disable_autocommit" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "SET autocommit=0;".PHP_EOL;

The string literal SET autocommit=0; does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end start_disable_autocommit()

    public function end_disable_autocommit()

Public method name "TypeAdapterMysql::end_disable_autocommit" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        return "COMMIT;".PHP_EOL;

The string literal COMMIT; does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end end_disable_autocommit()

    public function add_drop_database()

Public method name "TypeAdapterMysql::add_drop_database" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "/*!40000 DROP DATABASE IF EXISTS `${args[0]}`*/;".

Concat operator must not be surrounded by spaces

            PHP_EOL.PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end add_drop_database()

    public function add_drop_trigger()

Missing function doc comment

Public method name "TypeAdapterMysql::add_drop_trigger" is not in camel caps format

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Assignments must be the first block of code on a line

Variable "expected_num_args" is not in valid camel caps format

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "DROP TRIGGER IF EXISTS `${args[0]}`;".PHP_EOL;
    }

Expected //end add_drop_trigger()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

    public function drop_table()

Public method name "TypeAdapterMysql::drop_table" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "DROP TABLE IF EXISTS `${args[0]}`;".PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected //end drop_table()

Expected 1 blank line before closing function brace; 0 found

    public function drop_view()

Public method name "TypeAdapterMysql::drop_view" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "DROP TABLE IF EXISTS `${args[0]}`;".PHP_EOL.

Concat operator must not be surrounded by spaces

                "/*!50001 DROP VIEW IF EXISTS `${args[0]}`*/;".PHP_EOL;
    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end drop_view()

    public function getDatabaseHeader()

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

Variable "expected_num_args" is not in valid camel caps format

Assignments must be the first block of code on a line

        $args = func_get_args();

Equals sign not aligned with surrounding assignments; expected 55 spaces but found 1 space

        return "--".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

            "-- Current Database: `${args[0]}`".PHP_EOL.

Concat operator must not be surrounded by spaces

            "--".PHP_EOL.PHP_EOL;

The string literal -- does not require double quotes, as per coding-style, please use single quotes.

    }

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

Expected //end getDatabaseHeader()

    /**
     * Decode column metadata and fill info structure.
     * type, is_numeric and is_blob will always be available.
     *
     * @param array $colType Array returned from "SHOW COLUMNS FROM tableName"

Tag value indented incorrectly; expected 2 spaces but found 1

Parameter comment must end with a full stop

     * @return array

Tag cannot be grouped with parameter tags in a doc comment

     */
    public function parseColumnType($colType)

Type hint "array" missing for $colType

    {

Opening brace should be on the same line as the declaration

        $colInfo = array();

Equals sign not aligned with surrounding assignments; expected 2 spaces but found 1 space

Short array syntax must be used to define arrays

        $colParts = explode(" ", $colType['Type']);

The string literal does not require double quotes, as per coding-style, please use single quotes.

        if ($fparen = strpos($colParts[0], "(")) {

The string literal ( does not require double quotes, as per coding-style, please use single quotes.

Assignments must be the first block of code on a line

            $colInfo['type'] = substr($colParts[0], 0, $fparen);

Equals sign not aligned with surrounding assignments; expected 7 spaces but found 1 space

            $colInfo['length'] = str_replace(")", "", substr($colParts[0], $fparen + 1));

The string literal ) does not require double quotes, as per coding-style, please use single quotes.

The string literal does not require double quotes, as per coding-style, please use single quotes.

Arithmetic operation must be bracketed

Equals sign not aligned with surrounding assignments; expected 5 spaces but found 1 space

            $colInfo['attributes'] = isset($colParts[1]) ? $colParts[1] : null;

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of null please use NULL.

The value of a comparison must not be assigned to a variable

Inline IF statements are not allowed

        } else {
            $colInfo['type'] = $colParts[0];
        }

No blank line found after control structure

        $colInfo['is_numeric'] = in_array($colInfo['type'], $this->mysqlTypes['numerical']);
        $colInfo['is_blob'] = in_array($colInfo['type'], $this->mysqlTypes['blob']);

Equals sign not aligned with surrounding assignments; expected 4 spaces but found 1 space

        // for virtual columns that are of type 'Extra', column type

Inline comments must start with a capital letter

        // could by "STORED GENERATED" or "VIRTUAL GENERATED"
        // MySQL reference: https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html

This line exceeds maximum limit of 100 characters; contains 103 characters

Inline comments must end in full-stops, exclamation marks, or question marks

        $colInfo['is_virtual'] = strpos($colType['Extra'], "VIRTUAL GENERATED") !== false || strpos($colType['Extra'], "STORED GENERATED") !== false;

The string literal VIRTUAL GENERATED does not require double quotes, as per coding-style, please use single quotes.

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

The string literal STORED GENERATED does not require double quotes, as per coding-style, please use single quotes.

Boolean operators are not allowed outside of control structure conditions

This line exceeds maximum limit of 100 characters; contains 149 characters

        return $colInfo;
    }

Expected 1 blank line before closing function brace; 0 found

Expected //end parseColumnType()

Expected 2 blank lines after function; 1 found

    public function backup_parameters()

Public method name "TypeAdapterMysql::backup_parameters" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $ret = "/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;".PHP_EOL.

The string literal /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40101 SET NAMES ".$this->dumpSettings['default-character-set']." */;".PHP_EOL;

The string literal /*!40101 SET NAMES does not require double quotes, as per coding-style, please use single quotes.

The string literal */; does not require double quotes, as per coding-style, please use single quotes.

        if (false === $this->dumpSettings['skip-tz-utc']) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            $ret .= "/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;".PHP_EOL.

The string literal /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

                "/*!40103 SET TIME_ZONE='+00:00' */;".PHP_EOL;
        }

        if ($this->dumpSettings['no-autocommit']) {
                $ret .= "/*!40101 SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT */;".PHP_EOL;

The string literal /*!40101 SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT */; does not require double quotes, as per coding-style, please use single quotes.

        }

        $ret .= "/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;".PHP_EOL.

The string literal /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;".PHP_EOL.

The string literal /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

This line exceeds maximum limit of 100 characters; contains 106 characters

            "/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;".PHP_EOL.

Concat operator must not be surrounded by spaces

            "/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;".PHP_EOL.PHP_EOL;

The string literal /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; does not require double quotes, as per coding-style, please use single quotes.

        return $ret;
    }

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 1 found

Expected //end backup_parameters()

    public function restore_parameters()

Public method name "TypeAdapterMysql::restore_parameters" is not in camel caps format

Missing function doc comment

    {

Opening brace should be on the same line as the declaration

        $ret = "";

The string literal does not require double quotes, as per coding-style, please use single quotes.

        if (false === $this->dumpSettings['skip-tz-utc']) {

TRUE, FALSE and NULL should be uppercase as per the configured coding-style; instead of false please use FALSE.

            $ret .= "/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;".PHP_EOL;

The string literal /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; does not require double quotes, as per coding-style, please use single quotes.

        }

        if ($this->dumpSettings['no-autocommit']) {
                $ret .= "/*!40101 SET AUTOCOMMIT=@OLD_AUTOCOMMIT */;".PHP_EOL;

The string literal /*!40101 SET AUTOCOMMIT=@OLD_AUTOCOMMIT */; does not require double quotes, as per coding-style, please use single quotes.

        }

        $ret .= "/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;".PHP_EOL.

The string literal /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;".PHP_EOL.

The string literal /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;".PHP_EOL.

The string literal /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; does not require double quotes, as per coding-style, please use single quotes.

Concat operator must not be surrounded by spaces

            "/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;".PHP_EOL.

Concat operator must not be surrounded by spaces

The string literal /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; does not require double quotes, as per coding-style, please use single quotes.

            "/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;".PHP_EOL.PHP_EOL;

The string literal /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; does not require double quotes, as per coding-style, please use single quotes.

        return $ret;
    }

Expected //end restore_parameters()

Expected 2 blank lines after function; 1 found

Expected 1 blank line before closing function brace; 0 found

    /**
     * Check number of parameters passed to function, useful when inheriting.
     * Raise exception if unexpected.
     *
     * @param integer $num_args

Missing parameter comment

     * @param integer $expected_num_args

Missing parameter comment

     * @param string $method_name

Missing parameter comment

Expected 2 spaces after parameter type; 1 found

     */

Missing @return tag in function comment

Missing @throws tag in function comment

    private function check_parameters($num_args, $expected_num_args, $method_name)

Variable "method_name" is not in valid camel caps format

Private method name "TypeAdapterMysql::check_parameters" must be prefixed with an underscore

This method is not in camel caps format.

Variable "num_args" is not in valid camel caps format

Variable "expected_num_args" is not in valid camel caps format

    {

Opening brace should be on the same line as the declaration

        if ($num_args != $expected_num_args) {

Variable "expected_num_args" is not in valid camel caps format

Variable "num_args" is not in valid camel caps format

Operator != prohibited; use !== instead

            throw new Exception("Unexpected parameter passed to $method_name");

As per coding-style, please use concatenation or sprintf for the variable $method_name instead of interpolation.

Variable "method_name" is not in valid camel caps format

        }

No blank line found after control structure

        return;

Empty return statement not required here

    }

Expected //end check_parameters()

Expected 1 blank line before closing function brace; 0 found

Expected 2 blank lines after function; 0 found

}

Expected //end class

As per coding style, files should not end with a newline character.