Convert SQL Query to Rails ORM Query

Question

Whats the eqivalent Rails ORM command for the SQL Query ?

select next_refresh_time from yoddle_jobs where account_key = "YzI5ZDUyNWY5NmYwNWFiNjJiYmE1YTk4Y2VkYTBjYTZmOGM5ZTI0NzE2MzU2MzAwMmU2OWU2MzNiYmQ2YTZhMA==" order by id DESC LIMIT 1;

YoddleJob.where(account_key: "YzI5ZDUyNWY5NmYwNWFiNjJiYmE1YTk4Y2VkYTBjYTZmOGM5ZTI0NzE2MzU2MzAwMmU2OWU2MzNiYmQ2YTZhMA==").select('next_refresh_time').limit(1) try this — Vrushali Pawar
– Vrushali Pawar, Commented Jun 2, 2015 at 11:15
Its works.. but doesn't choose the latest one - last record. — Ninjinx
– Ninjinx, Commented Jun 3, 2015 at 8:32

Ninjinx · Accepted Answer · 2015-06-02 11:19:55Z

2

The equivalent query is

YoddleJob.select(:next_refresh_time).where(:account_key => "YzI5ZDUyNWY5NmYwNWFiNjJiYmE1YTk4Y2VkYTBjYTZmOGM5ZTI0NzE2MzU2MzAwMmU2OWU2MzNiYmQ‌2YTZhMA==").last(1)

answered Jun 2, 2015 at 11:19

Ninjinx

6452 gold badges7 silver badges13 bronze badges

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

Comments

Rajdeep Singh · Accepted Answer · 2015-06-02 11:24:00Z

2

You can try this

YoddleJob.select(:next_refresh_time).where(account_key: "YzI5ZDUyNWY5NmYwNWFiNjJiYmE1YTk4Y2VkYTBjYTZmOGM5ZTI0NzE2MzU2MzAwMmU2OWU2MzNiYmQ‌2YTZhMA==").order("id DESC").first

answered Jun 2, 2015 at 11:24

Rajdeep Singh

17.9k6 gold badges58 silver badges80 bronze badges

Comments

Sachin R · Accepted Answer · 2015-06-02 11:19:36Z

0

This should be like this

YoddleJob.where(:account_key => "YzI5ZDUyNWY5NmYwNWFiNjJiYmE1YTk4Y2VkYTBjYTZmOGM5ZTI0NzE2MzU2MzAwMmU2OWU2MzNiYmQ2YTZhMA==").select('next_refresh_time').order("id desc").limit(1)

answered Jun 2, 2015 at 11:19

Sachin R

11.9k11 gold badges37 silver badges42 bronze badges

Comments

Vrushali Pawar · Accepted Answer · 2015-06-03 08:33:25Z

0

YoddleJob.where(account_key: "YzI5ZDUyNWY5NmYwNWFiNjJiYmE1YTk4Y2VkYTBjYTZmOGM5ZTI0NzE2MzU2MzAwMmU2OWU2MzNiYmQ‌2YTZhMA==").select('next_refresh_time').last(1)

answered Jun 3, 2015 at 8:33

Vrushali Pawar

3,8131 gold badge16 silver badges22 bronze badges

Collectives™ on Stack Overflow

Convert SQL Query to Rails ORM Query

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related