Protoyping with python by creating an email task digest

import json

with open(".wekan-creds.json", "r") as creds_file:
    creds = json.load(creds_file)

creds.keys()

# Install a pip package in the current Jupyter kernel
import sys
!{sys.executable} -m pip install requests

import requests

headers = {
  'Content-Type': 'application/x-www-form-urlencoded',
  'Accept': '*/*'
}

api_key_resp = requests.post(f"{creds['host']}/users/login", {
    'username': creds['username'],
    'password': creds['password']
}, headers = headers)

api_key = api_key_resp.json()
api_key.keys()

def wekan(url):
    return requests.get(f"{creds['host']}{url}", headers = {
        'Accept': 'application/json',
        'Authorization': f"Bearer {api_key['token']}"
    }).json()

user = wekan('/api/user')
user['profile']['fullname']

cards = []
labels = {}
boards = {}
lists = {}

for board_id in user['profile']['starredBoards']:
    board = wekan(f"/api/boards/{board_id}")
    for label in board["labels"]:
        labels[label['_id']] = label['color']
    boards[board['_id']] = board
    board_lists = wekan(f"/api/boards/{board_id}/lists")
    for l in board_lists:
        list_id = l["_id"]
        lists[list_id] = l
        list_cards = wekan(f"/api/boards/{board_id}/lists/{list_id}/cards")
        for card in list_cards:
            cards.append(wekan(f"/api/boards/{board_id}/lists/{list_id}/cards/{card['_id']}"))

print(len(cards))
print(set(labels.values()))

test_card = wekan(f"/api/boards/8QBuF6qoBT6fsZPeF/lists/3usjdgnA97ZKDboRZ/cards/MSSb4YG9ioYDeHeoP")
test_card

from datetime import datetime, timezone
from functools import reduce

has_due = lambda card: 'dueAt' in card and card['dueAt'] is not None

# labels with this color multiply by this much
color_factor = {
    'red': 2,
    'yellow': 1.5,
    'green': 0.75
}

seconds_in_day = 60 * 60 * 24
due_falloff = 10 # not a factor until this long until
due_weight = 5 # when do has this much weight added

def determine_weight(card):
    weights = []
    
    if has_due(card):
        now = datetime.now(timezone.utc)
        due_datetime = datetime.fromisoformat(card['dueAt'].replace("Z", "+00:00"))
        days_until = (due_datetime - now).total_seconds() / seconds_in_day
        if days_until < 0:
            weights.append({
                'cause': 'overdue',
                'constant': due_weight
            })
        elif days_until < due_falloff:
            weights.append({
                'cause': 'due soon',
                'constant': max((1 - (days_until / due_falloff)) * due_weight, due_weight)
            })

    if 'labelIds' in card:
        for label_id in card['labelIds']:
            if label_id in labels:
                color = labels[label_id]
                if color in color_factor:
                    weights.append({
                        'cause': f"{color} label",
                        'factor': color_factor[color]
                    })
                    break # only the first color matters
    
    return weights
    
def sum_weight(weight):
    constant = sum(w['constant'] for w in weight if 'constant' in w)
    factored = reduce(lambda a, b: a * b, (w['factor'] for w in weight if 'factor' in w), constant)
    
    return factored

def describe_weight(weight):
    constants = [w for w in weight if 'constant' in w]
    constants.sort(key=lambda w: w['constant'])
    constants = [f"{w['cause']}({w['constant']:.2f})" for w in constants]
    factors = [w for w in weight if 'factor' in w]
    factors.sort(key=lambda w: w['factor'])
    factors = [f"{w['cause']}({w['factor']}x)" for w in factors]

    return f"{' + '.join(constants)} {' '.join(factors)}"

test_weight = determine_weight(test_card)
print(test_weight)
print(sum_weight(test_weight))
print(describe_weight(test_weight))

priority = sorted(cards, key=lambda c: sum_weight(determine_weight(c)), reverse=True)

for c in priority:
    print(f"{c['title']}: {sum_weight(determine_weight(c)):.2f}")

with open(".smtp-creds.json", "r") as creds_file:
    smtp_creds = json.load(creds_file)

smtp_creds.keys()

import smtplib

sender = smtp_creds['sender']
receiver = smtp_creds['receiver']

message = f"""From: {sender}
To: Vincent Khougaz <{receiver}>
Subject: Test Email

Email Body!"""

smtp = smtplib.SMTP_SSL(smtp_creds['host'], smtp_creds['port'])
print(smtp.login(smtp_creds['username'], smtp_creds['password']))

smtp.sendmail(sender, [receiver], message)

from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText

msg = MIMEMultipart()
msg['Subject'] = f"Daily Task Digest for {datetime.now().strftime('%A %Y-%m-%d')}"
msg['From'] = f"Task Digest <{sender}>"
msg['To'] = f"Vincent Khougaz <{receiver}>"

def format_card(card):
    weight = determine_weight(card)
    return f"""\
        <li>
            <a
                href="{creds['host']}/b/{card['boardId']}/{boards[card['boardId']]['slug']}/{card['_id']}">
                {card['title']} ({sum_weight(weight):.2f})
            </a>
            <br>
            <pre>{describe_weight(weight)}</pre>
        </li>
"""

html = f"""\
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="https://www.w3.org/1999/xhtml">
<head>
<title>Daily Task Digest for {datetime.now().strftime('%A %Y-%m-%d')}</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1.0 " />
</head>
<body>
Prioritized tasks for today:
<ul>
{"".join(format_card(c) for c in priority)}
</ul>
</body>
</html>
"""

msg.attach(MIMEText(html, 'html'))

print(msg.as_string())

smtp = smtplib.SMTP_SSL(smtp_creds['host'], smtp_creds['port'])
smtp.login(smtp_creds['username'], smtp_creds['password'])
smtp.sendmail(sender, [receiver], msg.as_string())