How to use find method on table with two column index

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

On Mar 29, 7:51 pm, RVRoadie [email protected] wrote:

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

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

On Mon, 29 Mar 2010 11:51:48 -0700 (PDT)
RVRoadie wrote:

  t.integer :club_id
add_index :members, :person_id

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/rubyonrails-talk?hl=en.

Miquel (a.k.a. Ktalà a.k.a. Ton)
Linux User #286784
GPG Key : 4D91EF7F
Debian GNU/Linux (Linux wolverine 2.6.23.1)

Welcome to the jungle, we got fun and games
Guns n’ Roses

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs