In this post, we will look at how to perform a NestJS TypeORM Transaction using the TypeORM QueryRunner class with examples. This is also the recommended …<\/b>
\nJoin the DZone community and get the full member experience. In this post, we will look at how to perform a NestJS TypeORM Transaction using the TypeORM QueryRunner class. This is also the recommended way of handling transactions in NestJS. If you are new to using TypeORM with NestJS, refer to this detailed post about NestJS TypeORM Integration. Transactions are one of the most important concepts while dealing with databases. Basically, a transaction is a unit of work. We should treat it as a whole. Either it happens completely or it does not happen. For example, you can think of transferring money from one account to another. At face value, this process involves multiple steps such as withdrawing money from the first account and then transferring it into the recipient\u2019s account. The transfer fails if even one of the steps fails. Hence, we should handle such operations in the form of transactions. A transaction must have the below properties. They are commonly known as ACID properties. The TypeORM package comes with the Connection class. We will inject this class into our LibraryService example. See below code: The Connection class resides in the typeorm package. The below import statement will be needed. The Connection object does not represent a single database connection. It basically points to a pool of connections. To refer to a single database collection, we use the QueryRunner class. Basically, every instance of the QueryRunner is a connection. We can now use the Connection object to create a transaction. See the below example: Basically, we use an instance of QueryRunner to establish a connection and start a transaction. Then, we save all the books (in this case 2 books) as part of the same transaction. If something goes wrong, we rollback everything. Else, we commit the transaction and release the connection. With this, we are done with NestJS TypeORM Transaction using QueryRunner. You can find the code for the same on Github. If you have any comments or queries about the post, please feel free to write in the comments section below. Published at DZone with permission of Saurabh Dashora. See the original article here. Opinions expressed by DZone contributors are their own.<\/p>\n