sqlc
sqlc copied to clipboard
sqlc-dev
postgresql "DO $$ BEGIN", not generate parameter.
What do you want to change?
query
DO $$ BEGIN
DELETE
FROM stage_seat
WHERE stage_id = $1; -- <--- HERE has parameter
-- other sql
END $$;
query
const resetStagePlace = `-- name: ResetStagePlace :exec
DO $$ BEGIN
DELETE
FROM stage_seat
WHERE stage_id = $1;
END $$
`
// DO $$ BEGIN
// DELETE
// FROM stage_seat
// WHERE stage_id = $1; -- <--- HERE has parameter
//
// -- other sql
// END $$
func (q *Queries) ResetStagePlace(ctx context.Context) error { // <-- HERE, not generate parameter
_, err := q.db.Exec(ctx, resetStagePlace)
return err
}
feature request: generate parameter for "DO $$ BEGIN ... END $$".
What database engines need to be changed?
PostgreSQL
What programming language backends need to be changed?
Go
