munenendereba/kenya-power-planned-interruption

This project aims to create an automated solution that converts Kenya Power Planned Power Interruptions Schedules from a pdf and image to a searchable online list. # Kenya Power Planned Power Interruption Notifier A project to improve access to Kenya Power Planned Power Interruption publications which appear on their website and on their twitter handle. ## Problem There is currently no accessible way to know if your area will be affected by planned power interruption. For most Kenyans, this comes as a suprise when around 9am, your power goes off. You reach out to Kenya Power customer service who then tell you that there is a planned maintenance on your line and this was published on their website. On the website, the information is available as a pdf download which you then need to open and check a week before. These are published once a week. Alternatively, you can check on their twitter handle which is published the night before as a screenshot. The information is not easily searchable especially if you are on mobile. ## Description The solution aspires to accomplish the following: - Automated pdf and screenshot downloader - Read the contents and insert into a SQL db - Web app to display the scheduled maintenance by date and are - Allow users to update their email and area they need notifications for - Send automated notifications to users who subscribe to the feed ## Getting Started ### Dependencies - You need Node installed in your environment - npm packages required: express, sharp, morgan-body, mariadb, sequelize, body-parser, ejs and nodemon (for dev auto-restart) ### Installing - Just clone the repo or download from this repo - Copy to a directory in your computer. #### Set up your .env Using the .env.example file, edit the values of the db connection as you wish, then rename the file as .env. Ensure you are able to connect to the db. #### Run the migration Run the migration to create the tables in the db using the command below: `npx sequelize-cli db:migrate` The output should be as below: Check the db to confirm the tables have been created. #### Run the seed Run the seed to populate the tab …