Using pipe.resolver for consecutive mutations

[spidertwin2]

As I understand, pipe.resolver should only be used if there are cascading queries/mutations to be performed in one function. For a simple name update in User model, or query to read name field, it shouldn't be used?

Also, how should I rewrite my mutation below to use pipe.resolver?

updateLocation.ts

type LocationProps = Omit<Location, "id">

export default async function updateLocation(location: LocationProps, ctx: Ctx) {
  ctx.session.$authorize

  if (!ctx.session.userId) return null

  console.log("Location to update: ", location)

  try {
    const updateOrCreateLocation = await db.location.upsert({
      where: {
        label: location.label,
      },
      update: {},
      create: {
        name: location.name,
        label: location.label,
        locality: location?.locality,
        region: location?.region,
        country: location?.country,
      },
    })

    const updatedLocation = await db.user.update({
      where: {
        id: ctx.session.userId,
      },
      data: {
        profile: {
          update: {
            locationId: updateOrCreateLocation.id,
          },
        },
      },
      select: {
        id: true,
        profile: true,
      },
    })

    console.log("updatedLocation: ", updatedLocation)

    return updateOrCreateLocation
  } catch (error) {
    console.log("Error while updating your location: ", error)
  }
}

maybe something like this..

const UpdateLocation = z.object({
  name: z.string(),
  label: z.string(),
  locality: z.string().optional(),
  country: z.string().optional(),
  region: z.string().optional(),
})

export default resolver.pipe(
  resolver.zod(UpdateLocation),
  resolver.authorize(),
  (location, ctx) => ({
    // should db.location.upsert go here?
    // can trycatch be used?
  }),
  async (updatedLocation, ctx) => {
    // should db.user.update go here?
  }
)

Thanks 🍒

[flybayer]

For a simple name update in User model, or query to read name field, it shouldn't be used?

Not sure if I totally understand, but sounds like you can use resolver.pipe for this without any issue.

[flybayer]

Also, how should I rewrite my mutation below to use pipe.resolver?

You can put all your code in a single function like below.

Really the only reason to add extra functions is if you want to easily share certain functions among multiple resolvers (like .zod and .authorize)

const UpdateLocation = z.object({
  name: z.string(),
  label: z.string(),
  locality: z.string().optional(),
  country: z.string().optional(),
  region: z.string().optional(),
})

export default resolver.pipe(
  resolver.zod(UpdateLocation),
  resolver.authorize(),
  async (location, ctx) => {
    try {
      const updateOrCreateLocation = await db.location.upsert({
        where: {
          label: location.label,
        },
        update: {},
        create: {
          name: location.name,
          label: location.label,
          locality: location?.locality,
          region: location?.region,
          country: location?.country,
        },
      })

      const updatedLocation = await db.user.update({
        where: {
          id: ctx.session.userId,
        },
        data: {
          profile: {
           update: {
              locationId: updateOrCreateLocation.id,
            },
          },
       },
        select: {
          id: true,
          profile: true,
        },
      })

      console.log("updatedLocation: ", updatedLocation)

      return updateOrCreateLocation
    } catch (error) {
      console.log("Error while updating your location: ", error)
    }
  }
)

[spidertwin2]

awesome! thanks @flybayer

🦕