update on a m:n table - Ruby on Rails: Talk

2 messages - Collapse all

Christoph Thommen

More options May 10, 2:54 pm

From: Christoph Thommen <rails-mailing-l...@andreas-s.net>

Date: Sat, 10 May 2008 20:54:38 +0200

Local: Sat, May 10 2008 2:54 pm

Subject: update on a m:n table

  Reply to author
  |
  Forward
  | Print
  | Individual message
  | Show original
  | Report this message
  | Find messages by this author
  

Hi all

following situation:
3 tables:
users (id, nickname,...)
conversations(id, ...)
conversations_users(user_id, conversation_id, date_deleted)

2: models
user (has_and_belongs_to_many :conversations,
:join_table=>'conversations_users', :conditions=>'date_deleted IS NULL')
conversation

How can i update update the "date_deleted" in the m:n join table? If i
want to do it by
user.conditions.date_deleted = DateTime.now

it don't work

Any idea?

Reply to author Forward

Rails Terrorist

More options May 10, 3:45 pm

From: Rails Terrorist <rails-mailing-l...@andreas-s.net>

Date: Sat, 10 May 2008 21:45:02 +0200

Local: Sat, May 10 2008 3:45 pm

Subject: Re: update on a m:n table

  Reply to author
  |
  Forward
  | Print
  | Individual message
  | Show original
  | Report this message
  | Find messages by this author
  

I dont like this way, but this is my answer :

for sample in user.conditions
sample.date_deleted = DateTime.now
end

but it will hurt your AR or database because it will connect to database
for each looping. Maybe another have lovely solution.

Reply to author Forward

End of messages