ReferenceParser::parseSQL() - Code Metrics - Inspection of "fix" - phuria/under-query - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 5b6dd2...e674ef )

by Beniamin

created 2016-09-26 15:38 UTC

ReferenceParser::parseSQL() A

↳ Parent: ReferenceParser

Complexity

Conditions	2
Paths	2

Size

Total Lines	10
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	6
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	10
ccs	6
cts	6
cp	1
rs	9.4285
cc	2
eloc	5
nc	2
nop	0
crap	2

<?php

/**
 * This file is part of Phuria SQL Builder package.
 *
 * Copyright (c) 2016 Beniamin Jonatan Šimko
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Phuria\SQLBuilder\Parser;

use Phuria\SQLBuilder\QueryBuilder\Component\QueryComponentInterface;
use Phuria\SQLBuilder\ReferenceManager;
use Phuria\SQLBuilder\Table\AbstractTable;

/**
 * @author Beniamin Jonatan Šimko <[email protected]>
 */
class ReferenceParser
{
    /**
     * @var string $rawSQL
     */
    private $rawSQL;

    /**
     * @var ReferenceManager $manager
     */
    private $manager;

    /**
     * @param                  $rawSQL
     * @param ReferenceManager $manager
     */
    public function __construct($rawSQL, ReferenceManager $manager)
    {
        $this->rawSQL = $rawSQL;
        $this->manager = $manager;
    }

    /**
     * @return string
     */
    public function parseSQL()
    {
        $references = $this->manager->all();

        foreach ($references as &$value) {
            $value = $this->convertReferenceToValue($value);
        }

        return str_replace(array_keys($references), array_values($references), $this->rawSQL);
    }

    /**
     * @param $reference
     *
     * @return string
     */
    private function convertReferenceToValue($reference)
    {
        if (is_string($reference)) {
            return "\"" . $reference ."\"";
        } elseif ($reference instanceof AbstractTable) {
            return $reference->getAliasOrName();
        } elseif ($reference instanceof QueryComponentInterface) {
            return $reference->buildSQL();
        }

        return $reference;
    }
}

1		<?php
2
3		/**
4		* This file is part of Phuria SQL Builder package.
5		*
6		* Copyright (c) 2016 Beniamin Jonatan Šimko
7		*
8		* For the full copyright and license information, please view the LICENSE
9		* file that was distributed with this source code.
10		*/
11
12		namespace Phuria\SQLBuilder\Parser;
13
14		use Phuria\SQLBuilder\QueryBuilder\Component\QueryComponentInterface;
15		use Phuria\SQLBuilder\ReferenceManager;
16		use Phuria\SQLBuilder\Table\AbstractTable;
17
18		/**
19		* @author Beniamin Jonatan Šimko <[email protected]>
20		*/
21		class ReferenceParser
22		{
23		/**
24		* @var string $rawSQL
25		*/
26		private $rawSQL;
27
28		/**
29		* @var ReferenceManager $manager
30		*/
31		private $manager;
32
33		/**
34		* @param $rawSQL
35		* @param ReferenceManager $manager
36		*/
37	29	public function __construct($rawSQL, ReferenceManager $manager)
38		{
39	29	$this->rawSQL = $rawSQL;
40	29	$this->manager = $manager;
41	29	}
42
43		/**
44		* @return string
45		*/
46	29	public function parseSQL()
47		{
48	29	$references = $this->manager->all();
49
50	29	foreach ($references as &$value) {
51	21	$value = $this->convertReferenceToValue($value);
52	29	}
53
54	29	return str_replace(array_keys($references), array_values($references), $this->rawSQL);
55		}
56
57		/**
58		* @param $reference
59		*
60		* @return string
61		*/
62	21	private function convertReferenceToValue($reference)
63		{
64	21	if (is_string($reference)) {
65	1	return "\"" . $reference ."\"";
66	21	} elseif ($reference instanceof AbstractTable) {
67	20	return $reference->getAliasOrName();
68	2	} elseif ($reference instanceof QueryComponentInterface) {
69	1	return $reference->buildSQL();
70		}
71
72	1	return $reference;
73		}
74		}

phuria / under-query

Push — master ( 5b6dd2...e674ef )

ReferenceParser::parseSQL() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like