Typeorm Transaction

[lamberto15]

Base on the current repository setup, is there an easy way to do transaction without rewriting the repository?

[MitchellRyrie-evanBuck]

Base on the current repository setup, is there an easy way to do transaction without rewriting the repository?基于当前仓库设置，有没有一种简单的方法进行事务处理而无需重写仓库？

This is just what I wanted😭

[lamberto15]

@MitchellRyrie-evanBuck Hello,I managed to accomplish this without modifying the repository by using the typeorm-transactional package.

1. In main.ts, add the following configuration:
   
2. In app.module.ts, initialize the transactional data source:
   addTransactionalDataSource(new DataSource(options));
   
3. To test it, annotate the validateLogin method in AuthService, which performs multiple read/write operations on the database:
   
4. Now, all database read/write operations within the method are wrapped in a single transaction:
   

[MitchellRyrie-evanBuck]

@lamberto15 Thanks

[mtthsnc]

@lamberto15 thanks for quick rundown

[sheiy]

@lamberto15 The typeorm-transactional package hasn’t been updated in two years. Is it still stable and reliable?

[hlongvu]

so here we are, why the framework designed in away that this is not supported?

[iwint]

Why did't we used Prisma instead of typeorm?