Hello. :raised_hand: Is there a way to `delete` an...
# orm-help
s
Hello. āœ‹ Is there a way to
delete
an item from the
db
and
update
all the other items in one
action
? I'm trying to do this:
Copy code
js
 await db.task.delete({
        where: {
          id: taskToDeleteId,
        },
      });
      for (let i = 0; i < fixedTasks.length; i++) {
        db.task.update({
          where: {
            id: fixedTasks[i].id,
          },
          data: {
            id: fixedTasks[i].id,
            name: fixedTasks[i].name,
            position: parseInt(fixedTasks[i].position),
            isCompleted: fixedTasks[i].isCompleted,
          },
        });
      }
I'm getting an error:
Copy code
Error: 
Invalid `db.task.delete()` invocation in
/Users/sb/Dev/my-remix-dnd/build/index.js:542:27

   539   }
   540   break;
   541 case "delete":
→  542   await db.task.delete(
  Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: ConnectionError(Timed out during query execution.) })
    at cb (/Users/sb/Dev/my-remix-dnd/node_modules/@prisma/client/runtime/index.js:38692:17)
    at async action (/Users/sb/Dev/my-remix-dnd/build/index.js:542:7)
    at async Object.callRouteAction (/Users/sb/Dev/my-remix-dnd/node_modules/@remix-run/server-runtime/data.js:36:14)
    at async handleDataRequest (/Users/sb/Dev/my-remix-dnd/node_modules/@remix-run/server-runtime/server.js:110:18)
    at async requestHandler (/Users/sb/Dev/my-remix-dnd/node_modules/@remix-run/server-runtime/server.js:45:20)
    at async /Users/sb/Dev/my-remix-dnd/node_modules/@remix-run/express/server.js:45:22
Thank you!