Hi, We were discussing this at work yesterday. One of the guys came up with the same solution and it sounds quite reasonable.
Out of interest we reverse engineered a schema.yml from a DB that had a view in it just to see what would happen. Symfony includes the view in the schema.yml file just like it was a regular table, but there was nothing to identify it as a view rather than a table that I could see, so presumably if we forward engineered the database from this schema.yml it would have created a table not a view (should have done that just to confirm I guess) My recommendation would be to create your DB as you want it, then reverse engineer your schema.yml with a ./symfony doctrine:build- schema then build-model, forms, filters etc... Just saves you dropping the tables and recreating the views which you'd have to do if you work in the opposite direction (although it's not such a big deal I guess). John On Oct 7, 7:48 pm, ridcully <[email protected]> wrote: > Hi, > > how can I use Database Views in Symfony with Doctrine? I need them > because of performance reasons. > > My Idee was to create dummys in the model and after building the Model > to drop the dummy tabels and create SQL Views. > > Is there a better way to do this? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
