BTW it's not necessary to initialize backend for the relation table:
symfony propel-init-admin backend article_author ArticleAuthor
is not needed in the example above.
Martin
On 5 Dez., 15:46, Martin H <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I played around some more time and now I got the ArticleAuthor example
> working with many-to-many relation!
> I will describe important steps here, because I think the
> documentation of generating n-m relations in Symfony is poor.
>
> Skipped: initialize project (symfony init-project)
>
> * Data model (file schema.yml):
>
> propel:
> _attributes: { noXsd: false }
>
> article:
> _attributes: { phpName: Article }
> id:
> title: varchar(255)
>
> author:
> _attributes: { phpName: Author }
> id:
> name: varchar(255)
>
> article_author:
> _attributes: { phpName: ArticleAuthor }
> id:
> article_id: { type: integer, required: true, primaryKey: true }
> author_id: { type: integer, required: true, primaryKey: true }
> _foreignKeys:
> -
> foreignTable: article
> onDelete: cascade
> references:
> - { local: article_id, foreign: id }
> -
> foreignTable: author
> onDelete: cascade
> references:
> - { local: author_id, foreign: id }
>
> * Build model
>
> symfony propel-build-model
>
> * Build sql
>
> symfony propel-build-sql
>
> * Insert sql
>
> symfony propel-insert-sql
>
> * Initialize module called "backend"
>
> symfony init-app backend
>
> * Initialize a backend module for each table
>
> symfony propel-init-admin backend article Article
> symfony propel-init-admin backend author Author
> symfony propel-init-admin backend article_author ArticleAuthor
>
> * Modify the file apps/backend/modules/article/config/gererator.yml
>
> generator:
> class: sfPropelAdminGenerator
> param:
> model_class: Article
> theme: default
>
> edit:
> display: [title, article_author]
> fields:
> article_author: { type: admin_double_list, params:
> through_class=ArticleAuthor }
>
> * Clear cache
>
> symfony cc
>
> When you create a new article record, you can choose your authors now.
>
> Good luck with symfony.
> It's really great!
>
> Martin
>
> On 4 Dez., 17:25, "Mat" <[EMAIL PROTECTED]> wrote:
>
> > I'd love to know as well, I assumed that Symfony didn't have anything to
> > cope with this at the moment and just created the table/code myself, but if
> > it does I'd love to hear about it.
>
> > Mat
>
> > -----Original Message-----
> > From: Martin H [mailto:[EMAIL PROTECTED]
> > Sent: 04 December 2007 16:16
> > To: symfony users
> > Subject: [symfony-users] many-to-many Relationships
>
> > Hi there,
>
> > I'm new to Symfony.
> > Before I start my real-live application I want to try how N-M-
> > Relations, or Many-to-Many Relations are defined in Symfony.
> > The
> > articlehttp://www.symfony-project.org/book/1_0/14-Generators#Many-to-Many%20...
> > nships
> > describes it a little bit to short.
>
> > I still have some questions:
>
> > * How do I define the config/schema.yml?
>
> > * Do I have to make the relationship-table by myself?
>
> > * If yes, how can I refer to this table?
>
> > I am trying to recognize the authors/articels example given in chapter
> > 14.
>
> > Thanks for help.
>
> > Martin
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
