Use Raw mysql retrieve data from ruby on rails get unexpected

Question

I want to retrieve status data from table projects in ror project.

the mysql code will be :

Setect status from projects where id = 2;

Im new to ror so I try use raw mysql to retrieve data:

sta1=Project.find_by_sql(["SELECT status FROM projects WHERE id = ?",id1]).first

This returns a #

I'm expecting a string either "on" or "off"

whats my problem?

possible duplicate of find_by_sql in Rails, accessing the resulting array — Ken Y-N
– Ken Y-N, Commented Jun 18, 2014 at 4:31
Incidentally, you probably never want to use find_by_sql when there is a 'Rails way' of doing this... sta1 = Project.find(id1).status is where'd you go if you're finding by id... — Helios de Guerra
– Helios de Guerra, Commented Jun 18, 2014 at 4:48
Most (almost all) queries can be written without raw SQL, so consider that thing a last resort. Even if standard ActiveRecord snippets you can find are not enough for you, you can use arel that defines queries similarly to SQL but with possibility to use Ruby in constructing it. — D-side
– D-side, Commented Jun 18, 2014 at 12:03

Mark Swardstrom · Accepted Answer · 2014-06-18 05:25:10Z

0

Use pluck to get a single value out of the record. It returns an array.

Project.where(id: id1).pluck(:status).first

answered Jun 18, 2014 at 5:25

Mark Swardstrom

18.3k6 gold badges75 silver badges76 bronze badges

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

1 Answer 1