- Notifications
You must be signed in to change notification settings - Fork 978
Closed
Labels
Description
Version
Other
What happened?
with query_parameter_limit set to 3 (or any value)
func (q*Queries) AddNewUser(ctx context.Context, dbDBTX, iDstring, passwordstring) (Users, error){row:=db.QueryRow(ctx, addNewUser, iD, password) err:=row.Scan(&i.ID, &i.Password) returni, err }notice declaration of var i Users is missing
it affects only AddNewUser since its the only one that has < 3 parameters.
Relevant log output
No response
Database schema
droptable if exists "clients"; createtable "clients"( "id" uuid not nullprimary key, "secret"textnot null, "redirect_uri"textnot null, "claims" jsonb not null ); droptable if exists "users"; createtable "users"( "id"textnot nullprimary key, "password"textnot null );SQL queries
-- name: AddNewClient :oneinsert into"clients"( "id", "secret", "redirect_uri", "claims" ) values ( sqlc.arg('id'), sqlc.arg('secret'), sqlc.arg('redirect_uri'), sqlc.arg('claims') ) returning *; -- name: BulkAddNewClients :copyfrominsert into"clients"( "id", "secret", "redirect_uri", "claims" ) values ( sqlc.arg('id'), sqlc.arg('secret'), sqlc.arg('redirect_uri'), sqlc.arg('claims') ); -- name: DeleteClient :execdeletefrom"clients"where"id"=sqlc.arg('id'); -- name: AddNewUser :oneinsert into"users"( "id", "password" ) values ( sqlc.arg('id'), sqlc.arg('password') ) returning *; -- name: BulkAddNewUsers :copyfrominsert into"users"( "id", "password" ) values ( sqlc.arg('id'), sqlc.arg('password') ); -- name: DeleteUser :execdeletefrom"users"where"id"=sqlc.arg('id');Configuration
version: "2"overrides: go: rename: redirect_uri: "RedirectURI"overrides: - db_type: "uuid"go_type: import: "github.com/aofei/sandid"type: "SandID" - db_type: "json"go_type: import: "encoding/json"type: "RawMessage" - db_type: "jsonb"go_type: import: "encoding/json"type: "RawMessage"sql: - engine: "postgresql"schema: "internal/db/authumn.schema.sql"queries: "internal/db/authumn.query.sql"gen: go: out: "internal/db"package: "db"sql_package: "pgx/v5"emit_exact_table_names: trueemit_methods_with_db_argument: truequery_parameter_limit: 3Playground URL
https://play.sqlc.dev/p/af9607b336d8ea4dee9a966b052679b54d15efe1b3d2e6493ceef59259f2ad83
What operating system are you using?
Linux
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
stepan-romankov