Overleaf/tools/migrations/20230428154643_history_chunks_garbage_collection_index.mjs

/* eslint-disable no-unused-vars */

import Helpers from './lib/helpers.mjs'

const tags = ['server-ce', 'server-pro', 'saas']

const oldIndexes = [
  {
    key: {
      state: 1,
    },
    name: 'state_1',
    partialFilterExpression: {
      state: 'deleted',
    },
  },
  {
    key: {
      state: -1,
    },
    name: 'state_pending',
    partialFilterExpression: {
      state: 'pending',
    },
  },
]
const newIndexes = [
  {
    key: {
      updatedAt: 1,
    },
    name: 'deleted_updated_at',
    partialFilterExpression: {
      state: 'deleted',
    },
  },
  {
    key: {
      updatedAt: -1,
    },
    name: 'pending_updated_at',
    partialFilterExpression: {
      state: 'pending',
    },
  },
]

const migrate = async client => {
  const { db } = client
  await Helpers.addIndexesToCollection(db.projectHistoryChunks, newIndexes)
  await Helpers.dropIndexesFromCollection(db.projectHistoryChunks, oldIndexes)
}

const rollback = async client => {
  const { db } = client
  await Helpers.addIndexesToCollection(db.projectHistoryChunks, oldIndexes)
  await Helpers.dropIndexesFromCollection(db.projectHistoryChunks, newIndexes)
}

export default {
  tags,
  migrate,
  rollback,
}