Dolphin\Builders\UpdateQueryBuilder

Complexity

Total Complexity

3

Size/Duplication

Total Lines	40
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	update()	0	29	3

<?php
/**
 * The Update Query builder Class.
 *
 * @author RN Kushwaha <rn.kushwaha022@gmail.com>
 * @since v0.0.8 <Date: 09th May, 2019>
 */

namespace Dolphin\Builders;

use Dolphin\Connections\Connection;
use Exception;

/**
 * This class provides the mechanism to build the Insert Queries.
 */
class UpdateQueryBuilder extends QueryBuilder
{
    /**
     * It inserts the new rows
     *
     * @param array $rows
     * @return integer $lastInsertedId
     * @throws Exception
     * @author RN Kushwaha <rn.kushwaha022@gmail.com>
     * @since v0.0.5
     */
    public function update($rows, $table)

The parameter $rows is not used and could be removed.

    {
        $db = Connection::get();

The assignment to $db is dead and can be removed.

        $wqb   = new WhereQueryBuilder();
        $query = "UPDATE ".$table." SET ";
        $ar    = array();

        foreach($row as $key => $val){

The variable $row does not exist. Did you maybe mean $rows?

            $ar[':'.$key] = $val;
            $query.= $this->quote($key)." =:".$key.",";
        }

        $query = rtrim($query, ",");

        try{
            $whereQuery = $wqb->buildAllWhereQuery(
                                $this->where,

The property where does not exist on Dolphin\Builders\UpdateQueryBuilder. Did you mean whereAdded?

                                $this->whereRaw,

The property whereRaw does not exist on Dolphin\Builders\UpdateQueryBuilder. Did you maybe forget to declare it?

                                $this->whereIn,

The property whereIn does not exist on Dolphin\Builders\UpdateQueryBuilder. Did you maybe forget to declare it?

                                $this->whereNotIn,

The property whereNotIn does not exist on Dolphin\Builders\UpdateQueryBuilder. Did you maybe forget to declare it?

                                $this->whereNull,

The property whereNull does not exist on Dolphin\Builders\UpdateQueryBuilder. Did you maybe forget to declare it?

                                $this->whereNotNull

The property whereNotNull does not exist on Dolphin\Builders\UpdateQueryBuilder. Did you maybe forget to declare it?

                            );
            $query.= " ".join(" ", $whereQuery);
            $stmt = Connection::get()->prepare($this->queryPrefix($query));
            $stmt->execute($ar);
            $this->reset();

The method reset() does not exist on Dolphin\Builders\UpdateQueryBuilder.

        } catch(Exception $e){
            throw new Exception($e->getMessage());
        }
    }
}