123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347 |
- <?php
- namespace Ddeboer\DataImport\Tests\Reader;
- use Ddeboer\DataImport\Reader\ArrayReader;
- use Ddeboer\DataImport\Reader\OneToManyReader;
- /**
- * Class OneToManyReaderTest
- * @package Ddeboer\DataImport\Tests\Reader
- * @author Aydin Hassan <aydin@hotmail.co.uk>
- */
- class OneToManyReaderTest extends \PHPUnit_Framework_TestCase
- {
- public function testReaderMergesOneToMany()
- {
- $leftData = array(
- array(
- 'OrderId' => 1,
- 'Price' => 30,
- ),
- array(
- 'OrderId' => 2,
- 'Price' => 15,
- ),
- );
- $rightData = array(
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 1',
- ),
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 2',
- ),
- array(
- 'OrderId' => 2,
- 'Name' => 'Super Cool Item 1',
- ),
- );
- $leftReader = new ArrayReader($leftData);
- $rightReader = new ArrayReader($rightData);
- $oneToManyReader = new OneToManyReader($leftReader, $rightReader, 'items', 'OrderId', 'OrderId');
- $expected = array(
- array(
- 'OrderId' => 1,
- 'Price' => 30,
- 'items' => array(
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 1',
- ),
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 2',
- ),
- ),
- ),
- array(
- 'OrderId' => 2,
- 'Price' => 15,
- 'items' => array(
- array(
- 'OrderId' => 2,
- 'Name' => 'Super Cool Item 1',
- ),
- )
- ),
- );
- $i = 0;
- foreach($oneToManyReader as $row) {
- $this->assertEquals($row, $expected[$i++]);
- }
- }
- public function testIfRightReaderIdFieldIsMissingLeftIsUsed()
- {
- $leftData = array(
- array(
- 'OrderId' => 1,
- 'Price' => 30,
- ),
- array(
- 'OrderId' => 2,
- 'Price' => 15,
- ),
- );
- $rightData = array(
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 1',
- ),
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 2',
- ),
- array(
- 'OrderId' => 2,
- 'Name' => 'Super Cool Item 1',
- ),
- );
- $leftReader = new ArrayReader($leftData);
- $rightReader = new ArrayReader($rightData);
- $oneToManyReader = new OneToManyReader($leftReader, $rightReader, 'items', 'OrderId');
- $expected = array(
- array(
- 'OrderId' => 1,
- 'Price' => 30,
- 'items' => array(
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 1',
- ),
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 2',
- ),
- ),
- ),
- array(
- 'OrderId' => 2,
- 'Price' => 15,
- 'items' => array(
- array(
- 'OrderId' => 2,
- 'Name' => 'Super Cool Item 1',
- ),
- )
- ),
- );
- $i = 0;
- foreach($oneToManyReader as $row) {
- $this->assertEquals($row, $expected[$i++]);
- }
- }
- public function testReaderThrowsExceptionIfNestKeyExistsInLeftReaderRow()
- {
- $leftData = array(
- array(
- 'OrderId' => 1,
- 'Price' => 30,
- 'items' => null,
- ),
- );
- $rightData = array(
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 1',
- ),
- );
- $leftReader = new ArrayReader($leftData);
- $rightReader = new ArrayReader($rightData);
- $oneToManyReader = new OneToManyReader($leftReader, $rightReader, 'items', 'OrderId');
- $this->setExpectedException('Ddeboer\DataImport\Exception\ReaderException', 'Left Row: "0" Reader already contains a field named "items". Please choose a different nest key field');
- $oneToManyReader->rewind();
- $oneToManyReader->current();
- }
- public function testReaderThrowsExceptionIfIdFieldDoesNotExistInLeftRow()
- {
- $leftData = array(
- array(
- 'Price' => 30,
- ),
- );
- $rightData = array(
- array(
- 'Name' => 'Super Cool Item 1',
- ),
- );
- $leftReader = new ArrayReader($leftData);
- $rightReader = new ArrayReader($rightData);
- $oneToManyReader = new OneToManyReader($leftReader, $rightReader, 'items', 'OrderId');
- $this->setExpectedException('Ddeboer\DataImport\Exception\ReaderException', 'Row: "0" has no field named "OrderId"');
- $oneToManyReader->rewind();
- $oneToManyReader->current();
- }
- public function testReaderThrowsExceptionIfIdFieldDoesNotExistInRightRow()
- {
- $leftData = array(
- array(
- 'OrderId' => 1,
- 'Price' => 30,
- ),
- );
- $rightData = array(
- array(
- 'Name' => 'Super Cool Item 1',
- ),
- );
- $leftReader = new ArrayReader($leftData);
- $rightReader = new ArrayReader($rightData);
- $oneToManyReader = new OneToManyReader($leftReader, $rightReader, 'items', 'OrderId');
- $this->setExpectedException('Ddeboer\DataImport\Exception\ReaderException', 'Row: "0" has no field named "OrderId"');
- $oneToManyReader->rewind();
- $oneToManyReader->current();
- }
- public function testGetKeysReturnsLeftReaderColumnsMergedWithNestKey()
- {
- $leftReader = new ArrayReader(array(array('col1' => 'data1', 'col2' => 'data2'), array('data3', 'data4')));
- $rightReader = new ArrayReader(array());
- $oneToManyReader = new OneToManyReader($leftReader, $rightReader, 'items', 'OrderId');
- $this->assertSame(array('col1', 'col2', 'items'), $oneToManyReader->getFields());
- }
- public function testCountReturnsTheCountOfTheLeftReader()
- {
- $leftReader = new ArrayReader(array());
- $rightReader = new ArrayReader(array());
- $oneToManyReader = new OneToManyReader($leftReader, $rightReader, 'items', 'OrderId');
- $this->assertEquals(0, $oneToManyReader->count());
- $leftReader = new ArrayReader(array(array(), array(), array()));
- $oneToManyReader = new OneToManyReader($leftReader, $rightReader, 'items', 'OrderId');
- $this->assertEquals(3, $oneToManyReader->count());
- }
- /**
- * This is probably a limitation - but it's not need for current implementation
- * @dataProvider outOfOrderRowProvider
- */
- public function testOutOfOrderRowsInRightReaderAreNotNested($leftData, $rightData, $expected)
- {
- //var_dump($leftData);
- //var_dump($rightData);
- $leftReader = new ArrayReader($leftData);
- $rightReader = new ArrayReader($rightData);
- $oneToManyReader = new OneToManyReader($leftReader, $rightReader, 'items', 'OrderId');
- $i = 0;
- foreach($oneToManyReader as $row) {
- $this->assertEquals($row, $expected[$i++]);
- }
- }
- public function outOfOrderRowProvider()
- {
- return array(
- 'skip-first-right-row' => array(
- 'left' => array(
- array(
- 'OrderId' => 3,
- 'Price' => 30,
- ),
- array(
- 'OrderId' => 2,
- 'Price' => 15,
- ),
- ),
- 'right' => array(
- array(
- 'OrderId' => 2,
- 'Name' => 'Super Cool Item 1',
- ),
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 1',
- ),
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 2',
- ),
- ),
- 'expected' => array(
- array(
- 'OrderId' => 3,
- 'Price' => 30,
- 'items' => array()
- ),
- array(
- 'OrderId' => 2,
- 'Price' => 15,
- 'items' => array(
- array(
- 'OrderId' => 2,
- 'Name' => 'Super Cool Item 1',
- ),
- )
- ),
- ),
- ),
- 'skip-out-of-order' => array(
- 'left' => array(
- array(
- 'OrderId' => 1,
- 'Price' => 30,
- ),
- array(
- 'OrderId' => 2,
- 'Price' => 15,
- ),
- ),
- 'right' => array(
- array(
- 'OrderId' => 0,
- 'Name' => 'Super Cool Item 1',
- ),
- array(
- 'OrderId' => 2,
- 'Name' => 'Super Cool Item 2',
- ),
- array(
- 'OrderId' => 1,
- 'Name' => 'Super Cool Item 3',
- ),
- ),
- 'expected' => array(
- array(
- 'OrderId' => 1,
- 'Price' => 30,
- 'items' => array()
- ),
- array(
- 'OrderId' => 2,
- 'Price' => 15,
- 'items' => array(),
- ),
- ),
- ),
- );
- }
- }
|