BulkDelete::bindValues() - Code Metrics - larapulse/database - Measure and Improve Code Quality continuously with Scrutinizer

BulkDelete::bindValues() A
last analyzed 2017-12-12 17:31 UTC

↳ Parent: BulkDelete

Complexity

Conditions	1
Paths	1

Size

Total Lines	12
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	8
nc	1
nop	1
dl	0
loc	12
rs	9.4285
c	0
b	0
f	0

<?php

namespace League\Database\BulkSql;

use PDOStatement;
use League\Database\Traits\BulkSqlTrait;

class BulkDelete extends Base
{
    use BulkSqlTrait;

    const QUERY_TEMPLATE = 'DELETE FROM %s WHERE %s IN (%s)';

    protected function buildQuery(): string
    {
        $this->resetFields();
        $this->resetPreparedItems();

        $fields = array_map(function ($field) {
            return "`{$field}`";
        }, $this->getFields());

        $queryParams = $this->iterateOverItems($this->getPreparedItems(), function ($iteration) use ($fields) {
            return ':'.current($fields).'_'.$iteration;
        });

        return sprintf(
            self::QUERY_TEMPLATE,
            $this->getTable(),
            current($fields),
            implode(',', $queryParams)
        );
    }

    protected function bindValues(PDOStatement $statement)
    {
        $this->resetFields();
        $this->resetPreparedItems();
        $fields = $this->getFields();

        $this->iterateOverItems($this->getPreparedItems(), function ($iteration) use ($statement, $fields) {
            $field = current($fields);
            $value = $this->getPreparedItems()[$iteration][$field] ?? current($this->getPreparedItems()[$iteration]);
            $statement->bindValue(':'.$field.'_'.$iteration, $value);
        });
    }
}


1			<?php
2
3			namespace League\Database\BulkSql;
4
5			use PDOStatement;
6			use League\Database\Traits\BulkSqlTrait;
7
8			class BulkDelete extends Base
9			{
10			use BulkSqlTrait;
11
12			const QUERY_TEMPLATE = 'DELETE FROM %s WHERE %s IN (%s)';
13
14			protected function buildQuery(): string
15			{
16			$this->resetFields();
17			$this->resetPreparedItems();
18
19			$fields = array_map(function ($field) {
20			return "`{$field}`";
21			}, $this->getFields());
22
23			$queryParams = $this->iterateOverItems($this->getPreparedItems(), function ($iteration) use ($fields) {
24			return ':'.current($fields).'_'.$iteration;
25			});
26
27			return sprintf(
28			self::QUERY_TEMPLATE,
29			$this->getTable(),
30			current($fields),
31			implode(',', $queryParams)
32			);
33			}
34
35			protected function bindValues(PDOStatement $statement)
36			{
37			$this->resetFields();
38			$this->resetPreparedItems();
39			$fields = $this->getFields();
40
41			$this->iterateOverItems($this->getPreparedItems(), function ($iteration) use ($statement, $fields) {
42			$field = current($fields);
43			$value = $this->getPreparedItems()[$iteration][$field] ?? current($this->getPreparedItems()[$iteration]);
44			$statement->bindValue(':'.$field.'_'.$iteration, $value);
45			});
46			}
47			}
48

larapulse / database

BulkDelete::bindValues() A last analyzed 2017-12-12 17:31 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

BulkDelete::bindValues() A
last analyzed 2017-12-12 17:31 UTC