| WITH fk_info as ( | |
| (SELECT (@fk_info:=NULL), | |
| (SELECT (0) | |
| FROM (SELECT kcu.table_schema, | |
| kcu.table_name, | |
| kcu.column_name as fk_column, | |
| kcu.constraint_name as foreign_key_name, | |
| kcu.referenced_table_schema as reference_schema, | |
| kcu.referenced_table_name as reference_table, | |
| kcu.referenced_column_name as reference_column, |
| log-queries | |
| log-facility=/var/log/dnsmasq.log | |
| no-resolv | |
| server=8.8.4.4 | |
| server=8.8.8.8 | |
| address=/router/10.1.1.1 | |
| address=/server/10.1.1.2 |
When running FastAPI app, all the logs in console are from Uvicorn and they do not have timestamp and other useful information. As Uvicorn applies python logging module, we can override Uvicorn logging formatter by applying a new logging configuration.
Meanwhile, it's able to unify the your endpoints logging with the Uvicorn logging by configuring all of them in the config file log_conf.yaml.
Before overriding:
uvicorn main:app --reload
| from __future__ import annotations | |
| import os | |
| import psutil | |
| import logging | |
| import subprocess | |
| import sqlite3 | |
| from typing import NamedTuple, DefaultDict, Literal | |
| from datetime import datetime | |
| from collections import defaultdict |
| def calculate_aspect(width: int, height: int) -> str: | |
| def gcd(a, b): | |
| """The GCD (greatest common divisor) is the highest number that evenly divides both width and height.""" | |
| return a if b == 0 else gcd(b, a % b) | |
| r = gcd(width, height) | |
| x = int(width / r) | |
| y = int(height / r) | |
| return f"{x}:{y}" |
| FILES=*.rst | |
| for f in $FILES | |
| do | |
| filename="${f%.*}" | |
| echo "Converting $f to $filename.md" | |
| `pandoc $f -f rst -t markdown -o $filename.md` | |
| done |
There are several ways to clone a repository from github. Similar from other providers, such as bitbucket, gitlab, etc.
https://git-scm.com/book/en/v2/Git-on-the-Server-The-Protocols
Mostly, we use
| def initializeLogger(name, logfile, log_level=logging.DEBUG, file_level=logging.INFO): | |
| logger = logging.getLogger(name) | |
| if logger.hasHandlers(): | |
| logger.handlers.clear() | |
| formatter = logging.Formatter( | |
| "[%(asctime)s] - %(levelname)s in %(pathname)s:%(lineno)d - %(message)s" | |
| ) |
| [Unit] | |
| Description=supervisord - Supervisor process control system for UNIX | |
| Documentation=http://supervisord.org | |
| After=network.target | |
| [Service] | |
| Type=forking | |
| ExecStart=/bin/supervisord -c /etc/supervisor/supervisord.conf | |
| ExecReload=/bin/supervisorctl reload | |
| ExecStop=/bin/supervisorctl shutdown |