Keep\Statement

Complexity

Total Complexity

7

Size/Duplication

Total Lines	50
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	update()	0	17	3
A	create()	0	8	1
A	select()	0	4	1
A	all()	0	4	1
A	delete()	0	4	1

<?php

namespace Keep;

trait Statement
{
    private $statement;
    private $attributes = [];

    public function create(string $table, array $attributes): self
    {
        $this->attributes = $attributes;
        $this->statement  = 'INSERT INTO `' . $table . '` (`';
        $this->statement .= Tool::getAttributesKey($attributes);
        $this->statement .= '`) VALUES (:';
        $this->statement .= Tool::getAttributesValue($attributes) . ')';
        return $this;
    }

    public function all(string $table): self
    {
        $this->statement = "SELECT * FROM `{$table}`";
        return $this;
    }

    public function select(string $table, array $columns): self
    {
        $this->statement = 'SELECT `' . Tool::columns($columns) . "` FROM `{$table}`";
        return $this;
    }

    public function update(string $table, array $attributes): self
    {
        $this->attributes = $attributes;

        $set = '';
        $key = array_keys($attributes);
        $pop = array_pop($key);

        foreach ($attributes as $key => $value) {
            $set .= ($key == $pop) ? '' : "`{$key}` = :{$key}, ";
        }

        $set .= "`{$pop}` = :{$pop}";

        $this->statement = "UPDATE `{$table}` SET {$set}";

        return $this;
    }

    public function delete(string $table): self
    {
        $this->statement = "DELETE FROM `{$table}`";
        return $this;
    }
}