Hi everyone, good day.
Please I am getting a
`For...
# orm-helpn
Nathaniel Babalola
02/01/2022, 12:32 PMHi everyone, good day.
Please I am getting a
Foreign key constraint failed on the field: transactions_senderId_fkey (index) Copy code
model user {
id Int @id @default(autoincrement())
email String @unique
password String
tokens String[]
created_at DateTime @default(now())
updated_at DateTime @updatedAt()
account account?
}
model account {
accNumber Int @id @default(autoincrement())
balance Float
user user @relation(fields: [userId], references: [id], onDelete: Cascade, onUpdate: Cascade)
userId Int @unique
Sender transactions[] @relation("sender")
Receiver transactions[] @relation("receiver")
created_at DateTime @default(now())
updated_at DateTime @updatedAt()
}
model transactions {
id Int @id @default(autoincrement())
txRef String @unique
amount Float
refundRef String? @unique // this will reference a txRef column of a transaction whenn it is a refund
from account @relation("sender", fields: [senderId], references: [accNumber])
senderId Int
to account @relation("receiver", fields: [receiverId], references: [accNumber])
receiverId Int
created_at DateTime @default(now())
updated_at DateTime @updatedAt()
}Nathaniel Babalola
02/01/2022, 12:34 PM@Nurul hi , thanks for the help. But see the problem I'm facing. Any idea why that field has a unique constraint on senderId , meanwhile I have never gotten that error on receiverId .
Your help will be greatly appreciated
👀 1
n
Nurul
02/01/2022, 12:53 PMCan you share the insert query which you are trying to execute?
Nurul
02/01/2022, 1:01 PMAre you passing
fromprisma.transactions.createn
Nathaniel Babalola
02/01/2022, 1:03 PM@Nurul yes I am, I'm running in tests and in a beforeEach I wipe the db and create new users with their account and two new transactions between the users .
Nathaniel Babalola
02/01/2022, 1:05 PMHere's my query
beforeEach(async () => {
//jest.resetModules();
userOne = {
email: 'babs@gmail.com',
password: 'nathaniel',
account: {
create: {
balance: 100000.00
}
}
}
userTwo = {
email: 'babalola@gmail.com',
password: 'nathaniel',
account: {
create: {
balance: 100000.00
}
}
}
const txDelete = prisma.transactions.deleteMany();
const accDelete = prisma.account.deleteMany();
const userDelete = prisma.user.deleteMany();
const deleteM = await prisma.$transaction([txDelete, accDelete, userDelete]);
console.log(deleteM);
userOneCreate = await prisma.user.create({
data: userOne,
include: {
account: true
}
});
userTwoCreate = await prisma.user.create({
data: userTwo,
include: {
account: true
}
});
token = await generateToken(userOneCreate);
tx = await prisma.transactions.createMany({
data: [
{
amount: 2000,
receiverId: userTwoCreate.id,
senderId: userOneCreate.id,
txRef: nanoid(12)
},
{
amount: 5000,
receiverId: userOneCreate.id,
senderId: userTwoCreate.id,
txRef: nanoid(12)
}
]
})
});
n
Nurul
02/01/2022, 1:21 PMI think you are passing userId in
receiverIdsenderIdsenderreceiver✅ 1
Nurul
02/01/2022, 1:23 PMIf you want to store userId’s then in your transactions schema
fromtouseraccountn
Nathaniel Babalola
02/01/2022, 1:49 PM@Nurul damn, that's true. Totally my fault 🤦🏾♂️.
Nathaniel Babalola
02/01/2022, 1:50 PMThanks a lot
💯 1
n
Nurul
02/01/2022, 1:53 PMNo worries! Glad that I could help 👍
3 Views