Introduction to Arel

Transcript

1. Introduction to Arel

2. Bruno Sutic
 Rails & Javascript developer
 
 Ideal Project Group,

   Chicago github.com/bruno-
 @brunosutic

3. What is Arel? • github.com/rails/arel • “Simplifies generation of complex

   SQL”
 You write Ruby, out comes the SQL • dependency of ActiveRecord • can be used together with ActiveRecord

4. How I learned about Arel? • credit: Janko Marohnic •

   used Arel to optimize a feature on a project

5. Demo to get you interested :)

6. Prerequisites for the examples • ‘Customer’ is an ActiveRecord model

   • Arel api for a column:
 Customer.arel_table[:name] • A “convention”:
 class Customer
 def self.[](column)
 arel_table[column]
 end
 end Customer[:name]

7. Basic example • ActiveRecord
 Customer.where(name: variable) • Arel
 Customer.where(Customer[:name].eq(variable))

8. A bit more useful example • ActiveRecord
 Customer.joins(:sales)
 .where(“sales.price” =>

   variable)
 
 or
 
 Customer.joins(:sales)
 .where(sales: { price: variable }) • Arel
 Customer.joins(:sales)
 .where(Sale[:price].eq(variable))

9. SQL comparisons example • ActiveRecord
 Customer.where(“credits > ?”, credits_variable) •

   Arel
 Customer.where(
 Customer[:credits].gt(credits_variable)
 ) • All comparison operators:
 gt, lt, gteq, lteq

10. OR condition example • ActiveRecord
 Customer.where(“credits > ? OR credits

    < ?”, var1, var2) • Arel
 Customer.where(
 Customer[:credits].gt(var1).or(
 Customer[:credits].lt(var2)
 )
 )

11. Complex conditions example • ActiveRecord
 Customer.where(
 “credits > ? OR

    (name = ? AND credits < ?)”, var1, var2, var3
 ) • Arel
 Customer.where(
 Customer[:credits].gt(var1).or(
 Customer[:name].eq(var2).and(
 Customer[:credits].lt(var3)
 )
 )
 )

12. LIKE example • ActiveRecord
 Customer.where(“name LIKE ?”, “%#{variable}%”) • Arel


    Customer.where(Customer[:name].matches(“%#{variable}%”))

13. Other features • support for all SQL ‘join’ types •

    SQL literals • writing only a part of a bigger query as SQL • example: CASE statement

14. Benefits of using Arel • pure Ruby, nicer looking code

    • proper code highlighting • ruby exceptions • completely avoids SQL injection

15. Arel resources • github repo:
 https://github.com/rails/arel • great speech:
 https://www.youtube.com/watch?v=ShPAxNcLm3o

    • source code walkthrough:
 https://www.youtube.com/watch?v=EJ6b_2S9Ids • examples from this talk:
 https://gist.github.com/bruno-/5964403476c791331c49

16. Questions?