SqlTrait::getSql() - Code Metrics - Inspection of "Updated & slightly redesigned, initial SqlString s..." - webino/WebinoDbDump - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 505f0b...e8b338 )

by Peter

created 2016-04-09 12:00 UTC

SqlTrait::getSql() B

↳ Parent: SqlTrait

Complexity

Conditions	4
Paths	1

Size

Total Lines	27
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	27
rs	8.5806
cc	4
eloc	14
nc	1
nop	0

<?php
/**
 * Webino (http://webino.sk)
 *
 * @link        https://github.com/webino/WebinoDbDump for the canonical source repository
 * @copyright   Copyright (c) 2016 Webino, s. r. o. (http://webino.sk)
 * @license     The BSD 3-Clause License
 */

namespace WebinoDbDump\Db\Sql;

/**
 * Sql trait
 *
 * @author Peter Bačinský <[email protected]>
 */
trait SqlTrait
{
    /**
     * @var string
     */
    protected $delimiter = ';';

    /**
     * @var string|null
     */
    protected $current;

    /**
     * @param callable $callback
     * @return mixed
     */
    abstract protected function eachQuery(callable $callback);

    /**
     * @return string
     */
    public function getSql()
    {
        $query = '';

        $this->eachQuery(function ($line) use (&$query) {
            if (0 === strpos($line, '--')) {
                // skip comments
                return false;
            }

            $match = [];
            if (preg_match('~delimiter\s*([^\s]+)$~iS', $line, $match)) {
                $this->delimiter = $match[1];
                return false;
            }

            $query .= $line;

            if (preg_match('~' . preg_quote($this->delimiter, '~') . '\s*$~iS', $line)) {
                return true;
            }

            return null;
        });

        return trim($query);
    }

    /**
     * @return bool
     */
    public function valid()
    {
        if (null === $this->current) {
            $this->current = $this->getSql();
        }
        return !empty($this->current);
    }

    /**
     * @return string
     */
    public function current()
    {
        return $this->current;
    }

    /**
     * @return void
     */
    public function next()
    {
        $this->current = $this->getSql();
    }
}


1			<?php
2			/**
3			* Webino (http://webino.sk)
4			*
5			* @link https://github.com/webino/WebinoDbDump for the canonical source repository
6			* @copyright Copyright (c) 2016 Webino, s. r. o. (http://webino.sk)
7			* @license The BSD 3-Clause License
8			*/
9
10			namespace WebinoDbDump\Db\Sql;
11
12			/**
13			* Sql trait
14			*
15			* @author Peter Bačinský <[email protected]>
16			*/
17			trait SqlTrait
18			{
19			/**
20			* @var string
21			*/
22			protected $delimiter = ';';
23
24			/**
25			* @var string\|null
26			*/
27			protected $current;
28
29			/**
30			* @param callable $callback
31			* @return mixed
32			*/
33			abstract protected function eachQuery(callable $callback);
34
35			/**
36			* @return string
37			*/
38			public function getSql()
39			{
40			$query = '';
41
42			$this->eachQuery(function ($line) use (&$query) {
43			if (0 === strpos($line, '--')) {
44			// skip comments
45			return false;
46			}
47
48			$match = [];
49			if (preg_match('~delimiter\s*([^\s]+)$~iS', $line, $match)) {
50			$this->delimiter = $match[1];
51			return false;
52			}
53
54			$query .= $line;
55
56			if (preg_match('~' . preg_quote($this->delimiter, '~') . '\s*$~iS', $line)) {
57			return true;
58			}
59
60			return null;
61			});
62
63			return trim($query);
64			}
65
66			/**
67			* @return bool
68			*/
69			public function valid()
70			{
71			if (null === $this->current) {
72			$this->current = $this->getSql();
73			}
74			return !empty($this->current);
75			}
76
77			/**
78			* @return string
79			*/
80			public function current()
81			{
82			return $this->current;
83			}
84
85			/**
86			* @return void
87			*/
88			public function next()
89			{
90			$this->current = $this->getSql();
91			}
92			}
93

webino / WebinoDbDump

Push — develop ( 505f0b...e8b338 )

SqlTrait::getSql() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like