Skip to content

Commit 80bcdc6

Browse files
kyleconroykyleconroy
committed
test: Add case for #2226 
1 parent cbc15c4 commit 80bcdc6

8 files changed

Lines changed: 121 additions & 0 deletions

File tree

‎internal/endtoend/testdata/cte_nested_with/issue.md‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
https://github.com/sqlc-dev/sqlc/issues/2226

‎internal/endtoend/testdata/cte_nested_with/postgresql/pgx/exec.json‎

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
{
2+
"contexts": ["managed-db"]
3+
}

‎internal/endtoend/testdata/cte_nested_with/postgresql/pgx/go/db.go‎

Lines changed: 32 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎internal/endtoend/testdata/cte_nested_with/postgresql/pgx/go/models.go‎

Lines changed: 15 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎internal/endtoend/testdata/cte_nested_with/postgresql/pgx/go/query.sql.go‎

Lines changed: 38 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎internal/endtoend/testdata/cte_nested_with/postgresql/pgx/query.sql‎

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
-- name: GetAuthor :one
2+
WITH person AS(
3+
WITH summary AS(
4+
WITH mb AS(
5+
select
6+
id, name, bio
7+
from authors
8+
)
9+
SELECT
10+
bio
11+
FROM mb
12+
)
13+
SELECT
14+
count(*) as total
15+
FROM summary
16+
)
17+
select total from person;

‎internal/endtoend/testdata/cte_nested_with/postgresql/pgx/schema.sql‎

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,5 @@
1+
CREATE TABLE authors (
2+
id BIGSERIAL PRIMARY KEY,
3+
name text NOT NULL,
4+
bio text
5+
);

‎internal/endtoend/testdata/cte_nested_with/postgresql/pgx/sqlc.yaml‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
version: "2"
2+
sql:
3+
- engine: "postgresql"
4+
schema: "schema.sql"
5+
queries: "query.sql"
6+
gen:
7+
go:
8+
package: "querytest"
9+
out: "go"
10+
sql_package: "pgx/v5"

0 commit comments

Comments
 (0)