#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
#refiningEffSkill
#oreProcSkill
corp = cachedApi.auth(keyID=1383071, vCode="m0ecx5e1r8RCMsizNKXyB91HQchkHjJmNJlG8or0xy3VvkpiAJj1J7wXb70lUMm0").corporation(98436502)
corpTransactions = corp.WalletTransactions()
for x in corpTransactions.transactions:
print (x)
corpJournal = corp.WalletJournal()
for x in corpJournal.entries:
print (x)
corpAssets = corp.AssetList().assets
for x in corpAssets:
print (x)
firstGo.createCorpAssetsTable(corpAssets)
firstGo.getValueCorpAssets()
#itemID, locationID, typeID, quantity, flag, singleton
for x in corpAssets:
print (firstGo.getItemName(x["typeID"]), firstGo.nowValueJita(x["typeID"]))
####################
