Ask A Question

Notifications

You’re not receiving notifications from this thread.

How can I convert this code to raw SQL and use in rails?

Priya Sharma asked in Rails

How can I convert this code to raw sql and use in rails? Because When I deploy this code in Heroku, there is a request timeout error. I think this will be faster if I use raw sql.

@payments = PaymentDetail.joins(:project).order('payment_details.created_at desc')
@payment_errors = PaymentError.joins(:project).order('payment_errors.created_at desc')

@all_payments = (@payments + @payment_errors)

Reply
@all_payments = PaymentDetail.joins(:project).order('payment_details.created_at desc')
  .union(PaymentError.joins(:project).order('payment_errors.created_at desc'))
  .order('created_at desc')
Reply

You can always call to_sql to see what the SQL is at the end of every query

Reply
Join the discussion
Create an account Log in

Want to stay up-to-date with Ruby on Rails?

Join 82,160+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more.

    © 2024 GoRails, LLC. All rights reserved.