activerecord_standalone_sqlite_crud_operations_quickstart.rb

1require "active_record"
2
3# 1. Establish a connection to the database
4ActiveRecord::Base.establish_connection(
5  adapter:  "sqlite3",
6  database: ":memory:"
7)
8
9# 2. Define the database schema (usually done via migrations)
10ActiveRecord::Schema.define do
11  create_table :users, force: true do |t|
12    t.string :name
13    t.string :email
14  end
15end
16
17# 3. Define the Model
18class User < ActiveRecord::Base
19end
20
21# 4. Use the Model
22# Create
23user = User.create(name: "Rubyist", email: "ruby@example.com")
24
25# Read
26found_user = User.find_by(name: "Rubyist")
27puts "Found: #{found_user.name} (#{found_user.email})"
28
29# Update
30found_user.update(email: "new_email@example.com")
31
32# Delete
33found_user.destroy
34puts "User count: #{User.count}"