require 'rubygems'
require 'sinatra'
require 'sequel'
require 'haml'

con = Sequel.connect('postgres://dmw:dmw@localhost:5433/domowoi_development')
enable :inline_template

get '/h' do
  'hello'
end

get '/hh' do
  haml :index
end

get '/n' do
    s = ''
    for i in 1..1000
      s << "#{i}" << "\n"
    end
    s
end

get '/nh' do
    haml :numbers
end

# users has about 40 rows in a table
get '/s' do
  '<pre>'+
  con[:users].all.map do |u|
    "#{u[:id]}\t#{u[:login]}\t#{u[:first_name]}\t#{u[:ser_name]}"
  end.join("\n") +
  '</pre>'
end

get '/sh' do
  @users = con[:users].all
  haml :sequel
end

class User < Sequel::Model
end

get '/m' do
  '<pre>'+
  User.all.map do |u|
    [u.id, u.login, u.first_name, u.ser_name].join("\t")
  end.join("\n") +
  '</pre>'
end

get '/mh' do
  @users = User.all
  haml :model
end

before do
  content_type 'text/html', :charset => 'utf-8'
end

__END__
@@ layout
%html
  %body
    = yield

@@ index
%h1 Hello

@@ numbers
- for i in 1..1000
  = i

@@ sequel
%pre
  - @users.each do |u|
    = "#{u[:id]}\t#{u[:login]}\t#{u[:first_name]}\t#{u[:ser_name]}"

@@ model
%pre
  - @users.each do |u|
    = [u.id, u.login, u.first_name, u.ser_name].join("\t")