require "rubygems"
require "sinatra"
require "dm-core"
require "dm-timestamps"
require "dm-aggregates"
require "syntaxi"
require "bb-ruby"

@db_info = {
  :host => 'localhost',
  :adapter => 'mysql',
  :database => 'vbulletin_dev',
  :username => 'root',
  :password => 'password'
  }

DataMapper.setup(:default, @db_info)

class Post
  include DataMapper::Resource

  storage_names[:default] = 'vb_post'

  property :id, Serial, :field => 'postid', :writer => :private
  property :parent, Integer, :field => 'parentid', :writer => :private
  property :username, String, :writer => :private
  property :title, String, :writer => :private
  property :content, Text, :field => 'pagetext', :lazy => false, :writer => :private

  belongs_to :topic, :child_key => [:threadid]
end

class Topic
  include DataMapper::Resource

  storage_names[:default] = 'vb_thread'

  property :id, Serial, :field => 'threadid', :writer => :private
  property :title, String, :writer => :private
  property :first_post, Integer, :field => 'firstpostid', :writer => :private
  property :forum, Integer, :field => 'forumid', :writer => :private
  property :author, String, :field => 'postusername', :writer => :private
  property :replies, Integer, :field => 'replycount', :writer => :private

  has n, :posts, :child_key => [:threadid]
end

get '/' do
  @topics = Topic.all(:limit => 30)

  haml :index
end