require 'dm-core'

DataMapper.setup :default,
                 :adapter => 'postgres',
                 :host => 'localhost',
                 :port => 5433,
                 :username => 'dofus_treasury',
                 :password => 'dofus_treasury',
                 :database => 'dofus_treasury'

# Items are identified by names, for example, Bread
# A recipe has one product item, and a few ingredient items each dosed with a
# quantity, for example, Bread = 2 Flour + 1 Yeast + 1 Water
# A dosage is to used to hold one ingredient item and its quantity

class Item
  include DataMapper::Resource

  property :name, String, :key => true
  has n, :dosages
  has n, :recipes, :through => :dosages
end

class Dosage
  include DataMapper::Resource

  property :id, Serial
  property :quantity, Integer
  belongs_to :item
  belongs_to :recipe
end

class Recipe
  include DataMapper::Resource

  property :id, Serial
  has 1, :product, :class_name => 'Item'
  has n, :dosages
  has n, :ingredients, :class_name => 'Item', :child_key => :item,
         :through => :dosages
end

Recipe.new do |r|
  r.product = Item.new(:name => 'Bread')
  r.ingredients << Dosage.new do |d|
    d.quantity = 2
    d.item = Item.new(:name => 'Flour')
  end
  r.ingredients << Dosage.new do |d|
    d.quantity = 1
    d.item = Item.new(:name => 'Yeast')
  end
  r.ingredients << Dosage.new do |d|
    d.quantity = 1
    d.item = Item.new(:name => 'Water')
  end
end.save

DataMapper.auto_migrate!