I'm trying to persist relational data in myql database with typeORM and nestjs but it's showing an error apparently in the database
Entity:
@ManyToMany(()=> Stock, stock => stock.seals)
@JoinTable()
stock: Stock[];
Service:
var c = getConnection().getRepository(Seals).save(createSealDto)
return c
Error:
ERROR [ExceptionsHandler] Cannot add or update a child row: a foreign key constraint fails (
stocksystem
.stock_seals_seals
, CONSTRAINTFK_70140d58e95fbceed988b224e64
FOREIGN KEY (stockId
) REFERENCESstock
(id
) ON DELETE CASCADE ON UPDATE CASCADE)
Payload:
{"client":{"id":1},"stock":[{"id":1},{"id":1}],"price":398}