Skip to content

wizacode/php-etl

master
Switch branches/tags
Code
This branch is 73 commits ahead, 20 commits behind leomarquine:master.
Contribute

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
src
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Wizaplace PHP ETL (WP-ETL)

License CircleCI Version Maintenance Ask Me Anything ! PHP Version

Extract, Transform and Load data using PHP. This library provides classes and a workflow to allow you to extract data from various sources (CSV, DB...), one or many, then transform them before saving them in another format.

You can also easily add your custom classes (Extractors, Transformers and Loaders).

ETL

Versions and compatibility

  • To benefit from the last features, you need PHP >= 7.4 and use the 2.x version of the library.
  • If you use older versions of PHP: 7.2 <= PHP <= 7.4, use the legacy 1.3.x version (still maintained for bugfixes).

Changelog

See the changelog here

Installation

In your application's folder, run:

composer require wizaplace/php-etl

Example 🚈

In the example below, we will extract data from a csv file, trim white spaces from the name and email columns and then insert the values into the users table:

use Wizaplace\Etl\Etl;
use Wizaplace\Etl\Extractors\Csv;
use Wizaplace\Etl\Transformers\Trim;
use Wizaplace\Etl\Loaders\Insert;
use Wizaplace\Etl\Database\Manager;
use Wizaplace\Etl\Database\ConnectionFactory;

// Get your database settings :
$config = [
    'driver'    => 'mysql',
    'host'      => 'localhost',
    'port'      => '3306',
    'database'  => 'myDatabase',
    'username'  => 'foo',
    'password'  => 'bar',
    'charset'   => 'utf8',
    'collation' => 'utf8_unicode_ci',
];

// Instanciate all the components (manually or automatically with DI)
$manager = new Manager(new ConnectionFactory());
$manager->addConnection($config);
$etl = new Etl();
$extractor = new Csv();
$transformer = new Trim();
$loader = new Insert($manager);

$etl->extract($extractor, '/path/to/users.csv')
    ->transform(
        $transformer,
        [Step::COLUMNS => ['name', 'email']]
    )
    ->load($loader, 'users')
    ->run();

The library is fully compatible with any PHP project. For instance, with Symfony, you can fully benefit from the autowiring. On the following example, you enable it on the main ETL object, with the shared parameter to false in order to have the possibility to get different instance of the ETL (optional).

services.yaml

    Wizaplace\Etl\Etl:
        shared: false

Documentation 📓

The documentation is available in a subfolder of the repo, here.

License

WP-ETL is licensed under the MIT license.

Origin of the project

This project is a fork and an improvement of the marquine/php-etl project by Leonardo Marquine.

About

Extract, Transform and Load data using PHP.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • PHP 98.9%
  • Other 1.1%