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")
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
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)