Re: Loosing faith in cake
It's a deliberate 'o' so you feel more melodramatic, as mbavio here
points out... And if you feel negative then i suppose you also have
issues with cake ? Wanna talk about it ? ;)
Maybe some group therapy ? ;) I suggest opening up a thread for a
'desperate cake believers'...
On Apr 6, 4:42 pm, villas <[EMAIL PROTECTED]> wrote:
> We are also losing faith in your ability to spell...
>
> Sorry, but even if you'd spelt it right, it's a terrible choice for a
> subject title. The rest of us read the subject to see whether we can
> either help or learn from the other replies. All your title does is
> make everyone feel negative.
>
> On Apr 5, 9:47 pm, keen <[EMAIL PROTECTED]> wrote:
>
> > My problem: Users -> habtm -> Teams. Users get invited to teams, when
> > they accept, they disapear from invitation list and become members.
> > Obvious design would be habtm table with additional fields like
> > 'membership status' = 'invited'/'member', but i remembered that
> > additional habtm fields and cake doesn't mix if i try to update one
> > invitation of some user to particular team all invitations of that
> > team will be deleted and then reinserted loosing additional fields. So
> > i ended up with two tables - for members and for invited.
> > After a lot of headache trying to come up with the elegant code for
> > deletion one habtm relationship and adding another one for the same
> > model, i finally i thought i got it with deleteAll, but no...
>
> > Firstly i couldn't get ->save method to work if i had following model
>
> > team
> > <..>
> > var $hasAndBelongsToMany = array(
> > 'Userteam' => array('className' => 'User',
> > 'joinTable'
> > => 'teamusers',
> >
> > 'foreignKey' => 'team_id',
> >
> > 'associationForeignKey' => 'user_id',
> > 'unique' =>
> > true,
> >
> > 'conditions' => '',
> > 'fields' =>
> > '',
> > 'order' =>
> > '',
> > 'limit' =>
> > '',
> > 'offset' =>
> > '',
> >
> > 'finderQuery' => '',
> >
> > 'deleteQuery' => '',
> >
> > 'insertQuery' => ''
> > ),
> > 'UserteamInvites' => array('className' => 'User',
> > 'joinTable'
> > => 'teamusersinvites',
> >
> > 'foreignKey' => 'team_id',
> >
> > 'associationForeignKey' => 'user_id',
> > 'unique' =>
> > true,
> >
> > 'conditions' => '',
> > 'fields' =>
> > '',
> > 'order' =>
> > '',
> > 'limit' =>
> > '',
> > 'offset' =>
> > '',
> >
> > 'finderQuery' => '',
> >
Loosing faith in cake
My problem: Users -> habtm -> Teams. Users get invited to teams, when
they accept, they disapear from invitation list and become members.
Obvious design would be habtm table with additional fields like
'membership status' = 'invited'/'member', but i remembered that
additional habtm fields and cake doesn't mix if i try to update one
invitation of some user to particular team all invitations of that
team will be deleted and then reinserted loosing additional fields. So
i ended up with two tables - for members and for invited.
After a lot of headache trying to come up with the elegant code for
deletion one habtm relationship and adding another one for the same
model, i finally i thought i got it with deleteAll, but no...
Firstly i couldn't get ->save method to work if i had following model
team
<..>
var $hasAndBelongsToMany = array(
'Userteam' => array('className' => 'User',
'joinTable' =>
'teamusers',
'foreignKey' =>
'team_id',
'associationForeignKey' => 'user_id',
'unique' =>
true,
'conditions' =>
'',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery'
=> '',
'deleteQuery'
=> '',
'insertQuery'
=> ''
),
'UserteamInvites' => array('className' => 'User',
'joinTable' =>
'teamusersinvites',
'foreignKey' =>
'team_id',
'associationForeignKey' => 'user_id',
'unique' =>
true,
'conditions' =>
'',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery'
=> '',
'deleteQuery'
=> '',
'insertQuery'
=> ''
)
);
and before save i had part of an array that looked like this
$data['Team']['id'] = 15
<..>
$data['UserteamInvites']['UserteamInvites'][0] = 1
<..>
$data['Userteam']['Userteam'][0] = 2
$data['Userteam']['Userteam'][1] = 13
After save my db would look like
Userteam table:
Team User
15 1
UserteamInvites table:
Team User
15 2
15 13
15 1 <-- ?
15 13 <- ?
I solved this by unset($data['Userteam']) first, saving $data, then
restoring $data['Userteam'] and unset($data['UserteamInvites']) then
saving for the second time...
That looked ugly, so i thought i'd create a separate model just for
habtm table and use deletAll and create, save. But i was suprised
again as i did deleteAll(array('team_id'=>'15','user_id'=>'13')); ALL
the records with team_id got deleted... I came to square one and had
to admit that cake didn't have a solution for this common scenario, i
was left with -query-.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~--~~~~--~~--~--~---
any way around habtm hacks ?
Are there any ways of implementing filtering rows with a clause from the the other model in habtm relation without a hack like described here http://bakery.cakephp.org/articles/view/habtm-hacks-to-menage-columns-in-both-models ? Recursion also adds a lot of queries, which cant be healthy for a big app. What is the best practice ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
