René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc.narg is not being added to parms","articleBody":"### Version\r\n\r\n1.18.0\r\n\r\n### What happened?\r\n\r\nA field should be added to params but it does not\r\n\r\n### Relevant log output\r\n\r\n```shell\r\nconst productListByOwner = `-- name: ProductListByOwner :many\r\nSELECT id, owner_id, created_by, name, slug, category_id, vendor_id, tags, created_at, updated_at, published_at, deleted_at\r\nFROM products\r\nWHERE owner_id = $1\r\nAND (deleted_at IS NOT NULL OR $4 IS NULL)\r\nORDER BY id ASC\r\nLIMIT $2 OFFSET $3\r\n`\r\n\r\ntype ProductListByOwnerParams struct {\r\n\tOwnerID int32\r\n\tLimit   int32\r\n\tOffset  int32\r\n}\r\n\r\nfunc (q *Queries) ProductListByOwner(ctx context.Context, arg *ProductListByOwnerParams) ([]Product, error) {\r\n\trows, err := q.db.QueryContext(ctx, productListByOwner, arg.OwnerID, arg.Limit, arg.Offset)\r\n\tif err != nil {\r\n\t\treturn nil, err\r\n\t}\r\n\tdefer rows.Close()\r\n\tvar items []Product\r\n\tfor rows.Next() {\r\n\t\tvar i Product\r\n\t\tif err := rows.Scan(\r\n\t\t\t\u0026i.ID,\r\n\t\t\t\u0026i.DeletedAt,\r\n\t\t); err != nil {\r\n\t\t\treturn nil, err\r\n\t\t}\r\n\t\titems = append(items, i)\r\n\t}\r\n\tif err := rows.Close(); err != nil {\r\n\t\treturn nil, err\r\n\t}\r\n\tif err := rows.Err(); err != nil {\r\n\t\treturn nil, err\r\n\t}\r\n\treturn items, nil\r\n}\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE products\r\n(\r\n    id           SERIAL PRIMARY KEY,\r\n    owner_id     INT NOT NULL,\r\n    created_by   INT  NOT NULL,\r\n    name         VARCHAR(100)               NOT NULL,\r\n    slug         VARCHAR(255)               NOT NULL,\r\n    created_at   TIMESTAMP                  NOT NULL DEFAULT NOW(),\r\n    updated_at   TIMESTAMP                  NOT NULL DEFAULT NOW(),\r\n    published_at TIMESTAMP,\r\n    deleted_at   TIMESTAMP\r\n);\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\nversion: \"2\"\r\nsql:\r\n  - engine: \"postgresql\"\r\n    queries: \"internal/db/query.sql\"\r\n    schema: \"internal/db/schema.sql\"\r\n    gen:\r\n      go:\r\n        package: \"db\"\r\n        out: \"internal/db\"\r\n        emit_params_struct_pointers: true\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/f2ae3b0558f20a7040d2aeb039f30d7c797b51fe6b2c67fcdc3522d838024a24\r\n\r\n### What operating system are you using?\r\n\r\nLinux\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/k1ng440","@type":"Person","name":"k1ng440"},"datePublished":"2023-06-13T22:52:56.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/2324/sqlc/issues/2324"}