Esempio n. 1
0
 def test_1_anathema(self):
     #    Anathema -> itemID -> bpID -> mats
     sdequeries = SDEQueries()
     idee = sdequeries.getItemID("Anathema")
     bp = sdequeries.getBpFromID(idee)
     mats = sdequeries.matsForBp(bp)
     self.assertEqual(idee, 11188, "item id isn't right")
     self.assertEqual(bp, 11189, "item bp id isn't right")
Esempio n. 2
0
from eveSQL.SDEQueries import SDEQueries
#from docutils.parsers.rst.directives import parts



#Test PSQL connectivity
conn = sqlite3.connect("/home/adam/Documents/eve/native/eve.db")
curr = conn.cursor()

queries = SDEQueries()

ALL_CHARS = firstGo.getAllCharacters()



mats =  (queries.matsForBp(queries.findBpNameFromName("Armor EM Hardener I")))
amount = 0 
for key, value in mats.iteritems():
   print (key, value)
   amount = amount + (firstGo.nowValueJita(key) * value)
print (amount)
    
#compare build price againsr recylce price
def reprocOre():
    pass
'''Reprocessing yield: Station Equipment 
x (1 + Refining skill x 0.03) 
x (1 + Refining Efficiency skill x 0.02) 
x (1 + Ore Processing skill x 0.02) )'''
#stationEquipment
#refiningSkill
Esempio n. 3
0
class test_matsForBp(unittest.TestCase):
    def setUp(self):
        
        self.queries = SDEQueries()
        
    def tearDown(self):
        pass

    def test_FOO(self):
        self.assertEqual('foo'.upper(), 'FOO')
        
    def test_returns_list(self):
        self.assertIsInstance(self.queries.matsForBp(11189), dict)
    
    def test_not_return_None(self):
        with self.assertRaises(AssertionError):
            self.queries.matsForBp("Lynda Tahri")
    
    def test_rejects_numbers(self):
        with self.assertRaises(AssertionError):
            self.queries.matsForBp(12)
            self.queries.matsForBp(-12)
            self.queries.matsForBp(12.0)
            self.queries.matsForBp(-12.0)