spiriitlabs / poliris-bundle
Poliris bundle for CSV
Requires
- php: >=7.2
- symfony/framework-bundle: ^5.4|^6.0
- symfony/serializer: ^5.4|^6.0
- symfony/yaml: ^5.4|^6.0
Requires (Dev)
- symfony/phpunit-bridge: ^5.4|^6.0
This package is auto-updated.
Last update: 2024-10-30 01:54:09 UTC
README
This bundle provide Poliris generation CSV.
Current version is V4.1.17.
Installation
Add
spiriitlabs/poliris-bundle
to your composer.json
file:
$ php composer.phar require "spiriitlabs/poliris-bundle"
How to use
A CSV Poliris is very long. More than 333 columns.
Here we propose to use the pattern Builder to create it.
Some classes:
The Column
class represents a position in a CSV file by associating an index with a value:
$column1 = new Column(1, 'Agence id'); // a string $column2 = new Column(2, true); // OUI / NON $column2 = new Column(2, new \DateTimeImmutable('2023-05-01')); // format d/m/Y $column2 = new Column(2, object); // return toString on object $column2 = new Column(2, 1); // 1
If a string is used, we remove spaces and EOL.
Exemple:
beautiful house with garage
is transformed into:
beautiful house with garage
After that we have a lot of classes, exemple "Exterieur"
If we look at the constructor:
public function __construct( $ascenseur, $calme, $piscine, $vueDegagee, $entree, $visAVis, $monteCharge ) { $this->ascenseur = new Column(41, $ascenseur); $this->calme = new Column(63, $calme); $this->piscine = new Column(65, $piscine); $this->vueDegagee = new Column(78, $vueDegagee); $this->entree = new Column(189, $entree); $this->visAVis = new Column(192, $visAVis); $this->monteCharge = new Column(197, $monteCharge); }
In this example, the CSV file contains data about Exterior features of a property, which are not sequentially
arranged in consecutive columns. To simplify the handling of this data, we decided to consolidate them using
the Column
class.
Each property is represented by an instance of Column
, where the index specifies the column position
in the CSV file, and the value holds the associated data. This approach allows for easier access to the exterior
features of the property, even if they are scattered throughout the CSV file.
There is 31 classes. models
Usage
$builder = new AnnonceExportBuilder(); foreach ($lines as $line) { try { $this->createLine($builder, $line); } catch (\Throwable $throwable) { // log } } return $builder->build();
function createLine() { $builder ->startLine() ->withIdentifiant( 'somewhere', 'agence_id', Annonce::ANNONCE_TYPE_VENTE, 'REF_BA123' ) ->withType( getType(), getSubType() )
Important - No validation
There is no validation on the data. Why? A CSV file can have several thousand rows, multiplied by approximately 300 columns, and PHP struggles to keep up.
Historically, there were validation classes using the Validator component, but it is too memory-intensive.
One solution would be to batch process the CSV and validate only a few rows at a time. However, that is not currently on the agenda.