foreign key constraint

[jagoanmamah]

[jorgebodega]

Sorry, I cannot work just with an image without any context.

Please, try to create a reproducible example in a repo, or at least, a decent amount of code.

[viki53]

Hi, I'm having a similar error when using subscribers and factories. Here's some stripped-down code to give an idea of how it works.

Basically I have a main entity:

@Entity()
class Ticket extends BaseEntity {
  // [...]
  @OneToMany(() => TicketEvent, (event) => event.ticket)
  events?: TicketEvent[];
  // [...]
}

A matching factory:

export class TicketFactory extends Factory<Ticket> {
  protected entity = Ticket;
  protected dataSource = dataSource;

  protected attrs(): FactorizedAttrs<Ticket> {
    return {
      id: randomUUID(),
      /* Other attributes, not related to sub-entity */
    }
  }
}

A sub-entity (mostly generated entries):

@Entity()
class TicketEvent extends BaseEntity {
  // [...]
  @Index()
  @Column({
    nullable: false,
  })
  ticketId!: Ticket['id'];
  // [...]
}

And I have a subscriber on the main entity that creates the sub-entity after insert:

@EventSubscriber()
export class TicketSubscriber implements EntitySubscriberInterface<Ticket> {
  constructor(
    @InjectDataSource()
    readonly dataSource: DataSource,
  ) {
    dataSource.subscribers.push(this);
  }
  listenTo() {
    return Ticket;
  }

  async afterInsert(event: InsertEvent<Ticket>): Promise<void> {
    const { manager, entity: ticket } = event;

    await manager
      .create(TicketEvent, {
        ticketId: ticket.id,
        /* Other internal attributes */
      })
      .save({
        data: { /* Some internal data */ },
      });
  }
}

And when running my e2e tests it triggers this SQL error:

QueryFailedError: insert or update on table "ticket_event" violates foreign key constraint "FK_xxxxxxxxxxxxxxxxxxxxxx"

The code looks like this:

const ticket = await new TicketFactory().create({
  /* Some entity attributes, possibly including an EagerInstanceAttribute (other relationship to a different parent entity that may) if that's of any incidence */
});` 

It this related to how we use the subscriber (I know it's not the updated way of doing it directly via an attribute on the Entity)? Or maybe the manager isn't awaiting properly between the subscriber and the factory?

Let me know if any more info can be helpful.

[viki53]

Nevermind, this was related to my use of the manager in the subscriber:

Replacing manager.create(TicketEvent, {}).save() by manager.save({}) fixed the issue (I guess TypeORM doesn't keep the transaction when returning from create 👌