René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Improve \"Using transactions\" documentation","articleBody":"## Overview\r\n\r\nI was trying to implement a simple transaction following the [documentation](https://docs.sqlc.dev/en/stable/howto/transactions.html) but it's not clear and the code return errors.\r\n\r\n## Details to reproduce\r\n\r\nFiles:\r\n```\r\n├── dbsqlc\r\n│   ├── db.go\r\n│   ├── models.go\r\n│   └── query.sql.go\r\n├── go.mod\r\n├── go.sum\r\n├── main.go\r\n├── query.sql\r\n├── schema.sql\r\n└── sqlc.yaml\r\n```\r\n\r\nschema.sql\r\n```sql\r\nCREATE TABLE records (\r\n  id SERIAL PRIMARY KEY,\r\n  counter INT NOT NULL\r\n);\r\n```\r\n\r\nquery.sql\r\n```sql\r\n-- name: GetRecord :one\r\nSELECT * FROM records\r\nWHERE id = $1;\r\n\r\n-- name: UpdateRecord :exec\r\nUPDATE records SET counter = $2\r\nWHERE id = $1;\r\n```\r\n\r\nsqlc.yaml\r\n```yaml\r\nversion: \"2\"\r\nsql:\r\n  - engine: \"postgresql\"\r\n    queries: \"query.sql\"\r\n    schema: \"schema.sql\"\r\n    gen:\r\n      go:\r\n        package: \"dbsqlc\"\r\n        out: \"dbsqlc\"\r\n        sql_package: \"pgx/v5\"\r\n```\r\n\r\nmain.go\r\n```go\r\npackage foo\r\n\r\nimport (\r\n\t\"context\"\r\n\t\"database/sql\"\r\n\t\"foo/dbsqlc\"\r\n\r\n\t\"github.com/jackc/pgx/v5\"\r\n)\r\n\r\nfunc bumpCounter(ctx context.Context, db *sql.DB, queries *dbsqlc.Queries, id int32) error {\r\n\ttx, err := db.Begin()\r\n\tif err != nil {\r\n\t\treturn err\r\n\t}\r\n\tdefer tx.Rollback()\r\n\tqtx := queries.WithTx(tx)  // ERROR 1\r\n\tr, err := qtx.GetRecord(ctx, id)\r\n\tif err != nil {\r\n\t\treturn err\r\n\t}\r\n\tif err := qtx.UpdateRecord(ctx, dbsqlc.UpdateRecordParams{\r\n\t\tID:      r.ID,\r\n\t\tCounter: r.Counter + 1,\r\n\t}); err != nil {\r\n\t\treturn err\r\n\t}\r\n\treturn tx.Commit()\r\n}\r\n\r\nfunc main() {\r\n\tctx := context.Background()\r\n\tconn, err := pgx.Connect(ctx, \"host=localhost user=*** password=*** sslmode=disable\")\r\n\tif err != nil {\r\n\t\tpanic(err)\r\n\t}\r\n\tdefer conn.Close(ctx)\r\n\r\n\tqueries := dbsqlc.New(conn)\r\n\r\n\tbumpCounter(ctx, conn, queries, 1)  // ERROR 2\r\n}\r\n``` \r\n\r\n## Issues encontered\r\n\r\nJust like the documentation indicates. But I came to two problems:\r\n\r\n1. `./main.go:17:24: cannot use tx (variable of type *sql.Tx) as pgx.Tx value in argument to queries.WithTx: *sql.Tx does not implement pgx.Tx (missing method Begin)`\r\n2. `./main.go:41:20: cannot use conn (variable of type *pgx.Conn) as *sql.DB value in argument to bumpCounter`\r\n\r\n## Questions\r\n\r\n1. Why this error happens in the code exactly copied from the documentation?\r\n2. Where the db parameter should come from? (This one maybe my skill issue :) )\r\n\r\n## Aditional info\r\n\r\n```\r\n$ sqlc version\r\nv1.25.0\r\n```\r\n\r\n```\r\n$ go version\r\ngo version go1.21.6 linux/amd64\r\n```\r\n\r\n```\r\nmodule foo\r\n\r\ngo 1.21.6\r\n\r\nrequire github.com/jackc/pgx/v5 v5.5.3\r\n\r\nrequire (\r\n\tgithub.com/jackc/pgpassfile v1.0.0 // indirect\r\n\tgithub.com/jackc/pgservicefile v0.0.0-20221227161230-091c0ba34f0a // indirect\r\n\tgolang.org/x/crypto v0.17.0 // indirect\r\n\tgolang.org/x/text v0.14.0 // indirect\r\n)\r\n```\r\n\r\nThanks!","author":{"url":"https://github.com/bbonagura9","@type":"Person","name":"bbonagura9"},"datePublished":"2024-02-11T23:58:39.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/3192/sqlc/issues/3192"}