gistfile1.builder

class GSE
  include DataMapper::Resource
  def self.default_repository_name; :expr_geo; end
  storage_names[:expr_geo] = "gse_list"
  property :gse, Integer, :key => true

  has n, :gse_gsms, "GSEGSM", :child_key => [:gse], :parent_key => [:gse]
  has n, :gsm_objects, "GSM", :through => :gse_gsm

end

class GSEGSM
  include DataMapper::Resource
  def self.default_repository_name; :expr_geo; end
  storage_names[:expr_geo] = "gse_gsm"
  belongs_to :gse_object, "GSE", :child_key => [:gse], :parent_key => [:gse], :key => true
  belongs_to :gsm_object, "GSM", :child_key => [:gsm], :parent_key => [:gsm], :key => true
end

class GSM
  include DataMapper::Resource
  def self.default_repository_name; :expr_geo; end
  storage_names[:expr_geo] = "gsm_list"
  property :gsm, Integer, :key => true

  has n, :gse_gsms, "GSEGSM", :child_key => [:gsm], :parent_key => [:gsm]
  has n, :gse_objects, "GSE", :through => :gse_gsm

end

logname = ENV["LOGNAME"]
database_base_uri = "mysql://#{logname}:#{logname}@bmir-db1.sunet/%s"
DataMapper.setup(:expr_geo, sprintf(database_base_uri, "expr_geo"))
#repository(:expr_geo).adapter.resource_naming_convention =
#DataMapper::NamingConventions::Resource::UnderscoredAndPluralizedWithoutModule
DataMapper.finalize

=begin
>> GSEGSM.first
DataObjects::SQLError: Unknown column 'gse_gse' in 'field list' (code: 1054, sql state: 42S22, query: SELECT `gse`, `gsm`, `gse_gse`, `gsm_gsm` FROM `gse_gsm` ORDER BY `gse`, `gsm` LIMIT 1, uri: mysql://rpt:rpt@bmir-db1.sunet/expr_geo)
	from /Library/Ruby/Gems/1.8/gems/dm-do-adapter-1.0.0/lib/dm-do-adapter/adapter.rb:142:in `execute_reader'
	from /Library/Ruby/Gems/1.8/gems/dm-do-adapter-1.0.0/lib/dm-do-adapter/adapter.rb:142:in `read'
	from /Library/Ruby/Gems/1.8/gems/dm-do-adapter-1.0.0/lib/dm-do-adapter/adapter.rb:260:in `with_connection'
	from /Library/Ruby/Gems/1.8/gems/dm-do-adapter-1.0.0/lib/dm-do-adapter/adapter.rb:138:in `read'
	from /Library/Ruby/Gems/1.8/gems/dm-core-1.0.0/lib/dm-core/repository.rb:162:in `read'
	from /Library/Ruby/Gems/1.8/gems/dm-core-1.0.0/lib/dm-core/model.rb:385:in `first'
	from (irb):3
=end