XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • P2
    • Resolution: Unresolved
    • None
    • None
    • CP: Roadmap backlog
    • 2
    • Core: Platform

    Description

      When I want to sync records to an external system like VuFind I need to determine which records have been deleted in FOLIO. I compare a list of all ids in FOLIO with the list of all ids in the external system. (Records that have been created or updated after a some point of time can easily been selected using the update_date field.)

      This issue is about exporting such a list from FOLIO.

      Implement a method that returns the sorted list of all ids using streaming:

      SELECT id FROM <table_name> ORDER BY id;

      Note that it uses the primary key id and not jsonb->>'id'. This is faster because it can use the primary key index and doesn't need to fetch the jsonb field.

      Example result:

      {
        "ids": [
          "4bf07eaa-a518-48d5-9f1a-80f0dd85b437", 
          "552b8a6b-d177-49aa-b160-3c3d20aea13d", 
          "583e5b71-a5ea-4ef3-b77f-c1071f746909"
        ]
      }
      

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Unassigned Unassigned
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:

                  TestRail: Runs

                    TestRail: Cases