def server_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (
config.serverConn.svrName, str(error),
config.serverTime)
onError(status)
print(status)
def api_fail(self, result):
XMLData = parseString(result)
error = XMLData.getElementsByTagName('error')
errorInfo = {'number': error[0].getAttribute('code'), 'text': error[0].firstChild.nodeValue}
status = '%s Returned Error:\n%s\n%s' % (config.serverConn.svrName, errorInfo['number'], errorInfo['text'])
onError(status)
def typeNames_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (config.serverConn.svrName, str(error), config.serverTime)
ids = idList[x].split(',')
numItems = range(len(ids))
for y in numItems:
locationNames.update({int(ids[y]): str(ids[y])})
onError(status)
print(status)
def typeNames_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (
config.serverConn.svrName, str(error), config.serverTime)
ids = idList[x].split(',')
numItems = range(len(ids))
for y in numItems:
locationNames.update({int(ids[y]): str(ids[y])})
onError(status)
print(status)
def api_fail(self, result):
XMLData = parseString(result)
error = XMLData.getElementsByTagName('error')
errorInfo = {
'number': error[0].getAttribute('code'),
'text': error[0].firstChild.nodeValue
}
status = '%s Returned Error:\n%s\n%s' % (
config.serverConn.svrName, errorInfo['number'], errorInfo['text'])
onError(status)
def checkClockDrift(serCurrentTime):
# As the serverTime in config may have been adjusted to compensate for the previous offset calc
# we will get the current time reported from the device in UTC to recalculate.
localUtcTime = datetime.datetime.utcnow().replace(microsecond=0)
if serCurrentTime > localUtcTime:
# Device clock is behind so we will add the difference.
config.clockDrift = serCurrentTime - localUtcTime
config.offset = '+'
else:
# Device clock in ahead so we will deduct the difference.
config.clockDrift = localUtcTime - serCurrentTime
config.offset = '-'
# Debug output if greater than 0 difference.
if config.clockDrift > datetime.timedelta(0):
print('Clock Drift:\nServer Reports: %s\nDevice Reports: %s' % (str(serCurrentTime), str(localUtcTime)))
# Warn the user if the clock drift is significant. (Set to 5 minutes)
if config.clockDrift > datetime.timedelta(minutes=5):
driftWarn = 'Warning Device Clock Drift:\nServer Reports: %s\nDevice Reports: %s' % (str(serCurrentTime), str(localUtcTime))
onError(driftWarn)
def checkClockDrift(serCurrentTime):
# As the serverTime in config may have been adjusted to compensate for the previous offset calc
# we will get the current time reported from the device in UTC to recalculate.
localUtcTime = datetime.datetime.utcnow().replace(microsecond=0)
if serCurrentTime > localUtcTime:
# Device clock is behind so we will add the difference.
config.clockDrift = serCurrentTime - localUtcTime
config.offset = '+'
else:
# Device clock in ahead so we will deduct the difference.
config.clockDrift = localUtcTime - serCurrentTime
config.offset = '-'
# Debug output if greater than 0 difference.
if config.clockDrift > datetime.timedelta(0):
print('Clock Drift:\nServer Reports: %s\nDevice Reports: %s' %
(str(serCurrentTime), str(localUtcTime)))
# Warn the user if the clock drift is significant. (Set to 5 minutes)
if config.clockDrift > datetime.timedelta(minutes=5):
driftWarn = 'Warning Device Clock Drift:\nServer Reports: %s\nDevice Reports: %s' % (
str(serCurrentTime), str(localUtcTime))
onError(driftWarn)
def id2name(idType, ids):
typeNames = {}
if idType == 'item':
# We'll use the local static DB for items as they don't change.
if ids != []: # We have some ids we don't know.
try:
idList = ("', '".join(map(str, ids[:])))
con = lite.connect(config.staticDB)
with con:
cur = con.cursor()
statement = "SELECT typeID, typeName FROM invtypes WHERE typeID IN ('" + idList + "')"
cur.execute(statement)
rows = cur.fetchall()
# Use the item strings returned to populate the typeNames dictionary.
for row in rows:
typeNames.update({int(row[0]): str(row[1])})
ids.remove(row[0])
if ids != []: # We have some ids we don't know.
numItems = range(len(ids))
for y in numItems:
typeNames.update({int(ids[y]): str(ids[y])})
error = ('ids not found in database: ' + str(ids)) # Error String
onError(error)
except lite.Error as err:
error = ('SQL Lite Error: ' + str(err.args[0]) + str(err.args[1:])) # Error String
ids = idList.split("', '")
numItems = range(len(ids))
for y in numItems:
typeNames.update({int(ids[y]): str(ids[y])})
onError(error)
finally:
if con:
con.close()
elif idType == 'character': # TODO: Check if Depreciated.
# We'll have to talk to the API server for Pilot names as this can't be in the static dump.
# cacheFile = config.characterCache
cacheFile = '../character.cache'
# TODO: Change to JSON if not depreciated. (See above TODO)
if (os.path.isfile('cacheFile')):
typeFile = open(cacheFile, 'r')
typeNames = pickle.load(typeFile)
typeFile.close()
numItems = list(range(len(ids)))
# print(ids) # Console debug
for x in numItems:
if ids[x] in typeNames:
ids[x] = 'deleted'
for y in ids[:]:
if y == 'deleted':
ids.remove(y)
# print(ids) # Console debug
if ids != []: # We still have some ids we don't know
baseUrl = config.serverConn.svrAddress + 'eve/CharacterName.xml.aspx?ids=%s'
key = 'characterID'
value = 'name'
# Calculate the number of ids we have left. Server has hard maximum of 250 IDs per query.
# So we'll need to split this into multiple queries.
numIDs = len(ids)
idList = []
if numIDs > 250:
startID = 0
endID = 250
while startID < numIDs:
idList.append(','.join(map(str, ids[startID:endID])))
startID = startID + 250
if ((numIDs - endID)) > 250:
endID = endID + 250
else:
endID = numIDs
else:
idList.append(','.join(map(str, ids[0:numIDs])))
numIdLists = list(range(len(idList)))
for x in numIdLists: # Iterate over all of the id lists generated above.
# Download the CharacterName Data from API server
apiURL = baseUrl % (idList[x])
# print(apiURL) # Console debug
def characterNames_process(self, result):
XMLData = parseString(result)
dataNodes = XMLData.getElementsByTagName('row')
for row in dataNodes:
typeNames.update({int(row.getAttribute(key)): str(row.getAttribute(value))})
# config.characterCache.put(int(row.getAttribute(key)), name=str(row.getAttribute(value)))
# Save the data we have so we don't have to fetch it
typeFile = open(cacheFile, 'w')
pickle.dump(typeNames, typeFile)
typeFile.close()
def characterNames_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (config.serverConn.svrName, str(error), config.serverTime)
ids = idList[x].split(',')
numItems = range(len(ids))
for y in numItems:
typeNames.update({int(ids[y]): str(ids[y])})
onError(status)
print(status)
req = UrlRequest(apiURL, on_success=characterNames_process, on_error=characterNames_error, req_headers=config.headers)
req.wait()
return typeNames
def skill_error(self, error):
status = 'This key may not have access to pilot skills.\nError Using %s:\n%s\nAt: %s' % (config.serverConn.svrName, str(error), config.serverTime)
onError(status)
def getStarbases(target):
"""Event handler to fetch starbase data from server"""
timingMsg = 'Using Local Cache'
# Inform the user what we are doing.
target.state = ('Connecting to ' + config.serverConn.svrName)
if config.serverConn.svrStatus == 'Online': # Status has returned a value other than online, so why continue?
if config.serverTime >= config.starbaseCachedUntil:
# Start the clock.
t = time.clock()
tempStarbaseRows = []
if config.pilotRows != []: # Make sure we have keys in the config
# keyID, vCode, characterID, characterName, corporationID, corporationName, keyType, keyExpires, skills, isActive
numPilotRows = list(range(len(config.pilotRows)))
for x in numPilotRows: # Iterate over all of the keys and character ids in config
# Download the Account Starbase Data
keyOK = 1 # Set key check to OK test below changes if expired
if config.pilotRows[x].keyExpires != 'Never':
if config.pilotRows[x].keyExpires < config.serverTime:
keyOK = 0
error = ('KeyID ' + config.pilotRows[x].keyID +
' has Expired')
onError(error)
if keyOK == 1 and config.pilotRows[
x].keyType == 'Corporation':
baseUrl = 'https://api.eveonline.com/corp/StarbaseList.xml.aspx?keyID=%s&vCode=%s'
apiURL = baseUrl % (config.pilotRows[x].keyID,
config.pilotRows[x].vCode)
# print(apiURL) # Console debug
def starbases_process(self, result):
XMLData = parseString(result)
starbaseNodes = XMLData.getElementsByTagName("row")
cacheuntil = XMLData.getElementsByTagName(
'cachedUntil')
cacheExpire = datetime.datetime(*(time.strptime((
cacheuntil[0].firstChild.nodeValue
), "%Y-%m-%d %H:%M:%S")[0:6]))
config.starbaseCachedUntil = cacheExpire
for row in starbaseNodes:
itemIDs = []
locationIDs = []
if int(row.getAttribute(
'typeID')) not in itemIDs:
itemIDs.append(
int(row.getAttribute('typeID')))
baseUrl = 'https://api.eveonline.com/corp/StarbaseDetail.xml.aspx?keyID=%s&vCode=%s&itemID=%s'
apiURL = baseUrl % (config.pilotRows[x].keyID,
config.pilotRows[x].vCode,
row.getAttribute('itemID'))
# print(apiURL) # Console debug
def starbase_detail(
self, result
): # Try to connect to the API server
XMLData = parseString(result)
starbaseDetailNodes = XMLData.getElementsByTagName(
"row")
fuel = []
for entry in starbaseDetailNodes:
if int(entry.getAttribute(
'typeID')) not in itemIDs:
itemIDs.append(
int(
entry.getAttribute(
'typeID')))
fuel.append(
int(entry.getAttribute('typeID')))
fuel.append(
int(entry.getAttribute(
'quantity')))
if int(row.getAttribute(
'locationID')) not in locationIDs:
locationIDs.append(
int(row.getAttribute(
'locationID')))
if int(row.getAttribute(
'moonID')) not in locationIDs:
locationIDs.append(
int(row.getAttribute('moonID')))
itemNames = id2name('item', itemIDs)
locationNames = id2location(
x, locationIDs, config.pilotRows)
tempStarbaseRows.append(
Starbase(
row.getAttribute('itemID'),
int(row.getAttribute('typeID')),
itemNames[int(
row.getAttribute('typeID'))],
locationNames[int(
row.getAttribute(
'locationID'))],
locationNames[int(
row.getAttribute('moonID'))],
int(row.getAttribute('state')),
row.getAttribute('stateTimestamp'),
row.getAttribute(
'onlineTimestamp'), fuel,
row.getAttribute(
'standingOwnerID')))
# itemID,typeID,locationID,moonID,state,stateTimestamp,onlineTimestamp,standingOwnerID
def server_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (
config.serverConn.svrName, str(error),
config.serverTime)
onError(status)
print(status)
target.state = ('Connecting to ' +
config.serverConn.svrName)
UrlRequest(apiURL,
on_success=starbase_detail,
on_error=server_error,
req_headers=config.headers)
target.state = ('Connecting to ' +
config.serverConn.svrName)
UrlRequest(apiURL,
on_success=starbases_process,
on_error=server_error,
req_headers=config.headers)
if tempStarbaseRows != []:
config.starbaseRows = tempStarbaseRows[:]
# self.starbaseList.SetObjects(starbaseRows)
timingMsg = 'Updated in: %0.2f ms' % ((
(time.clock() - t) * 1000))
target.state = str(timingMsg)
print(timingMsg + '(Fetch Starbases)')
else:
onError('Please open Config to enter a valid API key')
else:
# Don't Contact server as cache timer hasn't expired
# Fuel is used hourly so it shouldn't change within the cache expiry time.
print('Not Contacting Server, Cache Not Expired')
target.state = timingMsg
else:
# Server status is 'Offline' so skip everything send 'Using local cache' to status bar.
target.state = timingMsg
return ()
def id2location(pilotRowID, ids, pilotRows):
locationNames = {0: 'Unanchored'}
locationIDs = []
privateLocationIDs = []
conquerableIDs = []
numItems = list(range(len(ids)))
# print(ids) # Console debug
for x in numItems:
if is32(ids[x]) is False:
# 32 bit value: Only known to Pilot or Corp via API
privateLocationIDs.append(ids[x])
elif 66000000 < ids[x] < 66014933:
# Office in Station needs conversion
officeID = ids[x] - 6000001
if officeID not in locationIDs:
locationIDs.append(officeID)
elif 66014934 < ids[x] < 67999999:
# Office in Conquerable Station needs conversion
officeID = ids[x] - 6000000
if officeID not in locationIDs:
locationIDs.append(officeID)
elif 60014861 < ids[x] < 60014928:
# Conquerable Station
if ids[x] not in conquerableIDs:
conquerableIDs.append(ids[x])
elif 60000000 < ids[x] < 61000000:
# Station
if ids[x] not in locationIDs:
locationIDs.append(ids[x])
elif 61000000 <= ids[x] < 66000000:
# Conquerable Outpost
if ids[x] not in conquerableIDs:
conquerableIDs.append(ids[x])
elif ids[x] < 60000000: # locationID < 60000000 then the asset is somewhere in space
if ids[x] not in locationIDs:
locationIDs.append(ids[x])
else: # I am currently unsure how to translate this value, most likely an unexpected value.
if ids[x] not in locationIDs:
locationNames.update({int(ids[x]): str(ids[x])})
if locationIDs != []: # We still have some ids we don't know
try:
idList = ("', '".join(map(str, locationIDs[:])))
con = lite.connect(config.staticDB)
with con:
cur = con.cursor()
statement = "SELECT itemID, itemName FROM invnames WHERE itemID IN ('" + idList + "')"
cur.execute(statement)
rows = cur.fetchall()
# print((len(rows))) # Console debug
for row in rows:
# print(row) # Console debug
locationNames.update({int(row[0]): str(row[1])})
except lite.Error as err:
error = ('SQL Lite Error: ' + str(err.args[0]) + str(err.args[1:])) # Error String
ids = idList.split("', '")
numItems = range(len(ids))
for y in numItems:
locationNames.update({int(ids[y]): str(ids[y])})
onError(error)
finally:
if con:
con.close()
if privateLocationIDs != []: # We have some Pilot or Corp locations we don't know
if pilotRows[pilotRowID].keyType == 'Corporation':
baseUrl = config.serverConn.svrAddress + 'corp/locations.xml.aspx?keyID=%s&vCode=%s&characterID=%s&IDs=%s'
else: # Should be an account key
baseUrl = config.serverConn.svrAddress + 'char/locations.xml.aspx?keyID=%s&vCode=%s&characterID=%s&IDs=%s'
# Calculate the number of ids we have left. Server has hard maximum of 250 IDs per query.
# So we'll need to split this into multiple queries.
numIDs = len(privateLocationIDs)
idList = []
if numIDs > 250:
startID = 0
endID = 250
while startID < numIDs:
idList.append(','.join(map(str, privateLocationIDs[startID:endID])))
startID = startID + 250
if ((numIDs - endID)) > 250:
endID = endID + 250
else:
endID = numIDs
else:
idList.append(','.join(map(str, privateLocationIDs[0:numIDs])))
numIdLists = list(range(len(idList)))
for x in numIdLists: # Iterate over all of the id lists generated above.
# Download the TypeName Data from API server
apiURL = baseUrl % (pilotRows[pilotRowID].keyID, pilotRows[pilotRowID].vCode, pilotRows[pilotRowID].characterID, idList[x])
# print(apiURL) # Console debug
def typeNames_process(self, result):
XMLData = parseString(result)
dataNodes = XMLData.getElementsByTagName('row')
for row in dataNodes:
locationNames.update({int(row.getAttribute('itemID')): str(row.getAttribute('itemName'))})
def typeNames_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (config.serverConn.svrName, str(error), config.serverTime)
ids = idList[x].split(',')
numItems = range(len(ids))
for y in numItems:
locationNames.update({int(ids[y]): str(ids[y])})
onError(status)
print(status)
req = UrlRequest(apiURL, on_success=typeNames_process, on_error=typeNames_error, req_headers=config.headers)
req.wait()
if conquerableIDs != []: # We have some conquerableIDs we don't know
idList = []
apiURL = config.serverConn.svrAddress + 'eve/ConquerableStationList.xml.aspx'
def typeNames_process(self, result):
XMLData = parseString(result)
dataNodes = XMLData.getElementsByTagName('row')
for row in dataNodes:
if int(row.getAttribute('stationID')) in idList:
locationNames.update({int(row.getAttribute('stationID')): str(row.getAttribute('stationName'))})
def typeNames_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (config.serverConn.svrName, str(error), config.serverTime)
ids = idList[x].split(',')
numItems = range(len(ids))
for y in numItems:
locationNames.update({int(ids[y]): str(ids[y])})
onError(status)
print(status)
req = UrlRequest(apiURL, on_success=typeNames_process, on_error=typeNames_error, req_headers=config.headers)
req.wait()
return locationNames
def getJobs(target):
"""Event handler to fetch job data from server"""
timingMsg = 'Using Local Cache'
# Inform the user what we are doing.
target.state = ('Connecting to ' + config.serverConn.svrName)
if config.serverConn.svrStatus == 'Online': # Status has returned a value other than online, so why continue?
if config.serverTime >= config.jobsCachedUntil:
# Start the clock.
t = time.clock()
tempJobRows = []
if config.pilotRows != []: # Make sure we have keys in the config
# keyID, vCode, characterID, characterName, corporationID, corporationName, keyType, keyExpires, skills, isActive
numPilotRows = list(range(len(config.pilotRows)))
for x in numPilotRows: # Iterate over all of the keys and character ids in config
# Download the Account Industry Data
keyOK = 1 # Set key check to OK test below changes if expired
if config.pilotRows[x].keyExpires != 'Never':
if config.pilotRows[x].keyExpires < config.serverTime:
keyOK = 0
error = ('KeyID ' + config.pilotRows[x].keyID + ' has Expired')
onError(error)
if keyOK == 1:
if config.pilotRows[x].keyType == 'Corporation':
# baseUrl = 'corp/IndustryJobs.xml.aspx?keyID=%s&vCode=%s&characterID=%s'
apiURL = config.serverConn.svrAddress + config.corpIndustry % (config.pilotRows[x].keyID, config.pilotRows[x].vCode, config.pilotRows[x].characterID)
else: # Should be an account key
# baseUrl = 'char/IndustryJobs.xml.aspx?keyID=%s&vCode=%s&characterID=%s'
apiURL = config.serverConn.svrAddress + config.charIndustry % (config.pilotRows[x].keyID, config.pilotRows[x].vCode, config.pilotRows[x].characterID)
# apiURL = config.serverConn.svrAddress + baseUrl % (config.pilotRows[x].keyID, config.pilotRows[x].vCode, config.pilotRows[x].characterID)
print(apiURL) # Console debug
def jobs_process(self, result):
XMLData = parseString(result)
dataNodes = XMLData.getElementsByTagName("row")
cacheuntil = XMLData.getElementsByTagName('cachedUntil')
cacheExpire = datetime.datetime(*(time.strptime((cacheuntil[0].firstChild.nodeValue), "%Y-%m-%d %H:%M:%S")[0:6]))
config.jobsCachedUntil = cacheExpire
# itemIDs = [] # obsolete
# installerIDs = [] # obsolete
locationIDs = []
for row in dataNodes:
if row.getAttribute('status') != '101': # Ignore Delivered Jobs
# if int(row.getAttribute('installedItemTypeID')) not in itemIDs:
# itemIDs.append(int(row.getAttribute('installedItemTypeID')))
# if int(row.getAttribute('outputTypeID')) not in itemIDs:
# itemIDs.append(int(row.getAttribute('outputTypeID')))
# if int(row.getAttribute('installerID')) not in installerIDs:
# installerIDs.append(int(row.getAttribute('installerID')))
if int(row.getAttribute('outputLocationID')) not in locationIDs:
locationIDs.append(int(row.getAttribute('outputLocationID')))
# if int(row.getAttribute('installedInSolarSystemID')) not in locationIDs:
# locationIDs.append(int(row.getAttribute('installedInSolarSystemID')))
# itemNames = id2name('item', itemIDs) # Depreciated
# pilotNames = id2name('character', installerIDs) # Depreciated
# locationNames = id2location(x, locationIDs, config.pilotRows)
for row in dataNodes:
if row.getAttribute('status') != '101': # Ignore Delivered Jobs
tempJobRows.append(Job(row.getAttribute('jobID'),
row.getAttribute('status'),
int(row.getAttribute('activityID')), # Leave as int for clauses
# itemNames[int(row.getAttribute('installedItemTypeID'))],
row.getAttribute('blueprintTypeName'),
# int(row.getAttribute('installedItemProductivityLevel')),
# int(row.getAttribute('installedItemMaterialLevel')),
# locationNames[int(row.getAttribute('outputLocationID'))],
int(row.getAttribute('outputLocationID')),
# locationNames[int(row.getAttribute('installedInSolarSystemID'))],
row.getAttribute('solarSystemName'),
# pilotNames[int(row.getAttribute('installerID'))],
row.getAttribute('installerName'),
int(row.getAttribute('runs')),
# row.getAttribute('outputTypeID'),
row.getAttribute('productTypeName'),
# row.getAttribute('installTime'),
row.getAttribute('startDate'),
# row.getAttribute('endProductionTime'),
row.getAttribute('endDate')))
# Add job data to local cache.
config.jobCache.put(row.getAttribute('jobID'), jobID=row.getAttribute('jobID'),
status=row.getAttribute('status'),
activityID=int(row.getAttribute('activityID')), # Leave as int for clauses
blueprintTypeName=row.getAttribute('blueprintTypeName'),
outputLocationID=int(row.getAttribute('outputLocationID')),
solarSystemName=row.getAttribute('solarSystemName'),
installerName=row.getAttribute('installerName'),
runs=int(row.getAttribute('runs')),
productTypeName=row.getAttribute('productTypeName'),
startDate=row.getAttribute('startDate'),
endDate=row.getAttribute('endDate'))
config.statusCache.put('jobs', cacheExpires=cacheuntil[0].firstChild.nodeValue)
# Old API:
# columns="assemblyLineID,containerID,installedItemLocationID,installedItemQuantity,
# installedItemLicensedProductionRunsRemaining,outputLocationID,licensedProductionRuns,
# installedInSolarSystemID,containerLocationID,materialMultiplier,charMaterialMultiplier,
# timeMultiplier,charTimeMultiplier,containerTypeID,installedItemCopy,completed,
# completedSuccessfully,installedItemFlag,outputFlag,completedStatus,beginProductionTime,
# pauseProductionTime"
# New API Output
# columns="jobID,installerID,installerName,facilityID,solarSystemID,solarSystemName,
# stationID,activityID,blueprintID,blueprintTypeID,blueprintTypeName,blueprintLocationID,
# outputLocationID,runs,cost,teamID,licensedRuns,probability,productTypeID,productTypeName,
# status,timeInSeconds,startDate,endDate,pauseDate,completedDate,completedCharacterID,successfulRuns"
print(tempJobRows)
def server_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (config.serverConn.svrName, str(error), config.serverTime)
onError(status)
print(status)
target.state = ('Connecting to ' + config.serverConn.svrName)
UrlRequest(apiURL, on_success=jobs_process, on_error=server_error, req_headers=config.headers)
if tempJobRows != []:
config.jobRows = tempJobRows[:]
# self.jobList.SetObjects(config.jobRows)
timingMsg = '%0.2f ms' % (((time.clock() - t) * 1000))
target.state = str(timingMsg)
print(timingMsg + '(Fetch Jobs)')
else:
onError('Please open Config to enter a valid API key')
else:
# Don't Contact server as cache timer hasn't expired
# Iterate over the jobs and change their status if they should be ready.
numItems = list(range(len(config.jobRows)))
for r in numItems:
if config.jobRows[r].endProductionTime > config.serverTime:
config.jobRows[r].timeRemaining = config.jobRows[r].endProductionTime - config.serverTime
config.jobRows[r].state = 'In Progress'
else:
config.jobRows[r].timeRemaining = config.jobRows[r].endProductionTime - config.serverTime
config.jobRows[r].state = 'Ready'
# self.jobList.RefreshObjects(config.jobRows)
print('Not Contacting Server, Cache Not Expired')
target.state = timingMsg
else:
# Server status is 'Offline' so skip everything send 'Using local cache' to status bar.
target.state = timingMsg
return()
def getJobs(target):
"""Event handler to fetch job data from server"""
timingMsg = 'Using Local Cache'
# Inform the user what we are doing.
target.state = ('Connecting to ' + config.serverConn.svrName)
if config.serverConn.svrStatus == 'Online': # Status has returned a value other than online, so why continue?
if config.serverTime >= config.jobsCachedUntil:
# Start the clock.
t = time.clock()
tempJobRows = []
if config.pilotRows != []: # Make sure we have keys in the config
# keyID, vCode, characterID, characterName, corporationID, corporationName, keyType, keyExpires, skills, isActive
numPilotRows = list(range(len(config.pilotRows)))
for x in numPilotRows: # Iterate over all of the keys and character ids in config
# Download the Account Industry Data
keyOK = 1 # Set key check to OK test below changes if expired
if config.pilotRows[x].keyExpires != 'Never':
if config.pilotRows[x].keyExpires < config.serverTime:
keyOK = 0
error = ('KeyID ' + config.pilotRows[x].keyID +
' has Expired')
onError(error)
if keyOK == 1:
if config.pilotRows[x].keyType == 'Corporation':
# baseUrl = 'corp/IndustryJobs.xml.aspx?keyID=%s&vCode=%s&characterID=%s'
apiURL = config.serverConn.svrAddress + config.corpIndustry % (
config.pilotRows[x].keyID, config.pilotRows[x].
vCode, config.pilotRows[x].characterID)
else: # Should be an account key
# baseUrl = 'char/IndustryJobs.xml.aspx?keyID=%s&vCode=%s&characterID=%s'
apiURL = config.serverConn.svrAddress + config.charIndustry % (
config.pilotRows[x].keyID, config.pilotRows[x].
vCode, config.pilotRows[x].characterID)
# apiURL = config.serverConn.svrAddress + baseUrl % (config.pilotRows[x].keyID, config.pilotRows[x].vCode, config.pilotRows[x].characterID)
print(apiURL) # Console debug
def jobs_process(self, result):
XMLData = parseString(result)
dataNodes = XMLData.getElementsByTagName("row")
cacheuntil = XMLData.getElementsByTagName(
'cachedUntil')
cacheExpire = datetime.datetime(*(time.strptime((
cacheuntil[0].firstChild.nodeValue
), "%Y-%m-%d %H:%M:%S")[0:6]))
config.jobsCachedUntil = cacheExpire
# itemIDs = [] # obsolete
# installerIDs = [] # obsolete
locationIDs = []
for row in dataNodes:
if row.getAttribute(
'status'
) != '101': # Ignore Delivered Jobs
# if int(row.getAttribute('installedItemTypeID')) not in itemIDs:
# itemIDs.append(int(row.getAttribute('installedItemTypeID')))
# if int(row.getAttribute('outputTypeID')) not in itemIDs:
# itemIDs.append(int(row.getAttribute('outputTypeID')))
# if int(row.getAttribute('installerID')) not in installerIDs:
# installerIDs.append(int(row.getAttribute('installerID')))
if int(row.getAttribute('outputLocationID')
) not in locationIDs:
locationIDs.append(
int(
row.getAttribute(
'outputLocationID')))
# if int(row.getAttribute('installedInSolarSystemID')) not in locationIDs:
# locationIDs.append(int(row.getAttribute('installedInSolarSystemID')))
# itemNames = id2name('item', itemIDs) # Depreciated
# pilotNames = id2name('character', installerIDs) # Depreciated
# locationNames = id2location(x, locationIDs, config.pilotRows)
for row in dataNodes:
if row.getAttribute(
'status'
) != '101': # Ignore Delivered Jobs
tempJobRows.append(
Job(
row.getAttribute('jobID'),
row.getAttribute('status'),
int(row.getAttribute('activityID')
), # Leave as int for clauses
# itemNames[int(row.getAttribute('installedItemTypeID'))],
row.getAttribute(
'blueprintTypeName'),
# int(row.getAttribute('installedItemProductivityLevel')),
# int(row.getAttribute('installedItemMaterialLevel')),
# locationNames[int(row.getAttribute('outputLocationID'))],
int(
row.getAttribute(
'outputLocationID')),
# locationNames[int(row.getAttribute('installedInSolarSystemID'))],
row.getAttribute('solarSystemName'
),
# pilotNames[int(row.getAttribute('installerID'))],
row.getAttribute('installerName'),
int(row.getAttribute('runs')),
# row.getAttribute('outputTypeID'),
row.getAttribute('productTypeName'
),
# row.getAttribute('installTime'),
row.getAttribute('startDate'),
# row.getAttribute('endProductionTime'),
row.getAttribute('endDate')))
# Add job data to local cache.
config.jobCache.put(
row.getAttribute('jobID'),
jobID=row.getAttribute('jobID'),
status=row.getAttribute('status'),
activityID=int(
row.getAttribute('activityID')
), # Leave as int for clauses
blueprintTypeName=row.getAttribute(
'blueprintTypeName'),
outputLocationID=int(
row.getAttribute(
'outputLocationID')),
solarSystemName=row.getAttribute(
'solarSystemName'),
installerName=row.getAttribute(
'installerName'),
runs=int(row.getAttribute('runs')),
productTypeName=row.getAttribute(
'productTypeName'),
startDate=row.getAttribute(
'startDate'),
endDate=row.getAttribute('endDate'))
config.statusCache.put(
'jobs',
cacheExpires=cacheuntil[0].firstChild.
nodeValue)
# Old API:
# columns="assemblyLineID,containerID,installedItemLocationID,installedItemQuantity,
# installedItemLicensedProductionRunsRemaining,outputLocationID,licensedProductionRuns,
# installedInSolarSystemID,containerLocationID,materialMultiplier,charMaterialMultiplier,
# timeMultiplier,charTimeMultiplier,containerTypeID,installedItemCopy,completed,
# completedSuccessfully,installedItemFlag,outputFlag,completedStatus,beginProductionTime,
# pauseProductionTime"
# New API Output
# columns="jobID,installerID,installerName,facilityID,solarSystemID,solarSystemName,
# stationID,activityID,blueprintID,blueprintTypeID,blueprintTypeName,blueprintLocationID,
# outputLocationID,runs,cost,teamID,licensedRuns,probability,productTypeID,productTypeName,
# status,timeInSeconds,startDate,endDate,pauseDate,completedDate,completedCharacterID,successfulRuns"
print(tempJobRows)
def server_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (
config.serverConn.svrName, str(error),
config.serverTime)
onError(status)
print(status)
target.state = ('Connecting to ' +
config.serverConn.svrName)
UrlRequest(apiURL,
on_success=jobs_process,
on_error=server_error,
req_headers=config.headers)
if tempJobRows != []:
config.jobRows = tempJobRows[:]
# self.jobList.SetObjects(config.jobRows)
timingMsg = '%0.2f ms' % (((time.clock() - t) * 1000))
target.state = str(timingMsg)
print(timingMsg + '(Fetch Jobs)')
else:
onError('Please open Config to enter a valid API key')
else:
# Don't Contact server as cache timer hasn't expired
# Iterate over the jobs and change their status if they should be ready.
numItems = list(range(len(config.jobRows)))
for r in numItems:
if config.jobRows[r].endProductionTime > config.serverTime:
config.jobRows[r].timeRemaining = config.jobRows[
r].endProductionTime - config.serverTime
config.jobRows[r].state = 'In Progress'
else:
config.jobRows[r].timeRemaining = config.jobRows[
r].endProductionTime - config.serverTime
config.jobRows[r].state = 'Ready'
# self.jobList.RefreshObjects(config.jobRows)
print('Not Contacting Server, Cache Not Expired')
target.state = timingMsg
else:
# Server status is 'Offline' so skip everything send 'Using local cache' to status bar.
target.state = timingMsg
return ()
def id2location(pilotRowID, ids, pilotRows):
locationNames = {0: 'Unanchored'}
locationIDs = []
privateLocationIDs = []
conquerableIDs = []
numItems = list(range(len(ids)))
# print(ids) # Console debug
for x in numItems:
if is32(ids[x]) is False:
# 32 bit value: Only known to Pilot or Corp via API
privateLocationIDs.append(ids[x])
elif 66000000 < ids[x] < 66014933:
# Office in Station needs conversion
officeID = ids[x] - 6000001
if officeID not in locationIDs:
locationIDs.append(officeID)
elif 66014934 < ids[x] < 67999999:
# Office in Conquerable Station needs conversion
officeID = ids[x] - 6000000
if officeID not in locationIDs:
locationIDs.append(officeID)
elif 60014861 < ids[x] < 60014928:
# Conquerable Station
if ids[x] not in conquerableIDs:
conquerableIDs.append(ids[x])
elif 60000000 < ids[x] < 61000000:
# Station
if ids[x] not in locationIDs:
locationIDs.append(ids[x])
elif 61000000 <= ids[x] < 66000000:
# Conquerable Outpost
if ids[x] not in conquerableIDs:
conquerableIDs.append(ids[x])
elif ids[x] < 60000000: # locationID < 60000000 then the asset is somewhere in space
if ids[x] not in locationIDs:
locationIDs.append(ids[x])
else: # I am currently unsure how to translate this value, most likely an unexpected value.
if ids[x] not in locationIDs:
locationNames.update({int(ids[x]): str(ids[x])})
if locationIDs != []: # We still have some ids we don't know
try:
idList = ("', '".join(map(str, locationIDs[:])))
con = lite.connect(config.staticDB)
with con:
cur = con.cursor()
statement = "SELECT itemID, itemName FROM invnames WHERE itemID IN ('" + idList + "')"
cur.execute(statement)
rows = cur.fetchall()
# print((len(rows))) # Console debug
for row in rows:
# print(row) # Console debug
locationNames.update({int(row[0]): str(row[1])})
except lite.Error as err:
error = ('SQL Lite Error: ' + str(err.args[0]) + str(err.args[1:])
) # Error String
ids = idList.split("', '")
numItems = range(len(ids))
for y in numItems:
locationNames.update({int(ids[y]): str(ids[y])})
onError(error)
finally:
if con:
con.close()
if privateLocationIDs != []: # We have some Pilot or Corp locations we don't know
if pilotRows[pilotRowID].keyType == 'Corporation':
baseUrl = config.serverConn.svrAddress + 'corp/locations.xml.aspx?keyID=%s&vCode=%s&characterID=%s&IDs=%s'
else: # Should be an account key
baseUrl = config.serverConn.svrAddress + 'char/locations.xml.aspx?keyID=%s&vCode=%s&characterID=%s&IDs=%s'
# Calculate the number of ids we have left. Server has hard maximum of 250 IDs per query.
# So we'll need to split this into multiple queries.
numIDs = len(privateLocationIDs)
idList = []
if numIDs > 250:
startID = 0
endID = 250
while startID < numIDs:
idList.append(','.join(
map(str, privateLocationIDs[startID:endID])))
startID = startID + 250
if ((numIDs - endID)) > 250:
endID = endID + 250
else:
endID = numIDs
else:
idList.append(','.join(map(str, privateLocationIDs[0:numIDs])))
numIdLists = list(range(len(idList)))
for x in numIdLists: # Iterate over all of the id lists generated above.
# Download the TypeName Data from API server
apiURL = baseUrl % (pilotRows[pilotRowID].keyID,
pilotRows[pilotRowID].vCode,
pilotRows[pilotRowID].characterID, idList[x])
# print(apiURL) # Console debug
def typeNames_process(self, result):
XMLData = parseString(result)
dataNodes = XMLData.getElementsByTagName('row')
for row in dataNodes:
locationNames.update({
int(row.getAttribute('itemID')):
str(row.getAttribute('itemName'))
})
def typeNames_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (
config.serverConn.svrName, str(error), config.serverTime)
ids = idList[x].split(',')
numItems = range(len(ids))
for y in numItems:
locationNames.update({int(ids[y]): str(ids[y])})
onError(status)
print(status)
req = UrlRequest(apiURL,
on_success=typeNames_process,
on_error=typeNames_error,
req_headers=config.headers)
req.wait()
if conquerableIDs != []: # We have some conquerableIDs we don't know
idList = []
apiURL = config.serverConn.svrAddress + 'eve/ConquerableStationList.xml.aspx'
def typeNames_process(self, result):
XMLData = parseString(result)
dataNodes = XMLData.getElementsByTagName('row')
for row in dataNodes:
if int(row.getAttribute('stationID')) in idList:
locationNames.update({
int(row.getAttribute('stationID')):
str(row.getAttribute('stationName'))
})
def typeNames_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (
config.serverConn.svrName, str(error), config.serverTime)
ids = idList[x].split(',')
numItems = range(len(ids))
for y in numItems:
locationNames.update({int(ids[y]): str(ids[y])})
onError(status)
print(status)
req = UrlRequest(apiURL,
on_success=typeNames_process,
on_error=typeNames_error,
req_headers=config.headers)
req.wait()
return locationNames
def id2name(idType, ids):
typeNames = {}
if idType == 'item':
# We'll use the local static DB for items as they don't change.
if ids != []: # We have some ids we don't know.
try:
idList = ("', '".join(map(str, ids[:])))
con = lite.connect(config.staticDB)
with con:
cur = con.cursor()
statement = "SELECT typeID, typeName FROM invtypes WHERE typeID IN ('" + idList + "')"
cur.execute(statement)
rows = cur.fetchall()
# Use the item strings returned to populate the typeNames dictionary.
for row in rows:
typeNames.update({int(row[0]): str(row[1])})
ids.remove(row[0])
if ids != []: # We have some ids we don't know.
numItems = range(len(ids))
for y in numItems:
typeNames.update({int(ids[y]): str(ids[y])})
error = ('ids not found in database: ' + str(ids)
) # Error String
onError(error)
except lite.Error as err:
error = ('SQL Lite Error: ' + str(err.args[0]) +
str(err.args[1:])) # Error String
ids = idList.split("', '")
numItems = range(len(ids))
for y in numItems:
typeNames.update({int(ids[y]): str(ids[y])})
onError(error)
finally:
if con:
con.close()
elif idType == 'character': # TODO: Check if Depreciated.
# We'll have to talk to the API server for Pilot names as this can't be in the static dump.
# cacheFile = config.characterCache
cacheFile = '../character.cache'
# TODO: Change to JSON if not depreciated. (See above TODO)
if (os.path.isfile('cacheFile')):
typeFile = open(cacheFile, 'r')
typeNames = pickle.load(typeFile)
typeFile.close()
numItems = list(range(len(ids)))
# print(ids) # Console debug
for x in numItems:
if ids[x] in typeNames:
ids[x] = 'deleted'
for y in ids[:]:
if y == 'deleted':
ids.remove(y)
# print(ids) # Console debug
if ids != []: # We still have some ids we don't know
baseUrl = config.serverConn.svrAddress + 'eve/CharacterName.xml.aspx?ids=%s'
key = 'characterID'
value = 'name'
# Calculate the number of ids we have left. Server has hard maximum of 250 IDs per query.
# So we'll need to split this into multiple queries.
numIDs = len(ids)
idList = []
if numIDs > 250:
startID = 0
endID = 250
while startID < numIDs:
idList.append(','.join(map(str, ids[startID:endID])))
startID = startID + 250
if ((numIDs - endID)) > 250:
endID = endID + 250
else:
endID = numIDs
else:
idList.append(','.join(map(str, ids[0:numIDs])))
numIdLists = list(range(len(idList)))
for x in numIdLists: # Iterate over all of the id lists generated above.
# Download the CharacterName Data from API server
apiURL = baseUrl % (idList[x])
# print(apiURL) # Console debug
def characterNames_process(self, result):
XMLData = parseString(result)
dataNodes = XMLData.getElementsByTagName('row')
for row in dataNodes:
typeNames.update({
int(row.getAttribute(key)):
str(row.getAttribute(value))
})
# config.characterCache.put(int(row.getAttribute(key)), name=str(row.getAttribute(value)))
# Save the data we have so we don't have to fetch it
typeFile = open(cacheFile, 'w')
pickle.dump(typeNames, typeFile)
typeFile.close()
def characterNames_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (
config.serverConn.svrName, str(error),
config.serverTime)
ids = idList[x].split(',')
numItems = range(len(ids))
for y in numItems:
typeNames.update({int(ids[y]): str(ids[y])})
onError(status)
print(status)
req = UrlRequest(apiURL,
on_success=characterNames_process,
on_error=characterNames_error,
req_headers=config.headers)
req.wait()
return typeNames
def getStarbases(target):
"""Event handler to fetch starbase data from server"""
timingMsg = 'Using Local Cache'
# Inform the user what we are doing.
target.state = ('Connecting to ' + config.serverConn.svrName)
if config.serverConn.svrStatus == 'Online': # Status has returned a value other than online, so why continue?
if config.serverTime >= config.starbaseCachedUntil:
# Start the clock.
t = time.clock()
tempStarbaseRows = []
if config.pilotRows != []: # Make sure we have keys in the config
# keyID, vCode, characterID, characterName, corporationID, corporationName, keyType, keyExpires, skills, isActive
numPilotRows = list(range(len(config.pilotRows)))
for x in numPilotRows: # Iterate over all of the keys and character ids in config
# Download the Account Starbase Data
keyOK = 1 # Set key check to OK test below changes if expired
if config.pilotRows[x].keyExpires != 'Never':
if config.pilotRows[x].keyExpires < config.serverTime:
keyOK = 0
error = ('KeyID ' + config.pilotRows[x].keyID + ' has Expired')
onError(error)
if keyOK == 1 and config.pilotRows[x].keyType == 'Corporation':
baseUrl = 'https://api.eveonline.com/corp/StarbaseList.xml.aspx?keyID=%s&vCode=%s'
apiURL = baseUrl % (config.pilotRows[x].keyID, config.pilotRows[x].vCode)
# print(apiURL) # Console debug
def starbases_process(self, result):
XMLData = parseString(result)
starbaseNodes = XMLData.getElementsByTagName("row")
cacheuntil = XMLData.getElementsByTagName('cachedUntil')
cacheExpire = datetime.datetime(*(time.strptime((cacheuntil[0].firstChild.nodeValue), "%Y-%m-%d %H:%M:%S")[0:6]))
config.starbaseCachedUntil = cacheExpire
for row in starbaseNodes:
itemIDs = []
locationIDs = []
if int(row.getAttribute('typeID')) not in itemIDs:
itemIDs.append(int(row.getAttribute('typeID')))
baseUrl = 'https://api.eveonline.com/corp/StarbaseDetail.xml.aspx?keyID=%s&vCode=%s&itemID=%s'
apiURL = baseUrl % (config.pilotRows[x].keyID, config.pilotRows[x].vCode, row.getAttribute('itemID'))
# print(apiURL) # Console debug
def starbase_detail(self, result): # Try to connect to the API server
XMLData = parseString(result)
starbaseDetailNodes = XMLData.getElementsByTagName("row")
fuel = []
for entry in starbaseDetailNodes:
if int(entry.getAttribute('typeID')) not in itemIDs:
itemIDs.append(int(entry.getAttribute('typeID')))
fuel.append(int(entry.getAttribute('typeID')))
fuel.append(int(entry.getAttribute('quantity')))
if int(row.getAttribute('locationID')) not in locationIDs:
locationIDs.append(int(row.getAttribute('locationID')))
if int(row.getAttribute('moonID')) not in locationIDs:
locationIDs.append(int(row.getAttribute('moonID')))
itemNames = id2name('item', itemIDs)
locationNames = id2location(x, locationIDs, config.pilotRows)
tempStarbaseRows.append(Starbase(row.getAttribute('itemID'),
int(row.getAttribute('typeID')),
itemNames[int(row.getAttribute('typeID'))],
locationNames[int(row.getAttribute('locationID'))],
locationNames[int(row.getAttribute('moonID'))],
int(row.getAttribute('state')),
row.getAttribute('stateTimestamp'),
row.getAttribute('onlineTimestamp'),
fuel,
row.getAttribute('standingOwnerID')))
# itemID,typeID,locationID,moonID,state,stateTimestamp,onlineTimestamp,standingOwnerID
def server_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (config.serverConn.svrName, str(error), config.serverTime)
onError(status)
print(status)
target.state = ('Connecting to ' + config.serverConn.svrName)
UrlRequest(apiURL, on_success=starbase_detail, on_error=server_error, req_headers=config.headers)
target.state = ('Connecting to ' + config.serverConn.svrName)
UrlRequest(apiURL, on_success=starbases_process, on_error=server_error, req_headers=config.headers)
if tempStarbaseRows != []:
config.starbaseRows = tempStarbaseRows[:]
# self.starbaseList.SetObjects(starbaseRows)
timingMsg = 'Updated in: %0.2f ms' % (((time.clock() - t) * 1000))
target.state = str(timingMsg)
print(timingMsg + '(Fetch Starbases)')
else:
onError('Please open Config to enter a valid API key')
else:
# Don't Contact server as cache timer hasn't expired
# Fuel is used hourly so it shouldn't change within the cache expiry time.
print('Not Contacting Server, Cache Not Expired')
target.state = timingMsg
else:
# Server status is 'Offline' so skip everything send 'Using local cache' to status bar.
target.state = timingMsg
return()
def skill_error(self, error):
status = 'This key may not have access to pilot skills.\nError Using %s:\n%s\nAt: %s' % (
config.serverConn.svrName, str(error), config.serverTime)
onError(status)
def server_error(self, error):
status = 'Error Connecting to %s:\n%s\nAt: %s' % (config.serverConn.svrName, str(error), config.serverTime)
onError(status)
print(status)
