You can look etc into the Practical symfony-jobeet-1.4-doctrine-en.pdf
and there you can see that you have badly set your relations
look on the JobeetJob - JobeetCategory realation
1) specify the relation only on one side
2) specify the foreignAlias: etc JobeetJobs
...
JobeetCategory:
actAs: { Timestampable: ~ }
columns:
name: { type: string(255), notnull: true, unique: true }
JobeetJob:
actAs: { Timestampable: ~ }
columns:
category_id: { type: integer, notnull: true }
type: { type: string(255) }
company: { type: string(255), notnull: true }
...
relations:
JobeetCategory: { onDelete: CASCADE, local: category_id, foreign:
id, foreignAlias: JobeetJobs }
On 1 bře, 06:15, Samuel Morhaim <samuel.morh...@gmail.com> wrote:
> Never mind about this one, but now I am facing one more issue.. Based on
> the below schema.. why is the 1 to many between Command and Events not
> working? I get a method such as $command->getEvent() but it seems to be
> bringing the first record.. not all records.. i cant find a getEvents()
> method..
>
> Can anyone help? thank you.
>
> Command:
> columns:
> id:
> primary: true
> unique: true
> type: integer
> notnull: true
> autoincrement: true
> rule_id:
> type: integer
> notnull: true
> command:
> type: string(160)
> notnull: false
> relations:
> Rule:
> local: rule_id
> foreign: id
> cascade: [delete]
>
> Event:
> columns:
> id:
> primary: true
> unique: true
> type: integer
> notnull: true
> autoincrement: true
> command_id:
> type: integer
> notnull: true
> name:
> type: string(50)
> notnull: true
> campaign_id:
> type: integer
> notnull: false
> template_id:
> type: integer
> notnull: false
> relations:
> Command:
> local: command_id
> foreign: id
> type: many
> cascade: [delete]
> Campaign:
> local: campaign_id
> foreign: id
> cascade: [delete]
> Template:
> local: template_id
> foreign: id
>
> On Sun, Feb 28, 2010 at 2:42 PM, Samuel Morhaim
> <samuel.morh...@gmail.com>wrote:
>
>
>
> > It is a somewhat complex table relation but it should work..
>
> > A rule, can have a command, the command can have many events. I get this
> > error: Unknown record property / related component "ev1" on "Event"
>
> > Fixture:
> > Rule:
> > rule_1:
> > id: 1
> > type: User
> > campaign_id: 1
> > msg_to: 32075
> > msg_from: Outbound
> > description: See if the user replies the number 1 or 2
> > Command:
> > command_1:
> > command: 1
> > Event:
> > ev1:
> > name: Add
> > ev2:
> > name: Remove
> > command_2:
> > command: 2
>
> > Schema
>
> > Rule:
> > columns:
> > id:
> > primary: true
> > unique: true
> > type: integer
> > notnull: true
> > autoincrement: true
> > type:
> > type: enum
> > values: [User,System]
> > campaign_id:
> > type: integer
> > notnull: false
> > msg_to:
> > type: string(20)
> > notnull: false
> > msg_from:
> > type: enum
> > values: [Anyone,Outbound]
> > description:
> > type: string(255)
> > notnull: false
> > is_active:
> > default: true
> > type: boolean
> > notnull: true
> > relations:
> > Campaign:
> > local: campaign_id
> > foreign: id
> > type: many
> > cascade: [delete]
>
> > Command:
> > columns:
> > id:
> > primary: true
> > unique: true
> > type: integer
> > notnull: true
> > autoincrement: true
> > rule_id:
> > type: integer
> > notnull: true
> > command:
> > type: string(160)
> > notnull: false
> > relations:
> > Rule:
> > local: rule_id
> > foreign: id
> > cascade: [delete]
>
> > Event:
> > columns:
> > id:
> > primary: true
> > unique: true
> > type: integer
> > notnull: true
> > autoincrement: true
> > command_id:
> > type: integer
> > notnull: true
> > name:
> > type: string(50)
> > notnull: true
> > campaign_id:
> > type: integer
> > notnull: false
> > template_id:
> > type: integer
> > notnull: false
> > relations:
> > Command:
> > local: command_id
> > foreign: id
> > type: many
> > cascade: [delete]
> > Campaign:
> > local: campaign_id
> > foreign: id
> > cascade: [delete]
> > Template:
> > local: template_id
> > foreign: id
--
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
