vakata\database\driver\pdo\Statement::execute()

Complexity

Conditions	11
Paths	24

Size

Total Lines	41
Code Lines	30

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function execute(array $data = []) : ResultInterface
    {
        $data = array_values($data);
        //var_dump($data);
        foreach ($data as $i => $v) {
            switch (gettype($v)) {
                case 'boolean':
                    $this->statement->bindValue($i+1, $v, \PDO::PARAM_BOOL);
                    break;
                case 'integer':
                    $this->statement->bindValue($i+1, $v, \PDO::PARAM_INT);
                    break;
                case 'NULL':
                    $this->statement->bindValue($i+1, $v, \PDO::PARAM_NULL);
                    break;
                case 'double':
                    $this->statement->bindValue($i+1, $v);
                    break;
                default:
                    // keep in mind oracle needs a transaction when inserting LOBs, aside from the specific syntax:
                    // INSERT INTO table (column, lobcolumn) VALUES (?, ?, EMPTY_BLOB()) RETURNING lobcolumn INTO ?
                    if (is_resource($v) && get_resource_type($v) === 'stream') {
                        $this->statement->bindParam($i+1, $v, \PDO::PARAM_LOB);
                        continue;
                    }
                    if (!is_string($data[$i])) {
                        $data[$i] = serialize($data[$i]);
                    }
                    $this->statement->bindValue($i+1, $v);
                    break;
            }
        }
        try {
            if (!$this->statement->execute()) {
                throw new DBException('Prepared execute error');
            }
        } catch (\Exception $e) {
            throw new DBException($e->getMessage());
        }
        return new Result($this->statement, $this->driver);
    }
}