overleaf-cep/services/web/migrations/20250116090001_deletedUsers_non_expired_index.mjs
Jakob Ackermann 087c41190e [web] switch query for hard-deleting users and add index (#22920)
* [web] switch query for hard-deleting users and add index

Co-authored-by: Dr. Sasha Göbbels <sasha.goebbels@overleaf.com>

* [web] fix unit tests

---------

Co-authored-by: Dr. Sasha Göbbels <sasha.goebbels@overleaf.com>
GitOrigin-RevId: a7fd2a590351d2e0d60c0032ca78d457ef815e41
2025-03-11 09:05:04 +00:00

29 lines
660 B
JavaScript

import Helpers from './lib/helpers.mjs'
const tags = ['server-ce', 'server-pro', 'saas']
const index = {
key: { 'deleterData.deletedAt': 1 },
partialFilterExpression: { user: { $type: 'object' } },
name: 'deleterData_deletedAt_user_1',
}
const migrate = async client => {
const { db } = client
await Helpers.addIndexesToCollection(db.deletedUsers, [index])
}
const rollback = async client => {
const { db } = client
try {
await Helpers.dropIndexesFromCollection(db.deletedUsers, [index])
} catch (err) {
console.error('Something went wrong rolling back the migrations', err)
}
}
export default {
tags,
migrate,
rollback,
}