Migration1690874168FixPaymentStatusUnconfirmedMail example

$this->connection = KernelLifecycleManager::getConnection();
        $templateTypeId = $this->connection->fetchOne('SELECT HEX(id) FROM mail_template_type WHERE technical_name = :name', ['name' => Migration1688106315AddMissingTransactionMailTemplates::UNCONFIRMED_TYPE]);

        if (\is_string($templateTypeId)) {
            $this->connection->executeStatement('DELETE FROM `mail_template` WHERE `mail_template_type_id` = :id', ['id' => $templateTypeId]);
            $this->connection->executeStatement('DELETE FROM `mail_template_type` WHERE `id` = :id', ['id' => $templateTypeId]);
        }
    }

    public function testCreationTimestamp(): void
    {
        $migration = new Migration1690874168FixPaymentStatusUnconfirmedMail();
        static::assertSame(1690874168, $migration->getCreationTimestamp());
    }

    public function testMigration(): void
    {
        $migration = new Migration1690874168FixPaymentStatusUnconfirmedMail();
        $migration->update($this->connection);
        $migration->update($this->connection);
        $this->assertMailTemplate();
    }