How to generate a scaffold with enum column using cargo loco (MySQL/MariaDB)?

[alokmahor]

I'm using Loco along with MariaDB as my database. I’ve been using the code generation command like this:

cargo loco generate scaffold posts name:string title:string content:text --api

1. Is there any way to generate scaffold with enum column using cargo loco generate scaffold?

2. If not directly supported, what’s the best practice for integrating enum fields in the generated models and migrations when using MariaDB?

3. Should I manually adjust the migration file and model? Any examples would be helpful.

[kaplanelad]

MariaDB is not fully supported during scaffolding because the Rust types generated may differ. However, aside from scaffolding, Loco works seamlessly with MariaDB.

If you still want to use scaffolding, you can manually update the variable types in the generated controller to match those defined in the _entity folder.

[ISensuiI]

I also encountered this problem. My solution was to use string instead, then manually modify the migration file and manually create it in the migration file. I used postgres
m.create_type( Type::create() .as_enum(Alias::new("saga_logs_status_enum")) .values(vec![ Alias::new("started"), Alias::new("executing"), Alias::new("completed"), Alias::new("compensating"), Alias::new("compensated"), Alias::new("compensation_failed"), Alias::new("failed") ]) .to_owned(), ) .await?;