test: Add more test cases

sqlc-dev · kyleconroy · Oct 18, 2023 · Oct 16, 2023 · Oct 16, 2023 · Oct 16, 2023
commit 40a0c9e4f0a72d7388bf146bf2aeacd9068e0964
diff --git a/internal/endtoend/testdata/cte_recursive_star/postgresql/pgx/go/query.sql.go b/internal/endtoend/testdata/cte_recursive_star/postgresql/pgx/go/query.sql.go
diff --git a/internal/endtoend/testdata/star_expansion_series/issue.md b/internal/endtoend/testdata/star_expansion_series/issue.md
@@ -0,0 +1 @@
+https://github.com/sqlc-dev/sqlc/issues/1995
diff --git a/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/go/db.go b/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/go/db.go
diff --git a/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/go/models.go b/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/go/models.go
diff --git a/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/go/query.sql.go b/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/go/query.sql.go
diff --git a/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/query.sql b/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/query.sql
@@ -0,0 +1,11 @@
+-- name: CountAlertReportBy :many
+select DATE_TRUNC($1,ts)::text as datetime,coalesce(count,0) as count from 
+(
+    SELECT  DATE_TRUNC($1,eventdate) as hr ,count(*)
+    FROM    alertreport
+    where eventdate between $2 and $3
+    GROUP BY   1
+) AS cnt 
+right outer join ( SELECT * FROM generate_series ( $2, $3, CONCAT('1 ',$1)::interval) AS ts ) as dte
+on DATE_TRUNC($1, ts ) = cnt.hr 
+order by 1 asc;
diff --git a/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/schema.sql b/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/schema.sql
@@ -0,0 +1,3 @@
+CREATE TABLE alertreport (
+  eventdate date
+);
diff --git a/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/sqlc.yaml b/internal/endtoend/testdata/star_expansion_series/postgresql/pgx/sqlc.yaml
@@ -0,0 +1,14 @@
+version: "2"
+cloud:
+  project: "01HAQMMECEYQYKFJN8MP16QC41"
+sql:
+  - engine: "postgresql"
+    schema: "schema.sql"
+    queries: "query.sql"
+    gen:
+      go:
+        package: "querytest"
+        out: "go"
+        sql_package: "pgx/v5"
+    database:
+      managed: true