Skip to content

Commit 692bf2b

Browse files
kyleconroykyleconroy
authored
test: Add more test cases for new analyzer (sqlc-dev#2879)
* test: Add case for sqlc-dev#2132 * test: Add case for sqlc-dev#2152 * test: Mark case for sqlc-dev#2152 * test: Add case for sqlc-dev#2187 * test: Add case for sqlc-dev#2226 * test: Add case for sqlc-dev#2364 * test: Add case for sqlc-dev#2386 * test: Add case for sqlc-dev#2538 * test: Add case for sqlc-dev#2644 * test: Add case for sqlc-dev#2731
1 parent a8de31b commit 692bf2b

74 files changed

Lines changed: 1221 additions & 0 deletions

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎internal/endtoend/testdata/batch_parameter_type/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/2152

‎internal/endtoend/testdata/batch_parameter_type/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/batch_parameter_type/postgresql/pgx/go/batch.go‎

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

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

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

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

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

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

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

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

Lines changed: 32 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,32 @@
1+
-- name: InsertMappping :batchexec
2+
WITH
3+
table1
4+
AS (
5+
SELECT
6+
version
7+
FROM
8+
solar_commcard_mapping
9+
WHERE
10+
"deviceId" = $1
11+
ORDER BY
12+
"updatedAt" DESC
13+
LIMIT
14+
1
15+
)
16+
INSERT
17+
INTO
18+
solar_commcard_mapping
19+
("deviceId", version, sn, "updatedAt")
20+
SELECT
21+
$1, @version::text, $3, $4
22+
WHERE
23+
NOT
24+
EXISTS(
25+
SELECT
26+
*
27+
FROM
28+
table1
29+
WHERE
30+
table1.version = @version::text
31+
)
32+
OR NOT EXISTS(SELECT * FROM table1);

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

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,14 @@
1+
CREATE TABLE public.solar_commcard_mapping (
2+
id
3+
INT8 NOT NULL,
4+
"deviceId"
5+
INT8 NOT NULL,
6+
version
7+
VARCHAR(32) DEFAULT ''::VARCHAR NOT NULL,
8+
sn
9+
VARCHAR(32) DEFAULT ''::VARCHAR NOT NULL,
10+
"createdAt"
11+
TIMESTAMPTZ DEFAULT now(),
12+
"updatedAt"
13+
TIMESTAMPTZ DEFAULT now()
14+
);

‎internal/endtoend/testdata/batch_parameter_type/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"

‎internal/endtoend/testdata/cte_join_self/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/2132

0 commit comments

Comments
 (0)