test: Add two test cases

#1917 #1545
sqlc-dev · kyleconroy · Oct 18, 2023 · Oct 16, 2023 · Oct 16, 2023 · Oct 16, 2023
commit bd99f3bec193f11f624d286829f65d54ac7036ca
diff --git a/internal/endtoend/testdata/ddl_create_table_unknown_type/issue.md b/internal/endtoend/testdata/ddl_create_table_unknown_type/issue.md
@@ -0,0 +1 @@
+https://github.com/sqlc-dev/sqlc/issues/1917
diff --git a/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/exec.json b/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/exec.json
@@ -0,0 +1,3 @@
+{
+  "contexts": ["managed-db"]
+}
diff --git a/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/query.sql b/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/query.sql
@@ -0,0 +1,2 @@
+-- name: SelectOne :one
+SELECT 1;
diff --git a/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/schema.sql b/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/schema.sql
@@ -0,0 +1,3 @@
+CREATE TABLE test_table (
+    id STRING
+);
diff --git a/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/sqlc.yaml b/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/sqlc.yaml
@@ -0,0 +1,10 @@
+version: "2"
+sql:
+  - engine: "postgresql"
+    schema: "schema.sql"
+    queries: "query.sql"
+    gen:
+      go:
+        package: "querytest"
+        out: "go"
+        sql_package: "pgx/v5"
diff --git a/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/stderr.txt b/internal/endtoend/testdata/ddl_create_table_unknown_type/postgresql/pgx/stderr.txt
@@ -0,0 +1,5 @@
+# package querytest
+query.sql:1:1: rpc error: code = FailedPrecondition desc = type "string" does not exist (42704)
+CREATE TABLE test_table (
+    id STRING
+);
diff --git a/internal/endtoend/testdata/ddl_materialized_views_invalid/issue.md b/internal/endtoend/testdata/ddl_materialized_views_invalid/issue.md
@@ -0,0 +1 @@
+https://github.com/sqlc-dev/sqlc/issues/1545
diff --git a/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/exec.json b/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/exec.json
@@ -0,0 +1,3 @@
+{
+  "contexts": ["managed-db"]
+}
diff --git a/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/query.sql b/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/query.sql
@@ -0,0 +1,4 @@
+-- name: GetTotalEarned :one
+SELECT COALESCE(SUM(earned), 0) as total_earned
+FROM grouped_kpis
+WHERE day = @day;
diff --git a/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/schema.sql b/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/schema.sql
@@ -0,0 +1,9 @@
+CREATE TABLE kpis (
+  ts TIMESTAMPTZ,
+  event_id TEXT NOT NULL
+);
+
+CREATE MATERIALIZED VIEW IF NOT EXISTS grouped_kpis AS
+SELECT date_trunc('1 day', ts) as day, COUNT(*)
+FROM kpis
+GROUP BY 1;
diff --git a/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/sqlc.yaml b/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/sqlc.yaml
@@ -0,0 +1,10 @@
+version: "2"
+sql:
+  - engine: "postgresql"
+    schema: "schema.sql"
+    queries: "query.sql"
+    gen:
+      go:
+        package: "querytest"
+        out: "go"
+        sql_package: "pgx/v5"
diff --git a/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/stderr.txt b/internal/endtoend/testdata/ddl_materialized_views_invalid/postgresql/pgx/stderr.txt
@@ -0,0 +1,2 @@
+# package querytest
+query.sql:2:21: column "earned" does not exist
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		# package querytest
		query.sql:2:21: column "earned" does not exist