On 20 May 2008, at 16:48, oana wrote: > $this->User->Conversation->findAll() works, but retieves all the > conversations, not just the ones for a certain user
True. Even though it looks like you're working on a User's Conversations, $this->User->Conversation->findAll(); and $this->Conversation->findAll(); are identical. All you're doing is execute the method findAll() of the Conversation model. It doesn't matter wether you're doing it via $this- >Conversation->findAll() or $this->A->Really->Long->Way->Around- >Conversation->findAll(). The Conversation model doesn't care/know how it's called. So yes, $this->User->Conversation->findAll() will find ALL conversations, not just a specific users' ones. I know it's counter-intuitive and I wish Cake would be improved in this regard. Maybe in 2.0? Now why does it work the way it works? By convention Cake will automatically (try to) include the "User" model in your "UserController", giving you the possibility to access $this->User. The Conversation model is not automatically included, though you could include it manually and then also get access to $this->Conversation. The User model though happens to be linked to the Conversation model through associations, so from the User model you can always access the Conversation model. So in this case to use the Conversation model you "go through" the User model. Anyway, to find the conversations of a specific user, you do a find() on the User model: $this->User->find($conditions); This will give you the user record AND records of all associated models, including Conversations. > $this->User->ConversationsUser->findAllByUserId($userId) deletes the > entries in the ConversationsUser table. I don't know why it deletes entries, but you shouldn't have a ConversationsUser model in the first place! That should just be a table that helps you link Users to Conversations, but it should never be accessed directly. > On May 19, 4:26 pm, oana <[EMAIL PROTECTED]> wrote: >> I wrote almost everything again, because it was getting too messy, >> and >> now it works. (though the changes i've made don't concern any logic >> that may delete entries) >> >> Thank you very much for helping. >> >> On May 19, 11:09 am, David Christopher Zentgraf <[EMAIL PROTECTED]> >> wrote: >> >>> Well, nothing's being deleted in those queries, only SELECTed. >>> Of the top of my head I'd say there are two possibilities: >> >>> 1) Some really weird problem with your database engine that causes >>> it >>> to forget selected data. * >>> 2) There's some logic in your application that deletes entries which >>> is accidentally triggered. >>> *unlikely >> >>> What you usually do to select related model data is just this: >>> - You define your two models very simply, as >>> inhttp://book.cakephp.org/view/66/models#introduction-67 >>> - You set up associations between your two models as >>> inhttp://book.cakephp.org/view/66/models#associations-78 >>> - In your controller you do something like $this->User->find(), >>> which >>> returns an array like: >> >>> Array >>> ( >>> [User] => Array >>> ( >>> ... >>> ) >>> [Conversation] => Array >>> ( >>> ... >>> ) >>> ) >> >>> If you want to search for a specific entry in "Conversation" you'd >>> do >>> something like this: >>> $this->User->Conversation->find(array('topic' => 'How to bake >>> cookies')); >> >>> If your code is anymore complicated than that you're probably not >>> doing it right. >>> If you paste some more of your code (relevant controller actions, >>> model definitions etc.) into the bin (http://bin.cakephp.org/) we >>> might be able to tell where the problem is. >> >>> On 19 May 2008, at 16:35, oana wrote: >> >>>> These are the queries related concerning users, conversations, >>>> and the >>>> join table. >> >>>> If it isn't too much trouble, maybe you can point me to a complete >>>> piece of code for the users cotroller, to select a certain user's >>>> conversations. Because i have tried several, and i think this is my >>>> problem. >> >>>> Thanks for helping, >>>> Oana >> >>>> SELECT `Conversation`.`id`, `Conversation`.`availability`, >>>> `Conversation`.`created`, `Conversation`.`modified`, >>>> `Conversation`.`description`, `Conversation`.`title`, >>>> `Conversation`.`postscount`, `Conversation`.`ideascount`, >>>> `ConversationsUser`.`conversation_id`, >>>> `ConversationsUser`.`user_id` >>>> FROM `conversations` AS `Conversation` JOIN `conversations_users` >>>> AS >>>> `ConversationsUser` ON (`ConversationsUser`.`user_id` IN (1) AND >>>> `ConversationsUser`.`conversation_id` = `Conversation`.`id`) >> >>>> SELECT COUNT(*) AS `count` FROM `conversations_users` AS >>>> `ConversationsUser` LEFT JOIN `conversations` AS `Conversation` ON >>>> (`ConversationsUser`.`conversation_id` = `Conversation`.`id`) LEFT >>>> JOIN `users` AS `User` ON (`ConversationsUser`.`user_id` = >>>> `User`.`id`) WHERE `User`.`id` = 1 >> >>>> SELECT `ConversationsUser`.`conversation_id`, >>>> `ConversationsUser`.`user_id`, `Conversation`.`id`, >>>> `Conversation`.`availability`, `Conversation`.`created`, >>>> `Conversation`.`modified`, `Conversation`.`description`, >>>> `Conversation`.`title`, `Conversation`.`postscount`, >>>> `Conversation`.`ideascount`, `User`.`id`, `User`.`username`, >>>> `User`.`email`, `User`.`password`, `User`.`group`, >>>> `User`.`first_name`, `User`.`last_name` FROM >>>> `conversations_users` AS >>>> `ConversationsUser` LEFT JOIN `conversations` AS `Conversation` ON >>>> (`ConversationsUser`.`conversation_id` = `Conversation`.`id`) LEFT >>>> JOIN `users` AS `User` ON (`ConversationsUser`.`user_id` = >>>> `User`.`id`) WHERE `User`.`id` = 1 LIMIT 20 >> >>>> On May 18, 11:53 am, David Christopher Zentgraf <[EMAIL PROTECTED]> >>>> wrote: >>>>> Can you post the SQL queries generated by Cake? >>>>> Sounds really weird. >> >>>>> On 18 May 2008, at 16:04, oana wrote: >> >>>>>> Hi Keith, >> >>>>>> Your summary is very accurate, that is exactly what's happening. >> >>>>>> This is how i select the conversations for an user, in the user >>>>>> controller: >> >>>>>> $this->set('conversations',$this->paginate('ConversationsUser', >>>>>> array('User.id' => $userId))); >> >>>>>> Thank you for replying. >> >>>>>> On May 18, 6:48 am, Keith <[EMAIL PROTECTED]> wrote: >>>>>>> Hi Oana, >> >>>>>>> Can you post some code? >> >>>>>>> What do you mean by "extract?" >> >>>>>>> It sounds like you've got your HABTM working properly, but >>>>>>> when you >>>>>>> try to create a view that shows conversations for a specific >>>>>>> user >>>>>>> the >>>>>>> join table rows associated with that user are deleted. Is >>>>>>> this an >>>>>>> accurate summary of your problem? >> >>>>>>> On May 17, 4:34 am, oana <[EMAIL PROTECTED]> wrote: >> >>>>>>>> I know it has been posted a lor about this topic...but i can't >>>>>>>> figure >>>>>>>> it out. Maybe someone with some experience in cake may help me, >>>>>>>> because i am a newbie. >> >>>>>>>> I have 2 classes, Users and Conversations, between them it's >>>>>>>> habtm >>>>>>>> relationship, and i have the join table ConversationsUser. >> >>>>>>>> In the Users controller i have a function which extracts all >>>>>>>> the >>>>>>>> conversations of an user give by it's id. Whenever i try to do >>>>>>>> this, >>>>>>>> the fields in the join table are deleted. >> >>>>>>>> Can anyone please help me? I didn't post this right away, i >>>>>>>> tried a >>>>>>>> lot to make it work, but i think it's something big i am >>>>>>>> missing. >> >>>>>>>> Thanks, >>>>>>>> Oana > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
