Implement mapping generator. Mappings describe how tables will be presented in the database.
As input should take Excel file with following columns:
| Link |
File name |
Format |
Table name |
Department name |
Uploading type |
As output should produce Excel file with following columns:
| Table name |
Code |
Name_rus |
Data type |
Length |
PK |
FK |
Check Null |
Comment |
It must be module on uploader level with mapping_generator name.
Create folder named mapping_generator in the root of project.
Reuse uploader/excel_helper.py. It has function named read_excel that tuple of two items:
- Columns info
- list of maps. each map is row from the file.
mapping_generator must be usable either as library or executable module.
As library there should be function that we can import and call it with arguments:
- path to input file
- path to output file
As executable use argparse and add to two params as described above.
Implement mapping generator. Mappings describe how tables will be presented in the database.
As input should take Excel file with following columns:
As output should produce Excel file with following columns:
It must be module on uploader level with
mapping_generatorname.Create folder named
mapping_generatorin the root of project.Reuse
uploader/excel_helper.py. It has function namedread_excelthat tuple of two items:mapping_generatormust be usable either as library or executable module.As library there should be function that we can import and call it with arguments:
As executable use
argparseand add to two params as described above.