node-sql-template-strings icon indicating copy to clipboard operation
node-sql-template-strings copied to clipboard

Using append to compose multiple independent SQL queries

Open CMCDragonkai opened this issue 6 years ago • 2 comments

If I have 2 different queries like:

const seedOne = SQL`
  INSERT INTO table (col1, col2) VALUES (1, 2);
`;

const seedTwo = SQL`
  INSERT INTO table (col1, col2) VALUES (3, 4);
`;

Is there a way to compose seedOne and seedTwo together so I can run a single query?

const seedCombined = seedOne + seedTwo

CMCDragonkai avatar Jul 22 '19 10:07 CMCDragonkai

const seedCombined = seedOne.append(seedTwo);

?

felixfbecker avatar Jul 22 '19 10:07 felixfbecker

That's it? Awesome.

CMCDragonkai avatar Jul 22 '19 10:07 CMCDragonkai