Syncing data from clerk sign up to database

rafaelsilva81 · 2024-01-05T21:16:54.200Z

Is there a way of syncing new user sign ups on a "User" table on a database without using webhooks?

C

Circus•1/6/24, 2:26 AM

I asked this in the Clerk channel and they're adamant on using webhooks for this. I found that process to be very draining and incondite and wish this was simpler.
(Going to follow this thread to see other answers though)

CCircus I asked this in the Clerk channel and they're adamant on using webhooks for this...

D

DiamondDragon•1/6/24, 3:46 PM

Yeah it took me much longer to get the we hooks all setup. I'm syncing three tables myself

V

vibbin•1/6/24, 4:28 PM

I've created a function in my utils folder that I call in my /onboarding page (server component)

V

vibbin•1/6/24, 4:28 PM

export async function syncUser() {

  const clerkUser = await currentUser();

  if (!clerkUser?.id) {
    return null;
  }

  try {
    let user = await db.user.findUnique({
      where: {
        clerkId: clerkUser.id as string,
      },
    });

    if (!user) {
      user = await db.user.create({
        data: {
          clerkId: clerkUser.id,
          name: clerkUser.firstName,
          email: clerkUser.emailAddresses?.[0]?.emailAddress,
          image: clerkUser.imageUrl,
          levels: {
            create: { level: 1, xp: 0 },
          },
        },
      });
    }

    return user;
  } catch (error) {
    console.error('Error syncing user:', error);
    return null;
  }
}

export async function syncUser() {

  const clerkUser = await currentUser();

  if (!clerkUser?.id) {
    return null;
  }

  try {
    let user = await db.user.findUnique({
      where: {
        clerkId: clerkUser.id as string,
      },
    });

    if (!user) {
      user = await db.user.create({
        data: {
          clerkId: clerkUser.id,
          name: clerkUser.firstName,
          email: clerkUser.emailAddresses?.[0]?.emailAddress,
          image: clerkUser.imageUrl,
          levels: {
            create: { level: 1, xp: 0 },
          },
        },
      });
    }

    return user;
  } catch (error) {
    console.error('Error syncing user:', error);
    return null;
  }
}

export async function syncUser() {

  const clerkUser = await currentUser();

  if (!clerkUser?.id) {
    return null;
  }

  try {
    let user = await db.user.findUnique({
      where: {
        clerkId: clerkUser.id as string,
      },
    });

    if (!user) {
      user = await db.user.create({
        data: {
          clerkId: clerkUser.id,
          name: clerkUser.firstName,
          email: clerkUser.emailAddresses?.[0]?.emailAddress,
          image: clerkUser.imageUrl,
          levels: {
            create: { level: 1, xp: 0 },
          },
        },
      });
    }

    return user;
  } catch (error) {
    console.error('Error syncing user:', error);
    return null;
  }
}

export async function syncUser() {

  const clerkUser = await currentUser();

  if (!clerkUser?.id) {
    return null;
  }

  try {
    let user = await db.user.findUnique({
      where: {
        clerkId: clerkUser.id as string,
      },
    });

    if (!user) {
      user = await db.user.create({
        data: {
          clerkId: clerkUser.id,
          name: clerkUser.firstName,
          email: clerkUser.emailAddresses?.[0]?.emailAddress,
          image: clerkUser.imageUrl,
          levels: {
            create: { level: 1, xp: 0 },
          },
        },
      });
    }

    return user;
  } catch (error) {
    console.error('Error syncing user:', error);
    return null;
  }
}

Vvibbin ```export async function syncUser() { const clerkUser = await currentUser(); ...

R

rafaelsilva81OP•1/7/24, 7:40 PM

i thought about something like that initially, but i figured maybe there was some other way

but I think this is what ill end up doing, thanks!

M

mardo•2/13/24, 1:07 AM

I call their getUser on the API and then load my database each time they come into my application.

Syncing data from clerk sign up to database

Similar Threads

Similar Threads

Similar Threads