test: Add test case for CREATE TABLE LIKE

sqlc-dev · kyleconroy · Oct 31, 2023 · Oct 29, 2023 · Oct 31, 2023 · Oct 31, 2023
commit e1b200a1f66fe65e10e5a55b5cfe70a980bc547d
diff --git a/internal/endtoend/testdata/ddl_create_table_like/issue.md b/internal/endtoend/testdata/ddl_create_table_like/issue.md
@@ -0,0 +1 @@
+https://github.com/sqlc-dev/sqlc/issues/481
diff --git a/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/go/db.go b/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/go/db.go
diff --git a/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/go/models.go b/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/go/models.go
diff --git a/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/go/query.sql.go b/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/go/query.sql.go
diff --git a/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/query.sql b/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/query.sql
@@ -0,0 +1,2 @@
+-- name: AllRanked :many
+SELECT * FROM changes_ranked;
diff --git a/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/schema.sql b/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/schema.sql
@@ -0,0 +1,9 @@
+CREATE TABLE changes (
+    ranked INT NOT NULL
+);
+
+CREATE TABLE changes_ranked (
+    LIKE changes INCLUDING ALL,
+    rank_by_effect_size INT NOT NULL,
+    rank_by_abs_percent_change INT NOT NULL
+);
diff --git a/internal/endtoend/testdata/ddl_create_table_like/postgresql/pgx/sqlc.yaml b/internal/endtoend/testdata/ddl_create_table_like/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"
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- name: AllRanked :many
		SELECT * FROM changes_ranked;