diff options
| author | raylu <raylu@gridium.com> | 2013-10-21 22:52:57 -0700 |
|---|---|---|
| committer | raylu <raylu@gridium.com> | 2013-10-21 22:52:57 -0700 |
| commit | 413de1312131aac85dcb086c73f4c4a326b66398 (patch) | |
| tree | 285f0e1676a2f962b77be07bc3b2e0f7bd1194fd /db | |
| parent | 02c3d525e4712f8c0d9a938a099f582483b10d56 (diff) | |
| download | ykill-413de1312131aac85dcb086c73f4c4a326b66398.tar.xz | |
don't show :00 seconds
the api always returns :00
Diffstat (limited to 'db')
| -rw-r--r-- | db/queries.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/db/queries.py b/db/queries.py index 5da3262..a760c34 100644 --- a/db/queries.py +++ b/db/queries.py @@ -43,6 +43,7 @@ def corporation(corp_id): else: characters[kill_id]['attackers'] += 1 for kill in kills: + kill['kill_time'] = _format_kill_time(kill['kill_time']) chars = characters[kill['kill_id']] kill['victim'] = chars['victim'] kill['final_blow'] = chars['final_blow'] @@ -56,6 +57,7 @@ def kill(kill_id): JOIN eve.mapSolarSystems ON solar_system_id = solarSystemID WHERE kill_id = ? ''', kill_id) + kill['kill_time'] = _format_kill_time(kill['kill_time']) characters = db.query(c, ''' SELECT character_id, character_name, damage, victim, final_blow, @@ -136,3 +138,6 @@ def kill(kill_id): 'items': items, 'slots': slots, } + +def _format_kill_time(kill_time): + return kill_time.strftime('%Y-%m-%d %H:%m') |