python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - activerecord

Query deeply nested relations in rails

We have a lot of through relations in a model. Rails correctly joins the relations, however I am struggling in figuring out how to apply a where search to the joined table using active record. For ins...
test-img

Anders

ruby-on-rails

activerecord

Votes: 0

Answers: 1

Latest Answer

In a simple query where a table is only referenced once there is no alias and the table name is just used: irb(main):023:0> puts City.joins(:country).where(countries: { name: 'Portugal'}) City Load...
test-img

max

Modifying ActiveRecord models before preventing deletion

Some records in my application have a DOI assigned to them and in that case they should not be deleted. Instead, they should have their description changed and be flagged when a user triggers their de...
test-img

knirirr

ruby-on-rails

activerecord

Votes: 0

Answers: 1

Latest Answer

save and destroy are automatically wrapped in a transaction https://api.rubyonrails.org/classes/ActiveRecord/Transactions/ClassMethods.html So destroy fails, transactions is rolled back and you can'...
test-img

stolarz

Finding in array of active record results

I am using active record to create array. users = User.all.to_a now I want to later on find with in this array user id: 1 users.find(1) but it is not giving result but returning everything. How can ...
test-img

shahidkamal

arrays

ruby-on-rails

ruby

activerecord

rails-activerecord

Votes: 0

Answers: 2

Latest Answer

Since it is an array of objects, you should use find with block: users.find { |user| user.id == 1 }
test-img

potashin

Rails is breaking SQL query when modifying order

Context We have a Rails app that is retrieving conversations with the following raw SQL query: SELECT sub.*, profiles.status AS interlocutor_status FROM ( SELECT DISTINCT ON (conversations.id...
test-img

lkartono

ruby-on-rails

activerecord

sql-order-by

Votes: 0

Answers: 1

Latest Answer

Finally found a way to make it work using preload instead of includes. We wanted to avoid having seperate queries to load posts and categories but since performance is not affected by it, we don't min...
test-img

lkartono

Posts

Questions

Blogs

Jobs