Method init has 330 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    private function init()
    {
        $this->snippets = [
            'select'     => function () {
                return [

File PgSqlBag.php has 385 lines of code (exceeds 250 allowed). Consider refactoring.

Open

<?php

namespace ChrisAndChris\Common\RowMapperBundle\Services\Query\Parser\Snippets;

use ChrisAndChris\Common\RowMapperBundle\Events\RowMapperEvents;

Function init has a Cognitive Complexity of 34 (exceeds 5 allowed). Consider refactoring.

Open

    private function init()
    {
        $this->snippets = [
            'select'     => function () {
                return [

• Read up
  Read up

Avoid too many return statements within this method.

Open

                return [
                    'code'   => strtoupper($params['name']) . '(/@brace(f))',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'OR',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => strtoupper($params['type'])
                        . ' JOIN '
                        . $this->implodeIdentifier($params['table'],
                            self::DELIMITER)

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'NULL',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'ORDER BY /@brace(order)',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => $params['cast'],
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                    return [
                        'code'   => $params['comparison'],
                        'params' => null,
                    ];

Avoid too many return statements within this method.

Open

                    return [
                        'code'   => 'IN (' . $code . ')',
                        'params' => $params['in'],
                    ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => '?',
                    'params' => $params['value'],
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'VALUES',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'LIMIT ' . abs((int)$params['limit']),
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'OFFSET ' . abs((int)$params['offset']),
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'UPDATE ' . $params['table'] . ' SET',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => '( /@brace(brace) )',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                        return 'UNION DISTINCT';

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'IN ( /@brace(in) )',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => '=',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => $sql,
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'INSERT ' . $mode . ' INTO "' . $params['table'] . '"',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => ',',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'GROUP BY /@brace(group)',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'FROM ' . $table . ' ' . $alias,
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'USING(' . $using . ')',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'DELETE FROM ' .
                        $this->implodeIdentifier($params['table'],
                            self::DELIMITER),
                    'params' => null,

Avoid too many return statements within this method.

Open

                return [
                    'code'   => $params['raw'],
                    'params' => $params['params'],
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'ILIKE ?',
                    'params' => $params['pattern'],
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => $this->implodeIdentifier($params['field'],
                            self::DELIMITER)
                        . ' ' . strtoupper($params['direction']),
                    'params' => null,

Avoid too many return statements within this method.

Open

                return 'UNION';

Avoid too many return statements within this method.

Open

                return [
                    'code'   => '/@close',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => $this->implodeIdentifier($params['identifier'],
                        self::DELIMITER),
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'ON ( /@brace(on) )',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                    return 'UNION ALL';

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'WHERE /@brace(where)',
                    'params' => null,
                ];

Avoid too many return statements within this method.

Open

                    return [
                        'code'   => 'IS NULL',
                        'params' => null,
                    ];

Avoid too many return statements within this method.

Open

                return [
                    'code'   => 'IS NOT NULL',
                    'params' => null,
                ];

Identical blocks of code found in 2 locations. Consider refactoring.

Open

            'in'         => function (array $params) {
                if (is_array($params['in'])) {
                    $code = '';
                    $count = count($params['in']);
                    for ($i = 0; $i < $count; $i++) {

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

            'insert'     => function (array $params) {
                $modes = [
                    'ignore',
                ];
                $mode = null;

• Read up
  Read up

Identical blocks of code found in 2 locations. Consider refactoring.

Open

            'orderby'    => function (array $params) {
                if ($params['direction'] != 'asc' &&
                    $params['direction'] != 'desc'
                ) {
                    throw new MalformedQueryException('Unknown order type');

• Read up
  Read up

Identical blocks of code found in 2 locations. Consider refactoring.

Open

            'comparison' => function (array $params) {
                $allowed = [
                    '<',
                    '>',
                    '<>',

• Read up
  Read up