1 files changed, 15 insertions, 0 deletions
diff --git a/printer.py b/printer.py
new file mode 100644
index 0000000..6e13f2c
--- /dev/null
+++ b/printer.py
@@ -0,0 +1,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}")