InsertTest::testInsertComplex() - Code Metrics - Inspection of "Insert improvements" - abterphp/qb - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( 4b03c8...85c7ac )

by Peter

created 2021-06-27 17:55 UTC

InsertTest::testInsertComplex() A

↳ Parent: InsertTest::testComplex()

Complexity

Conditions	1
Paths	1

Size

Total Lines	15
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	10
c	1
b	0
f	0
nc	1
nop	0
dl	0
loc	15
rs	9.9332

<?php

declare(strict_types=1);

namespace QB\Generic\Statement;

use PHPUnit\Framework\TestCase;

class InsertTest extends TestCase
{
    public function testInsertSimple()
    {
        $sql = (string)$this->getSut('foo')->addValues('1234', '2345');

        $parts   = [];
        $parts[] = 'INSERT INTO foo';
        $parts[] = 'VALUES (?, ?)';

        $expectedSql = implode(PHP_EOL, $parts);

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

    public function testComplex()
    {
        $sql = (string)$this->getSut('foo')
            ->addModifier('BAR')
            ->addColumns('id', 'bar_id', 'baz')
            ->addValues('1234', '2345', 'a')
            ->addValues('3456', '4567', 'b');

        $parts   = [];
        $parts[] = 'INSERT BAR INTO foo (id, bar_id, baz)';
        $parts[] = 'VALUES (?, ?, ?),';
        $parts[] = '(?, ?, ?)';

        $expectedSql = implode(PHP_EOL, $parts);

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

    /**
     * @param string $table
     *
     * @return IInsert
     */
    protected function getSut(string $table): IInsert
    {
        return (new Insert())->setInto($table);
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace QB\Generic\Statement;
6
7			use PHPUnit\Framework\TestCase;
8
9			class InsertTest extends TestCase
10			{
11			public function testInsertSimple()
12			{
13			$sql = (string)$this->getSut('foo')->addValues('1234', '2345');
14
15			$parts = [];
16			$parts[] = 'INSERT INTO foo';
17			$parts[] = 'VALUES (?, ?)';
18
19			$expectedSql = implode(PHP_EOL, $parts);
20
21			$this->assertSame($expectedSql, $sql);
22			}
23
24			public function testComplex()
25			{
26			$sql = (string)$this->getSut('foo')
27			->addModifier('BAR')
28			->addColumns('id', 'bar_id', 'baz')
29			->addValues('1234', '2345', 'a')
30			->addValues('3456', '4567', 'b');
31
32			$parts = [];
33			$parts[] = 'INSERT BAR INTO foo (id, bar_id, baz)';
34			$parts[] = 'VALUES (?, ?, ?),';
35			$parts[] = '(?, ?, ?)';
36
37			$expectedSql = implode(PHP_EOL, $parts);
38
39			$this->assertSame($expectedSql, $sql);
40			}
41
42			/**
43			* @param string $table
44			*
45			* @return IInsert
46			*/
47			protected function getSut(string $table): IInsert
48			{
49			return (new Insert())->setInto($table);
50			}
51			}
52

abterphp / qb

Push — main ( 4b03c8...85c7ac )

InsertTest::testInsertComplex() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like