FilterCondition::getValueInDatabase() - Code Metrics - Inspection of "Merge pull request #12 from netdudes/feature/trans..." - netdudes/DataSourceryBundle - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 48c3ae...6eeb89 )

unknown

created 2016-02-03 16:44 UTC

FilterCondition::getValueInDatabase() A

↳ Parent: FilterCondition

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
c	1
b	0
f	1
dl	0
loc	4
rs	10
cc	1
eloc	2
nc	1
nop	0

<?php

namespace Netdudes\DataSourceryBundle\Query;

use Netdudes\DataSourceryBundle\UQL\Interpreter;

/**
 * Defines a filter
 */
class FilterCondition
{
    /**
     * Filter types: standard string and numeric comparison.
     * This set of comparison methods are understood by any DataSource that wants to be easily swappable
     *
     * Additional filtering methods may be defined to be consumed by custom data sources.
     */

    const METHOD_STRING_EQ = "STRING_EQ";
    const METHOD_STRING_LIKE = "STRING_LIKE";
    const METHOD_STRING_NEQ = "STRING_NEQ";
    const METHOD_NUMERIC_GT = "NUMERIC_GT";
    const METHOD_NUMERIC_GTE = "NUMERIC_GTE";
    const METHOD_NUMERIC_EQ = "NUMERIC_EQ";
    const METHOD_NUMERIC_LTE = "NUMERIC_LTE";
    const METHOD_NUMERIC_LT = "NUMERIC_LT";
    const METHOD_NUMERIC_NEQ = "NUMERIC_NEQ";
    const METHOD_IN = "IN";
    const METHOD_BOOLEAN = "BOOLEAN";
    const METHOD_IS_NULL = "IS_NULL";
    const METHOD_DATETIME_GT = "DATETIME_GT";
    const METHOD_DATETIME_GTE = "DATETIME_GTE";
    const METHOD_DATETIME_EQ = "DATETIME_EQ";
    const METHOD_DATETIME_LTE = "DATETIME_LTE";
    const METHOD_DATETIME_LT = "DATETIME_LT";
    const METHOD_DATETIME_NEQ = "DATETIME_NEQ";

    /**
     * Column ID to filter by
     *
     * @var string
     */
    private $fieldName;

    /**
     * Filtering method, of those defined in this class' constants
     *
     * @var string
     */
    private $method;

    /**
     * A value to filter by
     *
     * @var mixed
     */
    private $value;

    /**
     * @var mixed
     */
    private $valueInDatabase;

    /**
     * @param $columnIdentifier  string The unique identifier of the column to filter by
     * @param $method            string A value  passed to the data source in order to decide how to filter
     * @param $value             string The value to filter with
     * @param $valueInDatabase   string The presentation of the filtered value inside the database
     */
    public function __construct($columnIdentifier, $method, $value, $valueInDatabase)
    {
        $this->fieldName = $columnIdentifier;
        $this->method = $method;
        $this->value = $value;
        $this->valueInDatabase = $valueInDatabase;
    }

    /**
     * Returns an array serializable to JSON for the compact exchange format.
     *
     * @return array
     */
    public function toJsonSerializable()
    {
        return [
            'field' => $this->fieldName,
            'method' => $this->method,
            'value' => $this->value
        ];
    }

    /**
     * Get a UQL representation of this filter statement
     *
     * @return string
     */
    public function toUQL()
    {
        $numericMethods = [
            self::METHOD_NUMERIC_EQ,
            self::METHOD_NUMERIC_GT,
            self::METHOD_NUMERIC_GTE,
            self::METHOD_NUMERIC_LT,
            self::METHOD_NUMERIC_LTE,
            self::METHOD_NUMERIC_NEQ,
        ];

        $booleanMethods = [
            self::METHOD_BOOLEAN,
        ];

        $value = $this->getValue();
        if (is_array($value)) {
            // Array value (e.g. a IN statement)
            // Wrap every element in quotes, separate by commas and make into a square-bracket array.
            $value = '[' . implode(
                    ', ',
                    array_map(
                        function ($string) {
                            return "\"$string\"";
                        },
                        $value
                    )
                ) . ']';
        } else {
            if (in_array($this->method, $booleanMethods)) {
                $value = $value ? 'true' : 'false';
            } elseif (in_array($this->method, $numericMethods) && preg_match("/^[0-9]+$/", trim($value))) {
                $value = trim($value);
            } else {
                $value = "\"$value\"";
            }
        }

        return $this->getFieldName() . " " . Interpreter::methodToUQLOperator($this->getMethod()) . " " . $value;
    }

    /**
     * @return mixed
     */
    public function getValue()
    {
        return $this->value;
    }

    /**
     * @param mixed $value
     */
    public function setValue($value)
    {
        $this->value = $value;
    }

    /**
     * @return mixed
     */
    public function getFieldName()
    {
        return $this->fieldName;
    }

    /**
     * @param mixed $fieldName
     */
    public function setFieldName($fieldName)
    {
        $this->fieldName = $fieldName;
    }

    /**
     * @return mixed
     */
    public function getMethod()
    {
        return $this->method;
    }

    /**
     * @param mixed $method
     */
    public function setMethod($method)
    {
        $this->method = $method;
    }

    /**
     * @return mixed
     */
    public function getValueInDatabase()
    {
        return $this->valueInDatabase;
    }

    /**
     * @param mixed $valueInDatabase
     */
    public function setValueInDatabase($valueInDatabase)
    {
        $this->valueInDatabase = $valueInDatabase;
    }
}


1			<?php
2
3			namespace Netdudes\DataSourceryBundle\Query;
4
5			use Netdudes\DataSourceryBundle\UQL\Interpreter;
6
7			/**
8			* Defines a filter
9			*/
10			class FilterCondition
11			{
12			/**
13			* Filter types: standard string and numeric comparison.
14			* This set of comparison methods are understood by any DataSource that wants to be easily swappable
15			*
16			* Additional filtering methods may be defined to be consumed by custom data sources.
17			*/
18
19			const METHOD_STRING_EQ = "STRING_EQ";
20			const METHOD_STRING_LIKE = "STRING_LIKE";
21			const METHOD_STRING_NEQ = "STRING_NEQ";
22			const METHOD_NUMERIC_GT = "NUMERIC_GT";
23			const METHOD_NUMERIC_GTE = "NUMERIC_GTE";
24			const METHOD_NUMERIC_EQ = "NUMERIC_EQ";
25			const METHOD_NUMERIC_LTE = "NUMERIC_LTE";
26			const METHOD_NUMERIC_LT = "NUMERIC_LT";
27			const METHOD_NUMERIC_NEQ = "NUMERIC_NEQ";
28			const METHOD_IN = "IN";
29			const METHOD_BOOLEAN = "BOOLEAN";
30			const METHOD_IS_NULL = "IS_NULL";
31			const METHOD_DATETIME_GT = "DATETIME_GT";
32			const METHOD_DATETIME_GTE = "DATETIME_GTE";
33			const METHOD_DATETIME_EQ = "DATETIME_EQ";
34			const METHOD_DATETIME_LTE = "DATETIME_LTE";
35			const METHOD_DATETIME_LT = "DATETIME_LT";
36			const METHOD_DATETIME_NEQ = "DATETIME_NEQ";
37
38			/**
39			* Column ID to filter by
40			*
41			* @var string
42			*/
43			private $fieldName;
44
45			/**
46			* Filtering method, of those defined in this class' constants
47			*
48			* @var string
49			*/
50			private $method;
51
52			/**
53			* A value to filter by
54			*
55			* @var mixed
56			*/
57			private $value;
58
59			/**
60			* @var mixed
61			*/
62			private $valueInDatabase;
63
64			/**
65			* @param $columnIdentifier string The unique identifier of the column to filter by
66			* @param $method string A value passed to the data source in order to decide how to filter
67			* @param $value string The value to filter with
68			* @param $valueInDatabase string The presentation of the filtered value inside the database
69			*/
70			public function __construct($columnIdentifier, $method, $value, $valueInDatabase)
71			{
72			$this->fieldName = $columnIdentifier;
73			$this->method = $method;
74			$this->value = $value;
75			$this->valueInDatabase = $valueInDatabase;
76			}
77
78			/**
79			* Returns an array serializable to JSON for the compact exchange format.
80			*
81			* @return array
82			*/
83			public function toJsonSerializable()
84			{
85			return [
86			'field' => $this->fieldName,
87			'method' => $this->method,
88			'value' => $this->value
89			];
90			}
91
92			/**
93			* Get a UQL representation of this filter statement
94			*
95			* @return string
96			*/
97			public function toUQL()
98			{
99			$numericMethods = [
100			self::METHOD_NUMERIC_EQ,
101			self::METHOD_NUMERIC_GT,
102			self::METHOD_NUMERIC_GTE,
103			self::METHOD_NUMERIC_LT,
104			self::METHOD_NUMERIC_LTE,
105			self::METHOD_NUMERIC_NEQ,
106			];
107
108			$booleanMethods = [
109			self::METHOD_BOOLEAN,
110			];
111
112			$value = $this->getValue();
113			if (is_array($value)) {
114			// Array value (e.g. a IN statement)
115			// Wrap every element in quotes, separate by commas and make into a square-bracket array.
116			$value = '[' . implode(
117			', ',
118			array_map(
119			function ($string) {
120			return "\"$string\"";
121			},
122			$value
123			)
124			) . ']';
125			} else {
126			if (in_array($this->method, $booleanMethods)) {
127			$value = $value ? 'true' : 'false';
128			} elseif (in_array($this->method, $numericMethods) && preg_match("/^[0-9]+$/", trim($value))) {
129			$value = trim($value);
130			} else {
131			$value = "\"$value\"";
132			}
133			}
134
135			return $this->getFieldName() . " " . Interpreter::methodToUQLOperator($this->getMethod()) . " " . $value;
136			}
137
138			/**
139			* @return mixed
140			*/
141			public function getValue()
142			{
143			return $this->value;
144			}
145
146			/**
147			* @param mixed $value
148			*/
149			public function setValue($value)
150			{
151			$this->value = $value;
152			}
153
154			/**
155			* @return mixed
156			*/
157			public function getFieldName()
158			{
159			return $this->fieldName;
160			}
161
162			/**
163			* @param mixed $fieldName
164			*/
165			public function setFieldName($fieldName)
166			{
167			$this->fieldName = $fieldName;
168			}
169
170			/**
171			* @return mixed
172			*/
173			public function getMethod()
174			{
175			return $this->method;
176			}
177
178			/**
179			* @param mixed $method
180			*/
181			public function setMethod($method)
182			{
183			$this->method = $method;
184			}
185
186			/**
187			* @return mixed
188			*/
189			public function getValueInDatabase()
190			{
191			return $this->valueInDatabase;
192			}
193
194			/**
195			* @param mixed $valueInDatabase
196			*/
197			public function setValueInDatabase($valueInDatabase)
198			{
199			$this->valueInDatabase = $valueInDatabase;
200			}
201			}
202

netdudes / DataSourceryBundle

Push — master ( 48c3ae...6eeb89 )

FilterCondition::getValueInDatabase() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like