Simple AR without Rails Example

first_ar.rb

require 'active_record'

ActiveRecord::Base.establish_connection :adapter => 'sqlite3', :database => 'db/development.sqlite3'

class Customer < ActiveRecord::Base
  # Associated with the customers.
end

# SELECT * FROM customers ORDER BY id ASC LIMIT 1
first_customer = Customer.first

puts "#{first_customer.name} lives in the city of #{first_customer.city}."

# SELECT COUNT(*) FROM customers
customer_count = Customer.count

puts "My customers table contains #{customer_count} customers."