Migrate Aura Bot and Aura Groot context to Linkin Park

Prerequisites

• Mandatory requisite: A valid kubeconfig for the environment must be available.

• Recommendation: Create a snapshot/backup of the current DB data.

Process for context DB migration

Access MongoDB console

To access and open MongoDB console we can use the kubectl command below to export the intended environment, with MongoDB adminuser password. Use the right environment and database name in the commands.

$ export ATLAS_DEPLOYMENT_NAME=aura-br-pro-70 # Get from kubectl get -n aura-system atlasdeployments.atlas.mongodb.com
$ export ATLAS_DATABASE_NAME=aura-groot-br-pro # Set with the correct DB of your deployment
$ export MONGODB_USER=$(kubectl get -n aura-system atlasdatabaseusers.atlas.mongodb.com mongodb-adminuser-password -o jsonpath='{.spec.username}')
$ export MONGODB_PASSWORD=$(kubectl get -n aura-system secret mongodb-adminuser-password -o go-template='{{ .data.password | base64decode }}')
$ export MONGODB_URI="$(kubectl get -n aura-system atlasdeployments.atlas.mongodb.com $ATLAS_DEPLOYMENT_NAME -o jsonpath='{.status.connectionStrings.standardSrv}'|sed "s|srv://|srv://$MONGODB_USER:$MONGODB_PASSWORD@|g")/${ATLAS_DATABASE_NAME}"
$ kubectl -n aura-system run fix-script -i -q --rm --restart=Never --image=mongo:latest --command mongosh ${MONGODB_URI}

Migrate aura-bot context collection to new schema

• Update documents to the new format:

  > db["aura-context"].updateMany(
        {
          document: {
            $exists: true
          }
        },
        [
          {
            $set: {
              eTag: "$document.eTag",
              conversationData: { $mergeObjects: ["$conversationData", "$document.conversationData"] },
              dialogState: { $mergeObjects: ["$dialogState", "$document.dialogState"] },
              userData: { $mergeObjects: ["$userData", "$document.userData"] },
              userAuthData: { $mergeObjects: ["$userAuthData", "$document.userAuthData"] }
            }
          },
          { $unset: "document" }
        ]
      );
  

Migrate aura-groot context collection to new schema

• Update documents to the new format:

  > db["aura-context"].updateMany(
        {
          document: {
            $exists: true
          }
        },
        [
          {
            $set: {
              eTag: "$document.eTag",
              activeSkill: { $mergeObjects: ["$activeSkill", "$document.activeSkill"] },
              conversationHistory: { $concatArrays: [{ $ifNull: ["$conversationHistory", []] }, { $ifNull: ["$document.conversationHistory", []] }] },
              conversationDataProperty: { $mergeObjects: ["$conversationDataProperty", "$document.conversationDataProperty"] },
              dialogContext: { $concatArrays: [{ $ifNull: ["$dialogContext", []] }, { $ifNull: ["$document.dialogContext", []] }] },
              skillConversationReference: { $mergeObjects: ["$skillConversationReference", "$document.skillConversationReference"] }
            }
          },
          { $unset: "document" }
        ]
      );
  

Rollback aura-bot to the previous schema

• If a rollback is needed, documents should be modified to have the previous schema and maintain the users’ context data:

  > db["aura-context"].updateMany(
        {},
        [
          {
            $set: {
              document: {
                eTag: "$eTag",
                conversationData: { $mergeObjects: ["$document.conversationData", "$conversationData"] },
                dialogState: { $mergeObjects: ["$document.dialogState", "$dialogState"] },
                userData: { $mergeObjects: ["$document.userData", "$userData"] },
                userAuthData: { $mergeObjects: ["$document.userAuthData", "$userAuthData"] }
              }
            }
          },
          {
            $unset: [ "eTag", "conversationData", "dialogState", "userData", "userAuthData"]
          }
        ]
      );
  

Rollback aura-groot to the previous schema

• If a rollback is needed, documents should be modified to have the previous schema and maintain the users’ context data:

  > db["aura-context"].updateMany(
        {},
        [
          {
            $set: {
              document: {
                eTag: "$eTag",
                activeSkill: { $mergeObjects: ["$document.activeSkill", "$activeSkill"] },
                conversationHistory: { $concatArrays: [{ $ifNull: ["$document.conversationHistory", []] }, { $ifNull: ["$conversationHistory", []] }] },
                conversationDataProperty: { $mergeObjects: ["$document.conversationDataProperty", "$conversationDataProperty"] },
                dialogContext: { $concatArrays: [{ $ifNull: ["$document.dialogContext", []] }, { $ifNull: ["$dialogContext", []] }] },
                skillConversationReference: { $mergeObjects: ["$document.skillConversationReference", "$skillConversationReference"] }
              }
            }
          },
          {
            $unset: [ "eTag", "activeSkill", "conversationHistory", "conversationDataProperty", "dialogContext", "skillConversationReference"]
          }
        ]
      );