YAML
Splitting a Large YAML Config Into Several Files Cleanly
YAML has no include. Two ways to split a config: numbered fragments merged in order, and a custom include tag on a safe loader. Both tested, with traps.
7 min read
Tag
automation
40 posts
YAML
YAML Duplicate Keys and the Silent Overwrite Problem
PyYAML keeps the last of a repeated key silently, ruamel.yaml raises and yamllint flags it. A strict loader in eight lines and how merges create duplicates.
6 min read
Excel
Emailing a Scheduled Excel Report From a Database Job
Build a job that queries a database, writes an Excel file and emails it on a schedule with smtplib and cron, with safe credentials and failure alerts.
8 min read
YAML
YAML Version Numbers Turning Into Floats and How to Stop It
Python 3.10 in a CI matrix loads as 3.1 in every parser. See the proof, why quoting is the fix and a script that finds suspect floats in a repository.
6 min read