René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"omit_unused_structs ignores enum when used with sqlc.embed","articleBody":"### Version\r\n\r\n1.22.0\r\n\r\n### What happened?\r\n\r\nWhen `omit_unused_structs` is set to `true`, enums inside an sqlc.embed is ignored. This can cause invalid golang code due to undefined type on the model.\r\n\r\nCan be circumvented by creating another query without embed just so the enum model exists in the generated code.\r\n\r\n### Relevant log output\r\n\r\ncheck generated models.go\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TYPE enumtype AS ENUM('a','b');\r\n\r\nCREATE TABLE authors (\r\n  id   BIGSERIAL PRIMARY KEY,\r\n  e enumtype not null\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: GetAllAuthors :one\r\nSELECT sqlc.embed(authors) FROM authors;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\n{\r\n  \"version\": \"1\",\r\n  \"packages\": [\r\n    {\r\n      \"path\": \"db\",\r\n      \"engine\": \"postgresql\",\r\n      \"schema\": \"query.sql\",\r\n      \"queries\": \"query.sql\",\r\n      \"omit_unused_structs\": true\r\n    }\r\n  ]\r\n}\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/2203df48ffefbead62b4871ccb2269b8cdd425c64c27108b7857d79c89a5596d\r\n\r\n### What operating system are you using?\r\n\r\nLinux, Windows\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/Andy-William","@type":"Person","name":"Andy-William"},"datePublished":"2023-10-16T11:31:34.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2860/sqlc/issues/2860"}