ij2jgX8S

1require 'active_record'
2require 'sqlite3'
3ActiveRecord::Base.establish_connection :adapter  => 'sqlite3',
4                                        :database => 'db/students.db'
5ActiveRecord::Base.connection.execute <<SQL
6  CREATE TABLE IF NOT EXISTS students (
7    id INTEGER PRIMARY KEY AUTOINCREMENT,
8    first_name VARCHAR NOT NULL,
9    last_name  VARCHAR NOT NULL,
10    birthday   DATE,
11    gender     VARCHAR(8),
12    email      VARCHAR,
13    phone      VARCHAR,
14    created_at DATETIME NOT NULL,
15    updated_at DATETIME NOT NULL
16  );
17SQL
18
19class Student < ActiveRecord::Base
20end
21
22
23
24Student.create(:first_name => 'Adam', :last_name => 'Flint', :birthday => '1977-07-28')
25
26Student.create(:first_name => 'Brad', :last_name => 'Johnson', :birthday => '1977-01-07')
27
28Student.create(:first_name => 'Adam', :last_name => 'Johnson', :birthday => '1977-11-28')
29
30
31puts Student.select("first_name, last_name, created_at").inspect
32puts Student.where("first_name Like 'A%' ").inspect
33puts Student.where("strftime('%m',birthday) = '07'").inspect