Kysely•10mo 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};`
          )
        }

anybody have an idea how to do this query?

Solution:

I the end I went with

``ts
 await sql
           .raw(

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

Jump to solution

7 Replies

koskimas•10mo ago

Subtitutions are by default treated as values and passed as parameters. You want identifiers here. You can use sql.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};`)
)

capaj•10mo ago

this still throws

this query cannot be compiled to SQL

this query cannot be compiled to SQL

capaj•10mo ago

also TS is not happy about this

Solution

capaj•10mo ago

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•10mo ago

Yeah, I'm not sure executeQuery should even work with raw SQL. Is it even public interface? It is It should probably work

capaj•10mo ago

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

koskimas•10mo ago

Hmm.. The function takes a CompiledQuery or a Compilable. RawBuilder (returned from sql) shouldn't be either. I'll take a look at this. Something funky here

Gaming

Programming

Error this query cannot be compiled to SQL