From cd518ff1d07800d46812c016f1b73f9a5f2f4313 Mon Sep 17 00:00:00 2001
From: Cody Hiar <cody@hiar.ca>
Date: Thu, 4 Feb 2021 11:26:21 -0700
Subject: Add printer script for cleaner formatting

---
 printer.py | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 printer.py

(limited to 'printer.py')

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}")
-- 
cgit v1.2.3