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 a more integrated solution, using the Event System.
In my project configuration I register a new listener on post_command event
(which is a built-in event of sfTask)
$this->dispatcher->connect('command.post_command', array('DatabaseInit',
'createViews'));
Then I have a hook to create my views exactly where I want:
class DatabaseInit {
static public function createViews(sfEvent $event) {
if( $event->getSubject() instanceof sfDoctrineInsertSqlTask ) {
// create views here
}
}
}
Damien
2009/2/21 Lawrence Krubner <lkrub...@geocities.com>
>
> 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 the help for *doctrine:insert-sql* says:
> > The task connects to the database and creates tables for all the
> > lib/model/doctrine/*.php files.
> >
> > Anybody knows how to execute custom SQL script with Doctrine ?
>
>
> Why not just put this in a shell script and call it from the command
> line? That's really all that the above mentioned propel or doctrine
> commands do. It would take you, what, 5 minutes to write your own script?
>
>
> --- lawrence
>
>
>
>
>
>
>
>
>
>
>
>
> >
> >
> >
> > 2009/2/17 David Herrmann <d...@okto.tv>
> >
> >> 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
> >>> doctrine:build-db I think).
> >>>
> >>> I read about using Views with Doctrine here:
> >>>
> >>
> http://www.doctrine-project.org/documentation/manual/1_0/en/component-overview:views
> >>> But I miss information about how to integrate views when using doctrine
> >>> in symfony.
> >> I can only tell how I did it for Propel but I suppose it will work for
> >> Doctrine, too: just put the SQL to generate your view into something
> >> like /data/sql/my_view.sql and it will automatically be included during
> >> DB build/create execution.
> >> If there's a folder /data/sql/doctrine (can't find out atm) then that's
> >> your place of course.
> >>
> >> Just make sure your view code gets executed after all the other SQL
> >> statements (so all tables exist). Symfony will order the SQL files by
> >> name, so you can use the file name to change the order.
> >>
> >> Hope that helps
> >>
> >> David
> >>
> >
> > >
> >
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
