BACKLOG.md



CHANGES

Milestones

0.0.1 Release

Fixed #1 (closed) test 1 2 3


0.0.2 Release

Fixed #2 (closed) start data update job via web ui
Fixed #4 (closed) data update: who_country
Fixed #6 (closed) data update: who_global_data
Fixed #3 (closed) web ui: show table of who_region


0.0.3 Release

Fixed #8 (closed) view_who_today_new_deaths
Fixed #9 (closed) view_who_global_data
Fixed #10 (closed) view_who_today_new_cases
Fixed #11 (closed) view_who_germany
Fixed #12 (closed) view_max_new_deaths_who


0.0.4 Release

Fixed #13 (closed) Pagination for all Tables
Fixed #14 (closed) Running on Windows and Linux
Fixed #15 (closed) Navigation: Region, Countries, Data per Countries order by Date


0.0.5 Release

Fixed #1 (closed) Async Tasks for import and update Data with Celery and RabbitMQ
Fixed #2 (closed) Move Repo to github


0.0.6 Release

Fixed #6 (closed) data of all reported countries for WHO date reported
Fixed #7 (closed) WHO Countries all - data for Country


0.0.7 Release

Issue #8 (closed) WhoServiceUpdate.update_db_short()
Issue #9 (closed) URL: /who/update/short
Issue #10 (closed) async who_update_short_task
Issue #11 (closed) WhoServiceUpdate.__update_who_global_data_short()
Fixed #12 (closed) better layout for flash messages


0.0.8 Release

Fixed #13 (closed) /who/imported/
Fixed #14 (closed) /europe/imported/
Fixed #15 (closed) /who/update: Download
Fixed #16 (closed) /who/update: Import File to DB
Fixed #17 (closed) /who/update: Update DB
Fixed #21 (closed) better templates for who_global_data tables


0.0.9 Release

Fixed #18 (closed) /europe/update: Download
Fixed #19 (closed) /europe/update: Import File to DB
Fixed #20 (closed) /europe/update: Update DB
Fixed #21 (closed) update_date_reported
Fixed #22 (closed) update_continent
Fixed #23 (closed) update_country
Fixed #24 (closed) update_data
Fixed #25 (closed) /who/update/initial update_data_initial
Fixed #27 (closed) /admin/database/drop
Fixed #3 (closed) ORM: 3NF for ecdc_europa_data_import
Fixed #4 (closed) data update for 3NF ecdc_europa_data_import


0.0.10 Release

Fixed #24 (closed) update_data
Fixed #29 (closed) /who/info
Fixed #30 (closed) /europa/info
Fixed #31 (closed) /rki/info
Fixed #32 (closed) /nrw/info
Fixed #33 (closed) /europe/date_reported
Fixed #34 (closed) /europe/continent
Fixed #35 (closed) /europe/country
Fixed #36 (closed) /europe/data
Fixed #37 (closed) switch from RabbitMQ to Redis
Fixed #38 (closed) update Celery from 4 to 5


0.0.11 Release

Fixed #26 (closed) /admin/database/dump
Fixed #43 (closed) /europe/date_reported
Fixed #44 (closed) /europe/continent
Fixed #45 (closed) /europe/country
Fixed #46 (closed) /europe/country/germany
Fixed #50 (closed) remove unused requirements from requirements.txt
Fixed #51 (closed) /europe/imported


0.0.12 Release

Fixed #55 (closed) /vaccination/tasks
Fixed #56 (closed) /vaccination/info


0.0.13 Release

Fixed #49 (closed) EcdcServiceUpdate.__update_data_short() (wontfix)
Fixed #52 (closed) download vaccination timeline data file
Fixed #53 (closed) import vaccination timeline data file into db
Fixed #54 (closed) /vaccination/imported
Fixed #57 (closed) frontend: use npm for handling 3rdParty css and javascript modules like jQuery, Bootstrap
Fixed #58 (closed) frontend: remove jumbotron from all pageheader, put jumbotron as main content on home page
Fixed #47 (closed) major refactoring: Routes from app.py to org...who,europe,... (Doublette von #65 (closed))
Fixed #48 (closed) major refactoring: Tasks from server_mq.py to org...who,europe,... (Doublette von #65 (closed))
Fixed #64 (closed) major refactoring: create two packages: for web app and for celery worker
Fixed #68 (closed) TODO: move Queries from Services to Model-Classes
Fixed #65 (closed) major refactoring: add flask-blueprints for admin, common, europe, rki, vaccination, who


0.0.14 Release

Fixed #69 (closed) Branch: ISSUE_66_ATTEMPT_01
Fixed #70 (closed) load package.json from Bootstrap-Template sb-admin-angular into statics
Fixed #67 (closed) implement Flask-Login (wontfix)
Issue #159 (closed) merge Branch ISSUE_66_ATTEMPT_01 to master
Fixed #71 (closed) add python modules to requirements.txt for User Login, Authentication and Autorisation
Fixed #72 (closed) add python modules to requirements.txt for Ajax and other JS Features
Fixed #73 (closed) add python modules to requirements.txt for further research and development
Fixed #74 (closed) add Tasks to WHO Tasks Html
Fixed #78 (closed) add PlantUML
Fixed #79 (closed) add Gaphor UML (wonfix)
Fixed #80 (closed) rename WhoXYImport to OwidImport
Fixed #81 (closed) change tablename from who_global_data_import to who_import
Fixed #84 (closed) rename tablename from who_global_data to who_data
Fixed #85 (closed) rename WhoData to WhoData
Fixed #86 (closed) rename VaccinationDataXY to RkiVaccinationData
Fixed #89 (closed) change tablename from vaccination_germany_timeline_import to vaccination_import
Fixed #75 (closed) add Tasks to Europe Tasks Html
Fixed #76 (closed) add Tasks to Vaccination Tasks Html
Fixed #77 (closed) add Tasks to RKI Tasks Html
Fixed #124 (closed) rename RkiXXZBundeslaender to RkiBundeslaender
Fixed #162 (closed) rename table vaccination_germany_timeline into vaccination_data
Fixed #130 (closed) remove RkiGermanyDataImportTable


0.0.15 Release


Fixed #88 (closed) rename RkiVaccinationImport to RkiVaccinationImport
Fixed #89 (closed) change tablename from vaccination_germany_timeline_import to vaccination_import
Fixed #86 (closed) rename RkiVaccinationData to RkiVaccinationData
Fixed #162 (closed) rename table vaccination_germany_timeline into vaccination_data


Fixed #170 (closed) implement url_vaccination_task_update_star_schema_initial in vaccination_views.py
Fixed #171 (closed) implement url_vaccination_task_update_starschema_incremental in vaccination_views.py
Fixed #172 (closed) implement url_vaccination_task_import_only in vaccination_views.py
Fixed #173 (closed) implement url_vaccination_task_import_only in vaccination_views.py
Fixed #174 (closed) implement url_vaccination_task_update_dimensiontables_only in vaccination_views.py
Fixed #175 (closed) implement url_vaccination_task_update_facttable_incremental_only in vaccination_views.py
Fixed #176 (closed) implement url_vaccination_task_update_facttable_initial_only in vaccination_views.py


Fixed #91 (closed) implement RkiVaccinationService.run_download_only
Fixed #92 (closed) implement RkiVaccinationService.run_import_only
Fixed #93 (closed) implement RkiVaccinationService.run_update_dimension_tables_only
Fixed #94 (closed) implement RkiVaccinationService.run_update_fact_table_incremental_only
Fixed #95 (closed) implement RkiVaccinationService.run_update_fact_table_initial_only
Fixed #96 (closed) implement RkiVaccinationService.run_update_star_schema_incremental
Fixed #97 (closed) implement RkiVaccinationService.run_update_star_schema_initial
Fixed #101 (closed) implement RkiVaccinationServiceUpdate.update_dimension_tables_only
Fixed #102 (closed) implement RkiVaccinationServiceUpdate.update_fact_table_incremental_only
Fixed #103 (closed) implement RkiVaccinationServiceUpdate.update_fact_table_initial_only
Fixed #104 (closed) implement RkiVaccinationServiceUpdate.update_star_schema_incremental
Fixed #105 (closed) implement RkiVaccinationServiceUpdate.update_star_schema_initial


Fixed #90 (closed) refactor RkiVaccinationService to new method scheme introduced 07.02.2021
Fixed #98 (closed) refactor RkiVaccinationServiceDownload to new method scheme introduced 07.02.2021
Fixed #99 (closed) refactor RkiVaccinationServiceImport to new method scheme introduced 07.02.2021
Fixed #100 (closed) refactor RkiVaccinationServiceUpdate to new method scheme introduced 07.02.2021


Fixed #87 (closed) change to: Vaccination.datum many to one RkiVaccinationDateReported
Fixed #106 (closed) add Tasks and URLs for starting Tasks to vaccination_views


0.0.16 Release

Fixed #111 (closed) refactor to new method scheme introduced 07.02.2021
Fixed #117 (closed) refactor EcdcServiceUpdate to new method scheme introduced 07.02.2021
Fixed #112 (closed) implement EcdcService.run_update_dimension_tables_only
Fixed #113 (closed) implement EcdcService.run_update_fact_table_incremental_only
Fixed #114 (closed) implement EcdcService.run_update_fact_table_initial_only
Fixed #115 (closed) implement EcdcService.run_update_star_schema_incremental
Fixed #116 (closed) implement EcdcService.run_update_star_schema_initial
Fixed #118 (closed) implement EcdcServiceUpdate.update_dimension_tables_only
Fixed #119 (closed) implement EcdcServiceUpdate.update_fact_table_incremental_only
Fixed #120 (closed) implement EcdcServiceUpdate.update_fact_table_initial_only
Fixed #121 (closed) implement EcdcServiceUpdate.update_star_schema_incremental
Fixed #122 (closed) implement EcdcServiceUpdate.update_star_schema_initial


Fixed #163 (closed) implement url_europe_task_update_star_schema_initial in europe_views.py
Fixed #164 (closed) implement url_europe_task_update_starschema_incremental in europe_views.py
Fixed #165 (closed) implement url_europe_task_download_only in europe_views.py
Fixed #166 (closed) implement url_europe_task_import_only in europe_views.py
Fixed #167 (closed) implement url_europe_task_update_dimensiontables_only in europe_views.py
Fixed #168 (closed) implement url_europe_task_update_facttable_incremental_only in europe_views.py
Fixed #169 (closed) implement url_europe_task_update_facttable_initial_only in europe_views.py


0.0.17 Release

Fixed #82 (closed) change to ORM ClassHierarchy
Fixed #42 (closed) SQLalchemy instead of SQL: OwidImport.get_new_dates_as_array()
Fixed #83 (closed) SQLalchemy instead of SQL in OwidImport.get_new_dates_as_array
Fixed #108 (closed) change to ORM ClassHierarchy in: EcdcImport.get_countries_of_continent
Fixed #39 (closed) SQLalchemy instead of SQL: AllModelClasses.remove_all()
Fixed #40 (closed) SQLalchemy instead of SQL: EcdcImport.get_date_rep()
Fixed #41 (closed) SQLalchemy instead of SQL: EcdcImport.get_countries_of_continent()
Fixed #107 (closed) SQLalchemy instead of SQL in: EcdcImport.get_countries_of_continent
Fixed #109 (closed) SQLalchemy instead of SQL in: EcdcImport.get_date_rep
Fixed #110 (closed) SQLalchemy instead of SQL in: EcdcImport.get_continent
Fixed #123 (closed) split RkiBundeslaenderService into two Services, one for bundeslaender and one for landkreise
Fixed #128 (closed) add fields from csv to RkiLandkreiseImport
Fixed #139 (closed) refactor RkiBundeslaenderServiceDownload to new method scheme introduced 07.02.2021
Fixed #140 (closed) move OwidImport to RKI in: rk_service_import.py
Fixed #125 (closed) implement RkiLandkreise
Fixed #126 (closed) implement RkiBundeslaenderImport


0.0.18 Release

Fixed #133 (closed) implement RkiBundeslaenderService.task_database_drop_create
Fixed #134 (closed) implement RkiBundeslaenderService.run_update_dimension_tables_only
Fixed #135 (closed) implement RkiBundeslaenderService.run_update_fact_table_incremental_only
Fixed #136 (closed) implement RkiBundeslaenderService.run_update_fact_table_initial_only
Fixed #137 (closed) implement RkiBundeslaenderService.run_update_star_schema_incremental
Fixed #138 (closed) implement RkiBundeslaenderService.run_update_star_schema_initial
Fixed #132 (closed) refactor RkiBundeslaenderService to new method scheme introduced 07.02.2021


Fixed #147 (closed) refactor RkiBundeslaenderServiceUpdate.__update_who_date_reported
Fixed #148 (closed) refactor RkiBundeslaenderServiceUpdate.__update_who_region
Fixed #149 (closed) refactor RkiBundeslaenderServiceUpdate.__update_who_country
Fixed #150 (closed) refactor RkiBundeslaenderServiceUpdate.__update_who_global_data
Fixed #151 (closed) refactor RkiBundeslaenderServiceUpdate.__update_who_global_data_short
Fixed #152 (closed) refactor RkiBundeslaenderServiceUpdate.__update_who_global_data_initial
Fixed #153 (closed) refactor RkiBundeslaenderServiceUpdate.update_db
Fixed #154 (closed) refactor RkiBundeslaenderServiceUpdate.update_db_short
Fixed #155 (closed) refactor RkiBundeslaenderServiceUpdate.update_db_initial


Fixed #131 (closed) change to ORM ClassHierarchy in: RkiGermanyDataImportTable.get_new_dates_as_array
Fixed #129 (closed) change to ORM ClassHierarchy in: RkiLandkreiseImport.get_new_dates_as_array
Fixed #146 (closed) add Tasks and URLs for starting Tasks to rki_views
Fixed #127 (closed) implement RkiBundeslaenderImport.get_dates_reported


Fixed #141 (closed) implement RkiBundeslaenderServiceUpdate.update_dimension_tables_only
Fixed #142 (closed) implement RkiBundeslaenderServiceUpdate.update_fact_table_incremental_only
Fixed #143 (closed) implement RkiBundeslaenderServiceUpdate.update_fact_table_initial_only
Fixed #144 (closed) implement RkiBundeslaenderServiceUpdate.update_star_schema_incremental
Fixed #145 (closed) implement RkiBundeslaenderServiceUpdate.update_star_schema_initial


0.0.19 Release

Issue #177 (closed) BUG: RkiBundeslaenderServiceImport.import_file
Issue #178 (closed) BUG: RkiLandkreiseServiceImport.import_file
Issue #5 Visual Graphs for Data per Countries order by Date
Issue #59 frontend: add correct breadcrumb to every page
Issue #60 (closed) frontend: better design for tables
Issue #61 frontend: better design for navtabs
Issue #62 (closed) frontend: better design for pages
Issue #63 frontend: add footer design


0.0.20 Release

Issue #28 (closed) /admin/database/import
Issue #66 (closed) frontend: migrate to Bootstrap Theme sb-admin-angular
Issue #158 (closed) load Bootstrap-Template sb-admin-angular into static


0.0.21 Release


Issue #156 (closed) run_web.sh
Issue #157 (closed) run_worker.sh