I hereby claim:
- I am hest on github.
- I am hest (https://keybase.io/hest) on keybase.
- I have a public key ASAZ_nZh69YK6afHocv1aIFAmtg5UKMGjzMLK4thpiPlXgo
To claim this, I am signing this object:
Dongmin Jang hest
hest
/ flask_arrow.py
Last active
January 4, 2022 01:39
SQLAlchemy-Utils ArrowType with Flask-Babel Timezone
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from flask import Flask, g | |
| from flask_babel import Babel | |
| """ | |
| Use At Your Own Risk | |
| """ | |
| app = Flask(__name__) | |
| # app.config.from_object(config) | |
| babel = Babel(app) |
hest
/ keybase.md
Created
September 6, 2019 18:50
hest
/ gist:8798884
Created
February 4, 2014 06:08
Fast SQLAlchemy counting (avoid query.count() subquery)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def get_count(q): | |
| count_q = q.statement.with_only_columns([func.count()]).order_by(None) | |
| count = q.session.execute(count_q).scalar() | |
| return count | |
| q = session.query(TestModel).filter(...).order_by(...) | |
| # Slow: SELECT COUNT(*) FROM (SELECT ... FROM TestModel WHERE ...) ... | |
| print q.count() |