WebServCo\Framework\Traits\DatabaseTrait::generateAddQuery()

Complexity

Conditions	6
Paths	8

Size

Total Lines	31
Code Lines	24

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    protected function generateAddQuery($queryType, $tableName, $data)
    {
        $multiDimensional = is_array($data[key($data)]);
        
        list($keys, $data) = $this->getKeysValues($data);
        
        switch ($queryType) {
            case self::QUERY_TYPE_REPLACE:

The constant WebServCo\Framework\Traits\DatabaseTrait::QUERY_TYPE_REPLACE was not found. Maybe you did not declare it correctly or list all dependencies?

                $query = self::QUERY_TYPE_REPLACE . ' INTO';
                break;
            case self::QUERY_TYPE_INSERT_IGNORE:

The constant WebServCo\Framework\Traits\DatabaseTrait::QUERY_TYPE_INSERT_IGNORE was not found. Maybe you did not declare it correctly or list all dependencies?

                $query = self::QUERY_TYPE_INSERT_IGNORE . ' INTO';
                break;
            case self::QUERY_TYPE_INSERT:

The constant WebServCo\Framework\Traits\DatabaseTrait::QUERY_TYPE_INSERT was not found. Maybe you did not declare it correctly or list all dependencies?

            default:
                $query = self::QUERY_TYPE_INSERT . ' INTO';
                break;
        }
        $query .= ' '.$this->escapeIdentifier($tableName).' (' .

It seems like escapeIdentifier() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        implode(', ', array_map([$this, 'escapeIdentifier'], $keys)) .
        ') VALUES';
        if ($multiDimensional) {
            $valuesStrings = [];
            foreach ($data as $item) {
                $valuesStrings[] = $this->generateValuesString($item);
            }
            $query .= implode(', ', $valuesStrings);
        } else {
            $query .= $this->generateValuesString($data);
        }
        return $query;
    }