Company logo
  • Empleos
  • Bootcamp
  • Acerca de nosotros
  • Para profesionales
    • Inicio
    • Empleos
    • Cursos y retos
    • Preguntas
    • Profesores
    • Bootcamp
  • Para empresas
    • Inicio
    • Nuestro proceso
    • Planes
    • Pruebas
    • Nómina
    • Blog
    • Comercial
    • Calculadora

0

29
Vistas
Error when inserting into relational table many to many

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, CONSTRAINT FK_70140d58e95fbceed988b224e64 FOREIGN KEY (stockId) REFERENCES stock (id) ON DELETE CASCADE ON UPDATE CASCADE)

Payload:

{"client":{"id":1},"stock":[{"id":1},{"id":1}],"price":398}

7 months ago · Juan Pablo Isaza
Responde la pregunta
Encuentra empleos remotos