Module: EveStatic::Queries::Basic

Included in:
Database
Defined in:
lib/eve_static/queries/basic.rb

Instance Method Summary collapse

Instance Method Details

#categoryID(categoryName) ⇒ Object 



38
39
40
 
# File 'lib/eve_static/queries/basic.rb', line 38

def categoryID(categoryName)
  instance[:invCategories].where(:categoryName => categoryName).select(Sequel.lit('categoryID')).first[:categoryID]
end

#categoryName(categoryID) ⇒ Object 



34
35
36
 
# File 'lib/eve_static/queries/basic.rb', line 34

def categoryName(categoryID)
  instance[:invCategories].where(:categoryID => categoryID).select(Sequel.lit('categoryName')).first[:categoryName]
end

#groupID(groupName) ⇒ Object 



24
25
26
 
# File 'lib/eve_static/queries/basic.rb', line 24

def groupID(groupName)
  instance[:invGroups].where(:groupName => groupName).select(Sequel.lit('groupID')).first[:groupID]
end

#groupName(groupID) ⇒ Object 



20
21
22
 
# File 'lib/eve_static/queries/basic.rb', line 20

def groupName(groupID)
  instance[:invGroups].where(:groupID => groupID).select(Sequel.lit('groupName')).first[:groupName]
end

#typeCategory(type) ⇒ Object 



42
43
44
45
46
 
# File 'lib/eve_static/queries/basic.rb', line 42

def typeCategory(type)
  typeID = coerce_type_id(type)
  
  instance[:invTypes].inner_join(:invGroups, :groupID => :groupID).inner_join(:invCategories, :categoryID => :categoryID).where(:typeID => typeID).select_all(:invCategories).first
end

#typeGroup(type) ⇒ Object 



28
29
30
31
32
 
# File 'lib/eve_static/queries/basic.rb', line 28

def typeGroup(type)
  typeID = coerce_type_id(type)
  
  instance[:invTypes].inner_join(:invGroups, :groupID => :groupID).where(:typeID => typeID).select_all(:invGroups).first
end

#typeID(typeName) ⇒ Object 



4
5
6
7
8
9
10
 
# File 'lib/eve_static/queries/basic.rb', line 4

def typeID(typeName)
  if !typeName.is_a?(String)
    raise "please supply typeName as a String"
  end
  
  instance[:invTypes].where(:typeName => typeName).select(Sequel.lit('typeID')).first[:typeID]
end

#typeName(typeID) ⇒ Object 



12
13
14
15
16
17
18
 
# File 'lib/eve_static/queries/basic.rb', line 12

def typeName(typeID)
  if !typeID.is_a?(Integer)
    raise "please supply typeID as an Integer"
  end
  
  instance[:invTypes].where(:typeID => typeID).select(Sequel.lit('typeName')).first[:typeName]
end