Selecting all rows based off of multiple columns using ActiveRecord

Question

I'm trying to use activerecord to work with a mysql database, but not in Rails. I'm not at all familiar with databases or ActiveRecord, this is just a short query I need to grab an array of the hostnames of servers from a database. I need to grab all hostnames where the Realm column equals "Stage" and the Status column equals "UP". The database is named ops and the table is host.

I've looked up ActiveRecord queries and I think that I need to do something like

Host.all(:select => "hostname", :conditions => ["realm=stage", "status=UP"])

but this seems wrong.

Can anyone help with this?

And is hostname an attribute of the Host model? Edit: I forgot you're not in Rails. — Marcelo De Polli
– Marcelo De Polli, Commented Aug 27, 2013 at 23:25
Umm like I said, I'm not really familiar with ActiveRecord. I have a class called Host and it extends ActiveRecord::Base, but I didn't know I needed to do more. It should be a column in Host though. — snowe
– snowe, Commented Aug 27, 2013 at 23:27

shaish · Accepted Answer · 2013-08-27 23:24:17Z

1

Host.where(:realm=>"Stage",:status=>"UP")

answered Aug 27, 2013 at 23:24

shaish

1,5191 gold badge13 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

snowe Over a year ago

will this give me the hostname?

shaish Over a year ago

it will give the entire row, you can do Host.where(:realm=>"Stage",:status=>"UP").first().hostname if you want the hostname of the first item.

snowe Over a year ago

Ok, so what if I just want an array of all the hostnames?

shaish Over a year ago

use pluck(:hostname) instead of first().hostname

Marcelo De Polli · Accepted Answer · 2013-08-27 23:27:25Z

1

Host.where(:realm => 'stage', :status => 'UP').pluck(:hostname)

Pluck will give you an array of hostnames, which is what I think you want here.

answered Aug 27, 2013 at 23:27

Marcelo De Polli

29.4k4 gold badges41 silver badges47 bronze badges

1 Comment

snowe Over a year ago

Ok, I'm having trouble connecting to the database right now, but when I do, I think this is the answer that will work so I'll mark this one correct.

Collectives™ on Stack Overflow

Selecting all rows based off of multiple columns using ActiveRecord

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related