QueryExtractor::__construct() - Code Metrics - Inspection of "Adding Doctrine examples" - umpirsky/Extraload - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#17)

unknown

created 2018-04-23 09:34 UTC

QueryExtractor::__construct() A

↳ Parent: QueryExtractor

Complexity

Conditions	2
Paths	2

Size

Total Lines	16
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	16
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	10
nc	2
nop	3

<?php

namespace Extraload\Extractor\Doctrine;

use Doctrine\DBAL\Connection;
use Extraload\Extractor\ExtractorInterface;

class QueryExtractor implements ExtractorInterface
{
    protected $stmt;

    protected $position;

    protected $data;

    public function __construct(Connection $conn, string $sql, array $values = [])
    {
        $this->stmt = $conn->prepare($sql);
        foreach ($values as $value) {
            $this->stmt->bindValue(
                $value['parameter'],
                $value['value'],
                $value['data_type'] ?? null
            );
        }
        $this->stmt->execute();

        $this->position = 0;

        $this->data = [];
    }

    public function extract()
    {
        if (count($this->data) >= $this->stmt->rowCount()) {
            return;
        }
        $this->data[$this->position] = $this->stmt->fetch();
        $data = $this->current();
        $this->next();

        return $data;
    }

    public function current()
    {
        return $this->data[$this->position];
    }

    public function key()
    {
        return $this->position;
    }

    public function next()
    {
        $this->position += 1;
    }

    public function rewind()
    {
        $this->position = 0;
    }

    public function valid()
    {
        return isset($this->data[$this->position]);
    }
}


1			<?php
2
3			namespace Extraload\Extractor\Doctrine;
4
5			use Doctrine\DBAL\Connection;
6			use Extraload\Extractor\ExtractorInterface;
7
8			class QueryExtractor implements ExtractorInterface
9			{
10			protected $stmt;
11
12			protected $position;
13
14			protected $data;
15
16			public function __construct(Connection $conn, string $sql, array $values = [])
17			{
18			$this->stmt = $conn->prepare($sql);
19			foreach ($values as $value) {
20			$this->stmt->bindValue(
21			$value['parameter'],
22			$value['value'],
23			$value['data_type'] ?? null
24			);
25			}
26			$this->stmt->execute();
27
28			$this->position = 0;
29
30			$this->data = [];
31			}
32
33			public function extract()
34			{
35			if (count($this->data) >= $this->stmt->rowCount()) {
36			return;
37			}
38			$this->data[$this->position] = $this->stmt->fetch();
39			$data = $this->current();
40			$this->next();
41
42			return $data;
43			}
44
45			public function current()
46			{
47			return $this->data[$this->position];
48			}
49
50			public function key()
51			{
52			return $this->position;
53			}
54
55			public function next()
56			{
57			$this->position += 1;
58			}
59
60			public function rewind()
61			{
62			$this->position = 0;
63			}
64
65			public function valid()
66			{
67			return isset($this->data[$this->position]);
68			}
69			}
70

umpirsky / Extraload

Pull Request — master (#17)

QueryExtractor::__construct() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like