def alliance_oneday(mongohandle, alliance_id):
"""find by corp and system - one day"""
allkills = mongohandle.allkills
timeframe = 24 * 60 * 60
gmtminus = time.mktime(time.gmtime()) - timeframe
cursor = allkills.find({"alliance_id": alliance_id,
"unix_kill_time": {
"$gte": gmtminus}},
{"ship": 1,
"items": 1,
"_id": 0}).hint('alliancetime')
(ships, items, ammos) = parsecursor.ships_and_items(cursor)
return (ships, items, ammos)
def corporation_system_oneday(mongohandle, corporation_id, system):
"""find by corp and system - one day"""
allkills = mongohandle.allkills
system = int(system)
timeframe = 24 * 60 * 60
gmtminus = time.mktime(time.gmtime()) - timeframe
cursor = allkills.find({"corporation_id": corporation_id,
"solar_system_id": system,
"unix_kill_time": {
"$gte": gmtminus}},
{"ship": 1,
"items": 1,
"_id": 0}).hint('corpsystemtime')
(ships, items, ammos) = parsecursor.ships_and_items(cursor)
return (ships, items, ammos)
def corporation_date(mongohandle, corporation_id, date):
"""find by corp system and specified date"""
allkills = mongohandle.allkills
timeframe = 24 * 60 * 60
datestring = date + ' 11:05:00'
starttime = calendar.timegm(time.strptime(datestring, '%Y-%m-%d %H:%M:%S'))
stoptime = starttime + timeframe
cursor = allkills.find({"corporation_id": corporation_id,
"unix_kill_time": {
"$gte": starttime,
"$lt": stoptime}},
{"ship": 1,
"items": 1,
"_id": 0}).hint('corptime')
(ships, items, ammos) = parsecursor.ships_and_items(cursor)
return (ships, items, ammos)
def corporation_days(mongohandle, corporation_id, days):
"""find by corp and specified days"""
allkills = mongohandle.allkills
if float(days) > 7 or float(days) < 0:
shiptotals = [{"error":"parameter 'days' range error"}]
itemtotals = [{"error":"parameter 'days' range error"}]
ammototals = [{"error":"parameter 'days' range error"}]
return (shiptotals, itemtotals, ammototals)
else:
timeframe = float(days) * 24 * 60 * 60
gmtminus = time.mktime(time.gmtime()) - timeframe
cursor = allkills.find({"corporation_id": corporation_id,
"unix_kill_time": {
"$gte": gmtminus}},
{"ship": 1,
"items": 1,
"_id": 0}).hint('corptime')
(ships, items, ammos) = parsecursor.ships_and_items(cursor)
return (ships, items, ammos)
def alliance_system_days(mongohandle, alliance_id, system, days):
"""find by corp system and specified days"""
allkills = mongohandle.allkills
system = int(system)
if float(days) > 7 or float(days) < 0:
shiptotals = [{"error":"parameter 'days' range error"}]
itemtotals = [{"error":"parameter 'days' range error"}]
ammototals = [{"error":"parameter 'days' range error"}]
return (shiptotals, itemtotals, ammototals)
else:
timeframe = float(days) * 24 * 60 * 60
gmtminus = time.mktime(time.gmtime()) - timeframe
cursor = allkills.find({"alliance_id": alliance_id,
"solar_system_id": system,
"unix_kill_time": {
"$gte": gmtminus}},
{"ship": 1,
"items": 1,
"_id": 0}).hint('alliancesystemtime')
(ships, items, ammos) = parsecursor.ships_and_items(cursor)
return (ships, items, ammos)