Generate OrderableIndentifiers.csv file

Description

In referencedata service generate the csv file with structrue:

key

productCode

tradeItem

VC003000

tradeItem

VC003001

Mapping:

key -> referencedata.orderable_identifiers.key

productCode -> referencedata.orderables.code

Note: we should reuse what we prepared for previous file

All export data generation logic has been added in this task.

To do

Model

  • create a model class for OrderableIdentifier (currently it's just a Map<String, String> field in the Orderable class)

  • add @InputFile annotations on the fields in the OrderableIdentifier model class

Data

  • add a method that retrieves data in accordance with the OrderableIdentifier model class

    • use OrderableRepository

    • use a native query - the necessary data is in the orderables and orderable_identifiers tables, which are connected by a relationship

  • create service class for OrderableIdentifier (should import ExportableDataService)

Attachments

1

Checklists

Activity

Show:
Piotr Wargulak
February 23, 2023 at 11:26 AM

Looks fine.

Szymon Radziszewski
February 20, 2023 at 11:46 AM

I created a pull request.

cc:

Szymon Radziszewski
February 13, 2023 at 2:00 PM

I'm working on increasing the test coverage of the code to ensure the stability of the build in this task.

Szymon Radziszewski
January 31, 2023 at 7:18 AM

I have finished working on this task but it is blocked by OLMIS-7644

Szymon Radziszewski
January 26, 2023 at 7:43 AM

I am currently working on this task.

Unresolved
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Labels

Original estimate

Time tracking

1d logged

Priority

Time Assistant

Created October 27, 2022 at 5:42 AM
Updated February 24, 2023 at 11:57 AM