blob: 6e13f2cacd81b5194a8f0052a863af41eacb0d11 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
"""Print the results."""
from datetime import timedelta
from mappings import Message, get_session
session = get_session()
msgs = session.query(Message).order_by(Message.timestamp.desc()).all()
my_timezone = timedelta(hours=7)
for msg in msgs:
sent_at = msg.timestamp - my_timezone
sent_at_str = sent_at.strftime("[%m-%d %H:%M]")
text = msg.text[:70].replace("\n", "")
print(f"{sent_at_str} {msg.username:^10} {msg.type:^8} {text}")
|