This is templator business logic package for import/export data.
To install this package you can use composer:
composer require rkov/template-import-exportFirst, you need to configure import:
use Rkov\TemplateImportExport\Factories\ConfigFactory;
use Rkov\TemplateImportExport\Aggregates\FieldList;
use Rkov\TemplateImportExport\Fields\IdFiled;
use Rkov\TemplateImportExport\Fields\NumberField;
use Rkov\TemplateImportExport\Fields\StringField;
class UserConfig extends ConfigFactory
{
public function fieldList(): FieldList
{
return new FieldList(
IdFiled::make(),
StringField::make('name', 'Name'),
NumberField::make('age', 'Age'),
);
}
public function insertRow(array|object $row): string|int
{
$user = User::create([
'name' => $row['name'],
'age' => $row['age'],
]);
return $user->id;
}
public function updateRow(array|object $row): string|int
{
$user = User::find($row['id']);
$user->update([
'name' => $row['name'],
'age' => $row['age'],
]);
return $user->id;
}
}After, you need to parse data from source (database or file):
class UserJsonData implements ParseDataInterface
{
public function __construct(
private string $file
){}
public function getRawData(): RawDataAggregate
{
return new RawData(function () {
$data = file_get_contents($this->file);
yeild from json_decode($data, true);
});
}
}Now, run import in your project like this:
use Rkov\TemplateImportExport\DataExchange;
$config = new UserConfig();
$importService = DataExchange::make()->import($config);
$userData = new UserJsonData('path/to/file.json');
$importData = $importService->import($userData);
// the import start
foreach($importData->ids as $keyRow => $id) {
// do something with $id
}
// after import
foreach($importData->errors as $keyRow => $errorMessages) {
foreach($errorMessages as $errorMessage) {
// do something with $errorMessage
$message = (string) $errorMessage;
$key = $errorMessage->getKey();
$title = $errorMessage->getTitle();
}
}Copyright (c) Rochev Yakov. Distributed under the MIT.