Kysely•3y ago

Error this query cannot be compiled to SQL

I am trying to do

          await trx.executeQuery(
            sql<any>`ALTER SCHEMA ${current.subdomain} RENAME TO ${subdomain};`
          )
        }

          await trx.executeQuery(
            sql<any>`ALTER SCHEMA ${current.subdomain} RENAME TO ${subdomain};`
          )
        }

          await trx.executeQuery(
            sql<any>`ALTER SCHEMA ${current.subdomain} RENAME TO ${subdomain};`
          )
        }

          await trx.executeQuery(
            sql<any>`ALTER SCHEMA ${current.subdomain} RENAME TO ${subdomain};`
          )
        }

anybody have an idea how to do this query?

Solution

I the end I went with

 await sql
           .raw(`ALTER SCHEMA "${current.subdomain}" RENAME TO "${subdomain}"`)
            .execute(trx)

 await sql
           .raw(`ALTER SCHEMA "${current.subdomain}" RENAME TO "${subdomain}"`)
            .execute(trx)

 await sql
           .raw(`ALTER SCHEMA "${current.subdomain}" RENAME TO "${subdomain}"`)
            .execute(trx)

 await sql
           .raw(`ALTER SCHEMA "${current.subdomain}" RENAME TO "${subdomain}"`)
            .execute(trx)

koskimas•11/24/23, 10:50 AM

Subtitutions are by default treated as values and passed as parameters. You want identifiers here. You can use sql.idsql.id

await trx.executeQuery(
  sql<any>`ALTER SCHEMA ${sql.id(current.subdomain)} RENAME TO ${sql.id(subdomain)};`
)

await trx.executeQuery(
  sql<any>`ALTER SCHEMA ${sql.id(current.subdomain)} RENAME TO ${sql.id(subdomain)};`
)

another way is to just run a completely raw query

await trx.executeQuery(
  sql.raw(`ALTER SCHEMA ${current.subdomain} RENAME TO ${subdomain};`)
)

await trx.executeQuery(
  sql.raw(`ALTER SCHEMA ${current.subdomain} RENAME TO ${subdomain};`)
)

capajOP•11/24/23, 11:04 AM

this still throws

this query cannot be compiled to SQL

this query cannot be compiled to SQL

capajOP•11/24/23, 11:05 AM

also TS is not happy about this

Solution

capaj•11/24/23, 11:05 AM

I the end I went with

 await sql
           .raw(`ALTER SCHEMA "${current.subdomain}" RENAME TO "${subdomain}"`)
            .execute(trx)

 await sql
           .raw(`ALTER SCHEMA "${current.subdomain}" RENAME TO "${subdomain}"`)
            .execute(trx)

koskimas•11/24/23, 11:06 AM

Yeah, I'm not sure executeQueryexecuteQuery should even work with raw SQL. Is it even public interface?

koskimas•11/24/23, 11:07 AM

It is

koskimas•11/24/23, 11:07 AM

It should probably work

capajOP•11/24/23, 11:08 AM

no worries, DDL queries are quite an edgecase for most query builders

koskimas•11/24/23, 11:09 AM

Hmm.. The function takes a CompiledQueryCompiledQuery or a CompilableCompilable. RawBuilderRawBuilder (returned from

sql

sql

) shouldn't be either.

koskimas•11/24/23, 11:09 AM

I'll take a look at this. Something funky here