How to perform non updating upserts in Prisma


How the upsert query works in Prisma

28 Oct, 2021 ยท 2 min read

In our example yesterday, we are pushing specific playlists to our database. However, if we add a playlist twice, we will see that the URI is not unique and exists already.

There are several ways to go about this. And for this example, I want to look at doing a non-updating upsert.

This means we check if the URI already exists. If this is the case, we perform an update. If it doesn't exist, we perform the creation.

The small caveat here is that we push an empty update object.

This will result in the API returning the old existing object without updating it.

Upsert in Prisma

You can use the upsert command to perform an upsert in Prisma. It takes a where a query that should query on a unique field.

Then it comes with both the update and creates functions like so:

const playlist = await prisma.playlist.upsert({
  where: {
    uri: uri,
  update: {},
  create: playlistItem,

And there you go. This gives us a super good way only to create this if it doesn't exist functionality.

You can find the complete example based on the Spotify database on GitHub.

Thank you for reading, and let's connect!

Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter

Spread the knowledge with fellow developers on Twitter
Tweet this tip
Powered by Webmentions - Learn more

Read next ๐Ÿ“–

Adding Prisma to Remix

26 Apr, 2022 ยท 2 min read

Adding Prisma to Remix

CRUD operations with Prisma and Fastify

19 Jan, 2022 ยท 6 min read

CRUD operations with Prisma and Fastify

Join 2101 devs and subscribe to my newsletter