Making a calendar with Sinatra

Question

Well I don't actually want to make a calendar but I need a view for each day of the year which I guess is sort of the same. Say I have a view where you see e.g. "July 1st" in the top of the page and you have links to the day before and the day after. Beneath this there is a list of - in my example - rooms and they have different states - either available or reserved.

How could I make something like this using Sinatra and Datamapper? Do I put it in the url or what possibilities do I have?

get '/rooms/:date' do
  "List of rooms for " + params[:date]
end

So to recap. I'm trying to create a calendar where for each day you get a list of something that has a state of either available or reserved for every day of the year - but I don't know where to start.

Answer 1

I'd start with database design. What are your central tables? How do they incorporate temporal data? Let's say you have list of rooms. Then you would have to have another table (say room_reservations), each record having start_date, end_date and room_id. A query looking for a list of rooms occupied on a certain date should be trivial.

As for implementing date-centric view in Sinatra, it can be as simple as:

require 'rubygems'
require 'sinatra'
require 'date'
require 'haml'

get '/' do
  redirect "/rooms/#{Date.today}"
end

get '/rooms/:date' do |d|
  @date = Date.parse d
  haml :rooms
end

__END__

@@rooms
%a{:href => "/rooms/#{@date - 1}"}
  =@date-1
%span
  =@date
%a{:href => "/rooms/#{@date + 1}"}
  =@date+1