def itemPrices():
total = 0
curr.execute('SELECT typeid, locationid FROM corpassets;')
for x in curr.fetchall():
theyBuy = firstGo.nowValue(getSystemIDFromStation(x[1]), x[0])[0]
theySell = firstGo.nowValue(getSystemIDFromStation(x[1]), x[0])[1]
print (firstGo.getSystemName(getSystemIDFromStation(x[1])), firstGo.getItemName(x[0]), theyBuy, theySell)
conn = sqlite3.connect("/home/adam/Documents/eve/native/eve.db")
curr = conn.cursor()
#nowValueJita(34)
x = firstGo.quickValueJita(34)
for y in x.evec_api.quicklook.sell_orders.order:
print y.price.cdata, y.vol_remain.cdata
print ("### SQL MESS AROUND ###")
print firstGo.getItemId("Tritanium")
print firstGo.getItemName(34)
print firstGo.getRegionID("Catch")
print firstGo.getRegionName(10000014)
print firstGo.getSystemID('Jita')
print firstGo. getSystemName(30000142)
curr.close()
conn.close()
print ("### END OF SQL MESS AROUND ###")
#[{"buy":{"forQuery":{"bid":true,"types":[34],"regions":[],"systems":[30000142],"hours":24,"minq":10001},"volume":12247190000,"wavg":5.906915872130669,"avg":5.776666666666666,"variance":0.4084984126984128,"stdDev":0.6391388055019135,"median":6.01,"fivePercent":6.2056,"max":6.22,"min":3.19,"highToLow":true,"generated":1451850198106},"all":{"forQuery":{"bid":null,"types":[34],"regions":[],"systems":[30000142],"hours":24,"minq":10001},"volume":23125540019,"wavg":6.186607831493425,"avg":6.311372549019604,"variance":0.7708379853902345,"stdDev":0.877973795389267,"median":6.18,"fivePercent":4.484691780821918,"max":12.0,"min":1.19,"highToLow":false,"generated":1451850198036},"sell":{"forQuery":{"bid":false,"types":[34],"regions":[],"systems":[30000142],"hours":24,"minq":10001},"volume":10778350019,"wavg":6.550773157727789,"avg":6.5620909090909105,"variance":0.5057274462809929,"stdDev":0.7111451654064681,"median":6.505,"fivePercent":6.339434900641621,"max":12.0,"min":6.31,"highToLow":false,"generated":1451850198050}}]
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"]))
####################