Class: Bio::SQL

Inherits:
Object show all
Defined in:
lib/bio/io/sql.rb,
lib/bio/db/biosql/sequence.rb

Defined Under Namespace

Classes: Sequence

Class Method Summary collapse

Class Method Details

.delete_entry_accession(accession) ⇒ Object



73
74
75
# File 'lib/bio/io/sql.rb', line 73

def self.delete_entry_accession(accession)
  Bio::SQL::Bioentry.find_by_accession(accession.upcase).destroy!
end

.delete_entry_id(id) ⇒ Object



69
70
71
# File 'lib/bio/io/sql.rb', line 69

def self.delete_entry_id(id)
  Bio::SQL::Bioentry.delete(id)
end

.exists_accession(accession) ⇒ Object



47
48
49
50
# File 'lib/bio/io/sql.rb', line 47

def self.exists_accession(accession)
#      Bio::SQL::Bioentry.find_by_accession(accession.upcase).nil? ? false : true
  !Bio::SQL::Bioentry.find_by_accession(accession.upcase).nil?
end

.exists_database(name) ⇒ Object



52
53
54
55
# File 'lib/bio/io/sql.rb', line 52

def self.exists_database(name)
#      Bio::SQL::Biodatabase.find_by_name(name).nil? ? false : true
  !Bio::SQL::Biodatabase.first(:name=>name).nil?
end

.fetch_accession(accession) ⇒ Object



42
43
44
45
# File 'lib/bio/io/sql.rb', line 42

def self.fetch_accession(accession)
#     Bio::SQL::Bioentry.exists?(:accession => accession) ? Bio::SQL::Sequence.new(:entry=>Bio::SQL::Bioentry.find_by_accession(accession)) : nil
  Bio::SQL::Sequence.new(:entry=>Bio::SQL::Bioentry.find_by_accession(accession.upcase))
end

.fetch_id(id) ⇒ Object



38
39
40
# File 'lib/bio/io/sql.rb', line 38

def self.fetch_id(id)
  Bio::SQL::Bioentry.find(id)
end

.list_databasesObject



63
64
65
66
67
# File 'lib/bio/io/sql.rb', line 63

def self.list_databases
  Bio::SQL::Biodatabase.all.collect do|entry|
    {:id=>entry.biodatabase_id, :name => entry.name}
  end
end

.list_entriesObject



57
58
59
60
61
# File 'lib/bio/io/sql.rb', line 57

def self.list_entries
  Bio::SQL::Bioentry.all.collect do|entry|
    {:id=>entry.bioentry_id, :accession=>entry.accession}
  end
end