Skip to content

Implement column mapping generator #16

@umed

Description

@umed

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.

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions