le717

from html import unescape
from pathlib import Path
from xml.etree import ElementTree


all_memos = Path().rglob("memo_content.xml")
output_dir = Path("output")
output_dir.mkdir(exist_ok=True)

for memo in all_memos:

le717

"""Transparent app/non-app context Jinja rendering setup.

Use this module whenever you need to render Jinja templates outside
the app context or in code that is shared between app/non-app contexts,
such as in Celery tasks.

If available, the app context renderer will be used. Otherwise, a mostly
identical Jinja render environment will be created, with the caveat that
it may not be as efficient and will not support all Flask-provided
convenience rendering features.

le717

SET @year = 2022;

-- Get all hosts
SELECT
	w.handle AS `Host`,
	wd.date AS `Hosting period start date`
FROM writers w
	INNER JOIN writer_dates wd
		ON w.uid = wd.uid
WHERE

le717

SET @year = 2023;

-- Get all hosts
SELECT
	h.handle AS `Host`,
	hd.date AS `Hosting period start date`
FROM hosts h
	INNER JOIN host_dates hd
		ON h._id = hd.host_id
WHERE