Skip to content

Latest commit

 

History

History
73 lines (50 loc) · 1.56 KB

README.md

File metadata and controls

73 lines (50 loc) · 1.56 KB
Raw

ETL Adapter: CSV

Description

ETL Adapter that provides Loaders and Extractors that works with CSV files. It does not require any external dependencies, it's working on internal PHP functions.

Contributing

This repo is READ ONLY, in order to contribute to Flow PHP project, please open PR against flow monorepo.

Changes merged to monorepo are automatically propagated into sub repositories.

Installation

composer require flow-php/etl-adapter-csv:1.x@dev

Extractor

<?php

use Flow\ETL\DSL\CSV;
use Flow\ETL\Flow;

$rows = (new Flow())
    ->read(CSV::from(new LocalFile($path)))
    ->fetch();

Loader

<?php

use Flow\ETL\DSL\CSV;
use Flow\ETL\Row;
use Flow\ETL\Rows;

(new Flow())
    ->process(
        new Rows(
            Row::create(new Row\Entry\IntegerEntry('id', 1), new Row\Entry\StringEntry('name', 'Norbert')),
            Row::create(new Row\Entry\IntegerEntry('id', 2), new Row\Entry\StringEntry('name', 'Tomek')),
            Row::create(new Row\Entry\IntegerEntry('id', 3), new Row\Entry\StringEntry('name', 'Dawid')),
        )
    )
    ->load(CSV::to($path, true, true))
    ->run();

Development

In order to install dependencies please, launch following commands:

composer install

Run Tests

In order to execute full test suite, please launch following command:

composer build

It's recommended to use pcov for code coverage however you can also use xdebug by setting XDEBUG_MODE=coverage env variable.