Function delete_

apps/app-server/src/trpc/api/users/account/delete.ts:29–230

({
  ctx,
  input,
}: InferProcedureOpts<typeof baseProcedure>)

export const deleteProcedure = once(() => baseProcedure.mutation(delete_));

export async function delete_({
  ctx,
  input,
}: InferProcedureOpts<typeof baseProcedure>) {
  return await ctx.usingLocks(
    [[`user-lock:${ctx.userId}`]],
    async (signals) => {
      return await ctx.dataAbstraction.transaction(async (dtrx) => {
        // Assert correct password

        await ctx.assertCorrectUserPassword({
          userId: ctx.userId,
          loginHash: input.loginHash,
        });

        // Check if any group has more than one member

        const memberships = await GroupMemberModel.query(dtrx.trx)
          .where('group_members.user_id', ctx.userId)
          .leftJoin(
            GroupMemberModel.query(dtrx.trx)
              .groupBy('group_id')
              .select('group_id')
              .count('* as member_count')
              .as('member_counts'),
            'group_members.group_id',
            'member_counts.group_id',
          )
          .leftJoin(
            GroupMemberModel.query(dtrx.trx)
              .where('role', 'owner')
              .groupBy('group_id')
              .select('group_id')
              .count('* as owner_count')
              .as('owner_counts'),
            'group_members.group_id',
            'owner_counts.group_id',
          )
          .select(
            'group_members.group_id',
            raw('COALESCE(member_counts.member_count, 0) as member_count'),
            raw('COALESCE(owner_counts.owner_count, 0) as owner_count'),
          );

        if (
          memberships.some(
            (count) =>
              (count as any).member_count > 1 &&
              (count as any).owner_count <= 1,
          )
        ) {
          throw new TRPCError({
            message:
              'Some groups would be left without an owner. Transfer ownership before deleting your account.',
            code: 'BAD_REQUEST',
          });
        }