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 ?
2) My schema have some "one-to-one" relations like this :
TableA :
ub_product:
actAs:
I18N:
fields: [label]
className: %CLASS%_i18n
columns:
id: { type: integer(6), primary:true }
reference: { type: string(64), notnull:true }
label: { type: string(255), notnull:true }
is_enable: { type: boolean, default:false, notnull:true }
country_id: { type: integer(2), notnull:true }
product_type_id: { type: integer(2), notnull:true }
relations:
ub_country: { onDelete: CASCADE, local: country_id, foreign: id }
ub_product_type: { onDelete: CASCADE, local: product_type_id, foreign: id }
TableB :
ub_unit:
columns:
product_id: { type: integer(6), primary:true }
unit_type_id: { type: integer(2), notnull:true }
bypass: { type:boolean, default:false, notnull:true }
flow_normal: { type: integer(2), notnull:true }
flow_max: { type: integer(2), notnull:true }
relations:
ub_product: { onDelete: CASCADE, local: product_id, foreign: id,
foreignType: one, foreignAlias: %CLASS% }
ub_unit_type: { onDelete: CASCADE, local: unit_type_id, foreign: id }
...
Tables are correctly generated, but when I want to populate table, I
get an error : "SQLSTATE[23000]: Integrity constraint violation: 1048
Column 'id' cannot be null "
If I let doctrine to generate an additional column "id" as primary key
(I set product_id as unique), my problem is solved, but I really don't
like to have a additionnal field. Did I do something wrong, I see I'm
not alone with this issue, but I didn't found any solution.
Thanks for your help,
Sorry for my english
Fabien
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
