Blast\Orm\Query::addColumnValue PHP Method

addColumnValue() public method

Add a value for column on update or insert statement
public addColumnValue ( $column, $value )
$column
$value
    public function addColumnValue($column, $value)
    {
        switch ($this->getType()) {
            case QueryBuilder::INSERT:
                $this->setValue($column, $value);
                break;
            case QueryBuilder::UPDATE:
                $this->set($column, $value);
                break;
        }
        return $this;
    }

Usage Example

Example #1
0
 /**
  *
  * @todo determine exclusion from gateway and integration into query similar to php value convert
  *
  * @param $data
  * @param \Doctrine\DBAL\Schema\Column[] $fields
  * @param Query $query
  */
 protected function addDataToQuery($data, $fields, Query $query)
 {
     foreach ($data as $key => $value) {
         $query->addColumnValue($key, $query->createPositionalParameter($value, array_key_exists($key, $fields) ? $fields[$key]->getType()->getName() : Type::STRING));
     }
 }