[symfony-users] Re: extending doctrine schema with SQL views

2009-02-23 Thread Simon Gow
Despite that, if you're running on MYSQL, remember that view support is really REALLY bad. If you've got more than one sub-select. or nested joins, mysql won't use any indexes. On Feb 23, 4:32 am, Damien Lepage damienlep...@gmail.com wrote: Thanks for your suggestion Lawrence. But I don't

[symfony-users] Re: extending doctrine schema with SQL views

2009-02-22 Thread Damien Lepage
Thanks for your suggestion Lawrence. But I don't like it because it requires an extra step and breaks the built-in task doctrine:build-all-reload-test-all (because I need my views created between DB build and tests). Thanks to the tutorial published on symfony blog yesterday, I found a way to get

[symfony-users] Re: extending doctrine schema with SQL views

2009-02-21 Thread Lawrence Krubner
Damien Lepage wrote: Thanks for your help David. However, it seems to be different for doctrine. I tried it and it doesn't work. The help for *propel:insert-sql* says: The task connects to the database and executes all SQL statements found in [config/sql/*schema.sql|COMMENT] files. But

[symfony-users] Re: extending doctrine schema with SQL views

2009-02-17 Thread David Herrmann
Damien Lepage schrieb: I would like to know if there is an easy way to automatically create views each time I rebuild my database. In other words, is there a place where I can put a custom script which will create my views and will be triggered when my database is built (by

[symfony-users] Re: extending doctrine schema with SQL views

2009-02-17 Thread Damien Lepage
Thanks for your help David. However, it seems to be different for doctrine. I tried it and it doesn't work. The help for *propel:insert-sql* says: The task connects to the database and executes all SQL statements found in [config/sql/*schema.sql|COMMENT] files. But the help for