Structure for a Rails Postgres Query

Question

So i'm still trying to get to grips with Ruby & Rails and Postgres and i need to run a query but can't quite get my head round how to return the desired results

i have the following

ORDERS

the orders have many #ITEMS // as well as a TOTAL_PRICE variable

in the #ITEMS is an ORDERABLE_ID variable which refers to a #PRODUCT

i also have

USERS the users have many #ORDERS

I'm trying to run a query that will do the following

Check IF the current USER has an ORDER that contains an ITEM with ORDERABLE_ID == 71 with an ORDER TOTAL_PRICE > 40

OrderItem belongs_to :order 
OrderItem belongs_to :orderable 
Order has many :items, class_name "OrderItem"

jvillian · Accepted Answer · 2017-10-03 16:46:57Z

1

Assuming:

a variable @product that has the id = 71
a variable @total_price that has the value 40
a variable/function called current_user
OrderItem belongs_to :order
OrderItem belongs_to :orderable, polymorphic: true
Order belongs_to :user

Then I believe it would be something like:

Order.
  joins(:items).
  where(items: {id: OrderItem.where(orderable: @product)}).
  where('total_price > ?', @total_price).
  where(user: current_user).
  any?

edited Oct 3, 2017 at 16:46

answered Oct 3, 2017 at 16:09

jvillian

20.3k5 gold badges33 silver badges45 bronze badges

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

1 Comment

Bryan Spence Over a year ago

OrderItem belongs_to :order // OrderItem belongs_to :orderable // Order has many :items, class_name "OrderItem"

Collectives™ on Stack Overflow

Structure for a Rails Postgres Query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related