jtallant · March 25, 2024 13:26 · Dec 6, 2016 · Nov 30, 2016 · Nov 30, 2016 · Nov 30, 2016
diff --git a/setting-up-sinatra-with-active-record.md b/setting-up-sinatra-with-active-record.md
@@ -86,14 +86,30 @@ Load the User model into your app
 require './models'
 ```
 
-Create some users with IRB
+Create a seeds file
 
 ```ruby
-irb
-require './app' # Load app into IRB session
-User.connection
-User
-User.create(fname: 'Jane', lname: 'Doe', email: '[email protected]', created_at: Time.now(), updated_at: Time.now())
+touch db/seeds.rb
+```
+
+Write some seeds
+
+```ruby
+# 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
+
+```ruby
+rake db:seed
 ```
 
 Create an index.erb file in a views directory (views/index.erb)

diff --git a/setting-up-sinatra-with-active-record.md b/setting-up-sinatra-with-active-record.md
@@ -120,7 +120,7 @@ Create a route for the home page
 # app.rb
 get '/' do
   @users = User.all
-  erb :home
+  erb :index
 end
 ```
 

diff --git a/setting-up-sinatra-with-active-record.md b/setting-up-sinatra-with-active-record.md
@@ -90,6 +90,7 @@ Create some users with IRB
 
 ```ruby
 irb
+require './app' # Load app into IRB session
 User.connection
 User
 User.create(fname: 'Jane', lname: 'Doe', email: '[email protected]', created_at: Time.now(), updated_at: Time.now())

diff --git a/setting-up-sinatra-with-active-record.md b/setting-up-sinatra-with-active-record.md
@@ -92,7 +92,7 @@ Create some users with IRB
 irb
 User.connection
 User
-User.create(fname: 'Jane', lname: 'Doe', email: '[email protected]', created_at: Time.now(), updated_at: Time.now()))
+User.create(fname: 'Jane', lname: 'Doe', email: '[email protected]', created_at: Time.now(), updated_at: Time.now())
 ```
 
 Create an index.erb file in a views directory (views/index.erb)

diff --git a/setting-up-sinatra-with-active-record.md b/setting-up-sinatra-with-active-record.md
@@ -121,4 +121,14 @@ get '/' do
   @users = User.all
   erb :home
 end
-```
+```
+
+#### Adding more tables (models)
+
+1. Create migration with rake
+1. Populate the migration with code for adding columns
+1. Run the migration with rake db:migrate
+1. Create the model (add class to models file)
+1. Add some rows to the table with IRB
+1. Create a route and a view for displaying records
+
diff --git a/setting-up-sinatra-with-active-record.md b/setting-up-sinatra-with-active-record.md
@@ -39,7 +39,6 @@ Create a Rakefile
 
 ```ruby
 # Rakefile
-
 require 'sinatra/activerecord/rake'
 require './app'
 ```
@@ -74,15 +73,15 @@ rake db:migrate
 
 Create a User model
 
-```
+```ruby
 # models.rb
 class User < ActiveRecord::Base
 end
 ```
 
 Load the User model into your app
 
-```
+```ruby
 # at the bottom of app.rb
 require './models'
 ```
@@ -116,9 +115,8 @@ Create an index.erb file in a views directory (views/index.erb)
 
 Create a route for the home page
 
-```
+```ruby
 # app.rb
-
 get '/' do
   @users = User.all
   erb :home

diff --git a/setting-up-sinatra-with-active-record.md b/setting-up-sinatra-with-active-record.md
@@ -0,0 +1,126 @@
+# Setting up Sinatra Project
+
+create an empty project and add a Gemfile
+
+```bash
+cd ~/Desktop
+mkdir project-name
+cd project-name
+touch Gemfile
+```
+
+```ruby
+# Gemfile
+source 'https://rubygems.org'
+
+gem 'activerecord'
+gem 'sinatra-activerecord'
+gem 'sqlite3'
+gem 'rake'
+```
+
+Install the dependencies
+
+```bash
+bundle install
+```
+
+Create an app.rb file
+
+```ruby
+# app.rb
+require 'sinatra'
+require 'sinatra/activerecord'
+
+set :database, "sqlite3:project-name.sqlite3"
+```
+
+Create a Rakefile
+
+```ruby
+# Rakefile
+
+require 'sinatra/activerecord/rake'
+require './app'
+```
+
+Create a migration for creating a users table
+
+```bash
+rake db:create_migration NAME=create_users_table
+```
+
+Add code to the migration for creating columns
+
+```ruby
+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
+
+```bash
+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 some users with IRB
+
+```ruby
+irb
+User.connection
+User
+User.create(fname: 'Jane', lname: 'Doe', email: '[email protected]', created_at: Time.now(), updated_at: Time.now()))
+```
+
+Create an index.erb file in a views directory (views/index.erb)
+
+```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 :home
+end
+```