BfwSql\SqlInsert

Complexity

Total Complexity

6

Size/Duplication

Total Lines	55
Duplicated Lines	27.27 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	14	14	2
B	assembleRequest()	0	26	4

<?php

namespace BfwSql;

/**
 * Class to write INSERT INTO queries
 * 
 * @package bfw-sql
 * @author Vermeulen Maxime <bulton.fr@gmail.com>
 * @version 2.0
 */
class SqlInsert extends SqlActions
{
    /**
     * Constructor
     * 
     * @param \BfwSql\SqlConnect $sqlConnect Instance of SGBD connexion
     * @param string             $tableName  The table name used for query
     * @param array              $columns    (default: null) Datas to add
     *  Format is array('columnName' => 'value', ...);
     */
    public function __construct(

This method seems to be duplicated in your project.

        SqlConnect $sqlConnect,
        $tableName,
        $columns = null
    ) {
        parent::__construct($sqlConnect);
        
        $prefix          = $sqlConnect->getConnectionInfos()->tablePrefix;
        $this->tableName = $prefix.$tableName;
        
        if (is_array($columns)) {
            $this->columns = $columns;
        }
    }
    
    /**
     * {@inheritdoc}
     */
    protected function assembleRequest()
    {
        $lstColumns    = '';
        $lstValues     = '';
        $indexReadList = -1;
        
        foreach ($this->columns as $columnName => $columnValue) {
            $indexReadList++;
            if ($indexReadList > 0) {
                $lstColumns .= ',';
                $lstValues  .= ',';
            }
            
            $lstColumns .= '`'.$columnName.'`';
            $lstValues  .= $columnValue;
        }
        
        $this->assembledRequest = 'INSERT INTO '.$this->tableName;
        
        if ($this->columns !== []) {
            $this->assembledRequest .= ' ('.$lstColumns.')'
                .' VALUES ('.$lstValues.')';
        }
        
        $this->callObserver();
    }
}