pfp_seed.js

const { PrismaClient } = require("@prisma/client");
const { clerkClient } = require("@clerk/nextjs");

const prisma = new PrismaClient();

async function updateImageUrls() {
  const dbUsers = await clerkClient.users.getUserList({
    limit: 250,
  });

  try {
    for (const dbUser of dbUsers) {
      if (dbUser.imageUrl) {
        await prisma.user.update({
          where: {
            id: dbUser.id,
          },
          data: {
            imageUrl: dbUser.imageUrl,
          },
        });
        console.log(`Updated image URL for user ${dbUser.firstName} ${dbUser.lastName}.`);
      }
    }

    console.log("Image URLs updated successfully.");
  } catch (error) {
    console.error("Error updating image URLs:", error);
  } finally {
    await prisma.$disconnect();
  }
}

(async () => {
  await updateImageUrls();
})();