README.md

covid19python

• Version 0.0.5 SNAPSHOT

git

gitlab

• https://git.noc.ruhr-uni-bochum.de/learn_r_and_python/covid19python.git

github

• https://github.com/thomaswoehlke/covid19python.git

Data Sources:

• WHO
• ecdc.europa
• ecdc.europa - Information

Python

• flask
• flask: pypi
• flask: flask-admin
• flask: werkzeug
• flask: sqlalchemy
• sqlalchemy
• sqlite
• jinja
• jinja: markupsafe
• jinja: itsdangerous
• jinja: click

Info

• http://www.leeladharan.com/sqlalchemy-query-with-or-and-like-common-filters
• https://riptutorial.com/flask/example/22201/pagination-route-example-with-flask-sqlalchemy-paginate

Database

WHO

who_date_reported

CREATE TABLE public.who_date_reported (
    id integer NOT NULL,
    date_reported character varying(255) NOT NULL
);

class WhoDateReported(db.Model):
    __tablename__ = 'who_date_reported'

    id = db.Column(db.Integer, primary_key=True)
    date_reported = db.Column(db.String(255), unique=True, nullable=False)

who_region

CREATE TABLE public.who_region (
    id integer NOT NULL,
    region character varying(255) NOT NULL
);