Uploaded image for project: 'mod-inventory'
  1. mod-inventory
  2. MODINV-588

Implement deduplication for Instances

    XMLWordPrintable

Details

    • Folijet Sprint 129, Folijet Sprint 130
    • 8
    • Folijet
    • Lotus R1 2022

    Description

      Currently instance id equals to record id, that adds some confusion. Need to implement approach to generate different UUIDs for these entities and at the same to prevent duplicates processing.

      The approach has been designed in scope of spike: MODDATAIMP-500  and needs the creation of new table for deduplication purposes. The working flow described in the diagrams below. Currently mod-inventory does not have a database schema and code to work with it, so need to add these capabilities in scope of current story. 

      Diagram of instance id generation logic:

      Class diagram:

      What needs to be done:

      1. Add/enable possibility for database schema changes

      2. Add db schema change, that includes creating of new mod-inventory database schema and new table records_instances

      3. Add new InstanceIdStorageService class and DAO layer for it, that calls newly added table records_instances

      4. Modify CreateInstanceHandler to call new InstanceIdStorageService for checking UUIDs.

      5. Cover with tests.

      TestRail: Results

        Attachments

          Issue Links

            defines

            New Feature - New feature requests UXPROD-3210 NFR: R1 2022 Lotus Data import Stability/Reliability work

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            has to be done before

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINV-589 Implement deduplication for Holdings

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINV-590 Implement deduplication for Items

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINV-591 Implement deduplication for Authorities

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MODINV-603 Remove Kafka cache by handling Constraint Violation Exceptions for DataImportKafkaHandler

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            relates to

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODDATAIMP-500 SPIKE: Design approach for assigning UUIDs for entities created by DI

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODDATAIMP-588 Spike: Investigate possibility of removing Kafka cache

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODINV-460 SPIKE: Analyze possibilities to implement some constraints on the persistence level for blocking duplicate "holdings" and "items".

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINV-589 Implement deduplication for Holdings

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODINV-778 Type Mismatch Error on record_id column

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            mentioned in

            Page Loading...

            Page Loading...

            Page Loading...

            Activity

              People

                Aivar Iusupov Aivar Iusupov
                Nosko Serhii Nosko
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases