Function deleteUser

apps/manager/src/index.ts:117–289

(userId: string)

}

async function deleteUser(userId: string) {
  await dataAbstraction().transaction(async (dtrx) => {
    // Check if any group has more than one member

    const memberships = await GroupMemberModel.query(dtrx.trx)
      .where('group_members.user_id', 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 {
        message:
          'Some groups would be left without an owner. Transfer ownership before deleting your account.',
        code: 'BAD_REQUEST',
      };
    }

    const idsOfGroupsToDelete = memberships
      .filter((membership) => (membership as any).member_count <= 1)
      .map((membership) => membership.group_id);

    // Get all user data

    const [
      groupPageIds,
      invitations,
      requests,
      visitedPageIds,
      sessions,
      user,
    ] = await Promise.all([