Tests\Werkspot\BingAdsApiBundle\Api\Helper\CsvTest

Complexity

Total Complexity

9

Size/Duplication

Total Lines	124
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	6
Bugs	0	Features	0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	testArrayToCsvLine()	0	15	1
A	getCsvArray()	0	20	1
A	testRemoveOneLastLine()	0	9	1
A	testRemoveTwoLastLine()	0	9	1
A	testFixDate()	0	15	1
A	testRemoveAllHeaders()	0	14	1
A	testRemoveFileHeaders()	0	15	1
A	testRemoveAllHeadersInCount()	0	8	1
A	testRemoveFileHeadersAsCount()	0	8	1

<?php

namespace Tests\Werkspot\BingAdsApiBundle\Api\Helper;

use PHPUnit_Framework_TestCase;
use Werkspot\BingAdsApiBundle\Api\Helper\Csv;

class CsvTest extends PHPUnit_Framework_TestCase
{
    public function testRemoveOneLastLine()
    {
        $csvArray = $this->getCsvArray();

        $csvHelper = new Csv();
        $result = $csvHelper->removeLastLines($csvArray);

        $this->assertEquals((count($csvArray) - 1), count($result));
    }

    public function testRemoveTwoLastLine()
    {
        $csvArray = $this->getCsvArray();

        $csvHelper = new Csv();
        $result = $csvHelper->removeLastLines($csvArray, 2);

        $this->assertEquals((count($csvArray) - 2), count($result));
    }

    public function testFixDate()
    {
        $csvArray = [
            '"11/11/1988","account_1","1","group 1","1","0","EUR","0.00","Italy","","Bolzano","","Bolzano"',
            '"4/22/2007","account_1","2","group 2","4","0","EUR","0.00","Italy","","Milan","","Milan"',
        ];
        $csvHelper = new Csv();
        $result = $csvHelper->convertDateMDYtoYMD($csvArray);

        $expectedResult = [
            "\"1988/11/11\",\"account_1\",\"1\",\"group 1\",\"1\",\"0\",\"EUR\",\"0.00\",\"Italy\",\"\",\"Bolzano\",\"\",\"Bolzano\"\r\n",
            "\"2007/04/22\",\"account_1\",\"2\",\"group 2\",\"4\",\"0\",\"EUR\",\"0.00\",\"Italy\",\"\",\"Milan\",\"\",\"Milan\"\r\n",
        ];
        $this->assertEquals($expectedResult, $result);
    }

    public function testRemoveAllHeaders()
    {
        $csvArray = $this->getCsvArray();
        $csvHelper = new Csv();
        $result = $csvHelper->removeHeaders($csvArray);

        $expectedResult = [
            '"11/11/1988","account_1","1","group 1","1","0","EUR","0.00","Italy","","Bolzano","","Bolzano"',
            '"4/22/2007","account_1","2","group 2","4","0","EUR","0.00","Italy","","Milan","","Milan"',
            '',
            '"©2016 Microsoft Corporation. All rights reserved. "',
        ];
        $this->assertEquals($expectedResult, $result);
    }

    public function testRemoveFileHeaders()
    {
        $csvArray = $this->getCsvArray();
        $csvHelper = new Csv();
        $result = $csvHelper->removeHeaders($csvArray, false);

        $expectedResult = [
            '"GregorianDate","AccountName","AdGroupId","AdGroupName","Impressions","Clicks","CurrencyCode","Spend","CountryOrRegion","City","State","MetroArea","MostSpecificLocation"',
            '"11/11/1988","account_1","1","group 1","1","0","EUR","0.00","Italy","","Bolzano","","Bolzano"',
            '"4/22/2007","account_1","2","group 2","4","0","EUR","0.00","Italy","","Milan","","Milan"',
            '',
            '"©2016 Microsoft Corporation. All rights reserved. "',
        ];
        $this->assertEquals($expectedResult, $result);
    }

    public function testRemoveAllHeadersInCount()
    {
        $csvArray = $this->getCsvArray();
        $csvHelper = new Csv();
        $result = $csvHelper->removeHeaders($csvArray);

        $this->assertEquals((count($csvArray) - 11), count($result));
    }

    public function testRemoveFileHeadersAsCount()
    {
        $csvArray = $this->getCsvArray();
        $csvHelper = new Csv();
        $result = $csvHelper->removeHeaders($csvArray, false);

        $this->assertEquals((count($csvArray) - 10), count($result));
    }

    public function testArrayToCsvLine()
    {
        $array = [
            'one',
            'two',
            'three',
        ];

        $csvHelper = new Csv();
        $result = $csvHelper->arrayToCsvLine($array);
        $this->assertEquals("one,two,three\r\n", $result);

        $result = $csvHelper->arrayToCsvLine($array, '.', '"');
        $this->assertEquals("\"one\".\"two\".\"three\"\r\n", $result);
    }

    private function getCsvArray()
    {
        return [
            '"Report Name: GeoLocationPerformanceReportRequest"',
            '"Report Time: 2/28/2016"',
            '"Time Zone: (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna"',
            '"Last Completed Available Day: 2/29/2016 9:00:00 AM (GMT)"',
            '"Last Completed Available Hour: 2/29/2016 9:00:00 AM (GMT)"',
            '"Report Aggregation: Daily"',
            '"Report Filter: "',
            '"Potential Incomplete Data: false"',
            '"Rows: 2"',
            '',
            '"GregorianDate","AccountName","AdGroupId","AdGroupName","Impressions","Clicks","CurrencyCode","Spend","CountryOrRegion","City","State","MetroArea","MostSpecificLocation"',
            '"11/11/1988","account_1","1","group 1","1","0","EUR","0.00","Italy","","Bolzano","","Bolzano"',
            '"4/22/2007","account_1","2","group 2","4","0","EUR","0.00","Italy","","Milan","","Milan"',
            '',
            '"©2016 Microsoft Corporation. All rights reserved. "',
        ];
    }
}