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,969+ developers who get early access to new tutorials, screencasts, articles, and more.

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