Php Etl Sylius Admin Bundle

The Php Etl Sylius Admin Bundle allows the usage of Oliver's PHP Etl Bundle library in a Sylius environment.

Dependencies

composer require oliverde8/php-etl-sylius-admin-bundle

PhpEtlSyliusAdminBundle config

1. Install this module:

# config/bundles.php

return [
    [...]
    Oliverde8\PhpEtlSyliusAdminBundle\Oliverde8PhpEtlSyliusAdminBundle::class => ['all' => true],
];

2. Create EtlExecution table via migrations

3. Create messenger_messages table via migrations

4. Import configs

# config/packages/etl.yaml
imports:
    - { resource: "@Oliverde8PhpEtlSyliusAdminBundle/Resources/config/config.yaml" }

5. Import routes

# config/routes/etl.yaml
oliverde8_etl:
    resource: '@Oliverde8PhpEtlSyliusAdminBundle/Resources/config/routing.yaml'

6. Configure EtlExecution Message:

# config/packages/messenger.yaml
framework:
    messenger:
        # Uncomment this (and the failed transport below) to send failed messages to this transport for later handling.
        failure_transport: failed

        transports:
            failed: 'doctrine://default?queue_name=failed'
            generic_with_retry:
                dsn: 'doctrine://default?queue_name=generic_with_retry'
                retry_strategy:
                    max_retries: 3
                    multiplier: 4
                    delay: 3600000 #1H first retry, 4H second retry, 16H third retry (see multiplier) 
            etl_async:
                dsn: 'doctrine://default?queue_name=etl_async'
                retry_strategy:
                    max_retries: 0

        routing:
            'Oliverde8\PhpEtlBundle\Message\EtlExecutionMessage': etl_async

8. Create an ETL chain to execute: see the doc from this page