Politik-ai / data_collection

0 stars 0 forks source link

Add relational features to Database #8

Closed John-HarringtonNZ closed 4 years ago

John-HarringtonNZ commented 4 years ago

Rewire the database to be using classic relational aspects. Since we're using SQLAlchemy, this link will be helpful to start.

John-HarringtonNZ commented 4 years ago

Beth, can you help me on this?

John-HarringtonNZ commented 4 years ago

Example methodology: when building things like bill_ref, find relevant bill_id during creation through parsing and querying, then assign valid int to row for easier pull up later on.

John-HarringtonNZ commented 4 years ago

Helpful link: https://auth0.com/blog/sqlalchemy-orm-tutorial-for-python-developers/