src\pdodatabase\elementos\Insert

Complexity

Total Complexity

12

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	datos()	0	3	1
A	armarConsulta()	0	19	3
A	sql()	0	3	1
A	setDatos()	0	6	1
A	__construct()	0	3	1
A	estaVacio()	0	5	2
A	columnaVacia()	0	7	3

<?php
namespace src\pdodatabase\elementos;

use Exception;
use src\interfaces\InsertInterface;

class Insert implements InsertInterface
{
    private $_where;

    public function __construct(array $datos)
    {
        $this->_where = $this->setDatos($datos);
    }

    public function sql(): string
    {
        return $this->armarConsulta($this->_where);
    }

    public function datos(): array
    {
        return $this->_where;
    }

    private function setDatos(array $array): array
    {
        $this->estaVacio($array);
        $this->columnaVacia($array);

        return $array;
    }

    private function estaVacio(array $array): void
    {
        if (count($array) == 0)
        {
            throw new Exception("Error Processing Request");
        }
    }

    private function columnaVacia(array $array): void
    {
        foreach ($array as $key => $value)
        {
            if(empty($key))
            {
                throw new Exception("Error Processing Request");   
            }
        }
    }

    private function armarConsulta(array $array): string
    {
        $keys = array_keys($array);
        $values = '';
        $x=1;

        foreach($array as $field)
        {
            $values.= "?";

            if($x < count($array))
            {
                $values.= ', ';
            }

            $x++;
        }

        return "(`". implode('`, `', $keys) ."`) VALUES ({$values})";
    }
}