<?php


use PHPUnit\Framework\TestCase;
use function Flow\ETL\Adapter\Excel\DSL\from_excel;
use function Flow\ETL\DSL\data_frame;

class FlowTest extends TestCase
{

    /**
     * Successful test
     * @return void
     */
    public function test_existing_file_extension()
    {
        #file with file extension
        $filepath = __DIR__ . '/ExcelExample.xlsx';
        $dataFrame = data_frame()->read(from_excel($filepath));

        $definitions = $dataFrame->schema()->definitions();

        self::assertNotEmpty($definitions);

    }

    /**
     * Failing test with Flow\ETL\Exception\InvalidArgumentException
     * @return void
     */
    public function test_missing_file_extension()
    {
        # same file without file extension
        $filepath = __DIR__ . '/ExcelExample';
        $dataFrame = data_frame()->read(from_excel($filepath));

        # Flow\ETL\Exception\InvalidArgumentException: Failed to open file: Unsupported file extension: n/a
        # \vendor\flow - php\etl - adapter - excel\src\Flow\ETL\Adapter\Excel\ExcelExtractor . php:188
        # \vendor\flow - php\etl - adapter - excel\src\Flow\ETL\Adapter\Excel\ExcelExtractor . php:58
        # \vendor\flow - php\etl\src\Flow\ETL\Pipeline\SynchronousPipeline . php:47
        # \vendor\flow - php\etl\src\Flow\ETL\DataFrame . php:855
        $definitions = $dataFrame->schema()->definitions();

        self::assertNotEmpty($definitions);

    }

}