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

## setting-up-sinatra-with-active-record.md

      
    Raw
  

              setting-up-sinatra-with-active-record.md
            
          
    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: 'e@example.com'},
  {fname: 'Jane', lname: 'Doe', email: 'e@example.com'}
]

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