Rails: foreign_key that is set with a CASE WHEN mysql statement

Posted by user305270 on Stack Overflow See other posts from Stack Overflow or by user305270
Published on 2010-03-31T00:11:13Z Indexed on 2010/03/31 0:13 UTC
Read the original article Hit count: 703

Filed under:

rails

  belongs_to :removed_friend, 
      :class_name => 'Profile', 
      :foreign_key => "(CASE WHEN friendships.profile_id = #{self.id} THEN friendships.friend_id ELSE friendships.profile_id END)"

The self.id its not working too :s it should be the id of the profile that is triggered the action.

Anyway the main problem is that this foreign_key is not working and i got a mysql error.

please help.. thanks

Related posts about rails

Ruby on Rails: url_for :back leads to NoMethodError for back_url

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I'm trying to use url_for(:back) to create a redirect leading back to a previous page upon a user's logging in. I've had it working successfully for when the user just goes to the login page on his or her own. However, when the user is redirected to the login page due to accessing a page… >>> More
Why am I getting "ArgumentError: wrong number of arguments (1 for 0)" when running my rails function

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm stumped on what's causing this. I get this error and stack trace in all my functional tests where I call 'post'. Here is the full stack trace: 7) Error: test_should_validate(UsersControllerTest): ArgumentError: wrong number of arguments (1 for 0) /Users/hisham/src/rails/ftuBackend/vendor/rails/actionpack/lib/action_controller/routing/route… >>> More
Spork servers super slow (>3m) to start for RSpec & Cucumber BDD

as seen on Stack Overflow - Search for 'Stack Overflow'
I recently installed a fresh development setup on my laptop and now notice that my instances of spork take several minutes to start up. This is also most likely of the RSpec and Cucumber tests start up times running super slow. I ran in diagnostic mode with the -d flag and received the output below… >>> More
trying to convert rails 2.3.4 app to rails 3 but views not appearing

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a simple rails 2.3.4 application I am trying to get running with rails 3.0.0-beta2. I have the server running and all my links and navigation showing, however for some reason the content of my views is not displaying. When I navigate to Site/index the html in my index.html.erb in my site… >>> More
Create new Rails project with previews rails version

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, The latest version of rails installed on my mac is 3.0.0.beta gem list returns rails (3.0.0.beta, 2.3.5, 2.3.4, 2.3.2, 2.2.2, 1.2.6) I want to create a new project using version 2.3.5 So I run: rails _2.3.5_ myProject But it returns the following error $ rails _2.3.5_ photosbackup /Library/Ruby/Site/1… >>> More

Developer IT

Rails: foreign_key that is set with a CASE WHEN mysql statement - Developer IT

Rails: foreign_key that is set with a CASE WHEN mysql statement

rails

Related posts about rails

Ruby on Rails: url_for :back leads to NoMethodError for back_url

Why am I getting "ArgumentError: wrong number of arguments (1 for 0)" when running my rails function

Spork servers super slow (>3m) to start for RSpec & Cucumber BDD

trying to convert rails 2.3.4 app to rails 3 but views not appearing

Create new Rails project with previews rails version

Categories cloud