Be careful with your $belongsTo definitions. The second one just
overwrote the first. If you want to create two relations you need to
use this syntax:
var $belongsTo = array(
'FromTeam' => array(
'className' => 'Team',
'foreignKey' => 'from_team_id'
),
'ToTeam' => array(
'className' => 'Team',
'foreignKey' => 'to_team_id'
)
);
Michael
On Oct 1, 5:12 am, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> One simple thing I'd suggest is the naming of the fields team2_id does
> not tell me wether the trade is from or to this team.
> Something like from_team_id and to_team_id would make their role more
> obvious. At least imagine that is what a trade is in baseball... if
> they are always a bidirectional exchange then your team1 team2 would
> be fine.
>
> You can do the linking in this way:
> var $belongsTo = array(
> 'FromTeam' => array(
> 'className' => 'Team',
> 'foreignKey' => 'from_team_id'
> )
> );
> var $belongsTo = array(
> 'ToTeam' => array(
> 'className' => 'Team',
> 'foreignKey' => 'to_team_id'
> )
> );
> Your trade would now belong to two teams detified by their role in the
> transaction.
>
> For a bidirectional association I am not sure this kind of belongTo
> would find both teams (since it probably expects a single record).
> var $belongsTo = array(
> 'Team' => array(
> 'className' => 'Team',
> 'foreignKey' => false,
> 'conditions' => 'Team.id = Transaction.team1_id OR
> Team.id = Transaction.team2_id'
> )
> );
>
> You could probably do something similar using a hasMany or something
> if you had to.
>
> On Oct 1, 3:12 am, James <[EMAIL PROTECTED]> wrote:
>
> > I'm setting up a database that includes tracking of trades of baseball
> > teams. For the teams table I have:
>
> > CREATE TABLE teams (
> > id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
> > city VARCHAR(13),
> > name VARCHAR(12),
> > abbreviation VARCHAR(3)
> > );
>
> > I get lost when creating the trades table how do I set it up so
> > there's two foreign keys to the teams table? I'm trying to achieve
> > something along the lines of this:
>
> > CREATE TABLE trades (
> > id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
> > team2_id INT UNSIGNED NOT NULL,
> > team1_id INT UNSIGNED NOT NULL
> > );
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
