Fork me on GitHub!
Señor Developer!

RUG::B

Ruby User Group Berlin

Building complex queries with the Active Record Query Interface

this Topic will be presented by Gerrit @Study.EU

at April Meetup 2017, hosted by Tobias Pfeiffer

The Active Record query interface is a great way to build complex queries in a simple, (mostly) SQL-agnostic way.

In this talk I would like to describe how we are constructing a complex multi-parameter query at Study.EU to retrieve study programmes from the database based on a search initiated by the user.

The parameters include name, academic level, country, subject, tuition fees in different currencies, duration and the required level of English. Hence the queries include string and integer comparison, ranges, arrays, joins and basic arithmetic.

This talk will be accessible to Rails novices but also include advanced tweaks for seasoned Rails devs.

8 People like it