activerecord_standalone_sqlite_schema_and_crud_quickstart.rb

1require "active_record"
2
3# 1. Establish a connection to the database
4ActiveRecord::Base.establish_connection(adapter: "sqlite3", database: ":memory:")
5
6# 2. Define the database schema
7ActiveRecord::Schema.define do
8  create_table :posts, force: true do |t|
9    t.string :title
10    t.text :body
11  end
12end
13
14# 3. Define the Model
15class Post < ActiveRecord::Base
16end
17
18# 4. Use the Model to create and find records
19post = Post.create(title: "Hello World", body: "This is my first post using ActiveRecord!")
20puts "Created Post: #{post.title}"
21
22found_post = Post.find(post.id)
23puts "Found Post: #{found_post.title} - #{found_post.body}"
24
25puts "Total Posts: #{Post.count}"