ntentan\nibii\QueryEngine

Complexity

Total Complexity

12

Size/Duplication

Total Lines	107
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	0

Test Coverage

Coverage

47.46%

Importance

Changes	10
Bugs	0	Features	5

8 Methods

Rating	Name	Duplication	Size	Complexity
A	setDriver()	0	4	1
A	filter()	0	4	1
A	getBulkUpdateQuery()	0	14	2
A	getSelectQuery()	0	13	1
A	getCountQuery()	0	9	1
A	getDeleteQuery()	0	9	1
A	getInsertQuery()	0	17	2
B	getUpdateQuery()	0	24	3

<?php
namespace ntentan\nibii;

class QueryEngine
{

    private $db;

    public function setDriver($driver)
    {
        $this->db = $driver;
    }
    
    private function filter($query)

The return type could not be reliably inferred; please add a @return annotation.

    {
        return $query;
    }

    public function getInsertQuery($model)

The return type could not be reliably inferred; please add a @return annotation.

    {
        $data = $model->getData();
        $fields = array_keys($data[0]);
        $quotedFields = [];
        $valueFields = [];

        foreach ($fields as $field) {
            $quotedFields[] = $this->db->quoteIdentifier($field);
            $valueFields[] = ":{$field}";
        }

        return $this->filter(
            "INSERT INTO " . $this->db->quoteIdentifier($model->getTable()) .
            " (" . implode(", ", $quotedFields) . ") VALUES (" . implode(', ', $valueFields) . ")"
        );
    }

    public function getBulkUpdateQuery($data, $parameters)

The return type could not be reliably inferred; please add a @return annotation.

    {
        $updateData = [];
        foreach($data as $field => $value) {
            $updateData[] = "{$this->db->quoteIdentifier($field)} = :$field";
        }

        return $this->filter(sprintf(
            "UPDATE %s SET %s %s",
            $parameters->getTable(),
            implode(', ', $updateData),
            $parameters->getWhereClause()
        ));
    }

    public function getUpdateQuery($model)

The return type could not be reliably inferred; please add a @return annotation.

    {
        $data = $model->getData();
        $fields = array_keys($data[0]);
        $valueFields = [];
        $conditions = [];
        $primaryKey = $model->getDescription()->getPrimaryKey();

        foreach ($fields as $field) {
            $quotedField = $this->db->quoteIdentifier($field);

            if(array_search($field, $primaryKey) !== false) {
                $conditions[] = "{$quotedField} = :{$field}";
            } else {
                $valueFields[] = "{$quotedField} = :{$field}";
            }
        }

        return $this->filter("UPDATE " .
            $this->db->quoteIdentifier($model->getTable()) .
            " SET " . implode(', ', $valueFields) .
            " WHERE " . implode(' AND ', $conditions)
        );
    }

    public function getSelectQuery($parameters)

The return type could not be reliably inferred; please add a @return annotation.

    {
        return $this->filter(sprintf(
                "SELECT %s FROM %s%s%s%s%s",
                $parameters->getFields(),
                $parameters->getTable(),
                $parameters->getWhereClause(),
                $parameters->getSorts(),
                $parameters->getLimit(),
                $parameters->getOffset()
            )
        );
    }
    
    public function getCountQuery($parameters)

The return type could not be reliably inferred; please add a @return annotation.

    {
        return $this->filter(sprintf(
                "SELECT count(*) as count FROM %s%s",
                $parameters->getTable(),
                $parameters->getWhereClause()
            )
        );
    }

    public function getDeleteQuery($parameters)

The return type could not be reliably inferred; please add a @return annotation.

    {
        return $this->filter(sprintf(
                "DELETE FROM %s%s",
                $parameters->getTable(),
                $parameters->getWhereClause()
            )
        );
    }
}