Consider using SQLAlchemy ORM for queries - Githubissues

he7d3r / desafio-engenharia-dados

MIT License

2 stars 0 forks source link

Consider using SQLAlchemy ORM for queries #6

Open he7d3r opened 3 years ago

he7d3r commented 3 years ago

See https://docs.sqlalchemy.org/en/14/orm/queryguide.html.

BTW: Using string interpolation like this is probably asking for trouble (read: SQL injection?) https://github.com/he7d3r/desafio-engenharia-dados/blob/48e4aec8ae84ad7b151572426c2cdf670a30a8a0/dashboard/src/routes.py#L102-L110

he7d3r commented 3 years ago

See also this Python sqlalchemy cheat sheet (suggested at this post: SQLAlchemy makes ETL magically easy)