René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"unnecessary enum type generated for actual schema ","articleBody":"### Version\n\n1.19.1\n\n### What happened?\n\nThe code associated with the enum field is generated even if the table is dropped after define this field.\n\n### Relevant log output\n\n```shell\ntype StreamSessionState string\r\n\r\nconst (\r\n\tStreamSessionStateACTIVATING                StreamSessionState = \"ACTIVATING\"\r\n\tStreamSessionStateACTIVE                    StreamSessionState = \"ACTIVE\"\r\n\tStreamSessionStateCONNECTED                 StreamSessionState = \"CONNECTED\"\r\n\tStreamSessionStatePENDINGCLIENTRECONNECTION StreamSessionState = \"PENDING_CLIENT_RECONNECTION\"\r\n\tStreamSessionStateTERMINATED                StreamSessionState = \"TERMINATED\"\r\n\tStreamSessionStateERROR                     StreamSessionState = \"ERROR\"\r\n)\r\n\r\nfunc (e *StreamSessionState) Scan(src interface{}) error {\r\n\tswitch s := src.(type) {\r\n\tcase []byte:\r\n\t\t*e = StreamSessionState(s)\r\n\tcase string:\r\n\t\t*e = StreamSessionState(s)\r\n\tdefault:\r\n\t\treturn fmt.Errorf(\"unsupported scan type for StreamSessionState: %T\", src)\r\n\t}\r\n\treturn nil\r\n}\r\n\r\ntype NullStreamSessionState struct {\r\n\tStreamSessionState StreamSessionState\r\n\tValid                      bool // Valid is true if StreamSessionState is not NULL\r\n}\r\n\r\n// Scan implements the Scanner interface.\r\nfunc (ns *NullStreamSessionState) Scan(value interface{}) error {\r\n\tif value == nil {\r\n\t\tns.StreamSessionState, ns.Valid = \"\", false\r\n\t\treturn nil\r\n\t}\r\n\tns.Valid = true\r\n\treturn ns.StreamSessionState.Scan(value)\r\n}\r\n\r\n// Value implements the driver Valuer interface.\r\nfunc (ns NullStreamSessionState) Value() (driver.Value, error) {\r\n\tif !ns.Valid {\r\n\t\treturn nil, nil\r\n\t}\r\n\treturn string(ns.StreamSessionState), nil\r\n}\n```\n\n\n### Database schema\n\n```sql\nCREATE TABLE `stream_session` (\r\n  `id` int NOT NULL AUTO_INCREMENT,\r\n  `external_id` varchar(256) DEFAULT NULL,\r\n  `stream_group_id` int NOT NULL,\r\n  `state` enum('ACTIVATING','ACTIVE','CONNECTED','PENDING_CLIENT_RECONNECTION','TERMINATED','ERROR') NOT NULL,\r\n  PRIMARY KEY (`id`),\r\n  KEY `stream_group_id` (`stream_group_id`),\r\n  CONSTRAINT `stream_session_ibfk_1` FOREIGN KEY (`stream_group_id`) REFERENCES `stream_group` (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nDROP TABLE stream_session;\n```\n\n\n### SQL queries\n\n_No response_\n\n### Configuration\n\n```yaml\nversion: \"2\"\r\nsql:\r\n- schema: \"db/schema/DDL\"\r\n  queries: \"db/query\"\r\n  engine: \"mysql\"\r\n  gen:\r\n    go:\r\n      package: \"db\"\r\n      out: \"db/sqlc\"    \r\n      emit_json_tags: true\r\n      emit_interface: true\r\n      emit_empty_slices: true\r\n      emit_exact_table_names: true\n```\n\n\n### Playground URL\n\n_No response_\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nMySQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/maksim-ramenskiy","@type":"Person","name":"maksim-ramenskiy"},"datePublished":"2023-07-18T16:43:42.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/2475/sqlc/issues/2475"}