@@ 30-44 (lines=15) @@ | ||
27 | $this->assertEquals((count($csvArray) - 2), count($result)); |
|
28 | } |
|
29 | ||
30 | public function testFixDate() |
|
31 | { |
|
32 | $csvArray = [ |
|
33 | '"11/11/1988","account_1","1","group 1","1","0","EUR","0.00","Italy","","Bolzano","","Bolzano"', |
|
34 | '"4/22/2007","account_1","2","group 2","4","0","EUR","0.00","Italy","","Milan","","Milan"', |
|
35 | ]; |
|
36 | $csvHelper = new Csv(); |
|
37 | $result = $csvHelper->convertDateMDYtoYMD($csvArray); |
|
38 | ||
39 | $expectedResult = [ |
|
40 | "\"1988/11/11\",\"account_1\",\"1\",\"group 1\",\"1\",\"0\",\"EUR\",\"0.00\",\"Italy\",\"\",\"Bolzano\",\"\",\"Bolzano\"\r\n", |
|
41 | "\"2007/04/22\",\"account_1\",\"2\",\"group 2\",\"4\",\"0\",\"EUR\",\"0.00\",\"Italy\",\"\",\"Milan\",\"\",\"Milan\"\r\n", |
|
42 | ]; |
|
43 | $this->assertEquals($expectedResult, $result); |
|
44 | } |
|
45 | ||
46 | public function testRemoveAllHeaders() |
|
47 | { |
|
@@ 46-59 (lines=14) @@ | ||
43 | $this->assertEquals($expectedResult, $result); |
|
44 | } |
|
45 | ||
46 | public function testRemoveAllHeaders() |
|
47 | { |
|
48 | $csvArray = $this->getCsvArray(); |
|
49 | $csvHelper = new Csv(); |
|
50 | $result = $csvHelper->removeHeaders($csvArray); |
|
51 | ||
52 | $expectedResult = [ |
|
53 | '"11/11/1988","account_1","1","group 1","1","0","EUR","0.00","Italy","","Bolzano","","Bolzano"', |
|
54 | '"4/22/2007","account_1","2","group 2","4","0","EUR","0.00","Italy","","Milan","","Milan"', |
|
55 | '', |
|
56 | '"©2016 Microsoft Corporation. All rights reserved. "', |
|
57 | ]; |
|
58 | $this->assertEquals($expectedResult, $result); |
|
59 | } |
|
60 | ||
61 | public function testRemoveFileHeaders() |
|
62 | { |
|
@@ 61-75 (lines=15) @@ | ||
58 | $this->assertEquals($expectedResult, $result); |
|
59 | } |
|
60 | ||
61 | public function testRemoveFileHeaders() |
|
62 | { |
|
63 | $csvArray = $this->getCsvArray(); |
|
64 | $csvHelper = new Csv(); |
|
65 | $result = $csvHelper->removeHeaders($csvArray, false); |
|
66 | ||
67 | $expectedResult = [ |
|
68 | '"GregorianDate","AccountName","AdGroupId","AdGroupName","Impressions","Clicks","CurrencyCode","Spend","CountryOrRegion","City","State","MetroArea","MostSpecificLocation"', |
|
69 | '"11/11/1988","account_1","1","group 1","1","0","EUR","0.00","Italy","","Bolzano","","Bolzano"', |
|
70 | '"4/22/2007","account_1","2","group 2","4","0","EUR","0.00","Italy","","Milan","","Milan"', |
|
71 | '', |
|
72 | '"©2016 Microsoft Corporation. All rights reserved. "', |
|
73 | ]; |
|
74 | $this->assertEquals($expectedResult, $result); |
|
75 | } |
|
76 | ||
77 | public function testRemoveAllHeadersInCount() |
|
78 | { |