models.rb

# Database

require 'data_mapper'
require 'dm-pager'
require 'dm-validations'
require 'dm-constraints'
require 'dm-types'

DataMapper.setup(:default, settings.production_database_url || "sqlite://#{Dir.pwd}/development.db")

class Entry
  include DataMapper::Resource

  property :id,           Serial
  property :text,         Text, :length => 1..300

  property :vote_count,      Integer, :default => 0
  property :up_vote_count,   Integer, :default => 0
  property :down_vote_count, Integer, :default => 0
  property :vote_score,      Integer, :default => 0, :index => true

  property :ips,          Json, :default => []

  property :created_at,   DateTime, :index => true
  property :update_at,    DateTime

  def vote(ip, up=true)
    return if already_voted?(ip)
    self.vote_count      += 1
    self.up_vote_count   += 1 if up
    self.down_vote_count += 1 unless up
    self.vote_score      = self.up_vote_count - self.down_vote_count
    self.ips << ip
    self.save
  end

  def already_voted?(ip)
    (settings.block_repeated_votes? && self.ips.count(ip) != 0)
  end

end

#class Vote
#  include DataMapper::Resource
#
#  property :id,           Serial
#  property :ip,           String, :index => true
#  property :up,           Boolean, :default => true
#
#  property :created_at,   DateTime
#  property :update_at,    DateTime
#
#  belongs_to :entry
#end

DataMapper.finalize
DataMapper.auto_upgrade!