python#

January 4, 2021
in python, linter
11 min read

Rolling back from flask-restplus reqparse to native flask request to parse inputs

flask-restplus' (or flask-restx) reqparse module is deprecated, so I decided to use the native flask request object to parse the incoming inputs.

June 8, 2020
in python, sqlalchemy
4 min read

Compiling SQLAlchemy query to nearly real raw sql query

May 5, 2020
in python
1 min read

Using Python Contextmanager To Create A Timer Decorator

April 13, 2020
in python
4 min read

Fixing an ipython Windows ConEmu only bug on 'MouseEventType.MOUSE_DOWN'

This post is for manually fixing an ipython Windows ConEmu only bug (from prompt_toolkit): Exception ''MouseEventType.MOUSE_DOWN'' is not a valid MouseEventType.

April 13, 2020
in python, linter, vscode
2 min read

Making isort compatible with black

March 9, 2020
in python
1 min read

Flattening nested dict in Python

Flattening a nested dict/json with list as some keys' value.

October 27, 2019
in python, ubuntu
2 min read

Install Python3 on Ubuntu

A quick tutorial for installing Python from its official source on Ubuntu with sqlite3 support.

September 25, 2019
in python, sqlalchemy
1 min read

If I'm not wrong, the SQLAlchemy official doc provides some examples to explain how to share a set of common columns, some common table options, or other mapped properties, across many classes. But I cannot find how to share common methods (e.g. your customized to_dict() method). This post will just show you a POC to achieve this goal by using Python Mixin.

July 30, 2019
in python, package
3 min read

Troubleshooting Python Twine Cannot Upload Package On Windows

Python has several tools to upload packages to PyPi or some private Artifactory locations. The mostly used one should be twine. Although twine is not a Python originate tool, but it's officially recommended by Python.org.