Why would the find methods of the repository not return anything?

[nbro]

persist and flush work

I created an entity and the associated repository with make:entity.

After that, I created an object and stored it in the database.

$product = new Product();
$product->setName($request->getPayload()->get("name"));
$entityManager->persist($product);
$entityManager->flush();

Once I've executed this code, I can indeed see the data in the PostgreSQL database using pg Admin 4.

Find methods do not work

Now, if I try to retrieve a product using find(1), findBy(["name" => "thename"]); or findAll, nothing is returned, i.e. an empty array is returned.

Any idea why this may be happening?

I've tried both to use/inject the ProductRepesitory or EntityManagerInterface services. Either way, it doesn't work.

More details

So, I'm doing something like this

#[Route('/products/{id}', name: 'products')]
public function list(EntityManagerInterface $entity, int $id): Response
{
        $repository = $entity->getRepository(Product::class);
        $products = $repository->find($id); // Does not find anything, same for findBy or findAll
        return $this->json($products);   //empty response
}    

The Product entity and the associated repository were automatically created by make:entity. Anyway, here's some relevant code

#[ORM\Entity(repositoryClass: ProductRepository::class)]
class Product
{
    #[ORM\Id]
    #[ORM\GeneratedValue]
    #[ORM\Column]
    private ?int $id = null;

    #[ORM\Column(length: 255)]
    private ?string $name = null;

// ...

// Getters and setters and whatever

and

class ProductRepository extends ServiceEntityRepository
{
    public function __construct(ManagerRegistry $registry)
    {
        parent::__construct($registry, Product::class);
    }
}

composer show

doctrine/cache                      2.2.0  PHP Doctrine Cache library is a popular cache implementation that supports many diffe...
doctrine/collections                2.2.2  PHP Doctrine Collections library that adds additional functionality on top of PHP arr...
doctrine/dbal                       3.8.4  Powerful PHP database abstraction layer (DBAL) with many features for database schema...
doctrine/deprecations               1.1.3  A small layer on top of trigger_error(E_USER_DEPRECATED) or PSR-3 logging with option...
doctrine/doctrine-bundle            2.12.0 Symfony DoctrineBundle
doctrine/doctrine-migrations-bundle 3.3.0  Symfony DoctrineMigrationsBundle
doctrine/event-manager              2.0.0  The Doctrine Event Manager is a simple PHP event system that was built to be used wit...
doctrine/inflector                  2.0.10 PHP Doctrine Inflector is a small library that can perform string manipulations with ...
doctrine/instantiator               2.0.0  A small, lightweight utility to instantiate objects in PHP without invoking their con...
doctrine/lexer                      3.0.1  PHP Doctrine Lexer parser library that can be used in Top-Down, Recursive Descent Par...
doctrine/migrations                 3.7.4  PHP Doctrine Migrations project offer additional functionality on top of the database...
doctrine/orm                        3.1.3  Object-Relational-Mapper for PHP
doctrine/persistence                3.3.2  The Doctrine Persistence project is a set of shared interfaces and functionality that...
doctrine/sql-formatter              1.4.0  a PHP SQL highlighting library
nikic/php-parser                    5.0.2  A PHP parser written in PHP
psr/cache                           3.0.0  Common interface for caching libraries
psr/container                       2.0.2  Common Container Interface (PHP FIG PSR-11)
psr/event-dispatcher                1.0.0  Standard interfaces for event handling.
psr/log                             3.0.0  Common interface for logging libraries
symfony/cache                       7.0.7  Provides extended PSR-6, PSR-16 (and tags) implementations
symfony/cache-contracts             3.5.0  Generic abstractions related to caching
symfony/config                      7.0.7  Helps you find, load, combine, autofill and validate configuration values of any kind
symfony/console                     7.0.7  Eases the creation of beautiful and testable command line interfaces
symfony/dependency-injection        7.0.7  Allows you to standardize and centralize the way objects are constructed in your appl...
symfony/deprecation-contracts       3.5.0  A generic function and convention to trigger deprecation notices
symfony/doctrine-bridge             7.0.7  Provides integration for Doctrine with various Symfony components
symfony/dotenv                      7.0.7  Registers environment variables from a .env file
symfony/error-handler               7.0.7  Provides tools to manage errors and ease debugging PHP code
symfony/event-dispatcher            7.0.7  Provides tools that allow your application components to communicate with each other ...
symfony/event-dispatcher-contracts  3.5.0  Generic abstractions related to dispatching event
symfony/filesystem                  7.0.7  Provides basic utilities for the filesystem
symfony/finder                      7.0.7  Finds files and directories via an intuitive fluent interface
symfony/flex                        2.4.5  Composer plugin for Symfony
symfony/framework-bundle            7.0.7  Provides a tight integration between Symfony components and the Symfony full-stack fr...
symfony/http-foundation             7.0.7  Defines an object-oriented layer for the HTTP specification
symfony/http-kernel                 7.0.7  Provides a structured process for converting a Request into a Response
symfony/maker-bundle                1.59.1 Symfony Maker helps you create empty commands, controllers, form classes, tests and m...
symfony/mime                        7.0.7  Allows manipulating MIME messages
symfony/polyfill-intl-grapheme      1.29.0 Symfony polyfill for intl's grapheme_* functions
symfony/polyfill-intl-idn           1.29.0 Symfony polyfill for intl's idn_to_ascii and idn_to_utf8 functions
symfony/polyfill-intl-normalizer    1.29.0 Symfony polyfill for intl's Normalizer class and related functions
symfony/polyfill-mbstring           1.29.0 Symfony polyfill for the Mbstring extension
symfony/polyfill-php83              1.29.0 Symfony polyfill backporting some PHP 8.3+ features to lower PHP versions
symfony/process                     7.0.7  Executes commands in sub-processes
symfony/routing                     7.0.7  Maps an HTTP request to a set of configuration variables
symfony/runtime                     7.0.7  Enables decoupling PHP applications from global state
symfony/service-contracts           3.5.0  Generic abstractions related to writing services
symfony/stopwatch                   7.0.7  Provides a way to profile code
symfony/string                      7.0.7  Provides an object-oriented API to strings and deals with bytes, UTF-8 code points an...
symfony/translation-contracts       3.5.0  Generic abstractions related to translation
symfony/twig-bridge                 7.0.7  Provides integration for Twig with various Symfony components
symfony/twig-bundle                 7.0.7  Provides a tight integration of Twig into the Symfony full-stack framework
symfony/var-dumper                  7.0.7  Provides mechanisms for walking through any arbitrary PHP variable
symfony/var-exporter                7.0.7  Allows exporting any serializable PHP data structure to plain PHP code
symfony/web-profiler-bundle         7.0.7  Provides a development tool that gives detailed information about the execution of an...
symfony/yaml                        7.0.7  Loads and dumps YAML files
twig/extra-bundle                   3.10.0 A Symfony bundle for extra Twig extensions
twig/twig                           3.10.0 Twig, the flexible, fast, and secure template language for PHP

[nbro]

We can't simply return the entity objects returned by the find methods as JSON content. We need to use a serializer or create an array from the object properties.

In my case, I did

composer require symfony/serializer
composer require symfony/property-access

Then in the controller

...
$encoders = [new JsonEncoder()];
$normalizers = [new ObjectNormalizer()];
$serializer = new Serializer($normalizers, $encoders);
$products = $repo->findAll();
return $this->json($serializer->serialize($products, 'json')); 

Alternatively, instead of just installing the packages symfony/serializer and symfony/property-access, we can install the symfony/serializer-pack pack with composer install symfony/serializer-pack, then we can just do

public function list(ProductRepository $repo, SerializerInterface $serializer): JsonResponse
{
    $products = $repo->findAll();
    return $this->json($serializer->serialize($products, 'json'));   
}