Symfony entity on Postgres view

Question

I need to map an entity to a Postgres view which doesn't have primary id, no id defined.

Views in Postgresql can't have primary keys. On the same time Doctrine entities need a primary key defined.

Can I create a "virtual" property some like this?

class MyEntityClass
{
    /**
     * @var int
     *
     * @ORM\Id
     * @ORM\Column(type="uuid")
     */
     private $id;

     public function getId(): string
     {
          return generate_unique_id_just_for_my_join()
     }
 }

This entity need to be used only for select data. Never for insert/update.

Overriding getId is not going to help. Doctrine itself transfers data directly between entity properties and table columns. Check the Doctrine docs to see how to use compound keys for the id. — Cerad
– Cerad, Commented Dec 21, 2020 at 17:04
Ok i'll check thanks. This entity need to be used only for select data. Never for insert/update — Augusto Murri
– Augusto Murri, Commented Dec 21, 2020 at 18:35

Augusto Murri · Accepted Answer · 2020-12-21 19:35:22Z

0

Problem solved using Doctrine somposite primary keys

https://www.doctrine-project.org/projects/doctrine-orm/en/2.7/tutorials/composite-primary-keys.html

answered Dec 21, 2020 at 19:35

Augusto Murri

3315 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Symfony entity on Postgres view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related