Inlägg taggade ‘Sinatra’

# myapp.rb
require 'rubygems'
require 'sinatra'
get '/' do
  'Hello world!'
end

gem sources -a http://gems.github.com

sudo gem install sinatra gimite-google-spreadsheet-ruby haml

require 'rubygems'
require 'sinatra'
require 'google_spreadsheet'

# We want to save the posts in a session variable
set :sessions, true

def get_posts
  # Retrieve and return the posts
  session["posts"] ||= retrieve_posts
end
 
def retrieve_posts
  # Empty posts hash
  posts = {}
 
  # Log in to Google Spreadsheet
  session = GoogleSpreadsheet.login('xxxxxxxx', 'xxxxxxxx')
 
  # First worksheet of 
  #  http://spreadsheets.google.com/ccc?key=peGTxx6h1WT0ihw9-QETbQg
  ws = session.spreadsheet_by_key("peGTxx6h1WT0ihw9-QETbQg").worksheets[0]
 
  # Iterate over all the rows in the spreadsheet
  for i in 1...ws.num_rows
    # Store the data Identify data using the slug
    posts[ws[i+1,5]] = {
      :title    => ws[i+1,1],
      :content  => ws[i+1,2],
      :date     => Date.parse(ws[i+1,3]),
      :author   => ws[i+1,4],
    }
  end
 
  # Return the retrieved posts
  posts
end

get '/' do
  # Get all the posts
  @posts = get_posts
 
  # Render the index template
  haml :index
end

get '/:slug' do
  # Get the post
  @post = get_posts[params[:slug]]
 
  # Render the post template
  haml :post
end

__END__
 
@@ layout
%html
  %head
    %title Sinatra and Google Spreadsheet
  %body
    = yield
 
@@ index
%h1.title All posts
 
- @posts.each do |slug, post|
  %ul
    %li
      %a{:href => slug}
        = post[:title]
@@ post
%h1.title
  = @post[:title]
 
%div
  Published
  %span.date
    = @post[:date]
  by
  %span.author
    = @post[:author]
 
%p.content
  = @post[:content]
 
%a{:href => '/'} << Back

$ ruby sinatra-and-google-spreadsheet.rb 
== Sinatra/0.9.1 has taken the stage on 4567 for development with backup from Thin
>> Thin web server (v1.0.0 codename That´s What She Said)
>> Maximum connections set to 1024
>> Listening on 0.0.0.0:4567, CTRL+C to stop