YaEtl has no opinion about what a record should be. Though since array'ish structures are pretty common when dealing with data structures, many examples bellow will assume that $record is some kind of array.
An extractor should usually fetch many records at once using its extract() method and should return them one by one through its getTraversable() method, inherited from Nodalflow's TraversableInterface.
The extract() is YaEtl specific and is used to distinguish the actual extract, which in most cases should fetch many records at once, and the pure flow act of providing with each records one by one. It must return true in case of success (eg we got records) and false in case we fetched all records already.
YaEtl iterate on what's returned by getTraversable() while extract() returns true.
A KISS implementation could look like :
use fab2s\YaEtl\ExtractorAbstract;
/**
* Class Extractor
*/
class Extractor extends ExtractorAbstract
{
/**
* get records from somewhere
* @return bool
*/
public function extract()
{
if (!($this->extracted = $this->getAllRecords())) {
return false;
}
return true;
}
/**
* @return \Generator
*/
public function getTraversable()
{
foreach ($this->extracted as $record) {
yield $record;
}
}
}Of course, it's not realistic in many cases to get all records at once, but it's is simple to paginate the result and then exhaust each page record by record, especially since the extract operation is separated and used somehow in the "meta" loop.
YaEtl comes with many partial to complete Extractor implementations to address many use case with some emphasis on databases in general and PDO in particular:
ExtractorAbstract implements ExtractorInterface which extends NodalFlow's TraversableInterface. This is the minimal NodalFlow setup you can extend to create an extractor
ExtractorLimitAbstract extends ExtractorAbstract and adds logic to handle extraction limits.
ExtractorBatchLimitAbstract extends ExtractorLimitAbstract and adds logic to additionally handle batch extraction, eg paginated queries.
DbExtractorAbstract extends ExtractorBatchLimitAbstract and adds logic to extract from any DBMS.
PdoExtractor extends DbExtractorAbstract and is a ready to use PDO extractor implementation.
UniqueKeyExtractorAbstract extends DbExtractorAbstract and implements JoinableIUnterface. It adds logic to extract and Join from any DBMS provided that the sql query fetches records against a single unique KEY. The unique key may be composite for extraction, but joining is currently only supported against a single unique key. While you can join records on a single unique keys from an extractor that actually query on some other (composite) keys (as long as the Joined key remains unique in the records), you cannot currently Join on a composite unique key directly.
PdoUniqueKeyExtractor extends PdoExtractorAbstract and also implements JoinableIUnterface). It is a ready to use PDO Joinable (unique key) extractor.
Implementing a Joinable extractor requires a bit more work as there is a need to build records maps and transmit them among joiners. But it can be pretty quick using UniqueKeyExtractorAbstract and / or PdoUniqueKeyExtractor as they provides with much of the work. The Laravel UniqueKeyExtractor class is a working example of a class extending PdoUniqueKeyExtractor, being itself a working example of a class implementing UniqueKeyExtractorAbstract.
Both PDO extractors deactivate MySql buffered query if needed to speed up fetching large amounts of records at once.
YaEtl includes a generic FileExtractorAbstract abstract class which can be used as a foundation to file/resource extraction implementations.
The default constructor accepts both resources and file path as argument, and the partial implementation covers everything except the actual reading. Handles are released upon object destruction, but you also have access to releaseHandle() if you wish to do it earlier.
Every File based extractor should (and does for YaEtl's one) extend FileExtractorAbstract.
FileExtractorAbstract comes with a constructor handling both File Path or resource as input:
/**
* @param resource|string $input
*
* @throws YaEtlException
* @throws NodalFlowException
*/
public function __construct($input)Since v1.1.1, YaEtl includes OpinHelpers and FileExtractorAbstract became BOM aware. It will do nothing but detect the eventual presence of a BOM. Upon detection, the BOM is dropped from the line and encoding is detected (you can get if from $yourInstance->getEncoding()).
File locking
If you ever need to work with a locked source file, you can open and lock the file yourself and pass the resource to FileExtractorAbstract constructor.
Since v1.1.1 you can use FileLock:
$fileLock = FileLock::open($filePath, 'rb');
if ($fileLock) {
$fileExtractor = new SomeFileExtractor($fileLock->getHandle());
}File Encoding
Since v1.1.1, unicode (UTF-8(16|32_LE|BE)) file encoding can be auto-detected in the presence of BOM (enabled by default). Utf8 and Strings are also available to ease things a bit as they cover charset conversion and some more charset detection.
Any class extending FileExtractorAbstract will also use FileHandlerTrait which provides with $yourInstance->getEncoding() and $yourInstance->setEncoding() methods.
LineExtractor is a complete implementation of a read file line by line extractor. It can be easily extended or coupled with custom transformer to handle any line based format stored in files. Every extracted line is trim'd, only non empty trim'd line are yielded.
$lineExtractor = new LineExtractor($filePathOrHandle);
// in case you need to know the encoding detected
$fileEncoding = $lineExtractor->getEncoding();
// or just set it
$lineExtractor->setEncoding('UTF-8');
// in case you do not want to handle BOM
$lineExtractor->setUseBom(false);
// standalone
foreach($lineExtractor->getTraversable() as $line) {
// do something with trimed non empty $line
}
// or in a Flow
// (new YaEtl)->from($lineExtractor)-> ... // you get a line as record
// handle is released upon destruction, but you can do it earlier
$lineExtractor->releaseHandle();Unfortunately, at some point, one has to deal with CSV. While it could seem that this could be done using a simple str_getcsv() based transformer after a LineExtractor, things are a bit more complex in practice. Because a line based extraction is very likely to fail for csv fields including EOLs as it will not check if it is enclosed or not.
For this very reason, CsvExtractor will first go through the file byte by byte until it reaches the first byte that could be a CSV record, eg, non empty, not a BOM and not an infamous sep=. Of course, sep and BOM are handled when present, and the file handle is ultimately fseek'd to the first char of the first eventual CSV record (could be the header), and then starts extraction using the EOL safe fgetcsv().
SplFileObject could have been a solution, but since it does not let you access the underlying handle, it would limit options IRL. The excellent CSV handler by the PHP league is of course a strong candidate to handle CSV manipulations, and building an Extractor based on it would be pretty trivial.
But, while, fgetcsv() is not perfect and has some pitfalls, it is still pretty reliable when properly used, and doing so, we get the full speed of direct extraction with no other fancy computation.
CsvExtractor will ignore blank lines that could be found at any place in the file (while handling BOMs, sep= and parsing CSV records)
Constructor is pretty obvious:
/**
* CsvExtractor constructor
*
* @param resource|string $input
* @param string $delimiter
* @param string $enclosure
* @param string $escape
*
* @throws NodalFlowException
* @throws YaEtlException
*/
public function __construct($input, $delimiter = ',', $enclosure = '"', $escape = '\\')It just uses the same CSV parameters as fgetcsv().
CsvExtractor auto-detects the infamous sep= instruction from Excel but will not attempts to read a header by default.
When $input is a resource, extraction starts at the resource pointer, which means you can fseek() it before you pass it to CsvExtractor.
$csvExtractor = new CsvExtractor($filePathOrHandle);
// if you wish to detect header (to be used as record array keys)
$csvExtractor->setUseHeader(true);
// or if you prefer to define your own
// note that header field order is IMPORTANT
$csvExtractor->setHeader($header);
// standalone
foreach($csvExtractor->getTraversable() as $record) {
// do something with $record array
}
// or in a Flow
// (new YaEtl)->from($csvExtractor)-> ... // you get an array as record
// handle is released upon destruction, but you can do it earlier
$csvExtractor->releaseHandle();CallableExtractor is a complete implementation of an Extractor getting its records from a callable. Its main purpose is to test YaEtl but it could be also handy in real some cases :
$extractor = new CallableExtractor(function($param = null) {
return range(1, 100);
});The Transformer is where records are transformed. Data from various sources provided by the extractor could be assembled into totally different data structures, ready to be handled by the next node.
A trivial example could be an extractor gathering user data from both user and user_address table and passing them to an extractor that would use the data to return a complete address string, ready to be pushed into some postal API by the loader.
use fab2s\YaEtl\Transformers\TransformerAbstract;
/**
* Class Transformer
*/
class Transformer extends TransformerAbstract
{
/**
* Inherited from NodalFlow's ExecNodeInterface
* @return bool
*/
public function exec($record)
{
// do whatever you need to obtain
// the proper output ready for next operation
return array_map('trim', $record);
}
}YaEtl includes a ready to use CallableTransformer which takes a callable as argument to its constructor:
use fab2s\YaEtl\Transformers\CallableTransformer;
$callableTransformer = new CallableTransformer(function($record) {
return doSomething($record);
});
// or
$callableTransformer = new CallableTransformer([$someObject, 'relevantMethod']);It goes without saying that the callable should be relevant with the task.
As array is a pretty common record format, YaEtl comes with generic Array Transformer implementations :
ArrayMapTransformer : array_map() simple wrapper
/**
* @param callable $mapper
*
* @throws NodalFlowException
*/
// public function __construct(callable $mapper)
// action : array_map($this->mapper, $record);
$transformer = new ArrayMapTransformer('trim');ArrayReplaceTransformer : array_replace() wrapper
/**
* @param array $default An array of the default field values to use, if any
* @param array $override An array of the field to always set to the same value, if any
*
* @throws NodalFlowException
*/
// public function __construct(array $default, array $override = [])
// action : array_replace($this->default, $record, $this->override);
$transformer = new ArrayReplaceTransformer(['key' => 'defaultValue'], ['anotherKey' => 'forcedValue']);ArrayReplaceRecursiveTransformer : array_replace_recursive() wrapper
/**
* @param array $default An array of the default field values to use, if any
* @param array $override An array of the field to always set to the same value, if any
*
* @throws NodalFlowException
*/
// public function __construct(array $default, array $override = [])
// action : array_replace_recursive($this->default, $record, $this->override);
$transformer = new ArrayReplaceRecursiveTransformer(['key' => 'defaultValue'], ['anotherKey' => 'forcedValue']);ArrayWalkTransformer : array_walk() wrapper
/**
* @param callable $callable Worth nothing to say that the first callback argument should
* be a reference if you want anything to append to the record
* @param null|mixed $userData
*
* @throws NodalFlowException
*/
// public function __construct(callable $callable, $userData = null)
// action : array_walk($record, $this->callable, $this->userData);
$transformer = new ArrayWalkTransformer(function (&$value, $key, $userData) {
$value = doSomething($userData);
});ArrayWalkRecursiveTransformer : array_walk_recursive() wrapper
/**
* @param callable $callable Worth nothing to say that the first callback argument should
* be a reference if you want anything to append to the record
* @param null|mixed $userData
*
* @throws NodalFlowException
*/
// public function __construct(callable $callable, $userData = null)
// action : array_walk_recursive($record, $this->callable, $this->userData);
$transformer = new ArrayWalkRecursiveTransformer(function (&$value, $key, $userData) {
$value = doSomething($userData);
});KeyRenameTransformer : Rename Key(s) in Array, does not preserve key order
/**
* @param array $aliases
*
* @throws NodalFlowException
*/
// public function __construct(array $aliases)
$transformer = new KeyRenameTransformer(['oldKeyName' => 'newKeyName']);KeyUnsetTransformer : Unset Key(s) in Array
/**
* @param array $unsetList array of key to unset
*
* @throws NodalFlowException
*/
// public function __construct(array $unsetList)
$transformer = new KeyUnsetTransformer(['whatever' => 'keyToUnset1', 'KeyToUnset2']);The Loader holds the responsibility to "load" somehow and somewhere (or at least do something with) the record after it came through all upstream nodes in the flow. In many cases it is also desirable to actually flush many records at once while still getting them one by one from the transformer.
YaEtl will call its exec() method (again inherited from NodalFlow's ExecNodeInterface) each time a record comes through, but will only call flush() once, after the loop ended. This is done like this to allow multi inserts/update logic where applicable. In such cases, there could be some left overs after the loop ends as the Loader would not actually flush records upon each call to exec().
use fab2s\YaEtl\LoaderAbstract;
/**
* Class Loader
*/
class Loader extends LoaderAbstract
{
/**
* @var SuperCoolRepository
*/
protected $repository;
/**
* @var mixed
*/
protected $updateOrInsertData;
/**
* @return void
*/
public function exec($record)
{
// the bellow example is trivial, but this is where
// you can distinguish between updates and inserts
// in order to implement multi inserts
$this->updateOrInsertData = $record;
$this->flush();
}
/**
* This method is called at the end of the workflow in case the loader
* needs to flush some remaining data from its eventual buffer.
* Could be used to buffer records in order to perform multi inserts etc ...
*
* @param FlushStatusInterface $flushStatus the flush status, should only be set by
* YaEtl to indicate last flush() call status
* either :
* - clean (isClean()): everything went well
* - dirty (isDirty()): one extractor broke the flow
* - exception (isException()): an exception was raised during the flow
*
**/
public function flush(FlushStatusInterface $flushStatus = null)
{
if ($flushStatus !== null) {
/**
* This is YaEtl's call to flush()
* no need to further investigate here as
* we did not buffer anything
* but you could do things like:
* if ($flushStatus->isException()) {
* return;
* }
*
* The full story is :
* if ($flowStatus !== null) {
* // YaEtl's call to flush()
* if ($flowStatus->isClean()) {
* // everything went well
* } elseif ($flowStatus->isDirty()) {
* // a node broke the flow
* // you may want not to insert left overs
* } elseif ($flowStatus->isException()) {
* // an exception was raised during the flow execution
* }
* } else {
* // it should be you calling this method
* // during the flow execution (multi insert)
* }
*/
return;
}
// could be some kind of multi insert
$this->repository->CreateOrUpdate($this->updateOrInsertData);
}
}In some occasions, you could need to use several branches with a Loader in each. In such case, each branch will actually execute fully with each record from the root Flow. This creates an opportunity to call flush() each times the branch flow ends. YaEtl will detect the root Flow's call to flush() and by default will not trigger flush() among its own Loader(s) until the root Flow does it, which only occurs once per execution, when it ends.
This is done so because in most cases it makes more sense to synchronize flush() calls and keep the "triggered at the end of the process" logic. Especially since this would otherwise result in one call to flush() for every records in every branches.
Now if you where to find a use to trigger flush() more often among branches, you would just have to force flush on the relevant branches :
$branchInLoveWithFlush->forceFlush(true);By default, DB Loaders extending LoaderAbstract are not set to return a value, but this is only by declaration and is not a limitation. You can extend any existing Loader to just set the default as desired :
/**
* Class MyCustomLoader
*/
class MyCustomLoader extends LoaderAbstract // could be any other concrete implementation originally extending from LoaderAbstract
{
/**
* Loader can return a value, though it is set
* to false by default. If you need return values
* from a loader, set this to true, and next nodes
* will get the returned value as param.
*
* @var bool
*/
protected $isAReturningVal = true;
}or just set :
$this->isAReturningVal = true;directly where it make sense.
This can be very useful when you would have a loader in charge of generating UUIDs for new records, as it can in fact be chained with other Loaders that would need the generated ID/UUIDs from the same extraction.
A basic example of this could be object synchronisation with updates and insert in several repositories with a need for UUIDs. In such case, the first loader can be set to return a value and put in charge of generating the UUIDs (could also be a basic auto increment that would be required to derive other entries in more repos) for new objects. It then only needs to always return the complete and untouched incoming record from its load() method, that is to just add the generated UUIDs in the record for inserts and return it has is for updates.
YaEtl includes a generic FileLoaderAbstract abstract class which can be used as a foundation to file/resource load implementations.
The default constructor accepts both resources and file path as argument, and the partial implementation covers everything except the actual writing. Handles are released upon object destruction, but you also have access to releaseHandle() if you wish to do it earlier.
Every File based loader should (and does for YaEtl's one) extend FileLoaderAbstract.
FileLoaderAbstract comes with a constructor handling both File Path or resource as input:
/**
* @param resource|string $input
*
* @throws YaEtlException
* @throws NodalFlowException
*/
public function __construct($input)Since v1.1.1, YaEtl includes OpinHelpers, and FileLoaderAbstract based class will inherit the same BOM/encoding handling as FileExtractorAbstract from FileHandlerTrait.
Similarly, if you need to lock the file/resource being written, you can use FileLock:
$fileLock = FileLock::open($filePath, 'wb');
if ($fileLock) {
$fileLoader = new SomeFileLoader($fileLock->getHandle());
}Since one got to deal with CSV at some point, YaEtl comes with a CsvLoader implementation. It mostly follows the same spirit as CsvExtractor with a pretty obvious constructor:
/**
* CsvLoader constructor.
*
* @param string $destination
* @param string $delimiter
* @param string $enclosure
* @param string $escape
*
* @throws NodalFlowException
* @throws YaEtlException
*/
public function __construct($destination, $delimiter = ',', $enclosure = '"', $escape = '\\')Again, it justs uses the same CSV parameters as fputcsv().
$csvLoader = new CsvLoader($filePathOrHandle);
// if you wish to add header (first record array keys by default)
$csvLoader->setUseHeader(true);
// or if you prefer to define it manually
// note that header field order is IMPORTANT
$csvLoader->setHeader(['title', 'first', 'last']);
// in case you whish to add the infamous sep=$this->delimiter
$csvLoader->setUseSep(true);
// or a BOM, provided that you set an unicode encoding
$csvLoader->setUseBom(true)->setEncoding('UTF-16LE');
// standalone
$csvLoader->load(['Mr', 'John', 'Doe']);
/*
* will write
\xFE\xFFsep=,
title,first,last
Mr,John,Doe
* To the output file
*/
$csvLoader->load(['Mrs', 'Jane', 'Doe']);
/*
* will append
Mrs,Jane,Doe
* To the output file
*/
// or in a Flow
// (new YaEtl)->from($soemExtractor)-> ... ->to($csvLoader)->exec();// take an array as record
// handle is released upon destruction, but you can do it earlier
$csvLoader->releaseHandle();YaEtl version >= 1.1.0
Qualifiers are designed to isolate conditions that may or may not Qualify a record to be further processed. They can leverage the full power of NodalFlow's Interruptions but should in far most cases be used to isolate any conditions required on a record that would otherwise be implemented in other types of Nodes. The Qualifier Node aims at a better separation of concern among Nodes which in returns should increase re-usability. A simple use case could be a user extraction with several possible actions (load) depending on their properties. You could for example be sending a massive newsletter to all your user and add some perks for the mighty ones :
$yaetl = (new YaEtl)->from(new SuperSlowAndMassiveUserSourceExtractor);
$premiumBranch = (new YaEtl)->qualify(new CallableQualifier(function($record) {
// assuming that we deal with array in this case
if ($record['swagg_level'] > 9) {
// will get the perk
return true;
}
// too bad ^^
})
->to(new SendPerkLoader);
// send news letter and perks at once
// without any such condition in the loaders
$yaetl->branch($premiumBranch)
->to(new NewLetterLoaderLoader)
->exec();As you can see, by using a Qualifier, we did not have to put the condition in the Loaders (or Transformer), keeping them more agnostic and easy to re-use. This pattern can be used for more complex tasks such as qualifying record dimension in aggregation processes. In such cases, every dimension that can be derived from the same record can be handled by a branch holding the relevant Qualifier, the eventual Transformers and the Loader(s).
The QualifierInterface only defines one method :
/**
* Qualifies a record to either keep it, skip it or break the flow at the execution point
* or at any upstream Node
*
* @param mixed $param
*
* @return InterrupterInterface|bool|null|void `true` to accept the record, eg let the Flow proceed untouched
* `false|null|void` to deny the record, eg trigger a continue on the carrier Flow (not ancestors)
* `InterrupterInterface` to trigger an interrupt with a target (which may be one ancestor)
*/
public function qualify($param);