midorikocak\tabletools\DatabaseTable

Complexity

Total Complexity

11

Size/Duplication

Total Lines	58
Duplicated Lines	0 %

Test Coverage

Coverage

96.3%

Importance

Changes	2
Bugs	1	Features	1

8 Methods

Rating	Name	Duplication	Size	Complexity
A	filter()	0	4	1
A	columns()	0	4	1
A	search()	0	4	1
A	paginate()	0	6	1
A	__construct()	0	4	1
A	sort()	0	4	1
A	run()	0	3	1
A	range()	0	10	4

<?php

declare(strict_types=1);

namespace midorikocak\tabletools;

use midorikocak\nanodb\Database;

class DatabaseTable implements TableInterface
{
    private Database $db;
    private string $name;

    public function __construct(string $name, Database $db)
    {
        $this->db = $db->select($name);
        $this->name = $name;
    }

    public function sort(string $key, $order = 'ASC'): self
    {
        $this->db = $this->db->orderBy($key, $order);
        return $this;
    }

    public function columns($keys): self
    {
        $this->db = $this->db->select($this->name, $keys);
        return $this;
    }

    public function filter(string $key, $value): self
    {
        $this->db->where($key, $value);
        return $this;
    }

    public function search(string $key, $value): self
    {
        // $this->db = $this->db->where($key, $value, 'LIKE');
        return $this;
    }

    public function range(int $offset, ?int $limit = null): self
    {
        if ($offset !== null && $offset !== 0) {
            $this->db = $this->db->offset($offset);
        }
        if ($limit !== null) {
            $this->db = $this->db->limit($limit);
        }

        return $this;
    }

    public function paginate(int $page = 0, int $pageSize = 10): self
    {
        $offset = $page * $pageSize;
        $limit = $pageSize;

        return $this->range($offset, $limit);
    }

    public function run(): array
    {
        return $this->db->fetchAll();
    }
}