We are using TypeORM for our project in a Nest.js application and are missing some ins

I've tried something like this, inside a service: <div class="highlight highlight-

This is somewhat related to <a class="issue-link js-issue-link" data-error-text="Faile

Incremental adoption TypeORM with Nest.js about safeql HOT 2 CLOSED

simplenotezy commented on June 13, 2024

Incremental adoption TypeORM with Nest.js

from safeql.

Comments (2)

simplenotezy commented on June 13, 2024

I've tried something like this, inside a service:

  $typedQueryRaw(query: string, parameters?: any[], queryRunner?: QueryRunner) {
    return this.dataSource.query(query, parameters, queryRunner);
  }
  
  someMethod() {
  const query = await this.$typedQueryRaw`SELECT * FROM "user"`
  }

With the following setup:

  targets: [{ tag: '$typedQueryRaw', transform: '{type}[]' }],

However, I am getting this error:

Argument of type 'TemplateStringsArray' is not assignable to parameter of type 'string'.ts(2345)

from safeql.

Newbie012 commented on June 13, 2024

This is somewhat related to #108

TypeORM currently doesn't support template literals. I opened a PR on TypeORM, but I haven't received any official reply from them.

In any case, I added a TypeORM demo with a workaround until the mentioned-above PR will be merged.

import { sql as SafeQLTag } from "@ts-safeql/sql-tag";
import { DataSource } from "typeorm";
import { AppDataSource } from "./data-source";

function createDataSourceSqlTag(dataSource: DataSource) {
  return <TValue>(template: TemplateStringsArray, ...values: unknown[]): Promise<TValue> => {
    const tag = SafeQLTag(template, ...values);
    return dataSource.query<TValue>(tag.query, tag.values);
  };
}

const sql = createDataSourceSqlTag(AppDataSource);