Enables usage of PHP instead of XML or CSV for datasets
 
 
Go to file
Daniel Siepmann 3e594a0d15
Support MM Relations (#8)
Those don't have a hash or uid field.
We use a quick check whether a table is part of TCA in order to
determine those tables.
2023-08-10 08:34:14 +02:00
.github/workflows Add Support for TYPO3 v12.4 (#6) 2023-05-11 15:07:40 +02:00
Classes Support MM Relations (#8) 2023-08-10 08:34:14 +02:00
Tests/Functional Support MM Relations (#8) 2023-08-10 08:34:14 +02:00
bin Add command to convert from XML to PHP (#2) 2023-04-12 12:05:53 +02:00
.gitattributes First basic implementation (#1) 2023-04-11 15:12:51 +02:00
.gitignore First basic implementation (#1) 2023-04-11 15:12:51 +02:00
.php-cs-fixer.dist.php Add command to convert from XML to PHP (#2) 2023-04-12 12:05:53 +02:00
CHANGELOG.md Support MM Relations (#8) 2023-08-10 08:34:14 +02:00
LICENSE Initial commit 2023-04-11 09:30:44 +02:00
README.rst Add command to convert from XML to PHP (#2) 2023-04-12 12:05:53 +02:00
composer.json Add Support for TYPO3 v12.4 (#6) 2023-05-11 15:07:40 +02:00
phpstan-baseline.neon First basic implementation (#1) 2023-04-11 15:12:51 +02:00
phpstan.neon Add Support for TYPO3 v12.4 (#6) 2023-05-11 15:07:40 +02:00
phpunit.xml.dist First basic implementation (#1) 2023-04-11 15:12:51 +02:00
shell.nix Use composer update instead of install (#7) 2023-05-11 10:48:41 +02:00

README.rst

PHP DataSets for TYPO3

Provides APIs to use data sets written as PHP arrays with TYPO3.

Why

We don't like the approach of TYPO3 Testing Framework regarding DataSets.

We have the following issues:

  1. XML is only supported for imports, not for assertions
  2. CSV is a bad format that already got hacked, e.g. # to indicate comments. We consider it bad as one needs special toolings in order to properly write CSV files, they are not human readable.

That's why we prefer PHP files instead. That way developers are free to use whatever they want. Either plain PHP or even YAML or other formats. They are not forced to anything but can stick to their known tooling.

We also have situations where we wanna have static database records on production that are maintained by PHP data sets and update wizards.

So this package should in general handle PHP data sets for TYPO3. It should ease the abstract usage by providing convenient integrations for general use cases, like the testing framework.

Usage

See our own tests for how to use, as they do nothing else.

Within testing framework

  1. Create data set

    A data set is a PHP file that returns an array of tables with their records. Format is:

    return [
        'table_name' => [
            // Records
            [
                // column_name => value
                'uid' => 1,
            ],
        ],
    ];
  2. Add API

    use Codappix\Typo3PhpDatasets\TestingFramework;
  3. Use API

    Import:

    $this->importPHPDataSet(__DIR__ . '/Fixtures/SimpleSet.php');

    Assert:

    $this->assertPHPDataSet(__DIR__ . '/Fixtures/SimpleSet.php');

Converter

The package provides a single bin with command to convert existing data-sets. The bin is available as typo3-php-datasets. Available commands:

  • convert-from-xml

Each command will convert the existing file(s) and place a new php variant next to it. Existing files are only read, not changed.

TODO

  1. Implement use case to check for necessary updates and allow updates. Use for static data during deployment within update wizards or other scripts.