EntityManager API

  • connection - The connection used by EntityManager.
  1. const connection = manager.connection;
  • queryRunner - The query runner used by EntityManager.Used only in transactional instances of EntityManager.
  1. const queryRunner = manager.queryRunner;
  • transaction - Provides a transaction where multiple database requests will be executed in a single database transaction.Learn more Transactions.
  1. await manager.transaction(async manager => {
  2.     // NOTE: you must perform all database operations using the given manager instance
  3.     // it's a special instance of EntityManager working with this transaction
  4.     // and don't forget to await things here
  5. });
  • query - Executes a raw SQL query.
  1. const rawData = await manager.query(`SELECT * FROM USERS`);
  • createQueryBuilder - Creates a query builder use to build SQL queries.Learn more about QueryBuilder.
  1. const users = await manager.createQueryBuilder()
  2.     .select()
  3.     .from(User, "user")
  4.     .where("user.name = :name", { name: "John" })
  5.     .getMany();
  • hasId - Checks if given entity has its primary column property defined.
  1.  if (manager.hasId(user)) {
  2.     // ... do something
  3.  }
  • getId - Gets given entity’s primary column property value.If the entity has composite primary keys then the returned value will be an object with names and values of primary columns.
  1. const userId = manager.getId(user); // userId === 1
  • create - Creates a new instance of User. Optionally accepts an object literal with user propertieswhich will be written into newly created user object.
  1. const user = manager.create(User); // same as const user = new User();
  2. const user = manager.create(User, {
  3.     id: 1,
  4.     firstName: "Timber",
  5.     lastName: "Saw"
  6. }); // same as const user = new User(); user.firstName = "Timber"; user.lastName = "Saw";
  • merge - Merges multiple entities into a single entity.
  1. const user = new User();
  2. manager.merge(User, user, { firstName: "Timber" }, { lastName: "Saw" }); // same as user.firstName = "Timber"; user.lastName = "Saw";
  • preload - Creates a new entity from the given plain javascript object. If the entity already exist in the database, thenit loads it (and everything related to it), replaces all values with the new ones from the given object,and returns the new entity. The new entity is actually loaded from the database entity with all propertiesreplaced from the new object.
  1. const partialUser = {
  2.     id: 1,
  3.     firstName: "Rizzrak",
  4.     profile: {
  5.         id: 1
  6.     }
  7. };
  8. const user = await manager.preload(User, partialUser);
  9. // user will contain all missing data from partialUser with partialUser property values:
  10. // { id: 1, firstName: "Rizzrak", lastName: "Saw", profile: { id: 1, ... } }
  • save - Saves a given entity or array of entities.If the entity already exists in the database, then it’s updated.If the entity does not exist in the database yet, it’s inserted.It saves all given entities in a single transaction (in the case of entity manager is not transactional).Also supports partial updating since all undefined properties are skipped. In order to make a value NULL, you must manually set the property to equal null.
  1. await manager.save(user);
  2. await manager.save([
  3.     category1,
  4.     category2,
  5.     category3
  6. ]);
  • remove - Removes a given entity or array of entities.It removes all given entities in a single transaction (in the case of entity, manager is not transactional).
  1. await manager.remove(user);
  2. await manager.remove([
  3.     category1,
  4.     category2,
  5.     category3
  6. ]);
  • insert - Inserts a new entity, or array of entities.
  1. await manager.insert(User, { 
  2.     firstName: "Timber", 
  3.     lastName: "Timber" 
  4. });
  6. await manager.insert(User, [{ 
  7.     firstName: "Foo", 
  8.     lastName: "Bar" 
  9. }, { 
  10.     firstName: "Rizz", 
  11.     lastName: "Rak" 
  12. }]);
  • update - Partially updates entity by a given update options or entity id.
  1. await manager.update(User, { firstName: "Timber" }, { firstName: "Rizzrak" });
  2. // executes UPDATE user SET firstName = Rizzrak WHERE firstName = Timber
  4. await manager.update(User, 1, { firstName: "Rizzrak" });
  5. // executes UPDATE user SET firstName = Rizzrak WHERE id = 1
  • delete - Deletes entities by entity id, ids or given conditions:
  1. await manager.delete(User, 1);
  2. await manager.delete(User, [1, 2, 3]);
  3. await manager.delete(User, { firstName: "Timber" });
  • count - Counts entities that match given options. Useful for pagination.
  1. const count = await manager.count(User, { firstName: "Timber" });
  • increment - Increments some column by provided value of entities that match given options.
  1. await manager.increment(User, { firstName: "Timber" }, "age", 3);

  • decrement - Decrements some column by provided value that match given options.

    1. await manager.decrement(User, { firstName: "Timber" }, "age", 3);

  • find - Finds entities that match given options.

  1. const timbers = await manager.find(User, { firstName: "Timber" });
  • findAndCount - Finds entities that match given find options.Also counts all entities that match given conditions,but ignores pagination settings (from and take options).
  1. const [timbers, timbersCount] = await manager.findAndCount(User, { firstName: "Timber" });
  • findByIds - Finds multiple entities by id.
  1. const users = await manager.findByIds(User, [1, 2, 3]);
  • findOne - Finds the first entity that matches some id or find options.
  1. const user = await manager.findOne(User, 1);
  2. const timber = await manager.findOne(User, { firstName: "Timber" });
  • findOneOrFail - Finds the first entity that matches some id or find options.Rejects the returned promise if nothing matches.
  1. const user = await manager.findOneOrFail(User, 1);
  2. const timber = await manager.findOneOrFail(User, { firstName: "Timber" });
  • clear - Clears all the data from the given table (truncates/drops it).
  1. await manager.clear(User);
  • getRepository - Gets Repository to perform operations on a specific entity.Learn more about Repositories.
  1. const userRepository = manager.getRepository(User);
  • getTreeRepository - Gets TreeRepository to perform operations on a specific entity.Learn more about Repositories.
  1. const categoryRepository = manager.getTreeRepository(Category);
  • getMongoRepository - Gets MongoRepository to perform operations on a specific entity.Learn more about MongoDB.
  1. const userRepository = manager.getMongoRepository(User);
  1. const myUserRepository = manager.getCustomRepository(UserRepository);
  • release - Releases query runner of an entity manager.Used only when query runner was created and managed manually.
  1. await manager.release();