TechDivision\Import\Utils\ColumnSanitizerTest

Complexity

Total Complexity

7

Size/Duplication

Total Lines	97
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	4	1
A	testExecuteGivenMoreThanAllowedColumnsReturnsOnlAllowedColumns()	0	9	1
A	testExecuteGivenEmptyRowReturnsEmptyRow()	0	9	1
A	testExecuteGivenEmptyStatementReturnsEmptyRow()	0	9	1
A	testExecuteGivenAllAllowedColumnsReturnsAllColumns()	0	9	1
A	testExecuteGivenLessColumnsThanAllowedReturnsOnlyAllowedGivenColumns()	0	9	1
A	testExecuteGivenSpecialColumnReturnsDataIncludingSpecialColumn()	0	19	1

<?php

/**
 * TechDivision\Import\Utils\ColumnSanitizerTest
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is available through the world-wide-web at this URL:
 * http://opensource.org/licenses/osl-3.0.php
 *
 * PHP version 7
 *
 * @author    Team CSI <csi-kolbermoor@techdivision.com>
 * @copyright 2020 TechDivision GmbH <info@techdivision.com>
 * @license   http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */

namespace TechDivision\Import\Utils;

use PHPUnit\Framework\TestCase;

/**
 * Test class for the column sanitizer utility.
 *
 * @author    Team CSI <csi-kolbermoor@techdivision.com>
 * @copyright 2020 TechDivision GmbH <info@techdivision.com>
 * @license   http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
 * @link      https://github.com/techdivision/import
 * @link      http://www.techdivision.com
 */
class ColumnSanitizerTest extends TestCase
{

    /**
     * The utility we want to test.
     *
     * @var \TechDivision\Import\Utils\SanitizerInterface

The type TechDivision\Import\Utils\SanitizerInterface was not found. Maybe you did not declare it correctly or list all dependencies?

     */
    protected $columnSanitizer;

    /**
     * Sets up the fixture, for example, open a network connection.
     * This method is called before a test is executed.
     *
     * @return void
     * @see \PHPUnit\Framework\TestCase::setUp()
     */
    protected function setUp()
    {
        // initialize the utility we want to test
        $this->columnSanitizer = new ColumnSanitizer();
    }

    public function testExecuteGivenEmptyRowReturnsEmptyRow()
    {
        $query = 'UPDATE some_table SET column_1=:column_1, column_2=:column_2 WHERE condition=:value';
        $row = [];
        $expected = [];

        $actual = $this->columnSanitizer->execute($row, $query);

        $this->assertEquals($expected, $actual);
    }

    public function testExecuteGivenEmptyStatementReturnsEmptyRow()
    {
        $query = '';
        $row = ['column_1' => 'foo', 'value' => 'bar'];
        $expected = [];

        $actual = $this->columnSanitizer->execute($row, $query);

        $this->assertEquals($expected, $actual);
    }

    public function testExecuteGivenLessColumnsThanAllowedReturnsOnlyAllowedGivenColumns()
    {
        $query = 'UPDATE some_table SET column_1=:column_1, column_2=:column_2 WHERE condition=:value';
        $row = ['column_1' => 'foo', 'value' => 'bar'];
        $expected = ['column_1' => 'foo', 'value' => 'bar'];

        $actual = $this->columnSanitizer->execute($row, $query);

        $this->assertEquals($expected, $actual);
    }

    public function testExecuteGivenAllAllowedColumnsReturnsAllColumns()
    {
        $query = 'UPDATE some_table SET column_1=:column_1, column_2=:column_2 WHERE condition=:value';
        $row = ['column_1' => 'foo', 'column_2' => 'baz', 'value' => 'bar'];
        $expected = ['column_1' => 'foo', 'column_2' => 'baz', 'value' => 'bar'];

        $actual = $this->columnSanitizer->execute($row, $query);

        $this->assertEquals($expected, $actual);
    }

    public function testExecuteGivenMoreThanAllowedColumnsReturnsOnlAllowedColumns()
    {
        $query = 'UPDATE some_table SET column_1=:column_1, column_2=:column_2 WHERE condition=:value';
        $row = ['column_1' => 'foo', 'column_2' => 'baz', 'value' => 'bar', 'additional' => 'another value'];
        $expected = ['column_1' => 'foo', 'column_2' => 'baz', 'value' => 'bar'];

        $actual = $this->columnSanitizer->execute($row, $query);

        $this->assertEquals($expected, $actual);
    }

    public function testExecuteGivenSpecialColumnReturnsDataIncludingSpecialColumn()
    {
        $query = 'UPDATE some_table SET column_1=:column_1, column_2=:column_2 WHERE condition=:value';
        $row = [
            'column_1' => 'foo',
            'column_2' => 'baz',
            'value' => 'bar',
            'techdivision_import_utils_entityStatus_memberName' => 'update',
        ];
        $expected = [
            'column_1' => 'foo',
            'column_2' => 'baz',
            'value' => 'bar',
            'techdivision_import_utils_entityStatus_memberName' => 'update',
        ];

        $actual = $this->columnSanitizer->execute($row, $query);

        $this->assertEquals($expected, $actual);
    }
}