add alter change test case

sqlc-dev · kyleconroy · Oct 13, 2023 · Aug 30, 2023 · Aug 30, 2023 · Aug 31, 2023
commit 036f75edbdcc4868b9754e9c61a158aa4ea9dec3
diff --git a/...dtoend/testdata/enum_alter/mysql/go/db.go → ...testdata/enum_alter_change/mysql/go/db.go b/...dtoend/testdata/enum_alter/mysql/go/db.go → ...testdata/enum_alter_change/mysql/go/db.go
diff --git a/...nd/testdata/enum_alter/mysql/go/models.go → ...data/enum_alter_change/mysql/go/models.go b/...nd/testdata/enum_alter/mysql/go/models.go → ...data/enum_alter_change/mysql/go/models.go
diff --git a/...testdata/enum_alter/mysql/go/query.sql.go → ...a/enum_alter_change/mysql/go/query.sql.go b/...testdata/enum_alter/mysql/go/query.sql.go → ...a/enum_alter_change/mysql/go/query.sql.go
diff --git a/...toend/testdata/enum_alter/mysql/query.sql → ...estdata/enum_alter_change/mysql/query.sql b/...toend/testdata/enum_alter/mysql/query.sql → ...estdata/enum_alter_change/mysql/query.sql
diff --git a/internal/endtoend/testdata/enum_alter_change/mysql/schema.sql b/internal/endtoend/testdata/enum_alter_change/mysql/schema.sql
@@ -0,0 +1,9 @@
+-- similar to issue https://github.com/sqlc-dev/sqlc/issues/1503
+
+CREATE TABLE authors (
+  id   bigint primary key,
+  status enum("ok", "init") default "init" not null
+);
+
+-- remove this alter to see the change in models.go
+ALTER TABLE authors CHANGE status status enum('init', 'done', 'canceled', 'processing', 'waiting') default "init" not null;
diff --git a/...toend/testdata/enum_alter/mysql/sqlc.json → ...estdata/enum_alter_change/mysql/sqlc.json b/...toend/testdata/enum_alter/mysql/sqlc.json → ...estdata/enum_alter_change/mysql/sqlc.json
diff --git a/internal/endtoend/testdata/enum_alter_modify/mysql/go/db.go b/internal/endtoend/testdata/enum_alter_modify/mysql/go/db.go
diff --git a/internal/endtoend/testdata/enum_alter_modify/mysql/go/models.go b/internal/endtoend/testdata/enum_alter_modify/mysql/go/models.go
diff --git a/internal/endtoend/testdata/enum_alter_modify/mysql/go/query.sql.go b/internal/endtoend/testdata/enum_alter_modify/mysql/go/query.sql.go
diff --git a/internal/endtoend/testdata/enum_alter_modify/mysql/query.sql b/internal/endtoend/testdata/enum_alter_modify/mysql/query.sql
@@ -0,0 +1,2 @@
+-- name: ListAuthors :many
+select * from authors;
diff --git a/...oend/testdata/enum_alter/mysql/schema.sql → ...stdata/enum_alter_modify/mysql/schema.sql b/...oend/testdata/enum_alter/mysql/schema.sql → ...stdata/enum_alter_modify/mysql/schema.sql
diff --git a/internal/endtoend/testdata/enum_alter_modify/mysql/sqlc.json b/internal/endtoend/testdata/enum_alter_modify/mysql/sqlc.json
@@ -0,0 +1,13 @@
+{
+  "version": "1",
+  "packages": [
+    {
+      "name": "querytest",
+      "path": "go",
+      "schema": "schema.sql",
+      "queries": "query.sql",
+      "engine": "mysql",
+      "omit_unused_structs": true
+    }
+  ]
+}
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- name: ListAuthors :many
		select * from authors;