The Rails Way

Comments and changes to this ticket

• 
  This has been marked as spam

  Martin Carel May 28th, 2008 @ 06:30 PM

  So I assume something like that is missing from the "final BillingCode class"? :

  :delete_sql => `DELETE FROM related_billing_codes WHERE (second_billing_code_id = #{record.id} AND first_billing_code_id = #{id}) OR (second_billing_code_id = #{id} AND first_billing_code_id = #{record.id})’

• 

  Sean August 22nd, 2008 @ 02:05 AM

  • → Title changed from “p 231, Custom SQL Options seems to have stopped short/gone astray.” to “For those who don't want to wait for 2e...”
  • → Tag changed from “” to “chapter7”

  
  class BillingCode < ActiveRecord::Base
    has_and_belongs_to_many :related,
      :join_table => 'related_billing_codes',
      :foreign_key => 'first_billing_code_id',
      :association_foreign_key = 'second_billing_code_id',
      :class_name => 'BillingCode',
      :insert_sql => 'INSERT INTO related_billing_codes (`first_billing_code_id`, `second_billing_code_id`) VALUES (#{id}, #{record.id}), (#{record.id}, #{id})',
      :delete_sql => 'DELETE FROM related_billing_codes WHERE (`first_billing_code_id` = #{id} AND `second_billing_code_id` = #{record.id}) OR (`first_billing_code_id` = #{record.id} AND `second_billing_code_id` = #{id})'
  end
  

• 

  Sean August 22nd, 2008 @ 02:06 AM

  • → Title changed from “For those who don't want to wait for 2e...” to “p 231, Custom SQL Options seems to have stopped short/gone astray.”

  Sorry, mistakenly changed title of the ticket