Create new column for fixed utility prices & update automation

adizafri2000 / billscraper

Sample headless automation project to scrape bills, calculate monthly bill (rent + utilities) and generate a text message which is later sent to desired whatsapp recipients.

1 stars 0 forks source link

Create new column for fixed utility prices & update automation #21

Closed adizafri2000 closed 7 months ago

adizafri2000 commented 7 months ago

Update the utility table to contain a nullable column to contain the fixed price of a utility item
Change 'automation' to become data retrieval from DB to entirely remove fixed price numbers in the code

adizafri2000 commented 7 months ago

added new file to calculate every utility with fixed price
commented out the 'automation' of house rent and internet bill retrieval
in utility table, added new nullable, decimal column price to contain the fixed price of the utility
if row data in utility table has null for the price column, it is considered not having monthly fixed price and skipped for fixed price calculation