Connection::lastInsertId() - Code Metrics - Inspection of "Add types to Schema namespace" - doctrine/dbal - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — develop (#3565)

by Jonathan

created 2019-05-29 14:00 UTC

Connection::lastInsertId() A

↳ Parent: Connection

Complexity

Conditions	2
Paths	2

Size

Total Lines	10
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	6
CRAP Score	2.0625

Importance

Changes

Metric	Value
eloc	5
dl	0
loc	10
ccs	6
cts	8
cp	0.75
rs	10
c	0
b	0
f	0
cc	2
nc	2
nop	1
crap	2.0625

<?php

declare(strict_types=1);

namespace Doctrine\DBAL\Driver\PDOSqlsrv;

use Doctrine\DBAL\Driver\PDOConnection;
use Doctrine\DBAL\Driver\PDOStatement;
use function strpos;
use function substr;

/**
 * Sqlsrv Connection implementation.
 */
class Connection extends PDOConnection
{
    /**
     * {@inheritDoc}
     */
    public function lastInsertId($name = null)
    {
        if ($name === null) {
            return parent::lastInsertId($name);
        }

        $stmt = $this->prepare('SELECT CONVERT(VARCHAR(MAX), current_value) FROM sys.sequences WHERE name = ?');
        $stmt->execute([$name]);

        return $stmt->fetchColumn();
    }

    /**
     * {@inheritDoc}
     */
    public function quote(string $input) : string
    {
        $val = parent::quote($input);

        // Fix for a driver version terminating all values with null byte
        if (strpos($val, "\0") !== false) {
            $val = substr($val, 0, -1);
        }

        return $val;
    }

    /**
     * {@inheritDoc}
     */
    protected function createStatement(\PDOStatement $stmt) : PDOStatement
    {
        return new Statement($stmt);
    }
}


1		<?php
2
3		declare(strict_types=1);
4
5		namespace Doctrine\DBAL\Driver\PDOSqlsrv;
6
7		use Doctrine\DBAL\Driver\PDOConnection;
8		use Doctrine\DBAL\Driver\PDOStatement;
9		use function strpos;
10		use function substr;
11
12		/**
13		* Sqlsrv Connection implementation.
14		*/
15		class Connection extends PDOConnection
16		{
17		/**
18		* {@inheritDoc}
19		*/
20	8	public function lastInsertId($name = null)
21		{
22	8	if ($name === null) {
23	8	return parent::lastInsertId($name);
24		}
25
26	7	$stmt = $this->prepare('SELECT CONVERT(VARCHAR(MAX), current_value) FROM sys.sequences WHERE name = ?');
27	7	$stmt->execute([$name]);
28
29	7	return $stmt->fetchColumn();
30		}
31
32		/**
33		* {@inheritDoc}
34		*/
35	245	public function quote(string $input) : string
36		{
37	245	$val = parent::quote($input);
38
39		// Fix for a driver version terminating all values with null byte
40	245	if (strpos($val, "\0") !== false) {
41		$val = substr($val, 0, -1);
42		}
43
44	245	return $val;
45		}
46
47		/**
48		* {@inheritDoc}
49		*/
50	253	protected function createStatement(\PDOStatement $stmt) : PDOStatement
51		{
52	253	return new Statement($stmt);
53		}
54		}
55

doctrine / dbal

Pull Request — develop (#3565)

Connection::lastInsertId() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like