Issues in JsonQueryBuilder.php (master) - Issues in master - gin0115/pixie-wpdb - Measure and Improve Code Quality continuously with Scrutinizer

Issues (21)

src/QueryBuilder/JsonQueryBuilder.php (1 issue)

Labels

Severity

Major 1

<?php

namespace Pixie\QueryBuilder;

class JsonQueryBuilder extends QueryBuilderHandler
{
    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
    * @param mixed|null $value
    * @return static
    */
    public function whereJson($column, $nodes, $operator = null, $value = null): self
    {
        // If two params are given then assume operator is =
        if (3 === func_num_args()) {
            $value    = $operator;
            $operator = '=';
        }

        return $this->whereJsonHandler($column, $nodes, $operator, $value, 'AND');
    }

    /**
     * @param string|Raw $column The database column which holds the JSON value
     * @param string|Raw|string[] $nodes The json key/index to search
     * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
     * @param mixed|null $value
     * @return static
     */
    public function whereNotJson($column, $nodes, $operator = null, $value = null): self
    {
        // If two params are given then assume operator is =
        if (3 === func_num_args()) {
            $value    = $operator;
            $operator = '=';
        }

        return $this->whereJsonHandler($column, $nodes, $operator, $value, 'AND NOT');
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
    * @param mixed|null $value
    * @return static
    */
    public function orWhereJson($column, $nodes, $operator = null, $value = null): self
    {
        // If two params are given then assume operator is =
        if (3 === func_num_args()) {
            $value    = $operator;
            $operator = '=';
        }

        return $this->whereJsonHandler($column, $nodes, $operator, $value, 'OR');
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
    * @param mixed|null $value
    * @return static
    */
    public function orWhereNotJson($column, $nodes, $operator = null, $value = null): self
    {
        // If two params are given then assume operator is =
        if (3 === func_num_args()) {
            $value    = $operator;
            $operator = '=';
        }

        return $this->whereJsonHandler($column, $nodes, $operator, $value, 'OR NOT');
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param mixed[] $values
    * @return static
    */
    public function whereInJson($column, $nodes, $values): self
    {
        return $this->whereJsonHandler($column, $nodes, 'IN', $values, 'AND');
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param mixed[] $values
    * @return static
    */
    public function whereNotInJson($column, $nodes, $values): self
    {
        return $this->whereJsonHandler($column, $nodes, 'NOT IN', $values, 'AND');
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param mixed[] $values
    * @return static
    */
    public function orWhereInJson($column, $nodes, $values): self
    {
        return $this->whereJsonHandler($column, $nodes, 'IN', $values, 'OR');
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param mixed[] $values
    * @return static
    */
    public function orWhereNotInJson($column, $nodes, $values): self
    {
        return $this->whereJsonHandler($column, $nodes, 'NOT IN', $values, 'OR');
    }

    /**
     * @param string|Raw $column
    * @param string|Raw|string[] $nodes The json key/index to search
     * @param mixed $valueFrom
     * @param mixed $valueTo
     *
     * @return static
     */
    public function whereBetweenJson($column, $nodes, $valueFrom, $valueTo): self
    {
        return $this->whereJsonHandler($column, $nodes, 'BETWEEN', [$valueFrom, $valueTo], 'AND');
    }

    /**
     * @param string|Raw $column
    * @param string|Raw|string[] $nodes The json key/index to search
     * @param mixed $valueFrom
     * @param mixed $valueTo
     *
     * @return static
     */
    public function orWhereBetweenJson($column, $nodes, $valueFrom, $valueTo): self
    {
        return $this->whereJsonHandler($column, $nodes, 'BETWEEN', [$valueFrom, $valueTo], 'OR');
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
    * @param mixed|null $value
    * @return static
    */
    public function whereDayJson($column, $nodes, $operator = null, $value = null): self
    {
        // If two params are given then assume operator is =
        if (3 === func_num_args()) {
            $value    = $operator;
            $operator = '=';
        }
        return $this->whereFunctionCallJsonHandler($column, $nodes, 'DAY', $operator, $value);
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
    * @param mixed|null $value
    * @return static
    */
    public function whereMonthJson($column, $nodes, $operator = null, $value = null): self
    {
        // If two params are given then assume operator is =
        if (3 === func_num_args()) {
            $value    = $operator;
            $operator = '=';
        }
        return $this->whereFunctionCallJsonHandler($column, $nodes, 'MONTH', $operator, $value);
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
    * @param mixed|null $value
    * @return static
    */
    public function whereYearJson($column, $nodes, $operator = null, $value = null): self
    {
        // If two params are given then assume operator is =
        if (3 === func_num_args()) {
            $value    = $operator;
            $operator = '=';
        }
        return $this->whereFunctionCallJsonHandler($column, $nodes, 'YEAR', $operator, $value);
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
    * @param mixed|null $value
    * @return static
    */
    public function whereDateJson($column, $nodes, $operator = null, $value = null): self
    {
        // If two params are given then assume operator is =
        if (3 === func_num_args()) {
            $value    = $operator;
            $operator = '=';
        }
        return $this->whereFunctionCallJsonHandler($column, $nodes, 'DATE', $operator, $value);
    }

    /**
     * Maps a function call for a JSON where condition
     *
     * @param string|Raw $column
     * @param string|Raw|string[] $nodes
     * @param string $function
     * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
     * @param mixed|null $value
     * @return static
     */
    protected function whereFunctionCallJsonHandler($column, $nodes, $function, $operator, $value): self
    {
        // Handle potential raw values.
        if ($column instanceof Raw) {
            $column = $this->adapterInstance->parseRaw($column);
        }
        if ($nodes instanceof Raw) {
            $nodes = $this->adapterInstance->parseRaw($nodes);
        }

        return $this->whereFunctionCallHandler(

            $this->jsonHandler->jsonExpressionFactory()->extractAndUnquote($column, $nodes),
            $function,
            $operator,
            $value
        );
    }

    /**
    * @param string|Raw $column The database column which holds the JSON value
    * @param string|Raw|string[] $nodes The json key/index to search
    * @param string|mixed|null $operator Can be used as value, if 3rd arg not passed
    * @param mixed|null $value
    * @param string $joiner
    * @return static
    */
    protected function whereJsonHandler($column, $nodes, $operator = null, $value = null, string $joiner = 'AND'): self
    {
        // Handle potential raw values.
        if ($column instanceof Raw) {
            $column = $this->adapterInstance->parseRaw($column);
        }
        if ($nodes instanceof Raw) {
            $nodes = $this->adapterInstance->parseRaw($nodes);
        }

        return $this->whereHandler(
            $this->jsonHandler->jsonExpressionFactory()->extractAndUnquote($column, $nodes),
            $operator,
            $value,
            $joiner
        );
    }

    /**
     * @param string|Raw $table
     * @param string|Raw $leftColumn
     * @param string|Raw|string[]|null $leftNodes The json key/index to search
     * @param string $operator
     * @param string|Raw $rightColumn
     * @param string|Raw|string[]|null $rightNodes
     * @param string $type
     *
     * @return static
     */
    public function joinJson(
        $table,
        $leftColumn,
        $leftNodes,
        string $operator,
        $rightColumn,
        $rightNodes,
        $type = 'inner'
    ): self {
        // Convert key if json
        if (null !== $rightNodes) {
            $rightColumn = $this->jsonHandler->jsonExpressionFactory()->extractAndUnquote($rightColumn, $rightNodes);
        }

        // Convert key if json
        if (null !== $leftNodes) {
            $leftColumn = $this->jsonHandler->jsonExpressionFactory()->extractAndUnquote($leftColumn, $leftNodes);
        }

        return $this->join($table, $leftColumn, $operator, $rightColumn, $type);
    }

    /**
     * @param string|Raw $table
     * @param string|Raw $leftColumn
     * @param string|Raw|string[]|null $leftNodes The json key/index to search
     * @param string $operator
     * @param string|Raw $rightColumn
     * @param string|Raw|string[]|null $rightNodes
     *
     * @return static
     */
    public function leftJoinJson(
        $table,
        $leftColumn,
        $leftNodes,
        string $operator,
        $rightColumn,
        $rightNodes
    ): self {
        return $this->joinJson(
            $table,
            $leftColumn,
            $leftNodes,
            $operator,
            $rightColumn,
            $rightNodes,
            'left'
        );
    }

    /**
     * @param string|Raw $table
     * @param string|Raw $leftColumn
     * @param string|Raw|string[]|null $leftNodes The json key/index to search
     * @param string $operator
     * @param string|Raw $rightColumn
     * @param string|Raw|string[]|null $rightNodes
     *
     * @return static
     */
    public function rightJoinJson(
        $table,
        $leftColumn,
        $leftNodes,
        string $operator,
        $rightColumn,
        $rightNodes
    ): self {
        return $this->joinJson(
            $table,
            $leftColumn,
            $leftNodes,
            $operator,
            $rightColumn,
            $rightNodes,
            'right'
        );
    }

    /**
     * @param string|Raw $table
     * @param string|Raw $leftColumn
     * @param string|Raw|string[]|null $leftNodes The json key/index to search
     * @param string $operator
     * @param string|Raw $rightColumn
     * @param string|Raw|string[]|null $rightNodes
     *
     * @return static
     */
    public function outerJoinJson(
        $table,
        $leftColumn,
        $leftNodes,
        string $operator,
        $rightColumn,
        $rightNodes
    ): self {
        return $this->joinJson(
            $table,
            $leftColumn,
            $leftNodes,
            $operator,
            $rightColumn,
            $rightNodes,
            'FULL OUTER'
        );
    }

    /**
     * @param string|Raw $table
     * @param string|Raw $leftColumn
     * @param string|Raw|string[]|null $leftNodes The json key/index to search
     * @param string $operator
     * @param string|Raw $rightColumn
     * @param string|Raw|string[]|null $rightNodes
     *
     * @return static
     */
    public function crossJoinJson(
        $table,
        $leftColumn,
        $leftNodes,
        string $operator,
        $rightColumn,
        $rightNodes
    ): self {
        return $this->joinJson(
            $table,
            $leftColumn,
            $leftNodes,
            $operator,
            $rightColumn,
            $rightNodes,
            'cross'
        );
    }



    // JSON

    /**
     * @param string|Raw $column The database column which holds the JSON value
     * @param string|Raw|string[] $nodes The json key/index to search
     * @param string|null $alias The alias used to define the value in results, if not defined will use json_{$nodes}
     * @return static
     */
    public function selectJson($column, $nodes, ?string $alias = null): self
    {
        // Handle potential raw values.
        if ($column instanceof Raw) {
            $column = $this->adapterInstance->parseRaw($column);
        }
        if ($nodes instanceof Raw) {
            $nodes = $this->adapterInstance->parseRaw($nodes);
        }

        // If deeply nested jsonKey.
        if (is_array($nodes)) {
            $nodes = \implode('.', $nodes);
        }

        // Add any possible prefixes to the key
        $column = $this->addTablePrefix($column, true);

        $alias = null === $alias ? "json_{$nodes}" : $alias;
        return  $this->select(new Raw("JSON_UNQUOTE(JSON_EXTRACT({$column}, \"$.{$nodes}\")) as {$alias}"));
    }
}


1			<?php
2
3			namespace Pixie\QueryBuilder;
4
5			class JsonQueryBuilder extends QueryBuilderHandler
6			{
7			/**
8			* @param string\|Raw $column The database column which holds the JSON value
9			* @param string\|Raw\|string[] $nodes The json key/index to search
10			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
11			* @param mixed\|null $value
12			* @return static
13			*/
14			public function whereJson($column, $nodes, $operator = null, $value = null): self
15			{
16			// If two params are given then assume operator is =
17			if (3 === func_num_args()) {
18			$value = $operator;
19			$operator = '=';
20			}
21
22			return $this->whereJsonHandler($column, $nodes, $operator, $value, 'AND');
23			}
24
25			/**
26			* @param string\|Raw $column The database column which holds the JSON value
27			* @param string\|Raw\|string[] $nodes The json key/index to search
28			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
29			* @param mixed\|null $value
30			* @return static
31			*/
32			public function whereNotJson($column, $nodes, $operator = null, $value = null): self
33			{
34			// If two params are given then assume operator is =
35			if (3 === func_num_args()) {
36			$value = $operator;
37			$operator = '=';
38			}
39
40			return $this->whereJsonHandler($column, $nodes, $operator, $value, 'AND NOT');
41			}
42
43			/**
44			* @param string\|Raw $column The database column which holds the JSON value
45			* @param string\|Raw\|string[] $nodes The json key/index to search
46			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
47			* @param mixed\|null $value
48			* @return static
49			*/
50			public function orWhereJson($column, $nodes, $operator = null, $value = null): self
51			{
52			// If two params are given then assume operator is =
53			if (3 === func_num_args()) {
54			$value = $operator;
55			$operator = '=';
56			}
57
58			return $this->whereJsonHandler($column, $nodes, $operator, $value, 'OR');
59			}
60
61			/**
62			* @param string\|Raw $column The database column which holds the JSON value
63			* @param string\|Raw\|string[] $nodes The json key/index to search
64			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
65			* @param mixed\|null $value
66			* @return static
67			*/
68			public function orWhereNotJson($column, $nodes, $operator = null, $value = null): self
69			{
70			// If two params are given then assume operator is =
71			if (3 === func_num_args()) {
72			$value = $operator;
73			$operator = '=';
74			}
75
76			return $this->whereJsonHandler($column, $nodes, $operator, $value, 'OR NOT');
77			}
78
79			/**
80			* @param string\|Raw $column The database column which holds the JSON value
81			* @param string\|Raw\|string[] $nodes The json key/index to search
82			* @param mixed[] $values
83			* @return static
84			*/
85			public function whereInJson($column, $nodes, $values): self
86			{
87			return $this->whereJsonHandler($column, $nodes, 'IN', $values, 'AND');
88			}
89
90			/**
91			* @param string\|Raw $column The database column which holds the JSON value
92			* @param string\|Raw\|string[] $nodes The json key/index to search
93			* @param mixed[] $values
94			* @return static
95			*/
96			public function whereNotInJson($column, $nodes, $values): self
97			{
98			return $this->whereJsonHandler($column, $nodes, 'NOT IN', $values, 'AND');
99			}
100
101			/**
102			* @param string\|Raw $column The database column which holds the JSON value
103			* @param string\|Raw\|string[] $nodes The json key/index to search
104			* @param mixed[] $values
105			* @return static
106			*/
107			public function orWhereInJson($column, $nodes, $values): self
108			{
109			return $this->whereJsonHandler($column, $nodes, 'IN', $values, 'OR');
110			}
111
112			/**
113			* @param string\|Raw $column The database column which holds the JSON value
114			* @param string\|Raw\|string[] $nodes The json key/index to search
115			* @param mixed[] $values
116			* @return static
117			*/
118			public function orWhereNotInJson($column, $nodes, $values): self
119			{
120			return $this->whereJsonHandler($column, $nodes, 'NOT IN', $values, 'OR');
121			}
122
123			/**
124			* @param string\|Raw $column
125			* @param string\|Raw\|string[] $nodes The json key/index to search
126			* @param mixed $valueFrom
127			* @param mixed $valueTo
128			*
129			* @return static
130			*/
131			public function whereBetweenJson($column, $nodes, $valueFrom, $valueTo): self
132			{
133			return $this->whereJsonHandler($column, $nodes, 'BETWEEN', [$valueFrom, $valueTo], 'AND');
134			}
135
136			/**
137			* @param string\|Raw $column
138			* @param string\|Raw\|string[] $nodes The json key/index to search
139			* @param mixed $valueFrom
140			* @param mixed $valueTo
141			*
142			* @return static
143			*/
144			public function orWhereBetweenJson($column, $nodes, $valueFrom, $valueTo): self
145			{
146			return $this->whereJsonHandler($column, $nodes, 'BETWEEN', [$valueFrom, $valueTo], 'OR');
147			}
148
149			/**
150			* @param string\|Raw $column The database column which holds the JSON value
151			* @param string\|Raw\|string[] $nodes The json key/index to search
152			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
153			* @param mixed\|null $value
154			* @return static
155			*/
156			public function whereDayJson($column, $nodes, $operator = null, $value = null): self
157			{
158			// If two params are given then assume operator is =
159			if (3 === func_num_args()) {
160			$value = $operator;
161			$operator = '=';
162			}
163			return $this->whereFunctionCallJsonHandler($column, $nodes, 'DAY', $operator, $value);
164			}
165
166			/**
167			* @param string\|Raw $column The database column which holds the JSON value
168			* @param string\|Raw\|string[] $nodes The json key/index to search
169			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
170			* @param mixed\|null $value
171			* @return static
172			*/
173			public function whereMonthJson($column, $nodes, $operator = null, $value = null): self
174			{
175			// If two params are given then assume operator is =
176			if (3 === func_num_args()) {
177			$value = $operator;
178			$operator = '=';
179			}
180			return $this->whereFunctionCallJsonHandler($column, $nodes, 'MONTH', $operator, $value);
181			}
182
183			/**
184			* @param string\|Raw $column The database column which holds the JSON value
185			* @param string\|Raw\|string[] $nodes The json key/index to search
186			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
187			* @param mixed\|null $value
188			* @return static
189			*/
190			public function whereYearJson($column, $nodes, $operator = null, $value = null): self
191			{
192			// If two params are given then assume operator is =
193			if (3 === func_num_args()) {
194			$value = $operator;
195			$operator = '=';
196			}
197			return $this->whereFunctionCallJsonHandler($column, $nodes, 'YEAR', $operator, $value);
198			}
199
200			/**
201			* @param string\|Raw $column The database column which holds the JSON value
202			* @param string\|Raw\|string[] $nodes The json key/index to search
203			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
204			* @param mixed\|null $value
205			* @return static
206			*/
207			public function whereDateJson($column, $nodes, $operator = null, $value = null): self
208			{
209			// If two params are given then assume operator is =
210			if (3 === func_num_args()) {
211			$value = $operator;
212			$operator = '=';
213			}
214			return $this->whereFunctionCallJsonHandler($column, $nodes, 'DATE', $operator, $value);
215			}
216
217			/**
218			* Maps a function call for a JSON where condition
219			*
220			* @param string\|Raw $column
221			* @param string\|Raw\|string[] $nodes
222			* @param string $function
223			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
224			* @param mixed\|null $value
225			* @return static
226			*/
227			protected function whereFunctionCallJsonHandler($column, $nodes, $function, $operator, $value): self
228			{
229			// Handle potential raw values.
230			if ($column instanceof Raw) {
231			$column = $this->adapterInstance->parseRaw($column);
232			}
233			if ($nodes instanceof Raw) {
234			$nodes = $this->adapterInstance->parseRaw($nodes);
235			}
236
237			return $this->whereFunctionCallHandler(
			0 ignored issues – show Bug Best Practice introduced 2022-02-05 13:17 UTC by Report Bug Copy Issue Report Show Similar Issues like this The expression `return $this->whereFunct...ion, $operator, $value)` returns the type `Pixie\QueryBuilder\QueryBuilderHandler` which includes types incompatible with the type-hinted return `Pixie\QueryBuilder\JsonQueryBuilder`. Loading history...
238			$this->jsonHandler->jsonExpressionFactory()->extractAndUnquote($column, $nodes),
239			$function,
240			$operator,
241			$value
242			);
243			}
244
245			/**
246			* @param string\|Raw $column The database column which holds the JSON value
247			* @param string\|Raw\|string[] $nodes The json key/index to search
248			* @param string\|mixed\|null $operator Can be used as value, if 3rd arg not passed
249			* @param mixed\|null $value
250			* @param string $joiner
251			* @return static
252			*/
253			protected function whereJsonHandler($column, $nodes, $operator = null, $value = null, string $joiner = 'AND'): self
254			{
255			// Handle potential raw values.
256			if ($column instanceof Raw) {
257			$column = $this->adapterInstance->parseRaw($column);
258			}
259			if ($nodes instanceof Raw) {
260			$nodes = $this->adapterInstance->parseRaw($nodes);
261			}
262
263			return $this->whereHandler(
264			$this->jsonHandler->jsonExpressionFactory()->extractAndUnquote($column, $nodes),
265			$operator,
266			$value,
267			$joiner
268			);
269			}
270
271			/**
272			* @param string\|Raw $table
273			* @param string\|Raw $leftColumn
274			* @param string\|Raw\|string[]\|null $leftNodes The json key/index to search
275			* @param string $operator
276			* @param string\|Raw $rightColumn
277			* @param string\|Raw\|string[]\|null $rightNodes
278			* @param string $type
279			*
280			* @return static
281			*/
282			public function joinJson(
283			$table,
284			$leftColumn,
285			$leftNodes,
286			string $operator,
287			$rightColumn,
288			$rightNodes,
289			$type = 'inner'
290			): self {
291			// Convert key if json
292			if (null !== $rightNodes) {
293			$rightColumn = $this->jsonHandler->jsonExpressionFactory()->extractAndUnquote($rightColumn, $rightNodes);
294			}
295
296			// Convert key if json
297			if (null !== $leftNodes) {
298			$leftColumn = $this->jsonHandler->jsonExpressionFactory()->extractAndUnquote($leftColumn, $leftNodes);
299			}
300
301			return $this->join($table, $leftColumn, $operator, $rightColumn, $type);
302			}
303
304			/**
305			* @param string\|Raw $table
306			* @param string\|Raw $leftColumn
307			* @param string\|Raw\|string[]\|null $leftNodes The json key/index to search
308			* @param string $operator
309			* @param string\|Raw $rightColumn
310			* @param string\|Raw\|string[]\|null $rightNodes
311			*
312			* @return static
313			*/
314			public function leftJoinJson(
315			$table,
316			$leftColumn,
317			$leftNodes,
318			string $operator,
319			$rightColumn,
320			$rightNodes
321			): self {
322			return $this->joinJson(
323			$table,
324			$leftColumn,
325			$leftNodes,
326			$operator,
327			$rightColumn,
328			$rightNodes,
329			'left'
330			);
331			}
332
333			/**
334			* @param string\|Raw $table
335			* @param string\|Raw $leftColumn
336			* @param string\|Raw\|string[]\|null $leftNodes The json key/index to search
337			* @param string $operator
338			* @param string\|Raw $rightColumn
339			* @param string\|Raw\|string[]\|null $rightNodes
340			*
341			* @return static
342			*/
343			public function rightJoinJson(
344			$table,
345			$leftColumn,
346			$leftNodes,
347			string $operator,
348			$rightColumn,
349			$rightNodes
350			): self {
351			return $this->joinJson(
352			$table,
353			$leftColumn,
354			$leftNodes,
355			$operator,
356			$rightColumn,
357			$rightNodes,
358			'right'
359			);
360			}
361
362			/**
363			* @param string\|Raw $table
364			* @param string\|Raw $leftColumn
365			* @param string\|Raw\|string[]\|null $leftNodes The json key/index to search
366			* @param string $operator
367			* @param string\|Raw $rightColumn
368			* @param string\|Raw\|string[]\|null $rightNodes
369			*
370			* @return static
371			*/
372			public function outerJoinJson(
373			$table,
374			$leftColumn,
375			$leftNodes,
376			string $operator,
377			$rightColumn,
378			$rightNodes
379			): self {
380			return $this->joinJson(
381			$table,
382			$leftColumn,
383			$leftNodes,
384			$operator,
385			$rightColumn,
386			$rightNodes,
387			'FULL OUTER'
388			);
389			}
390
391			/**
392			* @param string\|Raw $table
393			* @param string\|Raw $leftColumn
394			* @param string\|Raw\|string[]\|null $leftNodes The json key/index to search
395			* @param string $operator
396			* @param string\|Raw $rightColumn
397			* @param string\|Raw\|string[]\|null $rightNodes
398			*
399			* @return static
400			*/
401			public function crossJoinJson(
402			$table,
403			$leftColumn,
404			$leftNodes,
405			string $operator,
406			$rightColumn,
407			$rightNodes
408			): self {
409			return $this->joinJson(
410			$table,
411			$leftColumn,
412			$leftNodes,
413			$operator,
414			$rightColumn,
415			$rightNodes,
416			'cross'
417			);
418			}
419
420
421
422			// JSON
423
424			/**
425			* @param string\|Raw $column The database column which holds the JSON value
426			* @param string\|Raw\|string[] $nodes The json key/index to search
427			* @param string\|null $alias The alias used to define the value in results, if not defined will use json_{$nodes}
428			* @return static
429			*/
430			public function selectJson($column, $nodes, ?string $alias = null): self
431			{
432			// Handle potential raw values.
433			if ($column instanceof Raw) {
434			$column = $this->adapterInstance->parseRaw($column);
435			}
436			if ($nodes instanceof Raw) {
437			$nodes = $this->adapterInstance->parseRaw($nodes);
438			}
439
440			// If deeply nested jsonKey.
441			if (is_array($nodes)) {
442			$nodes = \implode('.', $nodes);
443			}
444
445			// Add any possible prefixes to the key
446			$column = $this->addTablePrefix($column, true);
447
448			$alias = null === $alias ? "json_{$nodes}" : $alias;
449			return $this->select(new Raw("JSON_UNQUOTE(JSON_EXTRACT({$column}, \"$.{$nodes}\")) as {$alias}"));
450			}
451			}
452

gin0115 / pixie-wpdb

Issues (21)

src/QueryBuilder/JsonQueryBuilder.php (1 issue)

Labels

Severity

Introduced By

Duplication Side-by-Side

Filter issues like