nestjs-typeorm | PostgreSQL — full example development and project setup | Data Migration library

I am trying to mock createQueryBuilder to unit test pagination part, But i am getting below error

queryBuilder.take(...).skip is not a function

My Mock for createQueryBuilder

Edit:
I have looked at this question/answer How to exclude entity field from controller json
But, as per below - this is excluding that field from all queries (to the porint where when trying to process user validation, the password field is excluded using the findOne repository query on a route/controller method that does not have ClassSerializerInterceptor

I have an entity within nest.js / typeorm; I am trying to exclude the password field from the returned json, but not exclude the password field from any repository queries within my service. For example:

user.entity.ts:

I am implementing pagination using this https://github.com/nestjsx/nestjs-typeorm-paginate.

and i am receiving the error mentioned in the title in this line:

return this.usersService.findAll({ page, limit });

Any idea what seem to be the issue ? thanks.

Here is my controller

My Question is around transaction management using nestjs and Typeorm, my db is postgres.

1. Should I use decorators like @Transaction and @TransactionManager while doing transaction management. I heard that they are going to be removed in new releases. https://github.com/typeorm/typeorm/issues/3251

2. As a best practise how do we handle a transaction that is inserting or updating multiple tables. I see the following question nestjs / TypeOrm database transaction Is this the right away, can somebody give me a full example. Should I inject connection to my service class and get EntityManager from it and pass it around?

3. What would be the right way for unit testing such an insert on two tables.

I am right now using Transaction decorators from TypeOrm. All my create code is in a single class, I want to be able to move the code for creation of every entity to be moved to the entity's own service class and expect the transaction rollback still works.

I have a server side written in node.js and nestJs, querying with typeorm.

I'm trying to wrap some query's to the database with transaction as suggested here with some changes inspired by typeorm's docs, like this: