SQL-query to ActiveRecord-query. Ruby

Question

I need to write this SQL-query on ruby

SELECT value FROM CompanySetting WHERE company_id = 1 AND title = 'Work days'

and next get this value for the check, like this

value = ...SQL query... and then if value.nil?..

Can you help me write method which do this, please?

Christian-G · Accepted Answer · 2013-09-19 09:20:11Z

1

Assuming you have a model CompanySetting, you can use the following to obtain the record with your conditions:

CompanySetting.where(company_id: 1, title: "Work days").pluck(:value)

If you just want the first record use:

CompanySetting.where(company_id: 1, title: "Work days").pluck(:value).first

If you want to test if a value is nil, you can use value.nil?

I suggest you read some documentation

answered Sep 19, 2013 at 9:08

Christian-G

2,3614 gold badges28 silver badges47 bronze badges

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

5 Comments

About rest of the question I bet there was meaning value = ...SQL query... and then if value.nil?...

that returned me all row from table. But need to get only one value from the column.

Use the pluck method in combination with first (see updated answer)

great! That's it! Tnx

Also: CompanySetting.where(company_id: self.id, title:'Vacation days').first.value

santosh · Accepted Answer · 2013-09-19 09:25:53Z

0

val=CompanySetting.where(company_id: 1, title: "Work days").pluck(:value).first

"Do Something" if val.nil?

answered Sep 19, 2013 at 9:25

santosh

1,6111 gold badge13 silver badges22 bronze badges