I have two interconnected models, I'll oversimplify them:

model Wallet {
  user User
  balance Int
  transactions Transaction[] 
}

model Transaction {
  id Int 
  change Int
  wallet Wallet 
}

and now, I want to make a query that: creates a Transaction and increments the connected

wallet.balance

by the

change

, but I have no idea if it's even possible.

Hey Hubert, thanks for your question! This should work with a nested query starting at

prisma.wallet

like so:

const walletId = 42
const changeValue = 100
const updatedWallet = await prisma.wallet.update({
  where: {
    id: walletId
  },
  data: {
    balance: {
      increment: changeValue
    },
    transactions: {
      create: {
        change: changeValue
      }
    }
  }
})

Ok, that seems reasonable. Thank you 🙇

Hope this works, let me know if you have any further questions 😄

@nikolasburk and considering such models:

model Wallet {
  user User
  balance Int
  incomingTransactions Transaction[] @relation("incomingTransaction")
  outgoingTransactions Transaction[] @relation("outgoingTransaction")
}

model Transaction {
  id Int 
  change Int
  toWallet Wallet @relation(name: "incomingTransaction")
  fromWallet Wallet? @relation(name: "outgoingTransaction")
}

how can I create a query that creates a Transaction and: 1. decrements balance of fromWallet by

change

if specified 2. increments balance of toWallet by

change

3. and actually returns Transaction