Project

left_join

0.01
No release in over 3 years
Low commit activity in last 3 years
This gem helps doing LEFT JOIN's between ActiveRecord associations
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

~> 1.0
~> 2.1.0
~> 3.12
~> 3.3
 Project Readme

left_join

This gem helps you doing LEFT JOINs between your ActiveRecord associations, so you can do this:

Book.left_join(:category)
# SELECT "books".* FROM "books"
# LEFT OUTER JOIN "categories"
# ON "books"."category_id" = "categories"."id"

It also supports chaining associations, e.g. Category.left_join(books: :authors).

Why?

See this blog post for details.

Installation

Add to your Gemfile:

gem 'left_join'

Or install it manually

gem install left_join

Contributing

  • Fork the project.
  • Start a feature/bugfix branch.
  • Commit and push until you are happy with your contribution.
  • Make sure to add tests for it. This is important so I don't break it in a future version unintentionally.
  • Create a pull request.

Copyright

Copyright (c) 2015 Diego Aguir Selzlein. See LICENSE.txt for further details.