A simple news aggregator that updates news about coronavirus periodically.
Requires Python 3.6 or above
pip install -r requirements.txt
Inside MySQL console
create database corona_news;
use corona_news;
create table if not exists news
(
id int auto_increment
primary key,
title varchar(1024) null,
link varchar(512) null,
source varchar(255) null,
published_date datetime default CURRENT_TIMESTAMP null,
constraint news_link_uindex
unique (link)
);
Initialize env.py with proper variables
Update live stats csv
python csv_downloader.py
scrapy runspider rss_scraper.py
python corona_app.py
For deployment check this tutorial on DigitalOcean