You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We are currently trying to have a custom migration that runs everytime reagardless the current migration step. This migration will hold the last version of some stored procedure. These stored procedure must run using the latestconstant from our codebase.
We work with schema for testing purpose and we are doing the following
exportasyncfunctionup(db: Kysely<MyDatabase>): Promise<void>{awaitsql` CREATE OR REPLACE procedure recompute_ranges() LANGUAGE plpgsql as $$ declare _current record; begin select * into _current from ${sql.table('something_entry')} where "id" = b_current_entry_id; end; $$;`.execute(db)}
The compiled query does not contains any information about the schema provided by using:
Once b481619 gets released you'll be able to inject non-select queries built with builders into sql template tags like this.
Looks like support for sql.table wasn't implemented in WithSchemaPlugin. It creates a TableNode, so there's no good reason (that I can think of) to not transform it as well and add the schema name.
Hi,
We are currently trying to have a custom migration that runs everytime
reagardless
the current migration step. This migration will hold the last version of somestored procedure
. Thesestored procedure
must run using thelatest
constant
from our codebase.We work with schema for testing purpose and we are doing the following
The compiled query does not contains any information about the schema provided by using:
Is there any way to use the right schema ?
Thanks
The text was updated successfully, but these errors were encountered: