Dolphin\Builders\UpdateQueryBuilder::update()

Complexity

Conditions	3
Paths	10

Size

Total Lines	39
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function update(
      $row,
      $table,
      $where,
      $whereRaw,
      $whereIn,
      $whereNotIn,
      $whereNull,
      $whereNotNull
    ): bool
    {
        $wqb   = new WhereQueryBuilder();
        $query = "UPDATE ".$table." SET ";
        $ar    = [];

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

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

        try{
            $whereQuery = $wqb->buildAllWhereQuery(
                                $where,
                                $whereRaw,
                                $whereIn,
                                $whereNotIn,
                                $whereNull,
                                $whereNotNull
                            );
            $query.= " ".join(" ", $whereQuery);
            $stmt = Connection::get()->prepare($this->queryPrefix($query));
            $stmt->execute($ar);
        } catch(Exception $e){
            throw new Exception($e->getMessage());
        }

        return true;
    }