You cannot add the relationship to the I18n model from the yaml. You will
need to add the relationship with php code. The yaml schema builds the
opposite end of the relationship by finding the model in the yaml and adding
the relationship to it. In this case the I18n model doesn't exist in the
yaml, it is dynamically added at run-time.
- Jon
On Thu, Apr 9, 2009 at 7:44 AM, FlyLM [ML] <flylm...@gmail.com> wrote:
>
> 2009/4/8 FlyLM [ML] <flylm...@gmail.com>:
> > 2009/4/8 FlyLM [ML] <flylm...@gmail.com>:
> >> Hello,
> >>
> >> I have started my first "real" project with Symfony and I've some
> >> problems and questions.
> >>
> >> 1) I use Doctrine as ORM and I18N Behavior in my "schema.yml" file to
> >> declare localized fields.
> >>
> >> "Localized" tables were generated with a columns named "lang". I would
> >> like to have a relation between this column "lang" and a table where I
> >> declared an a available list of languages.
> >> I didn't found how I can add a foreign key on the "localized" tables.
> >> How can I do it, is it possible ?
> >>
>
> For this first question, I've found a way, but it doesn't work (or I
> didn't understood something...).
>
> My "languages" table :
>
> ub_language:
> columns:
> id: { type: integer(2), primary: true }
> label: { type: string(64), notnull:true }
> iso: { type: string(2), notnull:true, unique:true }
> rfc: { type: string(5), notnull:true, unique:true }
>
> A table with I18N behavior :
>
> ub_currency:
> actAs:
> I18N:
> fields: [label]
> className: %CLASS%_i18n
> columns:
> id: { type: integer(1), primary:true }
> symbol: { type: string(32), notnull:true }
> label: { type: string(128), notnull:true }
>
>
> => I've follow this ticket : http://trac.doctrine-project.org/ticket/1029
>
> So, I've :
>
> --------------------------------------------------------------------------------------------------------------
> ub_language:
> columns:
> id: { type: integer(2), primary: true }
> label: { type: string(64), notnull:true }
> iso: { type: string(2), notnull:true, unique:true }
> rfc: { type: string(5), notnull:true, unique:true }
> relations:
> ub_currency_i18n: { local: iso, foreign: lang, type: one, foreignType:
> one }
>
> ub_currency:
> actAs:
> I18N:
> fields: [label]
> className: %CLASS%_i18n
> columns:
> id: { type: integer(1), primary:true }
> symbol: { type: string(32), notnull:true }
> label: { type: string(128), notnull:true }
>
> --------------------------------------------------------------------------------------------------------------
> The generated SQL have not foreign key for columns 'lang'...
> Models don't show any relation between language and 'localized' table.
>
> Any idea ?
>
> >> Thanks for your help,
> >> Sorry for my english
> >>
> >> Fabien
>
> >
>
--
Jonathan H. Wage
Open Source Software Developer & Evangelist
http://www.jwage.com
http://www.doctrine-project.org
http://www.symfony-project.org
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
