require 'rubygems'
require 'sequel'
 
DB = Sequel.connect('jdbc:mysql://localhost/sequel_test?user=root&password=')
 
DB.create_table! :policies do # Create a new table
  primary_key :id, :serial
  date        :term_start_date
  varchar     :policy_ref, :size => 30
end
 
DB.create_table! :covers do
  primary_key :id, :serial
  foreign_key :policy_id, :policies
  varchar     :cover_code, :size => 30
  boolean     :is_primary
end
 
DB.create_table! :mod_factors do
  integer     :policy_id
  varchar     :cover_code, :size => 30
  varchar     :prem_mod_type
  float       :prem_mod_value
#  foreign_key [:policy_id, :cover_code], :covers
end
 
class Policy < Sequel::Model
  set_primary_key :id
  has_many :covers
  set_allowed_columns :term_start_date, :policy_ref, :cover_attributes
 
  def after_initialize
    puts self.id
    1.upto(3) do |i|
      add_cover(Cover.new({:cover_code => i}))
    end
  end
 
  def cover_attributes=(attribs)
    puts "cover_attributes="
  end
end
 
class Cover < Sequel::Model
  has_many :mod_factors
  belongs_to :policy
end
 
class ModFactor < Sequel::Model
  belongs_to :cover
end
 
p = Policy.new.set({
      :term_start_date => Date.today,
      :cover_attributes => [{:cover_code => "1020"}]})
 
p.save