docs: Update examples to use pgx/v5

sqlc-dev · kyleconroy · Oct 17, 2023 · Oct 16, 2023 · Oct 16, 2023 · Oct 16, 2023
commit 97be417b40e13f9031a60a85a798b1807522fc03
diff --git a/examples/authors/postgresql/db.go b/examples/authors/postgresql/db.go
diff --git a/examples/authors/postgresql/models.go b/examples/authors/postgresql/models.go
diff --git a/examples/authors/postgresql/query.sql.go b/examples/authors/postgresql/query.sql.go
diff --git a/examples/authors/sqlc.yaml b/examples/authors/sqlc.yaml
@@ -15,6 +15,7 @@ sql:
   gen:
     go:
       package: authors
+      sql_package: pgx/v5
       out: postgresql
 - schema: mysql/schema.sql
   queries: mysql/query.sql
@@ -45,4 +46,4 @@ rules:
   rule: "postgresql.explain.plan.total_cost > 300.0"
 - name: mysql-query-too-costly
   message: "Too costly"
-  rule: "has(mysql.explain.query_block.cost_info) && double(mysql.explain.query_block.cost_info.query_cost) > 2.0"
+  rule: "has(mysql.explain.query_block.cost_info) && double(mysql.explain.query_block.cost_info.query_cost) > 2.0"
diff --git a/examples/batch/postgresql/batch.go b/examples/batch/postgresql/batch.go
diff --git a/examples/batch/postgresql/db.go b/examples/batch/postgresql/db.go
diff --git a/examples/batch/postgresql/models.go b/examples/batch/postgresql/models.go
diff --git a/examples/batch/postgresql/querier.go b/examples/batch/postgresql/querier.go
diff --git a/examples/batch/postgresql/query.sql.go b/examples/batch/postgresql/query.sql.go
diff --git a/examples/batch/sqlc.json b/examples/batch/sqlc.json
@@ -19,7 +19,7 @@
       "rules": [
         "sqlc/db-prepare"
       ],
-      "sql_package": "pgx/v4",
+      "sql_package": "pgx/v5",
       "emit_json_tags": true,
       "emit_prepared_queries": true,
       "emit_interface": true

diff --git a/examples/booktest/postgresql/db.go b/examples/booktest/postgresql/db.go
diff --git a/examples/booktest/postgresql/models.go b/examples/booktest/postgresql/models.go