class SpreadsheetIteratorTest in Migrate Spreadsheet 2.0.x

Tests the spreadsheet iterator.

@coversDefaultClass \Drupal\migrate_spreadsheet\SpreadsheetIterator

@group migrate_spreadsheet

Hierarchy

• class \Drupal\Tests\migrate_spreadsheet\Unit\SpreadsheetIteratorTest extends \PHPUnit\Framework\TestCase

File

tests/src/Unit/SpreadsheetIteratorTest.php, line 19

Namespace

Drupal\Tests\migrate_spreadsheet\Unit

class SpreadsheetIteratorTest extends TestCase {

  /**
   * A worksheet.
   *
   * @var \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
   */
  protected $worksheet;

  /**
   * The spreadsheet iterator.
   *
   * @var \Drupal\migrate_spreadsheet\SpreadsheetIteratorInterface
   */
  protected $iterator;

  /**
   * {@inheritdoc}
   */
  protected function setUp() : void {
    parent::setUp();
    $this->iterator = (new SpreadsheetIterator())
      ->setConfiguration([
      'worksheet' => $this
        ->getWorksheet(),
      'origin' => 'B3',
      'header_row' => 2,
      'columns' => [
        'column b',
        'column d',
        'column e',
      ],
    ]);
  }

  /**
   * @covers ::getRowsCount
   * @covers ::getColumnsCount
   */
  public function testRowsAndColumnsCount() : void {
    $this
      ->assertEquals(5, $this->iterator
      ->getRowsCount());
    $this
      ->assertEquals(7, $this->iterator
      ->getColumnsCount());
  }

  /**
   * @covers ::getOrigin
   * @dataProvider providerTestGetException
   *
   * @param string $origin
   *   The origin cell reference to be tested.
   * @param bool $expect_exception
   *   If a exception is expected.
   */
  public function testGetOrigin(string $origin, bool $expect_exception) : void {
    $config = [
      'origin' => $origin,
    ] + $this->iterator
      ->getConfiguration();
    $this->iterator
      ->setConfiguration($config);
    if ($expect_exception) {
      $this
        ->expectException(\InvalidArgumentException::class);
    }
    $this
      ->assertEquals($origin, $this->iterator
      ->getOrigin());
  }

  /**
   * Provides test cases for ::testGetOrigin()
   *
   * @return array[]
   *   A list of test parameters to be passed to ::testGetOrigin().
   */
  public function providerTestGetException() : array {
    return [
      'The minimum valid origin' => [
        'A1',
        FALSE,
      ],
      'A valid origin' => [
        'B3',
        FALSE,
      ],
      'Column out of bounds' => [
        'H3',
        TRUE,
      ],
      'Row out of bounds' => [
        'E6',
        TRUE,
      ],
      'Both, row and column, out of bounds' => [
        'H6',
        TRUE,
      ],
      'The maximum valid value' => [
        'G5',
        FALSE,
      ],
    ];
  }

  /**
   * @covers ::getHeaders
   */
  public function testGetHeaders() : void {
    $cols = [
      'column b' => 'B',
      'column c' => 'C',
      'column d' => 'D',
      'column e' => 'E',
      'column g' => 'G',
    ];
    $this
      ->assertSame($cols, $this->iterator
      ->getHeaders());

    // Check headers when there's no header row. All columns should be used.
    $config = $this->iterator
      ->getConfiguration();
    unset($config['header_row']);
    $this->iterator
      ->setConfiguration($config);
    $this
      ->assertSame([
      'B' => 'B',
      'C' => 'C',
      'D' => 'D',
      'E' => 'E',
      'F' => 'F',
      'G' => 'G',
    ], $this->iterator
      ->getHeaders());

    // Check duplicate headers.
    $this
      ->getWorksheet()
      ->setCellValue('C2', 'column b');
    $config['header_row'] = 2;
    $this->iterator
      ->setConfiguration($config);
    $this
      ->expectException('RuntimeException');
    $this->iterator
      ->getHeaders();
  }

  /**
   * @covers ::current
   */
  public function testIteration() : void {
    $config = $this->iterator
      ->getConfiguration();
    $config['row_index_column'] = 'row';
    $this->iterator
      ->setConfiguration($config);
    $this
      ->assertTrue($this->iterator
      ->valid());
    $this
      ->assertSame([
      3,
    ], $this->iterator
      ->key());
    $this
      ->assertSame([
      'row' => 3,
      'column b' => 'cell b0',
      'column d' => 'cell d0',
      'column e' => 'cell e0',
    ], $this->iterator
      ->current());

    // Move the cursor.
    $this->iterator
      ->next();
    $this
      ->assertTrue($this->iterator
      ->valid());
    $this
      ->assertSame([
      4,
    ], $this->iterator
      ->key());
    $this
      ->assertSame([
      'row' => 4,
      'column b' => 'cell b1',
      'column d' => 7.0,
      // We test here a computed cell (E4 == 'D4+3.23').
      'column e' => 10.23,
    ], $this->iterator
      ->current());

    // Move the cursor.
    $this->iterator
      ->next();
    $this
      ->assertTrue($this->iterator
      ->valid());
    $this
      ->assertSame([
      5,
    ], $this->iterator
      ->key());
    $this
      ->assertSame([
      'row' => 5,
      'column b' => 'cell b2',
      'column d' => 'cell d2',
      'column e' => 'cell e2',
    ], $this->iterator
      ->current());

    // Move the cursor. Should run out of set.
    $this->iterator
      ->next();
    $this
      ->assertFalse($this->iterator
      ->valid());

    // Rewind.
    $this->iterator
      ->rewind();
    $this
      ->assertTrue($this->iterator
      ->valid());
    $this
      ->assertSame([
      3,
    ], $this->iterator
      ->key());
    $this
      ->assertSame([
      'row' => 3,
      'column b' => 'cell b0',
      'column d' => 'cell d0',
      'column e' => 'cell e0',
    ], $this->iterator
      ->current());

    // Try to return all columns.
    $config['columns'] = [];
    $this->iterator
      ->setConfiguration($config);
    $this
      ->assertTrue($this->iterator
      ->valid());
    $this
      ->assertSame([
      3,
    ], $this->iterator
      ->key());
    $this
      ->assertSame([
      'row' => 3,
      'column b' => 'cell b0',
      'column c' => 'cell c0',
      'column d' => 'cell d0',
      'column e' => 'cell e0',
      'column g' => 'cell g0',
    ], $this->iterator
      ->current());

    // Use different primary keys.
    $config['columns'] = [
      'column b',
      'column e',
    ];
    $config['keys'] = [
      'column c',
      'column d',
    ];
    unset($config['row_index_column']);
    $this->iterator
      ->setConfiguration($config);
    $this
      ->assertTrue($this->iterator
      ->valid());
    $this
      ->assertSame([
      'cell c0',
      'cell d0',
    ], $this->iterator
      ->key());
    $this
      ->assertSame([
      'column b' => 'cell b0',
      'column c' => 'cell c0',
      'column d' => 'cell d0',
      'column e' => 'cell e0',
    ], $this->iterator
      ->current());

    // Test with no header_row.
    unset($config['header_row']);
    $config['columns'] = [
      'B',
      'E',
    ];
    $config['keys'] = [
      'C',
      'D',
    ];
    $this->iterator
      ->setConfiguration($config);
    $this
      ->assertTrue($this->iterator
      ->valid());
    $this
      ->assertSame([
      'cell c0',
      'cell d0',
    ], $this->iterator
      ->key());
    $this
      ->assertSame([
      'B' => 'cell b0',
      'C' => 'cell c0',
      'D' => 'cell d0',
      'E' => 'cell e0',
    ], $this->iterator
      ->current());
  }

  /**
   * Populates a testing worksheet.
   *
   * @return \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
   *   A PhpSpreadsheet worksheet object.
   */
  protected function getWorksheet() : Worksheet {
    if (!isset($this->worksheet)) {

      // Test case:
      // - origin: B3;
      // - header_row: 2.
      $this->worksheet = (new Spreadsheet())
        ->getActiveSheet()
        ->setCellValue('B2', 'column b')
        ->setCellValue('C2', 'column c')
        ->setCellValue('D2', 'column d')
        ->setCellValue('E2', 'column e')
        ->setCellValue('G2', 'column g')
        ->setCellValue('B3', 'cell b0')
        ->setCellValue('C3', 'cell c0')
        ->setCellValue('D3', 'cell d0')
        ->setCellValue('E3', 'cell e0')
        ->setCellValue('F3', 'cell f0')
        ->setCellValue('G3', 'cell g0')
        ->setCellValue('B4', 'cell b1')
        ->setCellValue('C4', 'cell c1')
        ->setCellValue('D4', 7.0)
        ->setCellValue('E4', '=D4+3.23')
        ->setCellValue('F4', 'cell f1')
        ->setCellValue('G4', 'cell g1')
        ->setCellValue('B5', 'cell b2')
        ->setCellValue('C5', 'cell c2')
        ->setCellValue('D5', 'cell d2')
        ->setCellValue('E5', 'cell e2')
        ->setCellValue('F5', 'cell f2')
        ->setCellValue('G5', 'cell g2');
    }
    return $this->worksheet;
  }

}

Members

Name	Modifiers	Type	Description	Overrides
SpreadsheetIteratorTest::$iterator	protected	property	The spreadsheet iterator.
SpreadsheetIteratorTest::$worksheet	protected	property	A worksheet.
SpreadsheetIteratorTest::getWorksheet	protected	function	Populates a testing worksheet.
SpreadsheetIteratorTest::providerTestGetException	public	function	Provides test cases for ::testGetOrigin()
SpreadsheetIteratorTest::setUp	protected	function
SpreadsheetIteratorTest::testGetHeaders	public	function	@covers ::getHeaders
SpreadsheetIteratorTest::testGetOrigin	public	function	@covers ::getOrigin @dataProvider providerTestGetException
SpreadsheetIteratorTest::testIteration	public	function	@covers ::current
SpreadsheetIteratorTest::testRowsAndColumnsCount	public	function	@covers ::getRowsCount @covers ::getColumnsCount