overleaf/tools/migrations/20220105123000_cleanup_unused_collections.mjs

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

const tags = ['saas']

const unusedCollections = [
  'collaberatorcount',
  'db.subscriptions',
  'projectsDeletedByMigration',
  'readonlycount',
  'samllog',
  'sharelatex-production.docOps.2013-12-17T02-26-49.0',
  'sharelatex-production.projects.2013-12-17T02-26-49.1',
  'sharelatex-production.users.2013-12-17T02-26-49.2',
  'sharelatex_production.users',
  'totalwords',
  'user',
  'usersDeletedByMigration',
  'usersEmailDomains',
]

const migrate = async () => {
  for (const name of unusedCollections) {
    await Helpers.dropCollection(name)
  }
}

const rollback = async () => {
  // We lost the indexes. There is no way back.
}

export default {
  tags,
  migrate,
  rollback,
}