Blog post 4 - Returning a JSON Field From Rails GraphQL

1.sql

select
  items.id as ItemId,
  items.name as ItemName,
  items.price as ItemPrice
from items
where items.id = 12

2.rb

query = %(
  select
    items.id as ItemId,
    items.name as ItemName,
    items.price as ItemPrice
  from items
  where items.id = 12
)

query_results = ActiveRecord::Base.send(:sanitize_sql_array, query)
query_results = ActiveRecord::Base.connection.select_all(query_results).rows

query_results #=> [ [12, "My item", 4.99] ]

3.rb

query = %(
  select
    items.id as ItemId,
    items.name as ItemName,
    items.price as ItemPrice
  from items
  where items.id = #{item_id}
)

4.rb

query = %(
  select
    items.id as ItemId,
    items.name as ItemName,
    items.price as ItemPrice
  from items
  where items.id = ?
)

query_results = ActiveRecord::Base.send(:sanitize_sql_array, [query, item_id])
query_results = ActiveRecord::Base.connection.select_all(query_results).rows

5.sql

select
  items.id as ItemId,
  items.name as ItemName,
  items.price as ItemPrice
from items
where items.price > 3
and items.name ~ 'item'

6.rb

query = %(
  select
    items.id as ItemId,
    items.name as ItemName,
    items.price as ItemPrice
  from items
  where items.price > :item_price
  and items.name ~ :item_name
)

7.rb

ActiveRecord::Base.send(:sanitize_sql_array, [query, { item_price: 3, item_name: 'item' }])