Using TypeORM to update a relation and set it to NULL

Question

Using TypeORM to update a relation and set it to NULL

My challenge involves managing this specific Entity

@Entity({ name: 'orders' })
export class Order {
 ...

  @ManyToOne(() => BulkOrder, (bulkOrder) => bulkOrder.orders)
  bulkOrder?: BulkOrder
}

In my update process, I am attempting to reset the relation to null

.createQueryBuilder()
.update(Order)
.set({ status: OrderStatus.OPEN, bulkOrder: undefined }).
where(...).execute()

However, it seems that the bulkOrder field is not being updated correctly, as indicated by the generated query

query: UPDATE "orders" SET "status" = $1, "updated_at" = CURRENT_TIMESTAMP WHERE ("id" IN ($2, $3) ...

Is there a way to successfully set the relation to null? While I understand I could manually set it to null and save the entity, using a query builder is necessary in order to avoid updating unintended records

sql typescript typeorm

Answer 1

Answer №1

Looking at it from a database perspective, a relation is essentially a foreign key that points to a primary key. In this scenario, typeorm automatically creates a column called bulkOrderId in the orders table, linking it to the id column in the table associated with the BulkOrder entity.

If you need to eliminate this relationship, you can simply set the bulkOrderId column to null. A recommended approach to accomplish this is as follows:

@Entity({ name: 'orders' })
export class Order {
 ...

  @ManyToOne(() => BulkOrder, (bulkOrder) => bulkOrder.orders)
  @JoinColumn({ name: 'bulkOrderId' })
  bulkOrder?: BulkOrder;

  @Column({ name: 'bulkOrderId' })
  bulkOrderId?: string;
}

.createQueryBuilder()
.update(Order)
.set({ status: OrderStatus.OPEN, bulkOrderId: null }).
where(...).execute()

Answer 2

Looking at it from a database perspective, a relation is essentially a foreign key that points to a primary key. In this scenario, typeorm automatically creates a column called bulkOrderId in the orders table, linking it to the id column in the table associated with the BulkOrder entity.

If you need to eliminate this relationship, you can simply set the bulkOrderId column to null. A recommended approach to accomplish this is as follows:

@Entity({ name: 'orders' })
export class Order {
 ...

  @ManyToOne(() => BulkOrder, (bulkOrder) => bulkOrder.orders)
  @JoinColumn({ name: 'bulkOrderId' })
  bulkOrder?: BulkOrder;

  @Column({ name: 'bulkOrderId' })
  bulkOrderId?: string;
}

.createQueryBuilder()
.update(Order)
.set({ status: OrderStatus.OPEN, bulkOrderId: null }).
where(...).execute()

Using TypeORM to update a relation and set it to NULL

Answer №1

Similar questions

A guide on combining two native Record types in TypeScript

The interface 'HTMLIonIconElement' is not able to extend both 'IonIcon' and 'HTMLStencilElement' types at the same time

The value stored within an object does not automatically refresh when using the useState hook

Can you explain the distinction between `any[]` and `{ [s: string]: any }`?

Comparison of env.local and String variables

Utilizing CakePHP's DateTime with PHP's date() function

Leverage Ramda's clone function within a pipeline in a manner that ensures type safety

Tips for triggering an event from a function instead of the window

Challenges with React Event Listener Types

Is there a way for Ionic to remember the last page for a few seconds before session expiry?

An asynchronous function operates incessantly

Exploring subobjects while fetching observables (typescript/angular)

Purge the inversify-js container and fetch fresh service instances

Substitute all properties of a specific type with a predetermined value in Typescript using recursive substitution

Unable to modify the Express Request User type, however, I have the ability to incorporate new attributes to Request object

`Unresponsiveness in updating bound property after change in Angular2 child property`

Having trouble locating the Angular Material core theme within the asp.net core 2.0 template using Angular 5

What is the reason behind having to coerce the enum value before the object type can be properly recognized?

Styling Form validation with Ant Design

Set the value of HTML input type radio to a nested JSON string