Setting up Sinatra Project

create an empty project and add a Gemfile

cd ~/Desktop
mkdir project-name
cd project-name
touch Gemfile

# Gemfile
source 'https://rubygems.org'

gem 'activerecord'
gem 'sinatra-activerecord'
gem 'sqlite3'
gem 'rake'

Install the dependencies

bundle install

Create an app.rb file

# app.rb
require 'sinatra'
require 'sinatra/activerecord'

set :database, "sqlite3:project-name.sqlite3"

Create a Rakefile

# Rakefile
require 'sinatra/activerecord/rake'
require './app'

Create a migration for creating a users table

rake db:create_migration NAME=create_users_table

Add code to the migration for creating columns

class CreateUsersTable < ActiveRecord::Migration[5.0]
  def change
    create_table :users do |t|
      t.string :fname
      t.string :lname
      t.string :email
      t.datetime :created_at
      t.datetime :updated_at
    end
  end
end

Run the migration

rake db:migrate

Create a User model

# models.rb
class User < ActiveRecord::Base
end

Load the User model into your app

# at the bottom of app.rb
require './models'

Create a seeds file

touch db/seeds.rb

Write some seeds

# db/seeds.rb
users = [
  {fname: 'Jon', lname: 'Doe', email: '[email protected]'},
  {fname: 'Jane', lname: 'Doe', email: '[email protected]'}
]

users.each do |u|
  User.create(u)
end

Run the seeds

rake db:seed

Create an index.erb file in a views directory (views/index.erb)

<!DOCTYPE html>
<html>
<head>
    <title>Users</title>
</head>
<body>
    <ul>
        <% @users.each do |user| %>
            <li><%= user.email %></li>
        <% end %>
    </ul>
</body>
</html>

Create a route for the home page

# app.rb
get '/' do
  @users = User.all
  erb :index
end

Adding more tables (models)

Create migration with rake
Populate the migration with code for adding columns
Run the migration with rake db:migrate
Create the model (add class to models file)
Add some rows to the table with IRB
Create a route and a view for displaying records

jtallant/setting-up-sinatra-with-active-record.md

Setting up Sinatra Project

Adding more tables (models)

Abidzar16 commented Aug 10, 2021

Uh oh!

m-axis commented Sep 14, 2021

Uh oh!