[rails][bio] ensembl via ActiveRecord

http://hoged.tdiary.net/20060325.html#p02

とてもよいアイデア。バックアップがてら、コードの断片をミラーしておく

require 'active_record'
class Exons < ActiveRecord::Base
  set_table_name "hsapiens_gene_vega_structure__structure__main"
  set_primary_key "exon_id"
  set_inheritance_column do # Exon#type -> Exon#type_
    original_inheritance_column + "_"
  end
end

ActiveRecord::Base.pluralize_table_names = false
ActiveRecord::Base.establish_connection(:adopter => 'mysql', :database => 'vega_mart_37')

# WHERE biotype = 'protein_coding' GROUP BY gene_id_key な検索
protein_codings = Exons.find(:all, :conditions => ['biotype = ?', 'protein_coding'], :group => 'gene_id_key')