How to set up entity (doctrine) for database view in Symfony 2

by

The accepted answer is correct, but I’d like to offer some additional suggestions that you might want to consider:

Mark your entity as read-only.

Make the constructor private so that only Doctrine can create instances.

/**
 * @ORM\Entity(readOnly=true)
 * @ORM\Table(name="your_view_table")
 */
class YourEntity {
    private function __construct() {}
}

More Related Contents:

  1. Query on a many-to-many relationship using Doctrine with Symfony2
  2. How can I use DATE() in Doctrine 2 DQL?
  3. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  4. On delete cascade with doctrine2
  5. Doctrine 2 and Many-to-many link table with an extra field
  6. Doctrine Query Language get Max/Latest Row Per Group
  7. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  8. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  9. How to setup table prefix in symfony2
  10. PDOException “could not find driver” in php
  11. Symfony 2.0 getting service inside entity
  12. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  13. How to force Doctrine to update array type fields?
  14. Join subquery with doctrine 2 DBAL
  15. How to avoid to display this error in PHP?
  16. The requested URL was not found on this server.
  17. How to create a secure mysql prepared statement in php?
  18. Symfony2 – Force file download
  19. Post form and update multiple rows with mysql
  20. How to install pdo driver in php docker image?
  21. Calculating distance between zip codes in PHP
  22. MySQL retrieve variable from Stored Procedure in PHP PDO
  23. MySQL: Add sequence column based on another field
  24. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  25. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  26. Change name of Laravel’s created_at and updated_at
  27. How to avoid “Using temporary” in many-to-many queries?
  28. Difference between mysql_fetch_array and mysql_fetch_row?
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment