Két forrásból dolgozik: az archivált gyártók note mezőjéből (láncolást is követve, ha a célrekord maga is tovább olvadt), illetve a producers:dedupe --report JSON jelentéseiből, névalapú feloldással - a jelentésekben szereplő ID-k környezetenként eltérnek. Ütközés esetén kihagyja és jelenti a jelöltet, kétszeri futtatás nem hoz létre duplikált aliast.
162 lines
6.5 KiB
PHP
162 lines
6.5 KiB
PHP
<?php
|
||
|
||
use App\Enums\DbStatusFieldEnum;
|
||
use App\Models\Producer;
|
||
use App\Models\ProducerAlias;
|
||
use Illuminate\Foundation\Testing\RefreshDatabase;
|
||
use Tests\TestCase;
|
||
|
||
uses(TestCase::class, RefreshDatabase::class);
|
||
|
||
/**
|
||
* @return array<int, array{name: string, origin: string}>
|
||
*/
|
||
function writeDedupeReportFixture(string $path, int $keeperId, string $finalName, array $fromNames, ?string $keeperOriginalName = null): void
|
||
{
|
||
$report = [
|
||
'created_at' => now()->toDateTimeString(),
|
||
'database' => 'fixture',
|
||
'merges' => [[
|
||
'keeper_id' => $keeperId,
|
||
'final_name' => $finalName,
|
||
'from' => array_map(fn ($n, $i) => ['id' => 1000 + $i, 'name' => $n], $fromNames, array_keys($fromNames)),
|
||
]],
|
||
'restore' => [
|
||
'producers' => $keeperOriginalName !== null
|
||
? [$keeperId => ['id' => $keeperId, 'name' => $keeperOriginalName]]
|
||
: [],
|
||
],
|
||
];
|
||
|
||
file_put_contents($path, json_encode($report, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE));
|
||
}
|
||
|
||
test('az archivált gyártó note-jából aliast hoz létre a célrekordhoz --apply mellett', function () {
|
||
$keeper = Producer::create(['name' => 'Kőröstej Kft.', 'status' => DbStatusFieldEnum::active, 'canSee' => 1]);
|
||
Producer::create([
|
||
'name' => 'Kőröstej',
|
||
'status' => DbStatusFieldEnum::archive,
|
||
'canSee' => 0,
|
||
'note' => "Összevonva ide: #{$keeper->id} (Kőröstej Kft.) – 2026-09-15 producers:dedupe",
|
||
]);
|
||
|
||
$this->artisan('producers:alias-backfill', ['--apply' => true])->assertExitCode(0);
|
||
|
||
expect(ProducerAlias::where('producer_id', $keeper->id)->pluck('name')->all())->toBe(['Kőröstej']);
|
||
});
|
||
|
||
test('--apply nélkül csak kimutat, nem ír adatbázist', function () {
|
||
$keeper = Producer::create(['name' => 'Danone', 'status' => DbStatusFieldEnum::active, 'canSee' => 1]);
|
||
Producer::create([
|
||
'name' => 'Danone ',
|
||
'status' => DbStatusFieldEnum::archive,
|
||
'canSee' => 0,
|
||
'note' => "Összevonva ide: #{$keeper->id} (Danone) – 2026-09-15 producers:dedupe",
|
||
]);
|
||
|
||
$this->artisan('producers:alias-backfill')->assertExitCode(0);
|
||
|
||
expect(ProducerAlias::count())->toBe(0);
|
||
});
|
||
|
||
test('a láncolt archiválást a jelenlegi aktív rekordig követi', function () {
|
||
// 1. kör: "Régi A" -> #B, de #B maga is beolvad a 2. körben #C-be.
|
||
$c = Producer::create(['name' => 'Végleges C', 'status' => DbStatusFieldEnum::active, 'canSee' => 1]);
|
||
$b = Producer::create([
|
||
'name' => 'Köztes B',
|
||
'status' => DbStatusFieldEnum::archive,
|
||
'canSee' => 0,
|
||
'note' => "Összevonva ide: #{$c->id} (Végleges C) – 2026-09-16 producers:dedupe",
|
||
]);
|
||
Producer::create([
|
||
'name' => 'Régi A',
|
||
'status' => DbStatusFieldEnum::archive,
|
||
'canSee' => 0,
|
||
'note' => "Összevonva ide: #{$b->id} (Köztes B) – 2026-09-15 producers:dedupe",
|
||
]);
|
||
|
||
$this->artisan('producers:alias-backfill', ['--apply' => true])->assertExitCode(0);
|
||
|
||
expect(ProducerAlias::where('producer_id', $c->id)->pluck('name')->sort()->values()->all())
|
||
->toBe(['Köztes B', 'Régi A']);
|
||
});
|
||
|
||
test('a feloldhatatlan note-ot kihagyja, nem szakítja meg a futást', function () {
|
||
Producer::create([
|
||
'name' => 'Árva Rekord',
|
||
'status' => DbStatusFieldEnum::archive,
|
||
'canSee' => 0,
|
||
'note' => 'Nincs értelmezhető formátum',
|
||
]);
|
||
|
||
$this->artisan('producers:alias-backfill', ['--apply' => true])->assertExitCode(0);
|
||
|
||
expect(ProducerAlias::count())->toBe(0);
|
||
});
|
||
|
||
test('a jelentésfájlból névalapon oldja fel a célrekordot', function () {
|
||
$keeper = Producer::create(['name' => 'Voyagex', 'status' => DbStatusFieldEnum::active, 'canSee' => 1]);
|
||
$path = storage_path('app/private/teszt_alias_backfill_report.json');
|
||
// A "VOYAGEX" szándékosan hiányzik a várt eredményből: normalizálva megegyezik az
|
||
// élő "Voyagex" névvel, tehát a parancsnak redundánsként ki kell hagynia.
|
||
writeDedupeReportFixture($path, keeperId: 999, finalName: 'Voyagex', fromNames: ['Voyagex Kft', 'VOYAGEX']);
|
||
|
||
$this->artisan('producers:alias-backfill', ['reports' => [$path], '--skip-archives' => true, '--apply' => true])
|
||
->assertExitCode(0);
|
||
|
||
expect(ProducerAlias::where('producer_id', $keeper->id)->pluck('name')->sort()->values()->all())
|
||
->toBe(['Voyagex Kft']);
|
||
|
||
@unlink($path);
|
||
});
|
||
|
||
test('a jelentésben az átnevezett keeper eredeti neve is aliassá válik', function () {
|
||
$keeper = Producer::create(['name' => 'Végleges Név Kft', 'status' => DbStatusFieldEnum::active, 'canSee' => 1]);
|
||
$path = storage_path('app/private/teszt_alias_backfill_rename.json');
|
||
writeDedupeReportFixture(
|
||
$path,
|
||
keeperId: 999,
|
||
finalName: 'Végleges Név Kft',
|
||
fromNames: ['Elavult Név'],
|
||
keeperOriginalName: 'Régi Saját Név'
|
||
);
|
||
|
||
$this->artisan('producers:alias-backfill', ['reports' => [$path], '--skip-archives' => true, '--apply' => true])
|
||
->assertExitCode(0);
|
||
|
||
expect(ProducerAlias::where('producer_id', $keeper->id)->pluck('name')->sort()->values()->all())
|
||
->toBe(['Elavult Név', 'Régi Saját Név']);
|
||
|
||
@unlink($path);
|
||
});
|
||
|
||
test('ütköző jelöltet nem szúr be, csak jelenti', function () {
|
||
Producer::create(['name' => 'Bonduelle', 'status' => DbStatusFieldEnum::active, 'canSee' => 1]);
|
||
$keeper = Producer::create(['name' => 'Danone', 'status' => DbStatusFieldEnum::active, 'canSee' => 1]);
|
||
Producer::create([
|
||
'name' => 'Bonduelle', // ugyanaz a név, mint egy MÁSIK élő gyártóé - ütközik
|
||
'status' => DbStatusFieldEnum::archive,
|
||
'canSee' => 0,
|
||
'note' => "Összevonva ide: #{$keeper->id} (Danone) – 2026-09-15 producers:dedupe",
|
||
]);
|
||
|
||
$this->artisan('producers:alias-backfill', ['--apply' => true])->assertExitCode(0);
|
||
|
||
expect(ProducerAlias::count())->toBe(0);
|
||
});
|
||
|
||
test('kétszeri futtatás nem hoz létre duplikált aliast (idempotens)', function () {
|
||
$keeper = Producer::create(['name' => 'Danone', 'status' => DbStatusFieldEnum::active, 'canSee' => 1]);
|
||
Producer::create([
|
||
'name' => 'Danone ',
|
||
'status' => DbStatusFieldEnum::archive,
|
||
'canSee' => 0,
|
||
'note' => "Összevonva ide: #{$keeper->id} (Danone) – 2026-09-15 producers:dedupe",
|
||
]);
|
||
|
||
$this->artisan('producers:alias-backfill', ['--apply' => true])->assertExitCode(0);
|
||
$this->artisan('producers:alias-backfill', ['--apply' => true])->assertExitCode(0);
|
||
|
||
expect(ProducerAlias::count())->toBe(1);
|
||
});
|