#encoding: utf-8
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
  );'
end

get '/' do

  @results = @db.execute 'select * from Posts order by id desc'
  erb :index
end

get '/new' do
  erb :new
end

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

  if content.length <=0
    @error = 'Type your text'
    return erb :new
  end

  @db.execute 'insert into "Posts" (content, created_date) values (?,datetime())', [content]
  redirect to '/'
end

get '/details/:post_id' do
  post_id = params[:post_id]
  results = @db.execute 'select * from Posts where id = ?', [post_id]
  @raw = results[0]
  erb :details

end

#encoding: utf-8
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
  );'
end

get '/' do

  @results = @db.execute 'select * from Posts order by id desc'
  erb :index
end

get '/new' do
  erb :new
end

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

  if content.length <=0
    @error = 'Type your text'
    return erb :new
  end

  @db.execute 'insert into "Posts" (content, created_date) values (?,datetime())', [content]
  redirect to '/'
end

get '/details/:post_id' do
  post_id = params[:post_id]
  results = @db.execute 'select * from Posts where id = ?', [post_id]
  @raw = results[0]
  erb :details

end

post '/details/:post_id' do
  post_id = params[:post_id]
  content = params[:content]
  erb "Ypu typed comment #{content} for post #{post_id}"
end

Add simple details post handler
Add simple details post handler
