I don't know how do you understand, but this schema isn't correct at
all.
If you have some relation with local .( local: dinner_id ), you have
to have a dinner_id in this table where the relation is specified
Dinner:
columns:
dinner_id
date: { type: timestamp, notnull: true }
nb_presents: { type: integer, notnull: true }
relations:
Marks:
local: dinner_id
foreign: criteria_id
But you want to create a many-to-many relation.. read readme how to do
this
http://www.doctrine-project.org/documentation/manual/1_2/hu/yaml-schema-files
Example from the readme:
User:
columns:
id:
type: integer(4)
autoincrement: true
primary: true
username:
type: string(255)
password:
type: string(255)
attributes:
export: all
validate: true
Group:
tableName: group_table
columns:
id:
type: integer(4)
autoincrement: true
primary: true
name:
type: string(255)
relations:
Users:
foreignAlias: Groups
class: User
refClass: GroupUser
GroupUser:
columns:
group_id:
type: integer(4)
primary: true
user_id:
type: integer(4)
primary: true
relations:
Group:
foreignAlias: GroupUsers
User:
foreignAlias: GroupUsers
On 25 ún, 06:32, SymfonyNewbie <shore.cl...@gmail.com> wrote:
> Dinner:
> columns:
> date: { type: timestamp, notnull: true }
> nb_presents: { type: integer, notnull: true }
> relations:
> Marks:
> class: Criteria
> local: dinner_id
> foreign: criteria_id
> refClass: Mark
> type: many
>
> Criteria:
> columns:
> name: { type: string(50), notnull: true }
> relation:
> Marks:
> class: Dinner
> local: criteria_id
> foreign: dinner_id
> refClass: Mark
> type: many
>
> Mark:
> columns:
> criteria_id: { type: integer, primary: true }
> dinner_id: { type: integer, primary: true }
> value: { type: integer, notnull: true }
> relations:
> Dinner:
> local: dinner_id
> foreign: id
> Criteria:
> local: criteria_id
> foreign: id
>
> My question is why can `local` refer to a column which is not in the
> class itself.
>
> Take the `Dinner` as example,its `local` is `dinner_id` but the column
> is not within `Dinner`,but `Mark`.Or maybe I'm understanding the
> `local` wrongly ?
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
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
