Skip to content

Commit 035e0f8

Browse files
kyleconroykyleconroy
committed
test(analyzer): Add testcase for #1574 
1 parent 9de196f commit 035e0f8

8 files changed

Lines changed: 103 additions & 0 deletions

File tree

‎internal/endtoend/testdata/min_max_date/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/1574

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

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

‎internal/endtoend/testdata/min_max_date/postgresql/pgx/go/query.sql.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/min_max_date/postgresql/pgx/query.sql‎

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
-- name: ActivityStats :one
2+
SELECT COUNT(*) as NumOfActivities,
3+
MIN(event_time) as MinDate,
4+
MAX(event_time) as MaxDate
5+
FROM activities
6+
WHERE account_id = $1;

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

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
CREATE TABLE activities (
2+
account_id BIGINT NOT NULL,
3+
event_time TIMESTAMP WITH TIME ZONE NOT NULL
4+
);

‎internal/endtoend/testdata/min_max_date/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)