Select::offset() - Code Metrics - Inspection of "Scope to constrain - compatability update (#209)" - cycle/orm - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( abba32...0ee877 )

by Aleksei

created 2021-09-03 16:52 UTC

Select::offset() A

↳ Parent: Select

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php

/**
 * Cycle DataMapper ORM
 *
 * @license   MIT
 * @author    Anton Titov (Wolfy-J)
 */

declare(strict_types=1);

namespace Cycle\ORM;

use Countable;
use Cycle\ORM\Heap\Node;
use Cycle\ORM\Select\ConstrainInterface;
use Cycle\ORM\Select\JoinableLoader;
use Cycle\ORM\Select\QueryBuilder;
use Cycle\ORM\Select\RootLoader;
use Cycle\ORM\Select\ScopeInterface;
use IteratorAggregate;
use Spiral\Database\Query\SelectQuery;
use Spiral\Pagination\PaginableInterface;

/**
 * Query builder and entity selector. Mocks SelectQuery. Attention, Selector does not mount RootLoader scope by default.
 *
 * Trait provides the ability to transparently configure underlying loader query.
 *
 * @method Select distinct()
 * @method Select where(...$args);
 * @method Select andWhere(...$args);
 * @method Select orWhere(...$args);
 * @method Select having(...$args);
 * @method Select andHaving(...$args);
 * @method Select orHaving(...$args);
 * @method Select orderBy($expression, $direction = 'ASC');
 *
 * @method mixed avg($identifier) Perform aggregation (AVG) based on column or expression value.
 * @method mixed min($identifier) Perform aggregation (MIN) based on column or expression value.
 * @method mixed max($identifier) Perform aggregation (MAX) based on column or expression value.
 * @method mixed sum($identifier) Perform aggregation (SUM) based on column or expression value.
 */
final class Select implements IteratorAggregate, Countable, PaginableInterface
{
    // load relation data within same query
    public const SINGLE_QUERY = JoinableLoader::INLOAD;

    // load related data after the query
    public const OUTER_QUERY = JoinableLoader::POSTLOAD;

    /** @var ORMInterface @internal */
    private $orm;

    /** @var RootLoader */
    private $loader;

    /** @var QueryBuilder */
    private $builder;

    /**
     * @param ORMInterface $orm
     * @param string       $role
     */
    public function __construct(ORMInterface $orm, string $role)
    {
        $this->orm = $orm;
        $this->loader = new RootLoader($orm, $this->orm->resolveRole($role));
        $this->builder = new QueryBuilder($this->getLoader()->getQuery(), $this->loader);
    }

    /**
     * Remove nested loaders and clean ORM link.
     */
    public function __destruct()
    {
        $this->orm = null;
        $this->loader = null;
        $this->builder = null;
    }

    /**
     * Bypassing call to primary select query.
     *
     * @param string $name
     * @param array  $arguments
     * @return Select|mixed
     */
    public function __call(string $name, array $arguments)
    {
        if (in_array(strtoupper($name), ['AVG', 'MIN', 'MAX', 'SUM', 'COUNT'])) {
            // aggregations
            return $this->builder->withQuery(
                $this->loader->buildQuery()
            )->__call($name, $arguments);
        }

        $result = $this->builder->__call($name, $arguments);
        if ($result instanceof QueryBuilder) {
            return $this;
        }

        return $result;
    }

    /**
     * Cloning with loader tree cloning.
     *
     * @attention at this moment binded query parameters would't be cloned!
     */
    public function __clone()
    {
        $this->loader = clone $this->loader;
        $this->builder = new QueryBuilder($this->loader->getQuery(), $this->loader);
    }

    /**
     * @deprecated Will be dropped in next major release. Use {@see scope()} instead.
     */
    public function constrain(ConstrainInterface $constrain = null): self
    {
        return $this->scope($constrain);
    }

    /**
     * Create new Selector with applied scope. By default no scope used.
     */
    public function scope(ScopeInterface $scope = null): self
    {
        $this->loader->setScope($scope);

        return $this;
    }

    /**
     * Get Query proxy.
     *
     * @return QueryBuilder
     */
    public function getBuilder(): QueryBuilder
    {
        return $this->builder;
    }

    /**
     * Compiled SQL query, changes in this query would not affect Selector state (but binded parameters will).
     *
     * @return SelectQuery
     */
    public function buildQuery(): SelectQuery
    {
        return $this->loader->buildQuery();
    }

    /**
     * Shortcut to where method to set AND condition for entity primary key.
     *
     * @param string|int $id
     * @return $this|Select
     */
    public function wherePK($id): self
    {
        return $this->__call('where', [$this->loader->getPK(), $id]);
    }

    /**
     * Attention, column will be quoted by driver!
     *
     * @param string|null $column When column is null DISTINCT(PK) will be generated.
     * @return int
     */
    public function count(string $column = null): int
    {
        if ($column === null) {
            // @tuneyourserver solves the issue with counting on queries with joins.
            $column = sprintf('DISTINCT(%s)', $this->loader->getPK());
        }

        return (int) $this->__call('count', [$column]);
    }

    /**
     * @inheritdoc
     */
    public function limit(int $limit): self
    {
        $this->loader->getQuery()->limit($limit);

        return $this;
    }

    /**
     * @inheritdoc
     */
    public function offset(int $offset): self
    {
        $this->loader->getQuery()->offset($offset);

        return $this;
    }

    /**
     * Request primary selector loader to pre-load relation name. Any type of loader can be used
     * for data pre-loading. ORM loaders by default will select the most efficient way to load
     * related data which might include additional select query or left join. Loaded data will
     * automatically pre-populate record relations. You can specify nested relations using "."
     * separator.
     *
     * Examples:
     *
     * // Select users and load their comments (will cast 2 queries, HAS_MANY comments)
     * User::find()->with('comments');
     *
     * // You can load chain of relations - select user and load their comments and post related to
     * //comment
     * User::find()->with('comments.post');
     *
     * // We can also specify custom where conditions on data loading, let's load only public
     * // comments.
     * User::find()->load('comments', [
     *      'where' => ['{@}.status' => 'public']
     * ]);
     *
     * Please note using "{@}" column name, this placeholder is required to prevent collisions and
     * it will be automatically replaced with valid table alias of pre-loaded comments table.
     *
     * // In case where your loaded relation is MANY_TO_MANY you can also specify pivot table
     * // conditions, let's pre-load all approved user tags, we can use same placeholder for pivot
     * // table alias
     * User::find()->load('tags', [
     *      'wherePivot' => ['{@}.approved' => true]
     * ]);
     *
     * // In most of cases you don't need to worry about how data was loaded, using external query
     * // or left join, however if you want to change such behaviour you can force load method to
     * // INLOAD
     * User::find()->load('tags', [
     *      'method'     => Loader::INLOAD,
     *      'wherePivot' => ['{@}.approved' => true]
     * ]);
     *
     * Attention, you will not be able to correctly paginate in this case and only ORM loaders
     * support different loading types.
     *
     * You can specify multiple loaders using array as first argument.
     *
     * Example:
     * User::find()->load(['posts', 'comments', 'profile']);
     *
     * Attention, consider disabling entity map if you want to use recursive loading (i.e
     * post.tags.posts), but first think why you even need recursive relation loading.
     *
     * @param string|array $relation
     * @param array        $options
     * @return $this|self
     * @see with()
     */
    public function load($relation, array $options = []): self
    {
        if (is_string($relation)) {
            $this->loader->loadRelation($relation, $options, false, true);

            return $this;
        }

        foreach ($relation as $name => $subOption) {
            if (is_string($subOption)) {
                // array of relation names
                $this->load($subOption, $options);
            } else {
                // multiple relations or relation with addition load options
                $this->load($name, $subOption + $options);
            }
        }

        return $this;
    }

    /**
     * With method is very similar to load() one, except it will always include related data to
     * parent query using INNER JOIN, this method can be applied only to ORM loaders and relations
     * using same database as parent record.
     *
     * Method generally used to filter data based on some relation condition. Attention, with()
     * method WILL NOT load relation data, it will only make it accessible in query.
     *
     * By default joined tables will be available in query based on relation name, you can change
     * joined table alias using relation option "alias".
     *
     * Do not forget to set DISTINCT flag while including HAS_MANY and MANY_TO_MANY relations. In
     * other scenario you will not able to paginate data well.
     *
     * Examples:
     *
     * // Find all users who have comments comments
     * User::find()->with('comments');
     *
     * // Find all users who have approved comments (we can use comments table alias in where
     * statement). User::find()->with('comments')->where('comments.approved', true);
     *
     * // Find all users who have posts which have approved comments
     * User::find()->with('posts.comments')->where('posts_comments.approved', true);
     *
     * // Custom join alias for post comments relation
     * $user->with('posts.comments', [
     *      'as' => 'comments'
     * ])->where('comments.approved', true);
     *
     * // If you joining MANY_TO_MANY relation you will be able to use pivot table used as relation
     * // name plus "_pivot" postfix. Let's load all users with approved tags.
     * $user->with('tags')->where('tags_pivot.approved', true);
     *
     * // You can also use custom alias for pivot table as well
     * User::find()->with('tags', [
     *      'pivotAlias' => 'tags_connection'
     * ])
     * ->where('tags_connection.approved', false);
     *
     * You can safely combine with() and load() methods.
     *
     * // Load all users with approved comments and pre-load all their comments
     * User::find()->with('comments')->where('comments.approved', true)->load('comments');
     *
     * // You can also use custom conditions in this case, let's find all users with approved
     * // comments and pre-load such approved comments
     * User::find()->with('comments')->where('comments.approved', true)
     *             ->load('comments', [
     *                  'where' => ['{@}.approved' => true]
     *              ]);
     *
     * // As you might notice previous construction will create 2 queries, however we can simplify
     * // this construction to use already joined table as source of data for relation via "using"
     * // keyword
     * User::find()->with('comments')
     *             ->where('comments.approved', true)
     *             ->load('comments', ['using' => 'comments']);
     *
     * // You will get only one query with INNER JOIN, to better understand this example let's use
     * // custom alias for comments in with() method.
     * User::find()->with('comments', ['as' => 'commentsR'])
     *             ->where('commentsR.approved', true)
     *             ->load('comments', ['using' => 'commentsR']);
     *
     * @param string|array $relation
     * @param array        $options
     * @return $this|Select
     * @see load()
     */
    public function with($relation, array $options = []): self
    {
        if (is_string($relation)) {
            $this->loader->loadRelation($relation, $options, true, false);

            return $this;
        }

        foreach ($relation as $name => $subOption) {
            if (is_string($subOption)) {
                //Array of relation names
                $this->with($subOption, []);
            } else {
                //Multiple relations or relation with addition load options
                $this->with($name, $subOption);
            }
        }

        return $this;
    }

    /**
     * Find one entity or return null. Method provides the ability to configure custom query
     * parameters. Attention, method does not set a limit on selection (to avoid underselection of
     * joined tables), make sure to set the constrain in the query.
     *
     * @param array|null $query
     * @return object|null
     */
    public function fetchOne(array $query = null)
    {
        $data = (clone $this)->where($query)->limit(1)->fetchData();

        if (!isset($data[0])) {
            return null;
        }

        return $this->orm->make(
            $this->loader->getTarget(),
            $data[0],
            Node::MANAGED
        );
    }

    /**
     * Fetch all records in a form of array.
     *
     * @return object[]
     */
    public function fetchAll(): array
    {
        return iterator_to_array($this->getIterator());
    }

    /**
     * @return Iterator
     */
    public function getIterator(): Iterator
    {
        return new Iterator(
            $this->orm,
            $this->loader->getTarget(),
            $this->fetchData()
        );
    }

    /**
     * Load data tree from database and linked loaders in a form of array.
     *
     * @return array
     */
    public function fetchData(): array
    {
        $node = $this->loader->createNode();
        $this->loader->loadData($node);

        return $node->getResult();
    }

    /**
     * Compiled SQL statement.
     *
     * @return string
     */
    public function sqlStatement(): string
    {
        return $this->buildQuery()->sqlStatement();
    }

    /**
     * Return base loader associated with the selector.
     *
     * @return RootLoader
     */
    private function getLoader(): RootLoader
    {
        return $this->loader;
    }
}


1			<?php
2
3			/**
4			* Cycle DataMapper ORM
5			*
6			* @license MIT
7			* @author Anton Titov (Wolfy-J)
8			*/
9
10			declare(strict_types=1);
11
12			namespace Cycle\ORM;
13
14			use Countable;
15			use Cycle\ORM\Heap\Node;
16			use Cycle\ORM\Select\ConstrainInterface;
17			use Cycle\ORM\Select\JoinableLoader;
18			use Cycle\ORM\Select\QueryBuilder;
19			use Cycle\ORM\Select\RootLoader;
20			use Cycle\ORM\Select\ScopeInterface;
21			use IteratorAggregate;
22			use Spiral\Database\Query\SelectQuery;
23			use Spiral\Pagination\PaginableInterface;
24
25			/**
26			* Query builder and entity selector. Mocks SelectQuery. Attention, Selector does not mount RootLoader scope by default.
27			*
28			* Trait provides the ability to transparently configure underlying loader query.
29			*
30			* @method Select distinct()
31			* @method Select where(...$args);
32			* @method Select andWhere(...$args);
33			* @method Select orWhere(...$args);
34			* @method Select having(...$args);
35			* @method Select andHaving(...$args);
36			* @method Select orHaving(...$args);
37			* @method Select orderBy($expression, $direction = 'ASC');
38			*
39			* @method mixed avg($identifier) Perform aggregation (AVG) based on column or expression value.
40			* @method mixed min($identifier) Perform aggregation (MIN) based on column or expression value.
41			* @method mixed max($identifier) Perform aggregation (MAX) based on column or expression value.
42			* @method mixed sum($identifier) Perform aggregation (SUM) based on column or expression value.
43			*/
44			final class Select implements IteratorAggregate, Countable, PaginableInterface
45			{
46			// load relation data within same query
47			public const SINGLE_QUERY = JoinableLoader::INLOAD;
48
49			// load related data after the query
50			public const OUTER_QUERY = JoinableLoader::POSTLOAD;
51
52			/** @var ORMInterface @internal */
53			private $orm;
54
55			/** @var RootLoader */
56			private $loader;
57
58			/** @var QueryBuilder */
59			private $builder;
60
61			/**
62			* @param ORMInterface $orm
63			* @param string $role
64			*/
65			public function __construct(ORMInterface $orm, string $role)
66			{
67			$this->orm = $orm;
68			$this->loader = new RootLoader($orm, $this->orm->resolveRole($role));
69			$this->builder = new QueryBuilder($this->getLoader()->getQuery(), $this->loader);
70			}
71
72			/**
73			* Remove nested loaders and clean ORM link.
74			*/
75			public function __destruct()
76			{
77			$this->orm = null;
78			$this->loader = null;
79			$this->builder = null;
80			}
81
82			/**
83			* Bypassing call to primary select query.
84			*
85			* @param string $name
86			* @param array $arguments
87			* @return Select\|mixed
88			*/
89			public function __call(string $name, array $arguments)
90			{
91			if (in_array(strtoupper($name), ['AVG', 'MIN', 'MAX', 'SUM', 'COUNT'])) {
92			// aggregations
93			return $this->builder->withQuery(
94			$this->loader->buildQuery()
95			)->__call($name, $arguments);
96			}
97
98			$result = $this->builder->__call($name, $arguments);
99			if ($result instanceof QueryBuilder) {
100			return $this;
101			}
102
103			return $result;
104			}
105
106			/**
107			* Cloning with loader tree cloning.
108			*
109			* @attention at this moment binded query parameters would't be cloned!
110			*/
111			public function __clone()
112			{
113			$this->loader = clone $this->loader;
114			$this->builder = new QueryBuilder($this->loader->getQuery(), $this->loader);
115			}
116
117			/**
118			* @deprecated Will be dropped in next major release. Use {@see scope()} instead.
119			*/
120			public function constrain(ConstrainInterface $constrain = null): self
121			{
122			return $this->scope($constrain);
123			}
124
125			/**
126			* Create new Selector with applied scope. By default no scope used.
127			*/
128			public function scope(ScopeInterface $scope = null): self
129			{
130			$this->loader->setScope($scope);
131
132			return $this;
133			}
134
135			/**
136			* Get Query proxy.
137			*
138			* @return QueryBuilder
139			*/
140			public function getBuilder(): QueryBuilder
141			{
142			return $this->builder;
143			}
144
145			/**
146			* Compiled SQL query, changes in this query would not affect Selector state (but binded parameters will).
147			*
148			* @return SelectQuery
149			*/
150			public function buildQuery(): SelectQuery
151			{
152			return $this->loader->buildQuery();
153			}
154
155			/**
156			* Shortcut to where method to set AND condition for entity primary key.
157			*
158			* @param string\|int $id
159			* @return $this\|Select
160			*/
161			public function wherePK($id): self
162			{
163			return $this->__call('where', [$this->loader->getPK(), $id]);
164			}
165
166			/**
167			* Attention, column will be quoted by driver!
168			*
169			* @param string\|null $column When column is null DISTINCT(PK) will be generated.
170			* @return int
171			*/
172			public function count(string $column = null): int
173			{
174			if ($column === null) {
175			// @tuneyourserver solves the issue with counting on queries with joins.
176			$column = sprintf('DISTINCT(%s)', $this->loader->getPK());
177			}
178
179			return (int) $this->__call('count', [$column]);
180			}
181
182			/**
183			* @inheritdoc
184			*/
185			public function limit(int $limit): self
186			{
187			$this->loader->getQuery()->limit($limit);
188
189			return $this;
190			}
191
192			/**
193			* @inheritdoc
194			*/
195			public function offset(int $offset): self
196			{
197			$this->loader->getQuery()->offset($offset);
198
199			return $this;
200			}
201
202			/**
203			* Request primary selector loader to pre-load relation name. Any type of loader can be used
204			* for data pre-loading. ORM loaders by default will select the most efficient way to load
205			* related data which might include additional select query or left join. Loaded data will
206			* automatically pre-populate record relations. You can specify nested relations using "."
207			* separator.
208			*
209			* Examples:
210			*
211			* // Select users and load their comments (will cast 2 queries, HAS_MANY comments)
212			* User::find()->with('comments');
213			*
214			* // You can load chain of relations - select user and load their comments and post related to
215			* //comment
216			* User::find()->with('comments.post');
217			*
218			* // We can also specify custom where conditions on data loading, let's load only public
219			* // comments.
220			* User::find()->load('comments', [
221			* 'where' => ['{@}.status' => 'public']
222			* ]);
223			*
224			* Please note using "{@}" column name, this placeholder is required to prevent collisions and
225			* it will be automatically replaced with valid table alias of pre-loaded comments table.
226			*
227			* // In case where your loaded relation is MANY_TO_MANY you can also specify pivot table
228			* // conditions, let's pre-load all approved user tags, we can use same placeholder for pivot
229			* // table alias
230			* User::find()->load('tags', [
231			* 'wherePivot' => ['{@}.approved' => true]
232			* ]);
233			*
234			* // In most of cases you don't need to worry about how data was loaded, using external query
235			* // or left join, however if you want to change such behaviour you can force load method to
236			* // INLOAD
237			* User::find()->load('tags', [
238			* 'method' => Loader::INLOAD,
239			* 'wherePivot' => ['{@}.approved' => true]
240			* ]);
241			*
242			* Attention, you will not be able to correctly paginate in this case and only ORM loaders
243			* support different loading types.
244			*
245			* You can specify multiple loaders using array as first argument.
246			*
247			* Example:
248			* User::find()->load(['posts', 'comments', 'profile']);
249			*
250			* Attention, consider disabling entity map if you want to use recursive loading (i.e
251			* post.tags.posts), but first think why you even need recursive relation loading.
252			*
253			* @param string\|array $relation
254			* @param array $options
255			* @return $this\|self
256			* @see with()
257			*/
258			public function load($relation, array $options = []): self
259			{
260			if (is_string($relation)) {
261			$this->loader->loadRelation($relation, $options, false, true);
262
263			return $this;
264			}
265
266			foreach ($relation as $name => $subOption) {
267			if (is_string($subOption)) {
268			// array of relation names
269			$this->load($subOption, $options);
270			} else {
271			// multiple relations or relation with addition load options
272			$this->load($name, $subOption + $options);
273			}
274			}
275
276			return $this;
277			}
278
279			/**
280			* With method is very similar to load() one, except it will always include related data to
281			* parent query using INNER JOIN, this method can be applied only to ORM loaders and relations
282			* using same database as parent record.
283			*
284			* Method generally used to filter data based on some relation condition. Attention, with()
285			* method WILL NOT load relation data, it will only make it accessible in query.
286			*
287			* By default joined tables will be available in query based on relation name, you can change
288			* joined table alias using relation option "alias".
289			*
290			* Do not forget to set DISTINCT flag while including HAS_MANY and MANY_TO_MANY relations. In
291			* other scenario you will not able to paginate data well.
292			*
293			* Examples:
294			*
295			* // Find all users who have comments comments
296			* User::find()->with('comments');
297			*
298			* // Find all users who have approved comments (we can use comments table alias in where
299			* statement). User::find()->with('comments')->where('comments.approved', true);
300			*
301			* // Find all users who have posts which have approved comments
302			* User::find()->with('posts.comments')->where('posts_comments.approved', true);
303			*
304			* // Custom join alias for post comments relation
305			* $user->with('posts.comments', [
306			* 'as' => 'comments'
307			* ])->where('comments.approved', true);
308			*
309			* // If you joining MANY_TO_MANY relation you will be able to use pivot table used as relation
310			* // name plus "_pivot" postfix. Let's load all users with approved tags.
311			* $user->with('tags')->where('tags_pivot.approved', true);
312			*
313			* // You can also use custom alias for pivot table as well
314			* User::find()->with('tags', [
315			* 'pivotAlias' => 'tags_connection'
316			* ])
317			* ->where('tags_connection.approved', false);
318			*
319			* You can safely combine with() and load() methods.
320			*
321			* // Load all users with approved comments and pre-load all their comments
322			* User::find()->with('comments')->where('comments.approved', true)->load('comments');
323			*
324			* // You can also use custom conditions in this case, let's find all users with approved
325			* // comments and pre-load such approved comments
326			* User::find()->with('comments')->where('comments.approved', true)
327			* ->load('comments', [
328			* 'where' => ['{@}.approved' => true]
329			* ]);
330			*
331			* // As you might notice previous construction will create 2 queries, however we can simplify
332			* // this construction to use already joined table as source of data for relation via "using"
333			* // keyword
334			* User::find()->with('comments')
335			* ->where('comments.approved', true)
336			* ->load('comments', ['using' => 'comments']);
337			*
338			* // You will get only one query with INNER JOIN, to better understand this example let's use
339			* // custom alias for comments in with() method.
340			* User::find()->with('comments', ['as' => 'commentsR'])
341			* ->where('commentsR.approved', true)
342			* ->load('comments', ['using' => 'commentsR']);
343			*
344			* @param string\|array $relation
345			* @param array $options
346			* @return $this\|Select
347			* @see load()
348			*/
349			public function with($relation, array $options = []): self
350			{
351			if (is_string($relation)) {
352			$this->loader->loadRelation($relation, $options, true, false);
353
354			return $this;
355			}
356
357			foreach ($relation as $name => $subOption) {
358			if (is_string($subOption)) {
359			//Array of relation names
360			$this->with($subOption, []);
361			} else {
362			//Multiple relations or relation with addition load options
363			$this->with($name, $subOption);
364			}
365			}
366
367			return $this;
368			}
369
370			/**
371			* Find one entity or return null. Method provides the ability to configure custom query
372			* parameters. Attention, method does not set a limit on selection (to avoid underselection of
373			* joined tables), make sure to set the constrain in the query.
374			*
375			* @param array\|null $query
376			* @return object\|null
377			*/
378			public function fetchOne(array $query = null)
379			{
380			$data = (clone $this)->where($query)->limit(1)->fetchData();
381
382			if (!isset($data[0])) {
383			return null;
384			}
385
386			return $this->orm->make(
387			$this->loader->getTarget(),
388			$data[0],
389			Node::MANAGED
390			);
391			}
392
393			/**
394			* Fetch all records in a form of array.
395			*
396			* @return object[]
397			*/
398			public function fetchAll(): array
399			{
400			return iterator_to_array($this->getIterator());
401			}
402
403			/**
404			* @return Iterator
405			*/
406			public function getIterator(): Iterator
407			{
408			return new Iterator(
409			$this->orm,
410			$this->loader->getTarget(),
411			$this->fetchData()
412			);
413			}
414
415			/**
416			* Load data tree from database and linked loaders in a form of array.
417			*
418			* @return array
419			*/
420			public function fetchData(): array
421			{
422			$node = $this->loader->createNode();
423			$this->loader->loadData($node);
424
425			return $node->getResult();
426			}
427
428			/**
429			* Compiled SQL statement.
430			*
431			* @return string
432			*/
433			public function sqlStatement(): string
434			{
435			return $this->buildQuery()->sqlStatement();
436			}
437
438			/**
439			* Return base loader associated with the selector.
440			*
441			* @return RootLoader
442			*/
443			private function getLoader(): RootLoader
444			{
445			return $this->loader;
446			}
447			}
448

cycle / orm

Push — master ( abba32...0ee877 )

Select::offset() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like