'How to use Parameterized query using TypeORM for postgres database and nodejs as the application's back-end server

I want to fetch the rows from a postgres table where name = SUPREME INT'L, Note: this string has a single quote in between the name characters. I am using TypeORM as an ORM, POSTGRESQL as the database.

My query:

 import { getConnection } from 'typeorm';
 const connection =  getConnection();

 var query = `SELECT * from skusimulations where "name"= ? `;
 const output =await connection.query(query, ['SUPREME INT'L'])

I am getting error while executing this, I want to escape the single quote by using stored proc.

Any help would be highly appreciated.

node.jspostgresqltypeorm


Solution 1:[1]

SOLVED: Thanks for giving your time to my question, I really appreciate it. I changed a few things by referring to the typeorm.io docs. FINAL CHANGES:-

  var name = "SUPREME INT'L" ;
  var query = `SELECT * from skusimulations where "skuId"= $1 `;
  var skuData =await connection.query(query, [name])

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Rohan Kumar

Related Questions