JSON conversion
The JsonConverter
converts or store a collection into a JSON structure.
To reduce memory usage, the converter transforms one collection element at a time. This means
that the class settings are geared toward a single element and not the whole collection.
The only pre-requisite is that each element of your collection must either be an
object implementing the JsonSerializable
interface or a PHP structure that
can be encoded via json_encode
.
Settings
Prior to converting your collection into a JSON structure, you may wish to configure it.
JSON encode flags
public JsonConverter::addFlags(int ...$flag): self
public JsonConverter::removeFlags(int ...$flag): self
public JsonConverter::useFlags(int ...$flag): bool
These methods set the JSON flags to be used during conversion. The method handles all the
flags supported by PHP json_encode
function.
If you prefer a more expressive way for setting the flags you can use the with*
and without*
methods
whose name are derived from PHP JSON constants.
$converter = JsonConverter::create()
->addFlags(JSON_PRETTY_PRINT, JSON_HEX_QUOT, JSON_UNESCAPED_SLASHES, JSON_FORCE_OBJECT)
->removeFlags(JSON_HEX_QUOT);
//is equivalent to
$converter = JsonConverter::create()
->withPrettyPrint()
->withHexQuot()
->withUnescapedSlashes()
->withForceObject()
->withoutHexQuot();
To quickly check which flags is being used, calle the JsonConverter::useFlags
method. As for the other methods
a more expressive way exists.
$converter = JsonConverter::create()
->addFlags(JSON_PRETTY_PRINT, JSON_UNESCAPED_SLASHES, JSON_FORCE_OBJECT)
->removeFlags(JSON_HEX_QUOT);
$converter->useFlags(JSON_PRETTY_PRINT, JSON_FORCE_OBJECT); //returns true both flags are used
$converter->useFlags(JSON_PRETTY_PRINT, JSON_HEX_QUOT); //returns false at least one of the flag is not set
$converter->usePrettyPrint(); // returns true the flag is used
$converter->useThrowOnError(); // returns true the flag is always used
$converter->useHexQuot(); // returns false the flag is not used
$converter->flags; //returns the actual flags value (as used by json_encode)
Json encode depth
public JsonConverter::depth(int $depth): self
This method sets the JSON depth value during conversion. The method is a proxy to using the
json_encode
depth parameter.
$converter = JsonConverter::create()->depth(2);
$converter->depth; //returns the actual depth value (as used by json_encode)
Json encode indentation
public JsonConverter::indentSize(int $indentSize): self
This method sets the JSON indentation size value if you use the JSON_PRETTY_PRINT
flag. In
all other situation this value stored via this method is never used. By default, the indentation
size is the same as in PHP (ie : 4 characters long).
$converter = JsonConverter::create()->indentSize(2);
$converter->indentSize; //returns the value used
Json encode formatter
public JsonConverter::formatter(?callback $formatter): mixed
This method allow to apply a callback prior to json_encode
your collection individual item.
Since the encoder does not rely on PHP’s JsonSerializable
interface but on PHP’s iterable
structure. The resulting conversion may differ to what you expect. This callback allows you to
specify how each item will be converted. The formatter should return a type that can be handled
by PHP json_encode
function.
Conversion
public JsonConverter::convert(iterable $records): iterable<string>
public JsonConverter::encode(iterable $records): string
public JsonConverter::save(iterable $records, mixed $destination, $context = null): int
The JsonConverter::convert
accepts an iterable
which represents the records collection
and returns a iterable
structure lazily converted to JSON one item at a time to avoid
high memory usage. The class is built to handle large CSV documents but can be used with
small CSV document file if needed.
The JsonConverter::encode
and JsonConverter::save
methods are sugar syntactic methods to
ease storing the JSON in a file or displaying it in its full JSON string representation.
Here’s a conversion example:
$document = Reader::createFromPath(__DIR__.'/test_files/prenoms.csv');
$document->setDelimiter(';');
$document->setHeaderOffset(0);
CharsetConverter::addTo($document, 'iso-8859-15', 'utf-8');
$converter = JsonConverter::create()
->withPrettyPrint()
->withUnescapedSlashes()
->depth(2)
->indentSize(2)
->formatter(function (array $row) {
$row['nombre'] = (int) $row['nombre'];
$row['annee'] = (int) $row['annee'];
$row['sexe'] = $row['sexe'] === 'M' ? 'male' : 'female';
//other attributes of $row are not affected
//and will be rendered as they are.
return $row;
});
echo $converter->encode($document->slice(3, 2)), PHP_EOL;
This will produce the following response:
[
{
"prenoms": "Abdoulaye",
"nombre": 15,
"sexe": "male",
"annee": 2004
},
{
"prenoms": "Abel",
"nombre": 14,
"sexe": "male",
"annee": 2004
}
]
Of note, since the CSV document is not encoded in UTF-8
we first convert it using the CharsetConverter
class
otherwise an exception would have been triggered when json encoding the data.
If we wanted to store the data instead of displaying it we could do the following
- echo $converter->encode($document), PHP_EOL;
+ $converter->save($document, 'my/new/document.json');
the generated CSV will then be stored at the my/new/document.json
path.
The destination path can be specified using:
- a
SplFileObject
instance; - a
SplFileInfo
instance; - a resource created by
fopen
; - a string;
If you provide a string or a SplFileInfo
instance:
- the file will be open using the
w
open mode. - You can provide an additional
$context
parameter, a lafopen
, to fine tune where and how the JSON file will be stored.
Download
If we want to download the generated JSON the JsonConverter::download
method can be used as follows:
use League\Csv\Reader;
use League\Csv\JsonConverter;
$reader = Reader::createFromPath('file.csv');
$reader->setHeaderOffset(0);
header('Cache-Control: no-cache, no-store, must-revalidate');
header('Pragma: no-cache');
header('Expires: 0');
JsonConverter::create()->download($reader, 'generated_file.json'); //the filename will be the name of the downloaded json!
die;
The caching header are left to the implementor to decide how to be set if needed. The value are left as example.