Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-392

Make item.status.date read only field.

    XMLWordPrintable

Details

    • Core: F - Sprint 79, Core: F - Sprint 80
    • 3
    • Prokopovych

    Description

      Spike outcome: investigate what modules will be updated & get familiarized with code. Investigate ways of implementation.

      This is a breaking compatibility change.

      • Make the item.status.date as readonly (it is populated by a DB trigger now, see MODINVSTOR-367).
      • Add "format": "date-time" so the property becomes java Date instead of raw string.
      Implementation notes

      RMB removes readonly fields before updating them, so we additionally have to update instanceStatusUpdatedDateTrigger.sql trigger, so it will transfer the OLD statusUpdatedDate to the NEW record, i.e.:

      IF (OLD.jsonb->'status'->>'date' IS NOT NULL) THEN
         NEW.jsonb->'status'->>'date'= OLD.jsonb->'status'->>'date';
      END IF;
      

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                bohdan-suprun Bohdan Suprun
                VRohach Volodymyr Rohach
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases