TypeOrm - How to set relational field to null

TypeOrm – How to set relational field to null

When working with TypeOrm, you may come across situations where you need to set a relational field to null. This can be useful when you want to remove the association between two entities or when you want to clear the value of a relational field. In this blog post, we will explore two different solutions to achieve this.

Solution 1: Using the set() method

The first solution involves using the set() method provided by TypeOrm. This method allows you to set the value of a specific field to null. Here’s how you can use it:


import { EntityManager } from 'typeorm';

// Assuming you have an entity called User with a relational field called profile
const user = await entityManager.findOne(User, { id: 1 });
user.profile = null;
await entityManager.save(user);

In the above code snippet, we first retrieve the user entity from the database using the findOne() method. Then, we set the profile field to null and save the changes using the save() method. This will update the user entity in the database with the new value of the profile field.

Solution 2: Using the update() method

The second solution involves using the update() method provided by TypeOrm. This method allows you to update specific fields of an entity. Here’s how you can use it:


import { getConnection } from 'typeorm';

// Assuming you have an entity called User with a relational field called profile
await getConnection()
  .createQueryBuilder()
  .update(User)
  .set({ profile: null })
  .where("id = :id", { id: 1 })
  .execute();

In the above code snippet, we use the update() method provided by the query builder to update the profile field of the User entity. We set the profile field to null and specify the condition for the update using the where() method. Finally, we execute the query using the execute() method.

Both of the above solutions will set the relational field to null. Choose the solution that best fits your use case and implement it in your TypeOrm project.

That’s it! You now know how to set a relational field to null in TypeOrm. Happy coding!

TypeOrm – How to set relational field to null