Function testSql

test/node/src/test-setup.ts:325–348

(
  query: Compilable,
  dialect: DialectDescriptor,
  expectedPerDialect: PerSQLDialect<{
    sql: string | string[]
    parameters: any[]
  }> &
    Partial<
      Omit<
        PerDialectVariant<{ sql: string | string[]; parameters: any[] }>,
        keyof PerSQLDialect<any>
      >
    >,
)

}

export function testSql(
  query: Compilable,
  dialect: DialectDescriptor,
  expectedPerDialect: PerSQLDialect<{
    sql: string | string[]
    parameters: any[]
  }> &
    Partial<
      Omit<
        PerDialectVariant<{ sql: string | string[]; parameters: any[] }>,
        keyof PerSQLDialect<any>
      >
    >,
): void {
  const expected =
    expectedPerDialect[dialect.variant] || expectedPerDialect[dialect.sqlSpec]
  const expectedSql = Array.isArray(expected.sql)
    ? expected.sql.map((it) => it.trim()).join(' ')
    : expected.sql
  const sql = query.compile()

  chai.expect(expectedSql).to.equal(sql.sql)
  chai.expect(expected.parameters).to.eql(sql.parameters)
}

testSql.skip = function (
  _query: Compilable,