Lagdo\DbAdmin\Db\Traits\SelectTrait

Complexity

Total Complexity

4

Size/Duplication

Total Lines	63
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	selectFacade()	0	3	1
A	countSelect()	0	6	1
A	getSelectData()	0	6	1
A	execSelect()	0	6	1

<?php

namespace Lagdo\DbAdmin\Db\Traits;

use Lagdo\DbAdmin\Db\Facades\SelectFacade;
use Lagdo\DbAdmin\Db\Facades\Select\SelectEntity;
use Exception;

/**
 * Facade to table select functions
 */
trait SelectTrait
{
    use AbstractTrait;

    /**
     * Get the facade
     *
     * @return SelectFacade
     */
    protected function selectFacade(): SelectFacade
    {
        return $this->di()->g(SelectFacade::class);
    }

    /**
     * Get required data for create/update on tables
     *
     * @param string $table The table name
     * @param array $queryOptions The query options
     *
     * @return SelectEntity
     * @throws Exception
     */
    public function getSelectData(string $table, array $queryOptions = []): SelectEntity
    {
        $this->connectToSchema();
        $this->utils->input->table = $table;
        $this->utils->input->values = $queryOptions;
        return $this->selectFacade()->getSelectData($table, $queryOptions);
    }

    /**
     * Get required data for create/update on tables
     *
     * @param string $table The table name
     * @param array $queryOptions The query options
     *
     * @return int
     * @throws Exception
     */
    public function countSelect(string $table, array $queryOptions = []): int
    {
        $this->connectToSchema();
        $this->utils->input->table = $table;
        $this->utils->input->values = $queryOptions;
        return $this->selectFacade()->countSelect($table, $queryOptions);
    }

    /**
     * Get required data for create/update on tables
     *
     * @param string $table The table name
     * @param array $queryOptions The query options
     *
     * @return array
     * @throws Exception
     */
    public function execSelect(string $table, array $queryOptions = []): array
    {
        $this->connectToSchema();
        $this->utils->input->table = $table;
        $this->utils->input->values = $queryOptions;
        return $this->selectFacade()->execSelect($table, $queryOptions);
    }
}