PdoExtractorTrait::getLimitOffsetBit() - Code Metrics - Inspection of "fix batch extract" - fab2s/YaEtl - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 8edad9...f8fafa )

by Fabrice

created 2017-04-06 13:55 UTC

PdoExtractorTrait::getLimitOffsetBit() A

↳ Parent: Project

Complexity

Conditions	4
Paths	1

Size

Total Lines	8
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	8
rs	9.2
cc	4
eloc	5
nc	1
nop	0

<?php

/*
 * This file is part of YaEtl.
 *     (c) Fabrice de Stefanis / https://github.com/fab2s/YaEtl
 * This source file is licensed under the MIT license which you will
 * find in the LICENSE file or at https://opensource.org/licenses/MIT
 */

namespace fab2s\YaEtl\Extractors;

/**
 * trait PdoExtractorTrait
 */
trait PdoExtractorTrait
{
    /**
     * @var \PDO
     */
    protected $pdo;

    /**
     * @var bool
     */
    protected $driverBufferedQuery;

    /**
     * @var array
     */
    protected $supportedDrivers = [
        'mysql'  => 'mysql',
        'sqlite' => 'sqlite',
        'pgsql'  => 'pgsql',
    ];

    /**
     * @var string
     */
    protected $dbDriverName;

    /**
     * @var array
     */
    protected $queryBindings;

    /**
     * leave no trace
     */
    public function __destruct()
    {
        if ($this->dbDriverName === 'mysql' && $this->driverBufferedQuery) {
            // set driver state back to where we met
            $this->pdo->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
        }
    }

    /**
     * @param \PDO $pdo
     */
    public function configurePdo(\PDO $pdo)
    {
        $this->pdo          = $pdo;
        $this->dbDriverName = $this->pdo->getAttribute(\PDO::ATTR_DRIVER_NAME);

        if (!isset($this->supportedDrivers[$this->dbDriverName])) {
            throw new \Exception('[YaEtl] Pdo driver not supported, must be one of: ' . \implode(', ', \array_keys($this->supportedDrivers)));
        }

        if ($this->dbDriverName === 'mysql') {
            // buffered wueries can have great performance impact
            // with large data sets
            $this->driverBufferedQuery = $this->pdo->getAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY);

            if ($this->driverBufferedQuery) {
                // disable buffered queries as we should be querying by a lot
                $this->pdo->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
            }
        }
    }
}


1			<?php
2
3			/*
4			* This file is part of YaEtl.
5			* (c) Fabrice de Stefanis / https://github.com/fab2s/YaEtl
6			* This source file is licensed under the MIT license which you will
7			* find in the LICENSE file or at https://opensource.org/licenses/MIT
8			*/
9
10			namespace fab2s\YaEtl\Extractors;
11
12			/**
13			* trait PdoExtractorTrait
14			*/
15			trait PdoExtractorTrait
16			{
17			/**
18			* @var \PDO
19			*/
20			protected $pdo;
21
22			/**
23			* @var bool
24			*/
25			protected $driverBufferedQuery;
26
27			/**
28			* @var array
29			*/
30			protected $supportedDrivers = [
31			'mysql' => 'mysql',
32			'sqlite' => 'sqlite',
33			'pgsql' => 'pgsql',
34			];
35
36			/**
37			* @var string
38			*/
39			protected $dbDriverName;
40
41			/**
42			* @var array
43			*/
44			protected $queryBindings;
45
46			/**
47			* leave no trace
48			*/
49			public function __destruct()
50			{
51			if ($this->dbDriverName === 'mysql' && $this->driverBufferedQuery) {
52			// set driver state back to where we met
53			$this->pdo->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
54			}
55			}
56
57			/**
58			* @param \PDO $pdo
59			*/
60			public function configurePdo(\PDO $pdo)
61			{
62			$this->pdo = $pdo;
63			$this->dbDriverName = $this->pdo->getAttribute(\PDO::ATTR_DRIVER_NAME);
64
65			if (!isset($this->supportedDrivers[$this->dbDriverName])) {
66			throw new \Exception('[YaEtl] Pdo driver not supported, must be one of: ' . \implode(', ', \array_keys($this->supportedDrivers)));
67			}
68
69			if ($this->dbDriverName === 'mysql') {
70			// buffered wueries can have great performance impact
71			// with large data sets
72			$this->driverBufferedQuery = $this->pdo->getAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY);
73
74			if ($this->driverBufferedQuery) {
75			// disable buffered queries as we should be querying by a lot
76			$this->pdo->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
77			}
78			}
79			}
80			}
81

fab2s / YaEtl

Push — master ( 8edad9...f8fafa )

PdoExtractorTrait::getLimitOffsetBit() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like