Generate connected DB and Model from the command line

rails g model Book title:string description:text author: string price:integer

Create database from migration file

rake db:migrate

Start server

rails s

Generate controller from the command line

rails g controller Books

Check routes for the app

rake routes

In routes.rb file , create a restful route

resources :books

In routes.rb file defining the root of the application

root ‘books#index’

Install the gems, every time needs to be run when we installing new gems

bundle install

Install simple_form gems with incorporated bootstrap

rails g simple_form:install –bootstrap

Install gem devise for login, logout

gem 'devise', '~> 4.2'

rails g devise:install

rails g devise:views

rails g devise User

Update DB with the new USER tables

rake db:migrate

Create relashions between user_id and items

rails g migration add_user_id_to_items user_id:integer

Connect with the DB through the console. Item is the DB-table

rails c

Item.connection

Item – see all fields and types of fields

Item.first | Item.last | Item.find(3) – find by id

Create variables with results from the DB query

rails c

Item.connection

@book = Item.last

@item.user_id = 1

@item.save

In show.html.erb- Add the logic if the user is login

<% if user_signed_in? %>

<% if @item.user_id == current_user.id %>

<%= link_to “Edit”, edit_item_path(@item) %>

<%= link_to “Delete”, item_path(@item), method: :delete, data: { confirm: “Are you sure” } %>

<% end %>

<% end %>

Connect with the DB through the console and add Categories manually

rails c

Category.connection

Category.create(name: “Art”)

Write pure SQL to the DB

rails db

.tables

README