DCB MOBIUS Beta 2.2 - 25 Oct 2023

Changes

Additionally, in dcb-service

• [Ingest]

  • In Sierra - deleted=true means ONLY deleted records, and suppressed=true means ONLY suppressed records. The default is to return all and that's what we want. Do not send deleted or suppressed parameters when harvesting.

• [General]

  • Re-elect selected bib on cluster if current is deleted

• [Security]

  • remove anon auth from remaining rest endpoints

• [General]

  • Query for page then expand in separate query (Cluster export optimisations for pushing to ES/OS)

• [Refactor]

  • Move record clustering service into package.

• [Rework]

  • Cluster controller to use service and improve response time

• [Polaris]

  • Override the isEnabled method to honor settings from config

  • Force page-size to 100 maximum

Deployment

Summary

Scope: This release will create a test system involving a number of Stand-Alone Sierra systems which will be a part of the final MOBIUS network, and a number of Sierra Clusters which are currently using Sierra but will be moving to FOLIO in the final configuration. The purpose is to enable testing between member libraries, to build confidence with those libraries staying with their existing systems, and to allow libraries migrating to FOLIO to partially experience how the system will behave for them.

Instructions

1. Download and compile the tagged release sourcecode from dcb-service and dcb-locate

2. Fully remove existing tables from DCB Postgres schema. Take care to remove flyway_schema_history LAST. This is a manual operation normally completed through PGAGMIN.

3. Fully remove the existing Elastic/OpenSearch indexes and reconfigure the new schemas - there is a “schema.sh” script in the dcb-devops repository which can be adapted for this.

4. Update deployment of dcb-service and dcb-locate executables with newly built artefacts - this will cause regeneration of the tables in the Postgres schema. Check tables are present after deployment.

5. Verify and Deploy host LMS configurations (ingest:true) for:

   1. KCTOWERS (Cluster, Sierra)

   2. BRIDGES (Cluster, Sierra)

   3. AVALON (Cluster, SIerra)

   4. COOLCAT (Standalone, SGCL, Sierra)

   5. DM (Standalone Sierra)

   6. WASHU (Standalone Sierra)

   7. Optionally - SEMO IF we have creds

6. Verify and Load the mapping files

   1. Local to Central Patron Types

      1. Verify: TBD

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
         "profile":"numericRangeMappingImport",
         "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vSID6JxZ4txA-lOCCs8Z9ld2KnjCHWWixJVrbuzxL_IoBpKOHFInayPOyFMcX2Gh5-bxYFNNBzR4l0y/pub?gid=518437160&single=true&output=tsv "
         }'

   2. Local to Central Item Types

      1. Verify: TBD

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
         "profile":"numericRangeMappingImport",
         "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vSID6JxZ4txA-lOCCs8Z9ld2KnjCHWWixJVrbuzxL_IoBpKOHFInayPOyFMcX2Gh5-bxYFNNBzR4l0y/pub?output=tsv&gid=375838007 "
         }'

   3. Central to Local Patron Types

      1. Verify: TBD

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
         "profile":"referenceValueMappingImport",
         "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vSID6JxZ4txA-lOCCs8Z9ld2KnjCHWWixJVrbuzxL_IoBpKOHFInayPOyFMcX2Gh5-bxYFNNBzR4l0y/pub?gid=280712508&single=true&output=tsv "
         }'

   4. Central to Local Item Types

      1. Verify: TBD

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
         "profile":"referenceValueMappingImport",
         "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vSID6JxZ4txA-lOCCs8Z9ld2KnjCHWWixJVrbuzxL_IoBpKOHFInayPOyFMcX2Gh5-bxYFNNBzR4l0y/pub?output=tsv&gid=1273101045 "
         }'

   5. Shelving Location to Agency Mappings

      1. Verify: TBD

      2. Load: curl -X POST $TARGET/admin/cfg -H "Accept-Language: en" -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -d '{
         "profile":"referenceValueMappingImport",
         "url":"https://docs.google.com/spreadsheets/d/e/2PACX-1vTbJ3CgU6WYT4t5njNZPYHS8xjhjD8mevHVJK2oUWe5Zqwuwm_fbvv58hypPgDjXKlbr9G-8gVJz4zt/pub?gid=57428779&single=true&output=tsv "
         }'

   6. Pickup Location Mappings

      1. Verify: TBD

      2. Load:

   7. Agencies

      1. Verify:

      2. Load: (https://docs.google.com/spreadsheets/d/e/2PACX-1vTbJ3CgU6WYT4t5njNZPYHS8xjhjD8mevHVJK2oUWe5Zqwuwm_fbvv58hypPgDjXKlbr9G-8gVJz4zt/pub?gid=727698722&single=true&output=tsv via bash script)

7. Reset cfg.json - remove cursor key+value for push-to-opensearch script

Verification

• After clear down - check postgres database is EMPTY
• After deployment - check postgres tables recreated
• After deployment - check OpenSearch schema in place