Skip to content

Instantly share code, notes, and snippets.

@bcamarda
bcamarda / gist:3126795
Created July 17, 2012 03:19
fun times
begin
ActiveRecord::Schema.define do
create_table :listings do |table|
table.column :url, :string
table.column :title, :string
table.column :authors_email, :string
table.column :emailed_at, :datetime
table.column :created_at, :datetime
table.column :updated_at, :datetime
end
require 'active_record'
require 'sqlite3'
ActiveRecord::Base.establish_connection :adapter => 'sqlite3',
:database => 'db/address_book.db'
ActiveRecord::Base.connection.execute <<-SQL
-- Address book schema
CREATE TABLE contacts (
@bcamarda
bcamarda / gist:3127234
Created July 17, 2012 04:50
Active Record Query
Contact.joins(:addresses).includes(:addresses).where("first_name LIKE 'A%').each do |contact|
puts contact.address.inspect
end
@bcamarda
bcamarda / gist:3127244
Created July 17, 2012 04:51
Active Record Query
Contact.joins(:addresses).includes(:addresses).where("first_name LIKE 'A%').each do |contact|
puts contact.address.inspect
end