sea-orm-cli generates incorrect model for MySQL database containing 'MEDIUMINT UNSIGNED' columns

[ttys3]

Description

generate model using latest stable cli

a table has field type MEDIUMINT UNSIGNED was generated as String which is wrong, should be number types.

Steps to Reproduce

create a demo database, which as a demo table, has a field invited_by with type MEDIUMINT UNSIGNED
2.

sea-orm-cli generate entity --with-serde both \
--serde-skip-deserializing-primary-key \
--with-copy-enums \
-o src/entity

Expected Behavior

the model should generate something like:

    #[sea_orm(column_type = "custom(\"MEDIUMINT UNSIGNED\")")]
    pub invited_by:  u32,

Actual Behavior

    #[sea_orm(column_type = "custom(\"MEDIUMINT UNSIGNED\")")]
    pub invited_by: String,

Reproduces How Often

always

Workarounds

manual fixup after generation

Reproducible Example

Versions

sea-orm-cli -V
sea-orm-cli 0.11.1

[tyt2y3]

MEDIUMINT is not currently a supported type in SeaQuery / SeaORM, and will unlikely be, because it does not align with other databases.

[tyt2y3]

I think the best we can do is to map MEDIUMINT to i32, basically treating it the same as INT @billy1624

[ttys3]

@tyt2y3 In the latest sear orm cli, I encountered this problem again. I almost forgot that I had mentioned this issue before and it still hasn't been resolved. I think we should map medium int to big int, instead of treating it as a string like this, which is obviously wrong. Moreover, the generated model is completely unusable.

[ttys3]

I think the best we can do is to map MEDIUMINT to i32, basically treating it the same as INT @billy1624

also, we can map tinytext to varchar(255)

[ttys3]

here's the PR: SeaQL/sea-schema#141