oliverde8/php-etl-sylius-admin-bundle

v1.0.0-alpha4 2024-10-21 11:55 UTC

This package is auto-updated.

Last update: 2024-10-21 11:57:13 UTC


README

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],
];
  1. Create EtlExecution table via migrations

  2. Create messenger_messages table via migrations

  3. Import configs

# config/packages/etl.yaml
imports:
    - { resource: "@Oliverde8PhpEtlSyliusAdminBundle/Resources/config/config.yaml" }
  1. Import routes
# config/routes/etl.yaml
oliverde8_etl:
    resource: '@Oliverde8PhpEtlSyliusAdminBundle/Resources/config/routing.yaml'
  1. 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
  1. Create an ETL chain to execute: see the doc from this page