Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DBIAIT Improvements: Check DBI #425

Open
mattiagiupponi opened this issue Dec 12, 2024 · 0 comments
Open

DBIAIT Improvements: Check DBI #425

mattiagiupponi opened this issue Dec 12, 2024 · 0 comments

Comments

@mattiagiupponi
Copy link
Collaborator

mattiagiupponi commented Dec 12, 2024

The DBI_A and the DBI_A-1 are the seed file to be used during the export phase.
This two files are splitted in single sheet. Each sheet rappresent a table name in the postgres database.
In the export folder there are the json file that contains the extraction query and the relative tables.

To clarify better the following points, we use the sheet potabilizzatori as example

Each XSLX file is splitted in 3 sections:

  1. rappresent the data to validate, aka the output of the export phase (colums A:BL)
  2. checks for single opera (colums BM:BQ)
  3. Checks by aggregation (colums BR:EC)

All the checks should be able to:

  • Reproduce the manual copy of the export file into DBI_A and DBI_A-1 and the drop down of each formula
  • Log (a file is fine) where indicates the checks that are not correct

Techincal notes:

  • All the process must be asyncronous
  • The projects use dramatiq, doc here
  • The client uses python 3.6.9, we must be sure to be complaint with that version
  • If needed we might evaluate library upgrade (dramatiq, django, etc..)
  • QGIS version used is 3.16.0 Hannover
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants