diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/queries.py | 21 |
1 files changed, 20 insertions, 1 deletions
diff --git a/db/queries.py b/db/queries.py index 1e10629..a4605e8 100644 --- a/db/queries.py +++ b/db/queries.py @@ -23,7 +23,7 @@ def kill_list(entity_type, entity_id): with db.cursor() as c: kills = db.query(c, ''' SELECT DISTINCT(kills.kill_id), kill_time, cost, - solarSystemName as system_name, security, regionName as region + solarSystemName AS system_name, security, regionName AS region FROM kills JOIN characters ON characters.kill_id = kills.kill_id JOIN kill_costs ON kill_costs.kill_id = kills.kill_id @@ -154,5 +154,24 @@ def kill(kill_id): 'slots': slots, } +def top_cost(): + with db.cursor() as c: + kills = db.query(c, ''' + SELECT kills.kill_id, cost, + ship_type_id, typeName as ship_name, + solarSystemName AS system_name, security + FROM kills + JOIN kill_costs ON kill_costs.kill_id = kills.kill_id + JOIN characters ON characters.kill_id = kills.kill_id + JOIN eve.invTypes ON typeID = ship_type_id + JOIN eve.mapSolarSystems ON solar_system_id = solarSystemID + WHERE victim = 1 + ORDER BY cost DESC + LIMIT 25 + ''') + #for kill in kills: + # kill['kill_time'] = _format_kill_time(kill['kill_time']) + return kills + def _format_kill_time(kill_time): return kill_time.strftime('%Y-%m-%d %H:%m') |