Transactions

πŸ‘¨β€πŸ’Ό Whoops! So we've got an issue. If one of the steps in our multi-step process to update a note fails, we'll end up with a halfway updated note. This is problematic for our situation, but it could be worse (like in the banking example we had in the introduction to this exercise).
As a reminder, here's the example of prisma's transaction API:
await prisma.$transaction(async $prisma => {
	await $prisma.rocket.update({
		where: { id: 1 },
		data: { name: 'Falcon 9' },
	})
	await $prisma.rocket.update({
		where: { id: 2 },
		data: { name: 'Falcon Heavy' },
	})
})
With that, you should have enough to get going! Let's put all of these note update steps in a single transaction.
πŸ§β€β™‚οΈ If you'd like to test things out, I left a comment in there for an error. With that error, you should be able to update a note and get deleted images, but no new images or updated images. Your job is to make it so it all succeeds or fails together.
Login to get access to the exclusive discord channel.
  • general
    Welcome to EpicWeb.dev! Say Hello πŸ‘‹
    Kent C. Dodds β—† πŸš€πŸ†πŸŒŒ:
    This is the first post of many hopefully!
    • 18
    81 Β· a month ago
  • πŸ’Ύdata
    How often do you need to run a migration?
    Scott 🌌 πŸ†:
    I just finished the Data Migrations workshop (I come from a No-SQL background). Let's say I add a n...
    • βœ…1
    1 Β· a month ago
  • general
    npm install everytime I setup a new playground
    Duki 🌌:
    Is it normal that I have to run `npm install` in my playground directory, everytime I setup the play...
    • βœ…1
    2 Β· 2 months ago
  • πŸ’Ύdata
    Code snippets in workshop app
    remich 🌌:
    What is used to include the code snippets in the workshop app? I'd like to have syntax-highlighted P...
    • βœ…1
    1 Β· 3 months ago
  • πŸ’Ύdata
    a very large insert
    osmancakir πŸš€ 🌌:
    hi all, I need to perform seeding to my deployment. I followed the steps in the database documentati...
    • βœ…1
    2 Β· 7 months ago
  • πŸ’Ύdata
    πŸ“forms
    πŸ”­foundations
    Reviewing foundations, Mutations, Actions
    silvanet πŸš€ 🌌:
    Forgive me for this. I went over the file size limit. I don't want to sign up for being able to exce...
    • βœ…1
    2 Β· 7 months ago
  • general
    Migration to Vite: Server-only module referenced by client
    Fabian 🌌:
    Hi, I'm working on migrating to Vite following the remix docs (https://remix.run/docs/en/main/guides...
    • βœ…1
    1 Β· 4 months ago
  • πŸ’Ύdata
    Undesired behaviors while running the data-modeling workshop
    juliano.brasil 🌌:
    After pulling the latest updates I started experiencing 2 undesired behaviors while running the wor...
    • βœ…1
    2 Β· 6 months ago
  • πŸ’Ύdata
    πŸ“forms
    Getting a TS error that is not present in the course files
    OtterlyPunk:
    So I'm working in parallel and I'm feeling the problem is I'm using a new version of something in my...
    • βœ…2
    12 Β· 9 months ago
  • general
    Remix Vite Plugin
    Binalfew πŸš€ 🌌:
    <@105755735731781632> Now that remix officially supports vite (though not stable) what does it mean...
    • βœ…1
    3 Β· a year ago
  • πŸ’Ύdata
    Prisma Typed SQL
    Kent C. Dodds β—† πŸš€πŸ†πŸŒŒ:
    Hey <@&1123674184959148043> friends, check out the new Typed SQL feature in Prisma! I've added an ex...
    • 2
    • 2
    0 Β· 4 months ago
  • general
    πŸ”­foundations
    Solutions video on localhost:5639 ?
    quang πŸš€ 🌌:
    Hi, so I'm having a hard time navigating (hopefully will be better with time) The nav on epicweb.de...
    • βœ…1
    9 Β· a year ago
  • πŸ’Ύdata
    Multi-Column Index - How does it eliminate the B-tree?
    Darren πŸš€ 🌌:
    So I just finished the Query Optimization - 02 Multi-Column Index lesson and was confused by the fol...
    • βœ…1
    2 Β· 6 months ago
  • general
    Epicshop is now social and mobile friendly!
    Kent C. Dodds β—† πŸš€πŸ†πŸŒŒ:
    I'm excited to announce that now the Epic Web workshops are mobile friendly! https://foundations.ep...
    • πŸŽ‰2
    0 Β· 6 months ago
  • πŸ’Ύdata
    πŸ“forms
    πŸ”­foundations
    How can I do this?
    silvanet πŸš€ 🌌:
    Viewing the Intro (from the Workshop) for Mutations, the course has an embedded video where Kent exp...
    • βœ…1
    3 Β· 7 months ago
  • πŸ’Ύdata
    Query optimization for queries generated by prisma
    Allan 🌌:
    Hi everyone! I finished the data modeling workshop this week and was inspired to do some query optim...
    • βœ…1
    2 Β· 7 months ago
  • πŸ’Ύdata
    general
    πŸ“forms
    πŸ”­foundations
    double underscore?
    trendaaang 🌌:
    What with the `__note-editor.tsx`? I don't see that in the Remix docs and I don't remember Kent talk...
    • βœ…1
    2 Β· 7 months ago
  • πŸ”auth
    πŸ’Ύdata
    08. ROLE-BASED ACCESS / 02. ROLES SEED - migration to local vs production
    Fabian 🌌:
    So I'm in a bit over my head with this one, in particular with how migration works in a local env vs...
    • βœ…1
    1 Β· 7 months ago
  • πŸ’Ύdata
    data modeling 06/02 is missing part of the prompt
    Allan 🌌:
    In Data Modeling 06/02 the files include `server/index.ts` but there are no guiding emojis, no promp...
    • βœ…1
    2 Β· 8 months ago
  • πŸ’Ύdata
    Why does TS not like Buffer being used when the return type of the blob appears to be Buffer?
    OtterlyPunk:
    I'm looking at the return types from Prisma and it appears that the `petImage.blob` is a `Buffer` ty...
    • βœ…2
    5 Β· 8 months ago
  • πŸ’Ύdata
    πŸ”auth
    Prisma batching in the Require Authorized (07/03/solution)
    ajara 🌌 πŸš€:
    When I did the `requireUser` function in `auth.server.ts` I thought about using `requireUserId` func...
    • βœ…1
    4 Β· 8 months ago
  • πŸ’Ύdata
    πŸ”­foundations
    Handle Missing Data - Error when i'm using invariantResponse
    Luan.ibarra 🌌:
    Hello, I'm trying to use the invariantResponse utility from // "#app/utils/misc.ts" to do this in a...
    • βœ…2
    2 Β· 8 months ago
  • πŸ’Ύdata
    Data Modeling: a real world scenario
    trendaaang 🌌:
    Kent, In the data modeling workshop, you mentioned that polymorphism is generally a bad idea in dat...
    • βœ…1
    3 Β· 9 months ago
  • πŸ”­foundations
    πŸ’Ύdata
    general
    πŸ“forms
    πŸ”auth
    Native Logging
    trendaaang 🌌:
    I was thinking that it could be useful to log every CRUD operation to help track down errors. Is tha...
    • βœ…1
    6 Β· 8 months ago