blob: f5fd1032c6c9b647cfc3d66a066e960827d223a2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
"""Slack stuff."""
import os
from datetime import datetime
from mappings import Message, get_session
from slack_sdk import WebClient
RESULTS_FILE = "results.json"
def get_slack_client():
"""Initialize the slack client."""
token = os.environ["SLACK_TOKEN"]
return WebClient(token=token)
def fetch_results():
"""Query slack for the latest results."""
c = get_slack_client()
r = c.search_messages(query="@cody", sort="timestamp")
# Write the results if
if r.data["ok"]:
messages = r.data["messages"]["matches"]
write_to_database(messages)
print("Archival Complete.")
else:
print("Failed to search slack.")
def write_to_database(messages):
"""Write messages to database."""
session = get_session()
for msg in messages:
username = msg["username"]
timestamp = datetime.fromtimestamp(int(msg["ts"].split(".")[0]))
if session.query(Message).filter(Message.username == username).filter(Message.timestamp == timestamp).count() != 0:
continue
print("New notification")
session.add(
Message(
iid=msg["iid"],
type=msg["type"],
username=username,
text=msg["text"],
timestamp=timestamp,
)
)
session.commit()
fetch_results()
|