rtirrell

require "dm-core"
require "dm-timestamps"

# Note, a GSE etc could have two of the same field (i.e. Pubmed so check for that
# and make an array instead)

# child_key: set of fields identifying child model
# parent_key: set of fields identifying parent model

# GDS

rtirrell

require "dm-core"
require "dm-timestamps"

# Note, a GSE etc could have two of the same field (i.e. Pubmed so check for that
# and make an array instead)

# child_key: set of fields identifying child model
# parent_key: set of fields identifying parent model

# GDS

rtirrell

GSE.first.gsm_objects
 ~ (0.001788) SET sql_auto_is_null = 0
 ~ (0.001518) SET SESSION sql_mode = 'ANSI,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,TRADITIONAL'
 ~ (0.002525) SELECT `gse` FROM `gse_list` ORDER BY `gse` LIMIT 1
 ~ Unknown column 'gse_gsm.gse_gse' in 'where clause' (code: 1054, sql state: 42S22, query: SELECT `gsm_list`.`gsm` FROM `gsm_list` INNER JOIN `gse_gsm` ON `gsm_list`.`gsm` = `gse_gsm`.`gsm` INNER JOIN `gse_list` ON `gse_gsm`.`gse_gse` = `gse_list`.`gse` WHERE `gse_gsm`.`gse_gse` = 1 GROUP BY `gsm_list`.`gsm` ORDER BY `gsm_list`.`gsm`, uri: mysql://rpt:rpt@bmir-db1.sunet/expr_geo)
DataObjects::SQLError: Unknown column 'gse_gsm.gse_gse' in 'where clause' (code: 1054, sql state: 42S22, query: SELECT `gsm_list`.`gsm` FROM `gsm_list` INNER JOIN `gse_gsm` ON `gsm_list`.`gsm` = `gse_gsm`.`gsm` INNER JOIN `gse_list` ON `gse_gsm`.`gse_gse` = `gse_list`.`gse` WHERE `gse_gsm`.`gse_gse` = 1 GROUP BY `gsm_list`.`gsm` ORDER BY `gsm_list`.`gsm`, uri: mysql://r

rtirrell

DataObjects::SQLError: Unknown column 'gse_gsm.gse_gse' in 'where clause' (code: 1054, sql state: 42S22, query: SELECT `gsm_list`.`gsm` FROM `gsm_list` INNER JOIN `gse_gsm` ON `gsm_list`.`gsm` = `gse_gsm`.`gsm` INNER JOIN `gse_list` ON `gse_gsm`.`gse_gse` = `gse_list`.`gse` WHERE `gse_gsm`.`gse_gse` = 1 GROUP BY `gsm_list`.`gsm` ORDER BY `gsm_list`.`gsm`, uri: mysql://rpt:rpt@bmir-db1.sunet/expr_geo)

rtirrell

  class GSE < GEO
    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 < GEO

rtirrell

  class GEO
    def self.inherited(subclass)
      subclass.class_eval do
        include DataMapper::Resource
        def self.default_repository_name; :expr_geo; end
      end
    end
  end

rtirrell

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

rtirrell

require "rubygems"
require "dm-core"

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]

rtirrell

require "rubygems"
require "dm-core"

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]

rtirrell

#class GEO
#  def self.inherited(subclass)
#    subclass.class_eval do
#      include DataMapper::Resource
#      def self.default_repository_name; :expr_geo; end
#    end
#  end
#end
#