Hi John, the Problem is when you doing the views this way is, you don't have a clean deployment anymore then we can't use symfony build-all-reload-test for the dev. Team. I must use SQL-Dumps and I think this is not the right way, because you can't change the Model quick and easy.
There must be a better way to do this, because we need a the mostly clean Deployment without SQL-Dumps. Many thanks for your answer, Jörg On Oct 8, 11:47 am, John Masson <jmas...@gmail.com> wrote: > 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 <ohnhei...@googlemail.com> 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 symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---