Description
Version
1.24.0
What happened?
When using mysql as the engine, the table and column names are normalized to lowercase, losing useful naming conventions from the database. It's a very postgres specific thing that table and column names should be lowercase. But in Mysql this limitation does not exist.
e.g. a column called KapNr will become Kapnr in the generated struct. If I then marshal that into a JSON, even with JSON tags in camelCase it will just become kapnr instead of kapNr.
We can use the rename configuration, but then that configuration is ignored for generating the json tag, so it is still only half a workaround.
For context (feel free to skip), to keep my code simple, the way I name my columns in a database, structs and output JSON are usually as similar as possible. The less mapping from 1 format to another, the better. However, now I am forced to put extra mappings in between with custom structs to fix this.
Relevant log output
No response
Database schema
CREATE TABLE
`Gruppen` (
`GrVon` varchar(3) NOT NULL,
`GrBis` varchar(3) DEFAULT NULL,
`KapNr` varchar(2) DEFAULT NULL,
`GrTi` varchar(255) DEFAULT NULL,
PRIMARY KEY (`GrVon`),
KEY `KapNr` (`KapNr`),
CONSTRAINT `Gruppen_ibfk_1` FOREIGN KEY (`KapNr`) REFERENCES `Kapitel` (`KapNr`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;SQL queries
No response
Configuration
version: "2"
sql:
- engine: "mysql"
queries: "sql/queries"
schema: "sql/schema"
gen:
go:
out: "internal/database"
emit_json_tags: true
json_tags_case_style: camel
rename:
kapnr: "KapNr"Playground URL
https://play.sqlc.dev/p/28279d28759d2a8d64af19286ee73de6c27b7003d0caa821d0e311652cf01a17
What operating system are you using?
Linux
What database engines are you using?
MySQL
What type of code are you generating?
Go