Prev   Next

Please add support for SQL VIEWS 

http://www.symfony-project.org/forum/index.php?t=msg&goto=31774#msg_31774

Views already work with symfony. For complex queries, just define the view in your schema.?ml, set the table as "read only" in the schema unless you want the view to be updateable, re-build the model, and voila, you have a view which is accessible in the model.

documented on: 19 July 2007, halfer

Please add support for SQL VIEWS 

> Could you please do an example, because im having trouble findig any
> documentation on Propel's site?

There may not actually be any - I just worked it out myself:

  1. Create a view involving tables within or outside of your existing model
  2. Find your existing config/schema.xml or config/schema.yml file
  3. Edit it and add the <table> section for your view. Make sure you define a single or composite primary key as Propel needs this
  4. Rebuild the model

documented on: 19 July 2007, halfer


SourceForge.net LogoXpt.SourceForge.netCreative Commons Attribution-ShareAlike License
Single file version available here.
Last updated on 2008-05-28.
To discuss, comment here.
Prev   Next
 Home