CSVBulkLoaderTest::testLoad() - Code Metrics - i-lateral/silverstripe-slightly-better-bulkloader - Measure and Improve Code Quality continuously with Scrutinizer

CSVBulkLoaderTest::testLoad() A
last analyzed 2019-02-25 10:20 UTC

↳ Parent: CSVBulkLoaderTest

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	24
rs	9.536
c	0
b	0
f	0
cc	1
nc	1
nop	0

<?php

namespace ilateral\SilverStripe\SlightlyBetterBulkLoader\Tests;

use SilverStripe\ORM\DataObject;
use SilverStripe\Dev\SapphireTest;
use ilateral\SilverStripe\SlightlyBetterBulkLoader\CsvBulkLoader;
use ilateral\SilverStripe\SlightlyBetterBulkLoader\Tests\Data\Player;

class CSVBulkLoaderTest extends SapphireTest
{

    /**
     * Name of csv test dir
     *
     * @var string
     */
    protected $csv_path = null;

    protected static $extra_dataobjects = [
        Player::class
    ];

    protected function setUp()
    {
        parent::setUp();
        $this->csvPath = __DIR__ . '/csv/';
class MyClass { }

$x = new MyClass();
$x->foo = true;
    }

    /**
     * Does the importer correct CSV
     */
    public function testLoad()
    {
        $loader = new CsvBulkLoader(Player::class);
        $filepath = $this->csvPath . 'Player.csv';
        $file = fopen($filepath, 'r');
        $results = $loader->load($filepath);

        $this->assertEquals(
            5,
            $results->CreatedCount(),
            'Test correct count of imported data'
        );

        $obj = DataObject::get_one(
            Player::class,
            [ '"FirstName"' => 'John' ]
        );

        $this->assertNotNull($obj);
        $this->assertEquals("He's a good guy", $obj->Biography);
        $this->assertEquals("1988-01-31", $obj->Birthday);
        $this->assertEquals("1", $obj->IsRegistered);
        fclose($file);
    }

    /**
     * Does the importer fail on a duplicate column?
     */
    public function testDuplicateColumn()

    {
        // Remove any existing records
        Player::get()->removeAll();

        $loader = new CsvBulkLoader(Player::class);
        $filepath = $this->csvPath . 'PlayerDuplicate.csv';
        $file = fopen($filepath, 'r');
        $results = $loader->load($filepath);

        $this->assertEquals(
            1,
            $results->ErrorCount(),
            'Test error count on duplicates'
        );

        $obj = DataObject::get_one(
            Player::class,
            [ '"FirstName"' => 'John' ]
        );

        $this->assertNull($obj);
        fclose($file);
    }

    /**
     * Does the importer fail on a duplicate column
     */
    public function testMissingRequired()

    {
        // Remove any existing records
        Player::get()->removeAll();

        $loader = new CsvBulkLoader(Player::class);
        $filepath = $this->csvPath . 'PlayerMissingRequired.csv';
        $file = fopen($filepath, 'r');
        $results = $loader->load($filepath);

        $this->assertEquals(
            1,
            $results->ErrorCount(),
            'Test errors generated when required fields missing'
        );

        $obj = DataObject::get_one(
            Player::class,
            ['"FirstName"' => 'Jane']
        );

        $this->assertNull($obj);
        fclose($file);
    }
}


1		<?php
2
3		namespace ilateral\SilverStripe\SlightlyBetterBulkLoader\Tests;
4
5		use SilverStripe\ORM\DataObject;
6		use SilverStripe\Dev\SapphireTest;
7		use ilateral\SilverStripe\SlightlyBetterBulkLoader\CsvBulkLoader;
8		use ilateral\SilverStripe\SlightlyBetterBulkLoader\Tests\Data\Player;
9
10		class CSVBulkLoaderTest extends SapphireTest
11		{
12
13		/**
14		* Name of csv test dir
15		*
16		* @var string
17		*/
18		protected $csv_path = null;
19
20		protected static $extra_dataobjects = [
21		Player::class
22		];
23
24		protected function setUp()
25		{
26		parent::setUp();
27		$this->csvPath = __DIR__ . '/csv/';
		0 ignored issues – show Bug introduced 2019-02-08 12:23 UTC by Report Bug Copy Issue Report The property `csvPath` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
28		}
29
30		/**
31		* Does the importer correct CSV
32		*/
33		public function testLoad()
34		{
35		$loader = new CsvBulkLoader(Player::class);
36		$filepath = $this->csvPath . 'Player.csv';
37		$file = fopen($filepath, 'r');
38		$results = $loader->load($filepath);
39
40		$this->assertEquals(
41		5,
42		$results->CreatedCount(),
43		'Test correct count of imported data'
44		);
45
46		$obj = DataObject::get_one(
47		Player::class,
48		[ '"FirstName"' => 'John' ]
49		);
50
51		$this->assertNotNull($obj);
52		$this->assertEquals("He's a good guy", $obj->Biography);
53		$this->assertEquals("1988-01-31", $obj->Birthday);
54		$this->assertEquals("1", $obj->IsRegistered);
55		fclose($file);
56		}
57
58		/**
59		* Does the importer fail on a duplicate column?
60		*/
61	View Code Duplication	public function testDuplicateColumn()
		0 ignored issues – show Duplication introduced 2019-02-08 12:23 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
62		{
63		// Remove any existing records
64		Player::get()->removeAll();
65
66		$loader = new CsvBulkLoader(Player::class);
67		$filepath = $this->csvPath . 'PlayerDuplicate.csv';
68		$file = fopen($filepath, 'r');
69		$results = $loader->load($filepath);
70
71		$this->assertEquals(
72		1,
73		$results->ErrorCount(),
74		'Test error count on duplicates'
75		);
76
77		$obj = DataObject::get_one(
78		Player::class,
79		[ '"FirstName"' => 'John' ]
80		);
81
82		$this->assertNull($obj);
83		fclose($file);
84		}
85
86		/**
87		* Does the importer fail on a duplicate column
88		*/
89	View Code Duplication	public function testMissingRequired()
		0 ignored issues – show Duplication introduced 2019-02-08 12:23 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
90		{
91		// Remove any existing records
92		Player::get()->removeAll();
93
94		$loader = new CsvBulkLoader(Player::class);
95		$filepath = $this->csvPath . 'PlayerMissingRequired.csv';
96		$file = fopen($filepath, 'r');
97		$results = $loader->load($filepath);
98
99		$this->assertEquals(
100		1,
101		$results->ErrorCount(),
102		'Test errors generated when required fields missing'
103		);
104
105		$obj = DataObject::get_one(
106		Player::class,
107		['"FirstName"' => 'Jane']
108		);
109
110		$this->assertNull($obj);
111		fclose($file);
112		}
113		}
114

i-lateral / silverstripe-slightly-better-bulkloader

CSVBulkLoaderTest::testLoad() A last analyzed 2019-02-25 10:20 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

CSVBulkLoaderTest::testLoad() A
last analyzed 2019-02-25 10:20 UTC