Doctrine ORM en modulos PrestaShop 8/9

<?php

declare(strict_types=1);

namespace MyModule\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Table(name="mymodule_item")
 * @ORM\Entity(repositoryClass="MyModule\Repository\MyItemRepository")
 */
class MyItem
{
    /**
     * @ORM\Id
     * @ORM\Column(name="id_mymodule_item", type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private int $id;

    /**
     * @ORM\Column(name="name", type="string", length=255)
     */
    private string $name = '';

    /**
     * @ORM\Column(name="active", type="boolean")
     */
    private bool $active = true;

    /**
     * @ORM\Column(name="sort_order", type="integer", options={"default":0})
     */
    private int $sortOrder = 0;

    public function getId(): int { return $this->id; }
    public function getName(): string { return $this->name; }
    public function setName(string $name): self { $this->name = $name; return $this; }
    public function isActive(): bool { return $this->active; }
    public function setActive(bool $active): self { $this->active = $active; return $this; }
}

<?php

use Doctrine\ORM\Tools\SchemaTool;
use MyModule\Entity\MyItem;

public function install(): bool
{
    return parent::install()
        && $this->installDoctrineTables();
}

public function uninstall(): bool
{
    return $this->uninstallDoctrineTables()
        && parent::uninstall();
}

private function installDoctrineTables(): bool
{
    try {
        $em         = $this->get('doctrine.orm.default_entity_manager');
        $schemaTool = new SchemaTool($em);
        $metadata   = $em->getMetadataFactory()->getMetadataFor(MyItem::class);
        $schemaTool->createSchema([$metadata]);
        return true;
    } catch (\Exception $e) {
        return false;
    }
}

private function uninstallDoctrineTables(): bool
{
    try {
        $em         = $this->get('doctrine.orm.default_entity_manager');
        $schemaTool = new SchemaTool($em);
        $metadata   = $em->getMetadataFactory()->getMetadataFor(MyItem::class);
        $schemaTool->dropSchema([$metadata]);
        return true;
    } catch (\Exception $e) {
        return false;
    }
}

<?php

$em = $this->get('doctrine.orm.default_entity_manager');

// ── CREATE ──
$item = new MyItem();
$item->setName('Nuevo item');
$item->setActive(true);
$em->persist($item);
$em->flush();

// ── READ ──
$item = $em->find(MyItem::class, 42);
$repo = $em->getRepository(MyItem::class);
$all  = $repo->findAll();
$active = $repo->findBy(['active' => true], ['sortOrder' => 'ASC']);

// ── UPDATE ──
$item = $em->find(MyItem::class, 42);
$item->setName('Nombre actualizado');
$em->flush();

// ── DELETE ──
$item = $em->find(MyItem::class, 42);
$em->remove($item);
$em->flush();