Fork me on GitHub!
Señor Developer!

Hamburg on Ruby

Heimathafen der Hamburger Ruby Community

Ruby / Rails Jobs in Hamburg: Ruby on Rails Developer bei Toptranslation (toptranslation.com)

Building complex queries with the Active Record Query Interface (HH)

dieses Thema wird vorgestellt von Gerrit (Study.EU) 🎓

bei Ruby Usergroup Hamburg - September 2016, gehostet durch 💥 Peter Schröder 💥

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.

gefällt 2 Leuten