A Doctrine Collection Bridge to work with League CSV
This package contains:
<?php
use Bakame\Csv\Extension as CsvExtension;
use Doctrine\Common\Collections\Criteria;
use League\Csv\Reader;
$csv = Reader::createFromPath('/path/to/my/file.csv');
$csv->setHeaderOffset(0);
$csv->setDelimiter(';');
$criteria = Criteria::create()
->andWhere(Criteria::expr()->eq('prenom', 'Adam'))
->orderBy( [ 'annee' => 'ASC', 'foo' => 'desc', ] )
->setFirstResult(0)
->setMaxResults(10)
;
//you can do
$resultset = CsvExtension\CriteriaConverter::convert($criteria)->process($csv);
$result = new CsvExtension\RecordCollection($resultset);
//or
$collection = new CsvExtension\RecordCollection($csv);
$result = $collection->matching($criteria);
but the latest stable version of each dependency is recommended.
$ composer require bakame/csv-doctrine-collection-bridge
League\Csv\Reader
into a Doctrine Collection object.<?php
use Bakame\Csv\Extension\RecordCollection;
use League\Csv\Reader;
$csv = Reader::createFromPath('/path/to/my/file.csv');
$csv->setHeaderOffset(0);
$csv->setDelimiter(';');
$collection = new RecordCollection($csv);
League\Csv\ResultSet
into a Doctrine Collection object.<?php
$csv = Reader::createFromPath('/path/to/my/file.csv');
$csv->setHeaderOffset(0);
$csv->setDelimiter(';');
$stmt = (new Statement())
->where(function (array $row) {
return isset($row['email'])
&& false !== strpos($row['email'], '@github.com');
});
$collection = new RecordCollection($stmt->process($csv));
League\Csv\Reader
objectYou can simply use the provided Bakame\Csv\Extension\criteria_convert
function to convert a Doctrine\Common\Collections\Criteria
object into a League\Csv\Statement
one.
<?php
use Bakame\Csv\Extension\CriteriaConverter;
use Doctrine\Common\Collections\Criteria;
use League\Csv\Reader;
$csv = Reader::createFromPath('/path/to/my/file.csv');
$csv->setHeaderOffset(0);
$csv->setDelimiter(';');
$criteria = Criteria::create()
->andWhere(Criteria::expr()->eq('name', 'Adam'))
->orderBy(['years', 'ASC'])
->setFirstResult(0)
->setMaxResults(10)
;
$stmt = CriteriaConverter::convert($criteria);
$resultset = $stmt->process($csv);
<?php
use Doctrine\Common\Collections\Criteria;
use League\Csv\Statement;
public static CriteriaConverter::convert(Criteria $criteria, Statement $stmt = null): Statement
public static CriteriaConverter::addWhere(Criteria $criteria, Statement $stmt = null): Statement
public static CriteriaConverter::addOrderBy(Criteria $criteria, Statement $stmt = null): Statement
public static CriteriaConverter::addInterval(Criteria $criteria, Statement $stmt = null): Statement
CriteriaConverter::convert
converts the Criteria
object into a Statement
object.CriteriaConverter::addWhere
adds the Criteria::getWhereExpression
filters to the submitted Statement
object.CriteriaConverter::addOrderBy
adds the Criteria::getOrderings
filters to the submitted Statement
object.CriteriaConverter::addInterval
adds the Criteria::getFirstResult
and Criteria::getMaxResults
filters to the submitted Statement
object.WARNING: While the Criteria
object is mutable the Statement
object is immutable. All returned Statement
objects are new instances
Contributions are welcome and will be fully credited. Please see CONTRIBUTING for details.
The library has a :
To run the tests, run the following command from the project folder.
$ composer test
If you discover any security related issues, please email [email protected] instead of using the issue tracker.
The MIT License (MIT). Please see License File for more information.