overleaf/tools/migrations/20260601160305_unset_stripe_subscription_id_from_recurly_field.mjs

import { db } from './lib/mongodb.mjs'

const tags = ['saas']

const migrate = async () => {
  const result = await db.subscriptions.updateMany(
    {
      recurlySubscription_id: /^sub_/,
      $expr: {
        $eq: ['$recurlySubscription_id', '$paymentProvider.subscriptionId'],
      },
    },
    { $unset: { recurlySubscription_id: '' } }
  )
  console.log(
    `Updated ${result.modifiedCount} subscriptions (matched ${result.matchedCount}).`
  )
}

const rollback = async () => {}

export default {
  tags,
  migrate,
  rollback,
}