Ben Chuanlong Du's Blog

It is never too late to learn.

Measure Python Code Coverage

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Measure Python Code Coverage using coverage.py

pip3 install coverage

poetry run coverage run -m pytest

poetry run coverage report -m

poetry run coverage html

PyTest

$ pip install pytest-cov $ py.test …

Volatile CTE and Subqueries in SQL

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

  1. A volatile table persistents in the duration of the connection that creates it while a CTE is only accessible by the query following it. That is the scope of CTE is …

Send Emails in Python

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Use Standard Libraries smtplib and email

Below is a function for sending email leveraging standard libraries smtplib and email.

import smtplib
from email.mime.text import MIMEText


def send_email(recipient: Union …

Tips on pyenv

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

pyenv lets you easily switch between multiple versions of Python. It's simple, unobtrusive, and follows the UNIX tradition of single-purpose tools that do one thing well.

Install pyenv

curl https://pyenv …