The activerecord_crud's intro from chefboyrt

activerecord_crud's Introduction

Steps to setup Ruby app with activerecord

In root of project/app, run bundle init
Add gems: activerecord, pry, sinatra, sintra-activerecord, require_all, run bundle install
Create config and lib directories
Create config/environment.rb
mkdir lib/models
Touch Rakefile - require ‘sinatra/activerecord/rake’ and ‘config/environment.rb’
In config/environment.rb, require ‘sinatra/activerecord’ and ‘require_all’, then do ‘require_all ‘lib’’, establish ActiveRecord::Base connection to db (call database whatever the name of the db is)

ActiveRecord::Base.establish_connection(
  :adapter => 'sqlite3',
  :database => 'db/cats.db'
)

Run rake -T to make sure we have access to raketasks
Run rake db:create_migration NAME=create_cats_table (will create the db folder if it doesn’t already exist) and will add the migration file to db/migration
Write migration file, then run rake db:migrate
Then can see schema in file structure, can also drop into sqlite3 cats.db to see the tables and schema, but don’t really need to do that anymore. Review rollback here
Create seeds in db/seeds.rb and run rake db:seed
Now can put a pry in environment.rb to run Breed.all and see your seeds.

To view database, can run sqlite3 db/cats.db, then can run .schema or .tables and can run any SQL commands. (Don't need to do this anymore though! ActiveRecord gives us a schema file!)

Recommend Projects