<?php
declare(strict_types=1);

namespace App\Tests\Functional;

use App\Entity\Book;
use App\Entity\OustedBook;
use App\Tests\DatabaseTestCase;
use App\Tests\LegacyDatabase;
use Symfony\Bundle\FrameworkBundle\Console\Application;
use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Tester\CommandTester;

final class ImportLegacyCommandTest extends DatabaseTestCase {
	use LegacyDatabase;

	protected function setUp(): void {
		parent::setUp();

		$this->createLegacyTables();
	}

	public function testImportMapsBooks(): void {
		$this->addLegacyBook(['id' => 0, 'tytul' => 'Zerowa', 'autor' => 'A', 'jezyk' => 'polski', 'rok' => 2005, 'miejsce' => 'Wrocław', 'wydawnictwo' => 'W', 'wydanie' => '2', 'ISBN' => '9788373843455', 'regal' => 'HOL', 'polka' => '4', 'rzad' => '1']);
		$this->addLegacyBook(['id' => 1, 'tytul' => 'Bez danych', 'autor' => 'B', 'jezyk' => '', 'rok' => 0]);
		$this->addLegacyBook(['id' => 2, 'tytul' => 'Częściowa lokalizacja', 'autor' => 'C', 'jezyk' => 'eng', 'regal' => 'K', 'ISBN' => '306406152', 'ISSN' => '3161234']);
		$this->addLegacyBook(['id' => 3, 'tytul' => 'Wycofana', 'autor' => 'D', 'jezyk' => 'polski', 'regal' => 'JK', 'polka' => '1', 'ISBN' => '9788303001795', 'wycofana' => '1', 'powod' => 'Zniszczona']);

		$tester = $this->runImport();

		$tester->assertCommandIsSuccessful();
		$this->entityManager()->clear();

		$full = $this->findBook(0);
		self::assertSame('Zerowa', $full?->getTitle());
		self::assertSame('polski', $full?->getLanguage());
		self::assertSame(2005, $full?->getPublicationYear());
		self::assertSame('9788373843455', $full?->getIsbn());
		self::assertSame('HOL/4/1', $full?->getPlacement());

		$sparse = $this->findBook(1);
		self::assertNull($sparse?->getLanguage());
		self::assertNull($sparse?->getPublicationYear());
		self::assertNull($sparse?->getPlacement());

		$partial = $this->findBook(2);
		self::assertSame('K', $partial?->getPlacement());
		self::assertSame('9780306406157', $partial?->getIsbn());
		self::assertSame('03161234', $partial?->getIssn());

		$ousted = $this->entityManager()->find(OustedBook::class, 3);
		self::assertSame('Zniszczona', $ousted?->getReason());
		self::assertSame('JK/1', $ousted?->getPlacement());
		self::assertSame('9788303001795', $ousted?->getIsbn());
		self::assertNull($this->findBook(3));
	}

	public function testInvalidIsbnIsKeptAsATextLabel(): void {
		$this->addLegacyBook(['id' => 1, 'tytul' => 'Zły numer', 'autor' => 'A', 'jezyk' => 'polski', 'ISBN' => '9788373843456']);

		$tester = $this->runImport();

		$tester->assertCommandIsSuccessful();
		self::assertStringContainsString('book 1: 9788373843456', $tester->getDisplay());
		$book = $this->findBook(1);
		self::assertNull($book?->getIsbn());
		self::assertSame('9788373843456', $book?->getTextLabels()[0]->getLabel());
	}

	public function testImportedBooksAreSearchable(): void {
		$this->addLegacyBook(['id' => 1, 'tytul' => 'Łódź', 'autor' => 'A', 'jezyk' => 'polski']);

		$this->runImport();

		$crawler = $this->client->request('GET', '/search', ['q' => 'Łódź']);
		self::assertCount(1, $crawler->filter('.tile'));
	}

	public function testImportMapsLoans(): void {
		$this->addLegacyBook(['id' => 1, 'tytul' => 'Na półce', 'autor' => 'A', 'jezyk' => 'polski']);
		$this->addLegacyBook(['id' => 2, 'tytul' => 'Wycofana', 'autor' => 'B', 'jezyk' => 'polski', 'wycofana' => '1', 'powod' => 'Prezent']);
		$this->legacy->insert('pozycz', ['id' => 1, 'kto' => 'Osoba A', 'od' => 1556909792]);
		$this->legacy->insert('pozycz_historia', ['id' => 1, 'kto' => 'Osoba B', 'od' => 1212076475, '"do"' => 1212176475]);
		$this->legacy->insert('pozycz_historia', ['id' => 2, 'kto' => 'Osoba C', 'od' => 1212076475, '"do"' => 1212176475]);

		$tester = $this->runImport();
		$tester->assertCommandIsSuccessful();

		$book = $this->findBook(1);
		self::assertSame('Osoba A', $book?->getBorrow()?->getWho());
		self::assertSame(1556909792, $book?->getBorrow()?->getAt()->getTimestamp());

		$entry = $book?->getBorrowHistory()->first();
		self::assertSame('Osoba B', $entry->getWho());
		self::assertSame(1212176475, $entry->getTill()->getTimestamp());

		self::assertCount(1, $this->entityManager()->find(OustedBook::class, 2)?->getBorrowHistory() ?? []);
		self::assertStringNotContainsString('left out', $tester->getDisplay());
	}

	public function testRowsWithoutAPlaceInTheNewSchemaAreReported(): void {
		$this->addLegacyBook(['id' => 1, 'tytul' => 'Dwa razy', 'autor' => 'A', 'jezyk' => 'polski']);
		$this->addLegacyBook(['id' => 2, 'tytul' => 'Wycofana', 'autor' => 'B', 'jezyk' => 'polski', 'wycofana' => '1', 'powod' => 'Prezent']);
		$this->legacy->insert('pozycz', ['id' => 1, 'kto' => 'Starsze', 'od' => 1000]);
		$this->legacy->insert('pozycz', ['id' => 1, 'kto' => 'Nowsze', 'od' => 2000]);
		$this->legacy->insert('pozycz', ['id' => 2, 'kto' => 'Osoba', 'od' => 1000]);
		$this->legacy->insert('pozycz', ['id' => 99, 'kto' => 'Osoba', 'od' => 1000]);
		$this->legacy->insert('pozycz_historia', ['id' => 99, 'kto' => 'Osoba', 'od' => 1000, '"do"' => 2000]);
		$this->legacy->insert('pozycz_historia', ['id' => 1, 'kto' => 'Osoba', 'od' => 1000, '"do"' => null]);

		$tester = $this->runImport();

		$tester->assertCommandIsSuccessful();
		self::assertSame('Nowsze', $this->findBook(1)?->getBorrow()?->getWho());

		$display = preg_replace('/\s+/', ' ', $tester->getDisplay());
		self::assertStringContainsString('5 rows were left out', $display);
		self::assertStringContainsString('book 1 has more than one open loan', $display);
		self::assertStringContainsString('book 2 is on loan but ousted', $display);
		self::assertStringContainsString('pozycz: book 99 does not exist', $display);
		self::assertStringContainsString('pozycz_historia: book 99 does not exist', $display);
		self::assertStringContainsString('has no end date', $display);
	}

	public function testDryRunSavesNothing(): void {
		$this->addLegacyBook(['id' => 1, 'tytul' => 'Książka', 'autor' => 'A', 'jezyk' => 'polski']);

		$tester = $this->runImport(['--dry-run' => true]);

		$tester->assertCommandIsSuccessful();
		self::assertStringContainsString('nothing was saved', $tester->getDisplay());
		self::assertSame(0, $this->entityManager()->getRepository(Book::class)->count());
	}

	public function testImportKeepsBooksAlreadyInTheTarget(): void {
		$this->createBook(1, 'Edited title');
		$ousted = new OustedBook('Lost')->setId(2)->setTitle('Ousted since')->setAuthor('B');
		$this->entityManager()->persist($ousted);
		$this->entityManager()->flush();
		$this->addLegacyBook(['id' => 1, 'tytul' => 'Legacy title', 'autor' => 'A', 'jezyk' => 'polski']);
		$this->addLegacyBook(['id' => 2, 'tytul' => 'Na półce', 'autor' => 'B', 'jezyk' => 'polski']);
		$this->addLegacyBook(['id' => 3, 'tytul' => 'Nowa', 'autor' => 'C', 'jezyk' => 'polski']);
		$this->legacy->insert('pozycz', ['id' => 1, 'kto' => 'Osoba A', 'od' => 1000]);
		$this->legacy->insert('pozycz_historia', ['id' => 2, 'kto' => 'Osoba B', 'od' => 1000, '"do"' => 2000]);

		$tester = $this->runImport();

		$tester->assertCommandIsSuccessful();
		$book = $this->findBook(1);
		self::assertSame('Edited title', $book?->getTitle());
		self::assertNull($book?->getBorrow());
		self::assertNull($this->findBook(2));
		self::assertCount(0, $this->entityManager()->find(OustedBook::class, 2)?->getBorrowHistory() ?? [1]);
		self::assertSame('Nowa', $this->findBook(3)?->getTitle());
		self::assertMatchesRegularExpression('/already in target, kept\s+2/', $tester->getDisplay());
		self::assertStringNotContainsString('left out', $tester->getDisplay());
	}

	public function testRunningTheImportTwiceChangesNothing(): void {
		$this->addLegacyBook(['id' => 1, 'tytul' => 'Książka', 'autor' => 'A', 'jezyk' => 'polski', 'ISBN' => '9788373843456']);
		$this->addLegacyBook(['id' => 2, 'tytul' => 'Wycofana', 'autor' => 'B', 'jezyk' => 'polski', 'wycofana' => '1', 'powod' => 'Prezent']);
		$this->legacy->insert('pozycz', ['id' => 1, 'kto' => 'Osoba A', 'od' => 2000]);
		$this->legacy->insert('pozycz_historia', ['id' => 1, 'kto' => 'Osoba B', 'od' => 1000, '"do"' => 1500]);
		$this->legacy->insert('pozycz_historia', ['id' => 2, 'kto' => 'Osoba C', 'od' => 1000, '"do"' => 1500]);
		$this->runImport()->assertCommandIsSuccessful();

		$tester = $this->runImport();

		$tester->assertCommandIsSuccessful();
		self::assertSame(1, $this->entityManager()->getRepository(Book::class)->count());
		self::assertSame(1, $this->entityManager()->getRepository(OustedBook::class)->count());
		$book = $this->findBook(1);
		self::assertSame('Osoba A', $book?->getBorrow()?->getWho());
		self::assertCount(1, $book?->getBorrowHistory() ?? []);
		self::assertCount(1, $book?->getTextLabels() ?? []);
		self::assertCount(1, $this->entityManager()->find(OustedBook::class, 2)?->getBorrowHistory() ?? []);
		self::assertMatchesRegularExpression('/already in target, kept\s+2/', $tester->getDisplay());
	}

	public function testFailureLeavesTheTargetUntouched(): void {
		$this->addLegacyBook(['id' => 1, 'tytul' => 'Książka', 'autor' => 'A', 'jezyk' => 'polski']);
		$this->legacy->executeStatement('ALTER TABLE pozycz RENAME TO pozycz_missing');

		try {
			$this->runImport();
			self::fail('The import should have failed.');
		} catch (\Doctrine\DBAL\Exception) {
			self::assertSame(0, $this->entityManager()->getRepository(Book::class)->count());
		}
	}

	/**
	 * @param array<string, mixed> $row
	 */
	private function addLegacyBook(array $row): void {
		$this->legacy->insert('ksiazki', $row);
	}

	/**
	 * @param array<string, mixed> $input
	 */
	private function runImport(array $input = []): CommandTester {
		$application = new Application(static::$kernel);
		$tester = new CommandTester($application->find('app:import-legacy'));
		$tester->execute($input);

		return $tester;
	}
}