PgsqlPDOQuerySplitter::getc() - Code Metrics - Inspection of "PSR-12 and other CS fixes" - phingofficial/phing - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — main ( 4889b2...808ce0 )

by Michiel
created 2021-02-11 12:34 UTC
PgsqlPDOQuerySplitter::getc() A

↳ Parent: PgsqlPDOQuerySplitter
Complexity

Conditions	4
Paths	3
Size

Total Lines	12
Code Lines	7
Duplication

Lines	0
Ratio	0 %
Code Coverage

Tests	8
CRAP Score	4
Importance

Changes
Metric	Value
eloc	7
dl	0
loc	12
rs	10
c	0
b	0
f	0
ccs	8
cts	8
cp	1
cc	4
nc	3
nop	0
crap	4
<?php
/**
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information please see
 * <http://phing.info>.
 *
 */

namespace Phing\Task\System\Pdo;

/**
 * Splits PostgreSQL's dialect of SQL into separate queries
 *
 * Unlike DefaultPDOQuerySplitter this uses a lexer instead of regular
 * expressions. This allows handling complex constructs like C-style comments
 * (including nested ones) and dollar-quoted strings.
 *
 * @author  Alexey Borzov <[email protected]>
 * @link    http://www.phing.info/trac/ticket/499
 * @link    http://www.postgresql.org/docs/current/interactive/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING
 */
class PgsqlPDOQuerySplitter extends PDOQuerySplitter
{
    /**#@+
     * Lexer states
     */
    public const STATE_NORMAL = 0;
    public const STATE_SINGLE_QUOTED = 1;
    public const STATE_DOUBLE_QUOTED = 2;
    public const STATE_DOLLAR_QUOTED = 3;
    public const STATE_COMMENT_LINEEND = 4;
    public const STATE_COMMENT_MULTILINE = 5;
    public const STATE_BACKSLASH = 6;
    /**#@-*/

    /**
     * Nesting depth of current multiline comment
     *
     * @var int
     */
    protected $commentDepth = 0;

    /**
     * Current dollar-quoting "tag"
     *
     * @var string
     */
    protected $quotingTag = '';

    /**
     * Current lexer state, one of STATE_* constants
     *
     * @var int
     */
    protected $state = self::STATE_NORMAL;

    /**
     * Whether a backslash was just encountered in quoted string
     *
     * @var bool
     */
    protected $escape = false;

    /**
     * Current source line being examined
     *
     * @var string
     */
    protected $line = '';

    /**
     * Position in current source line
     *
     * @var int
     */
    protected $inputIndex;

    /**
     * Gets next symbol from the input, false if at end
     *
     * @return string|bool
     */
    public function getc()
    {
        if (!strlen($this->line) || $this->inputIndex >= strlen($this->line)) {
            if (null === ($line = $this->sqlReader->readLine())) {
                return false;
            }
            $project = $this->parent->getOwningTarget()->getProject();
            $this->line = $project->replaceProperties($line) . "\n";
            $this->inputIndex = 0;
        }

        return $this->line[$this->inputIndex++];
    }

    /**
     * Bactracks one symbol on the input
     *
     * NB: we don't need ungetc() at the start of the line, so this case is
     * not handled.
     */
    public function ungetc()
    {
        $this->inputIndex--;
    }

    /**
     * Checks whether symbols after $ are a valid dollar-quoting tag
     *
     * @return string|bool Dollar-quoting "tag" if it is present, false otherwise
     */
    protected function checkDollarQuote()
    {
        $ch = $this->getc();
        if ('$' === $ch) {
            // empty tag
            return '';
        }

        if (!ctype_alpha($ch) && '_' !== $ch) {
            // not a delimiter
            $this->ungetc();

            return false;
        }

        $tag = $ch;
        while (false !== ($ch = $this->getc())) {
            if ('$' === $ch) {
                return $tag;
            }

            if (ctype_alnum($ch) || '_' === $ch) {
                $tag .= $ch;
            } else {
                for ($i = 0, $tagLength = strlen($tag); $i < $tagLength; $i++) {
                for ($i = 0, $tagLength = strlen(/** @scrutinizer ignore-type */ $tag); $i < $tagLength; $i++) {
                    $this->ungetc();
                }

                return false;
            }
        }

        return $tag;
    }

    /**
     * @return null|string
     */
    public function nextQuery()
    {
        $sql = '';
        $delimiter = $this->parent->getDelimiter();
        $openParens = 0;

        while (false !== ($ch = $this->getc())) {
            switch ($this->state) {
                case self::STATE_NORMAL:
                    switch ($ch) {
                        case '-':
                            if ('-' == $this->getc()) {
                                $this->state = self::STATE_COMMENT_LINEEND;
                            } else {
                                $this->ungetc();
                            }
                            break;
                        case '"':
                            $this->state = self::STATE_DOUBLE_QUOTED;
                            break;
                        case "'":
                            $this->state = self::STATE_SINGLE_QUOTED;
                            break;
                        case '/':
                            if ('*' === $this->getc()) {
                                $this->state = self::STATE_COMMENT_MULTILINE;
                                $this->commentDepth = 1;
                            } else {
                                $this->ungetc();
                            }
                            break;
                        case '$':
                            if (false !== ($tag = $this->checkDollarQuote())) {
                                $this->state = self::STATE_DOLLAR_QUOTED;
                                $this->quotingTag = $tag;
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}
                                $sql .= '$' . $tag . '$';
                                $sql .= '$' . /** @scrutinizer ignore-type */ $tag . '$';
                                continue 3;
                            }
                            break;
                        case '(':
                            $openParens++;
                            break;
                        case ')':
                            $openParens--;
                            break;
                        // technically we can use e.g. psql's \g command as delimiter
                        case $delimiter[0]:
                            // special case to allow "create rule" statements
                            // http://www.postgresql.org/docs/current/interactive/sql-createrule.html
                            if (';' === $delimiter && 0 < $openParens) {
                                break;
                            }
                            $hasQuery = true;
                            for ($i = 1, $delimiterLength = strlen($delimiter); $i < $delimiterLength; $i++) {
                                if ($delimiter[$i] != $this->getc()) {
                                    $hasQuery = false;
                                }
                            }
                            if ($hasQuery) {
                                return $sql;
                            }

                            for ($j = 1; $j < $i; $j++) {
                                $this->ungetc();
                            }
                    }
                    break;

                case self::STATE_COMMENT_LINEEND:
                    if ("\n" === $ch) {
                        $this->state = self::STATE_NORMAL;
                    }
                    break;

                case self::STATE_COMMENT_MULTILINE:
                    switch ($ch) {
                        case '/':
                            if ('*' != $this->getc()) {
                                $this->ungetc();
                            } else {
                                $this->commentDepth++;
                            }
                            break;

                        case '*':
                            if ('/' != $this->getc()) {
                                $this->ungetc();
                            } else {
                                $this->commentDepth--;
                                if (0 == $this->commentDepth) {
                                    $this->state = self::STATE_NORMAL;
                                    continue 3;
                                }
                            }
                    }

                // no break
                case self::STATE_SINGLE_QUOTED:
                case self::STATE_DOUBLE_QUOTED:
                    if ($this->escape) {
                        $this->escape = false;
                        break;
                    }
                    $quote = $this->state == self::STATE_SINGLE_QUOTED ? "'" : '"';
                    switch ($ch) {
                        case '\\':
                            $this->escape = true;
                            break;
                        case $quote:
                            if ($quote == $this->getc()) {
                                $sql .= $quote;
                            } else {
                                $this->ungetc();
                                $this->state = self::STATE_NORMAL;
                            }
                    }

                // no break
                case self::STATE_DOLLAR_QUOTED:
                    if ('$' == $ch && false !== ($tag = $this->checkDollarQuote())) {
                        if ($tag == $this->quotingTag) {
                            $this->state = self::STATE_NORMAL;
                        }
                        $sql .= '$' . $tag . '$';
                        continue 2;
                    }
            }

            if ($this->state != self::STATE_COMMENT_LINEEND && $this->state != self::STATE_COMMENT_MULTILINE) {
                $sql .= $ch;
            }
        }
        if ('' !== $sql) {
            return $sql;
        }

        return null;
    }
}

phingofficial / phing

Push — main ( 4889b2...808ce0 )

PgsqlPDOQuerySplitter::getc() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like
