import { User } from 'nexus-plugin-prisma/client' import { prismaClient as prisma } from '../../prismaClient' prisma.user.findMany().then(async (users: User[]) => { console.log(`Processing ${users.length} users`) for await (const user of users) { if (user.email) { const lowerCaseEmail = user.email?.toLowerCase()?.trim() if (lowerCaseEmail !== user.email) { console.log('new lowerCaseEmail', lowerCaseEmail) await prisma.user.update({ where: { id: user.id, }, data: { email: lowerCaseEmail.trim(), }, }) } } } console.log('Finished') })