currently, db-related executions and queries are spread in 3 python script: db.py, db_helper.py, db_manager.py, it is hard to manage and understand what each one does. Therefore, it'd be better if we can put all db queries into one file or a single directory, like what we do in NewsScraping -- all sql command in the queries directory, and manage sql execution using pugsql.
currently, db-related executions and queries are spread in 3 python script:
db.py
,db_helper.py
,db_manager.py
, it is hard to manage and understand what each one does. Therefore, it'd be better if we can put all db queries into one file or a single directory, like what we do in NewsScraping -- all sql command in thequeries
directory, and manage sql execution usingpugsql
.