CommandTest::testGetParams() - Code Metrics - Inspection of "Add Command statement type" - abterphp/qb - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( 0c2f80...877d81 )

by Peter

created 2021-06-27 21:08 UTC

CommandTest::testGetParams() A

↳ Parent: CommandTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	16
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	9
c	1
b	0
f	0
nc	1
nop	0
dl	0
loc	16
rs	9.9666

<?php

declare(strict_types=1);

namespace QB\Generic\Statement;

use PDO;
use PHPUnit\Framework\TestCase;
use QB\Generic\Clause\Column;
use QB\Generic\Expr\Expr;

class CommandTest extends TestCase
{
    public function testToStringSimple()
    {
        $command = 'BEGIN TRANSACTION';

        $query = new Command($command);

        $sql = (string)$query;

        $this->assertSame($command, $sql);
    }

    public function testGetParams()
    {
        $command = 'EXPLAIN %s';

        $query = (new Select())->addColumns(new Column(new Expr('?', [2])));

        $query = new Command($command, $query);

        $sql    = (string)$query;
        $params = $query->getParams();

        $expectedSql = 'EXPLAIN SELECT ?';
        $expectedParams = [[2, PDO::PARAM_INT]];

        $this->assertSame($expectedSql, $sql);
        $this->assertSame($expectedParams, $params);
    }

    /**
     * @param string ...$tables
     *
     * @return IDelete
     */
    protected function getSut(string ...$tables): IDelete
    {
        return (new Delete())->addFrom(...$tables);
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace QB\Generic\Statement;
6
7			use PDO;
8			use PHPUnit\Framework\TestCase;
9			use QB\Generic\Clause\Column;
10			use QB\Generic\Expr\Expr;
11
12			class CommandTest extends TestCase
13			{
14			public function testToStringSimple()
15			{
16			$command = 'BEGIN TRANSACTION';
17
18			$query = new Command($command);
19
20			$sql = (string)$query;
21
22			$this->assertSame($command, $sql);
23			}
24
25			public function testGetParams()
26			{
27			$command = 'EXPLAIN %s';
28
29			$query = (new Select())->addColumns(new Column(new Expr('?', [2])));
30
31			$query = new Command($command, $query);
32
33			$sql = (string)$query;
34			$params = $query->getParams();
35
36			$expectedSql = 'EXPLAIN SELECT ?';
37			$expectedParams = [[2, PDO::PARAM_INT]];
38
39			$this->assertSame($expectedSql, $sql);
40			$this->assertSame($expectedParams, $params);
41			}
42
43			/**
44			* @param string ...$tables
45			*
46			* @return IDelete
47			*/
48			protected function getSut(string ...$tables): IDelete
49			{
50			return (new Delete())->addFrom(...$tables);
51			}
52			}
53

abterphp / qb

Push — main ( 0c2f80...877d81 )

CommandTest::testGetParams() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like