This Sinatra app uses erb for the templating and active record for the database ORM. To get the cod eto show up I have had to change "< a" to <-a tags and insert extra space in other tags, unfortunately this means they are not quite cut and paste. To simplify The setup I have created a ./create_db.rb file.
./create_db.rb
require 'rubygems'
require 'sequel'
# Connect to the database
DB = Sequel.sqlite('./db/blog.db')
unless DB.table_exists? :posts
DB.create_table :posts do
primary_key :id
varchar :title
text :body
end
# populate the table
DB[:posts].insert(:title => 'Post Man Pat', :body => "has a black and white cat" )
DB[:posts].insert(:title => 'Sandwiches', :body => "Peanut butter and Marmite, Yum")
DB[:posts].insert(:title => 'Leaves', :body => "Grow on trees")
end
class Posts < Sequel::Model
end
The Main Application. ./app.rb
require 'rubygems'
require 'sinatra'
require 'active_record'
#Load extra functions
require 'url_logic'
ActiveRecord::Base.establish_connection(
:adapter => 'sqlite3',
:database => './db/blog.db'
)
class Post < ActiveRecord::Base
end
$blogpath = "article"
get '/' do
erb :index
end
#Setup paths for blog
get '/article/?' do
@posts = Post.all()
erb :readallblog
end
#view a post
get '/article/:id/?' do
@posts = Post.find(params[:id])
erb :showoneblog
end
#edit a post
get '/article/:id/edit/?' do |id|
@posts = Post.find(params[:id])
erb :editblog
end
#Update post
put '/article/:id/?' do
@posts = Post.find(params[:id])
@posts.title = params['post']['title']
@posts.body = params['post']['body']
@posts.save
erb :showoneblog
end
#create a Post
post '/article/?' do
Post.create(
:title =>params['post']['title'] ,
:body => params['post']['body']
)
@posts = Post.all()
erb :readallblog
end
#delete an article
delete '/article/?' do
@posts = Post.find(params['post']['id'])
@posts.delete
@posts = Post.all()
erb :readblog
end
./views/readallblog.erb
readBlog All Posts
<%# $blogpath is global set in the main controller%>
<% for post in @posts %>
< h 1><-a href="/<%=$blogpath%>/<%=post.id%>"><%=post.id%>:<%= post.title %>< / a>
<%=post.body%>
<-a href="/<%=$blogpath%>/<%=post.id%>/edit">edit< / a>
<% end %>
< f orm method="post" action="/<%=$blogpath%>/">
< i nput name="_method" type="hidden" value="post" />
< d iv>
Title< i nput type="text" name="post[title]" value="title"/>
Body< i nput type="text" name="post[body]" value="body"/>
< b utton type="submit">Create
< / d iv>
< / f orm>
./views/showoneblog.erb
Show Single Post
< h 1><%=@posts.id%>:<%= @posts.title %>< / h 1>
< p ><%= @posts.body%>
<-a href="/<%=$blogpath%>/<%=@posts.id%>/edit">edit< / a>
./views/blog
Edit Single Post
< h 1><%=@posts.id%>:<%= @posts.title %>< / h 1>
<%=@posts.body%>
< f orm method="post" action="/<%=$blogpath%>/<%=@posts.id%>/">
< i nput name="_method" type="hidden" value="put" />
< d iv>
Title< i nput type="text" name="post[title]" value="<%=@posts.title%>"/>
Body< i nput type="text" name="post[body]" value="<%=@posts.body%>"/>
< b utton type="submit">Update
< / div>
< / f orm>
Hopefully this has covered creating new, editing and retrieving database entries using ActiveRecord. I have probably missed some of the tricks to simplify writing Sinatra apps.
Posts
