sea-orm-cli generate entity does not generate mysql field comments

[988494]

sea-orm-cli generate entity -u mysql://root:root@localhost:3306/aigc -o entity/src --lib --with-serde both --date-time-crate time --model-extra-derives "Default" --expanded-format

[For8stt]

sea-orm-cli generate entity currently does not preserve MySQL column comments as Rust doc comments.

It reads the DB schema mainly to generate columns/types/relations, but comments from INFORMATION_SCHEMA.COLUMNS.COLUMN_COMMENT are not emitted into the generated entity code.

So nothing is wrong with your command. This is probably just not supported yet.

Would be nice to have an option like:

sea-orm-cli generate entity \
  -u mysql://root:root@localhost:3306/aigc \
  -o entity/src \
  --with-column-comments

which would generate something like:

/// MySQL column comment here
#[sea_orm(column_name = "field_name")]
pub field_name: String,

For now the workaround is to add the comments manually after generation, or use a custom script/template if you regenerate entities often.