I’m trying to find all Users with an id greater than 200, but I’m having some trouble with the specific syntax. User.where(:id > 200) and User.where(“? > 200”, :id) have both failed. Any suggestions? 10 Answers 10
I need to add timestamps (created_at & updated_at) to an existing table. I tried the following code but it didn’t work. class AddTimestampsToUser < ActiveRecord::Migration def change_table add_timestamps(:users) end end 21 Answers 21
Suppose I have the following two objects: first_name_relation = User.where(:first_name => ‘Tobias’) # ActiveRecord::Relation last_name_relation = User.where(:last_name => ‘Fünke’) # ActiveRecord::Relation is it possible to combine the two relations to produce one ActiveRecord::Relation object containing both conditions? Note: I’m aware that I can chain the wheres to get this behavior, what I’m really interested in … Read more
I have a rake task that won’t work unless a table exists. I’m working with more than 20 engineers on a website so I want to make sure they have migrated the table before they can do a rake task which will populate that respective table. Does AR have a method such as Table.exists? How … Read more
How do you do an OR query in Rails 3 ActiveRecord. All the examples I find just have AND queries. Edit: OR method is available since Rails 5. See ActiveRecord::QueryMethods 14 Answers 14
I need to query comments made in one day. The field is part of the standard timestamps, is created_at. The selected date is coming from a date_select. How can I use ActiveRecord to do that? I need something like: “SELECT * FROM comments WHERE created_at BETWEEN ‘2010-02-03 00:00:00’ AND ‘2010-02-03 23:59:59′” 11 Answers 11
Is there a rails-way way to validate that an actual record is unique and not just a column? For example, a friendship model / table should not be able to have multiple identical records like: user_id: 10 | friend_id: 20 user_id: 10 | friend_id: 20 3 Answers 3
Please help me in understanding the :source option of has_one/has_many :through association. The Rails API explanation makes very little sense to me. “Specifies the source association name used by has_many :through => :queries. Only use it if the name cannot be inferred from the association. has_many :subscribers, :through => :subscriptions will look for either :subscribers … Read more
I have a list of events that I fetch. I’m trying to include every user associated to this event and every profile associated to each user. The Users get included but not their profiles. How Would i do this Event.includes(:users [{profile:}]) The docs don’t seem to be clear: http://guides.rubyonrails.org/active_record_querying.html 3 Answers 3
In Rails, you can find the number of records using both Model.size and Model.count. If you’re dealing with more complex queries is there any advantage to using one method over the other? How are they different? For instance, I have users with photos. If I want to show a table of users and how many … Read more
