Convert SQL query to rails Active Record query interface

Question

I have the following sql query and I want to map it to a rails count query:

SELECT count(*), DATE(CONVERT_TZ(created_at, '+00:00', '-05:00')) as converted_date 
FROM video_logs 
where user_id = 19 and question_id = 96 and dashboard = 'player_question' 
GROUP BY converted_date;

How do I do this?

alony · Accepted Answer · 2011-12-15 12:10:52Z

4

In rails 3:

VideoLog.select("count(*), DATE(CONVERT_TZ(created_at, '+00:00', '-05:00')) as converted_date").\
    where(:user_id => 19, :question_id => 96, :dashboard => 'player_question').\
    group('converted_date')

In rails 2:

VideoLog.all(:select => "count(*), DATE(CONVERT_TZ(created_at, '+00:00', '-05:00')) as converted_date",
    :conditions => {:user_id => 19, :question_id => 96, :dashboard => 'player_question'},
    :group => 'converted_date')

edited Dec 15, 2011 at 12:10

answered Dec 15, 2011 at 9:30

alony

10.8k3 gold badges41 silver badges46 bronze badges

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

1 Comment

Furqan Asghar Over a year ago

.select is not available in rails 2, i'm using rails 2.3.5 any suggestions ?

Collectives™ on Stack Overflow

Convert SQL query to rails Active Record query interface

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related