ActiveRecord includes/join example

activerecord.rb

require 'active_record'
require 'pg'

ActiveRecord::Base.logger = Logger.new(STDOUT)

ActiveRecord::Base.establish_connection(
    :adapter => "postgresql",
    :host     => 'ec2-54-204-41-178.compute-1.amazonaws.com',
    :username => 'bmdjwluxchptuq',
    :password => 'aEH-cKdr2zoXYUAjI8Xjma5eXK',
    :database => 'dfq35t7uirbums',
    :encoding => 'utf8',
)

class Author < ActiveRecord::Base
  def to_s
    "#{first_name} #{last_name}"
  end
end

class Book < ActiveRecord::Base
  belongs_to :author

  def to_s
    "#{title}"
  end

end



books = Book.includes(:author).where('authors.id > 1000').references(:authors)

# books = Book.all
books.each do |book|
  puts book, book.author
end