kainlite's Profile

kainlite on #355 Hacking with Arel (pro) 2013-01-18 18:30:06

Ryan, I've been watching a lot of railscasts, I'm lacking of knowledge in the subject, but there is a "Right way TM." to do a proper union in a "complex sql query" using ActiveRecord or Arel? I will show you what I'm trying to generate :(

          sql
        
SELECT * FROM users WHERE id = (SELECT enrollable_id FROM enrollments WHERE enrollable_type='User')
UNION ALL
SELECT * FROM users WHERE id = (SELECT user_id FROM memberships WHERE group_id = (SELECT enrollable_id FROM enrollments WHERE enrollable_type='Group'))

Is awesome what you can get with Arel but I don't know if what I'm trying to do is breaking any rule or is just not possible using AR or Arel..

kainlite on #248 Offline Apps Part 2 2013-01-17 18:19:06

awesomeness on every railscast!

kainlite on #181 Include vs Joins 2011-11-25 11:24:11

Great episode thank you Ryan, keep the good work ;-)

kainlite on #74 Complex Forms Part 2 2011-11-21 21:01:09

Awesome, you're great, I love your screencasts :)

Comments by