Using the IN clause in a prepared statement with a single variable in TypeORM

Question

Using the IN clause in a prepared statement with a single variable in TypeORM

I have a SQL file that contains a query like this:

SELECT * WHERE id IN ($1)

The SQL query is read and passed into a TypeORM query with an array of parameters.

const result = await this.entityManager.query(myQuery, parameters);

I want the parameters to be an array with only one value that combines all the IDs I want to search for as a single string. This way, I can use my SQL file regardless of how many IDs I need to filter by.

I've attempted to format the parameters in a way that keeps only $1 irrespective of the number of items in my array:

const ids = ['1', '2', '3'];

const parameters = [ids.join(",")];

or

const parameters = ["'" + ids.join(",") + "'"];

and so on

Unfortunately, I haven't found a syntax that successfully achieves this. Is there a way to make this work?

sql typescript typeorm

Answer 1

Answer №1

I modified the original query by replacing IN ($1) with = ANY($1) and now I am passing the ids as an array. This adjustment is producing the desired outcome.

SELECT * WHERE id = ANY($1);

const ids = ['1', '2', '3'];
const result = await this.entityManager.query(myQuery, [ids]);

Answer 2

I modified the original query by replacing IN ($1) with = ANY($1) and now I am passing the ids as an array. This adjustment is producing the desired outcome.

SELECT * WHERE id = ANY($1);

const ids = ['1', '2', '3'];
const result = await this.entityManager.query(myQuery, [ids]);

Using the IN clause in a prepared statement with a single variable in TypeORM

Answer №1

Similar questions

The tables that are currently present in the database are not displayed by Microsoft Azure Mobile Service

Ways to extract a return from an Observable

Enriching SpriteWithDynamicBody with Phaser3 and Typescript

Determining the parent type in Typescript by inferring it from a nested member

Tips for transforming a string into a variable within an Angular framework

Encountering difficulty using a template file as a component template within the Liferay angular portlet

Issue with Angular authentication during login attempt

Retrieving the top x records by date and a particular id using a Postgresql SELECT statement

The mysterious appearance of the <v-*> custom element in Vuetify Jest

Displaying search results in various Angular components

Encase a function with an observable

Creating a Blob or ArrayBuffer in Ionic 2 and Cordova: Step-by-Step Guide

The ReferenceError occurs exclusively during the execution of tests

To dismiss a popup on a map, simply click on any area outside the map

Tips for implementing the handleChange event with CalendarComponent from the PrimeReact library

The Conundrum of Angular 5 Circular Dependencies

What is the functionality of ngModel in the Angular Heroes Tour tutorial?

What is the method for including word boundaries in a regex constructor?

Is it possible to create two subclasses where the methods return the types of each other?

Leverage the power of Typescript to flatten a JSON model with the help of Class