DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

BhargavMantha
BhargavMantha

Posted on • Updated on

Running the stored procedure from NestJs

using the repository that was created,
for instance you want to interact with the table users
and say you have the repository UserRepository. 
Enter fullscreen mode Exit fullscreen mode
  1. dependency inject the user repository into the current service
constructor(
@InjectRepository(Users)
private  userRepository:  Repository<UserRepository>
)  {}
Enter fullscreen mode Exit fullscreen mode
  1. now use the created userReposotory to run the command to invoke the stored procedure
this.userRepository.query("call dev_db.listUsers(?)",[the_input_paramenters_required]);
Enter fullscreen mode Exit fullscreen mode

--the above query returns a promise with result of stored Procedure or error
So make sure you add await to function having the above line

Top comments (2)

Collapse
notaduck profile image
notaduck

BhargavMantha I am almos sure that this.userRepository.query(call dev_db.listUsers(${the_input_paramenters_required}); is prone to sql injection, you should use a param list instead.

Collapse
bhargavmantha profile image
BhargavMantha Author

Thank you so much for pointing that out notaduck. My apologies for missing your comment. :)

🌱 DEV runs on 100% open source code that we started called Forem.

Β 
You can contribute to the codebase or host your own.