app.rb

require 'rubygems'
require 'sinatra'
require 'sinatra/reloader'
require 'sqlite3'

def init_db
  @db = SQLite3::Database.new 'leprosorium.db'
  @db.results_as_hash = true
end

before do
  init_db
end

configure do
  init_db
  @db.execute 'CREATE TABLE IF NOT EXISTS Posts
    (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      created_date DATE,
      content TEXT
    )'

  @db.execute 'CREATE TABLE IF NOT EXISTS Comments
    (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      created_date DATE,
      content TEXT,
      post_id INTEGER
    )'
end

get '/' do
  @results = @db.execute 'SELECT * FROM POSTS ORDER BY id DESC'

	erb :index
end

get '/NewPost' do
  erb :NewPost
end

post '/NewPost' do
  content = params[:content]

  if content.length == 0
    @error = "Type post text"
    return erb :NewPost
  end

  @db.execute 'INSERT INTO Posts (content, created_date) VALUES (?, datetime())', [content]

  #После добавления каждого нового поста перенаправление на главную

  redirect to '/'

end

get '/details/:post_id' do
  #получаем переменную из URL
  post_id = params[:post_id]

  #получаем пост из базы
  results = @db.execute 'SELECT * FROM POSTS WHERE id = ?', [post_id]
  @row = results[0]

  @comments = @db.execute 'SELECT * FROM Comments WHERE post_id = ? ORDER BY id', [post_id]

  erb :details
end

post '/details/:post_id' do
  post_id = params[:post_id]
  content = params[:content]

  @db.execute 'INSERT INTO Comments
                (content, created_date, post_id)
                  VALUES (?, datetime(), ?)', [content, post_id]

  redirect to('details/' + post_id)
end