How to use find method on table with two column index

rubyonrails-talk
1

I created an index with person_id and club_id but I can't figure out how to properly access it (doesn't show up in the find_by... lists)

Can someone provide me a sample find statement to best use this index

Thanks.

class CreateMembers < ActiveRecord::Migration   def self.up     create_table :members do |t|       t.integer :club_id       t.integer :person_id       t.text :comment       t.string :status       t.string :member_type       t.integer :registrations_count

      t.timestamps     end

    add_index :members, :club_id     add_index :members, :person_id     add_index :members, [:person_id, :club_id]   end

  def self.down     drop_table :members   end end

2

I created an index with person_id and club_id but I can't figure out how to properly access it (doesn't show up in the find_by... lists)

Can someone provide me a sample find statement to best use this index

You don't need to do anything explicitly - just find :all, :conditions => ... will use the index if needed (you may have been looking for find_by_xxx_and_yyy though) The index on person_id is usually superfluous - when you have a multicolumn index then any left prefix of that index is also an index ie the index on [:person_id, :club_id] can be used as an index on just person_id

Fred

3

Hi there

What you are trying to find is (I think it's the easiest option )

class CreateListSongs < ActiveRecord::Migration   def self.up     create_table :members, :primary_key =>[:club_id, :person_id] do |t|          t.integer :club_id          t.integer :person_id          t.text :comment          t.string :status          t.string :member_type          t.integer :registrations_count          t.timestamps

    end   end

  def self.down     drop_table :members   end end

Hope this helps

Best regards

  Miquel