Column name type

[cemoktra]

Hey,

when generating code column named type should be renamed to r#type. Maybe check other rust keywords.

[billy1624]

Related to #76

[tyt2y3]

Continuing from #82

Annotations we need to add to DeriveColumn

#[derive(DeriveColumn)]
pub enum Column {
    #[sea_orm(column_name = "my_db_col")]
    Name,
}

And also DeriveEntityModel

#[derive(DeriveEntityModel)]
#[sea_orm(table_name = "cake")]
pub struct Model {
    #[sea_orm(column_type = "Text", column_name = "my_db_col", nullable)]
    pub name: Option<String> ,
}

---

If feeling fancy, we can also add enum variant remapping:

#[derive(DeriveEntityModel)]
#[sea_orm(table_name = "cake")]
pub struct Model {
    #[sea_orm(column_name = "type", enum_name = "Type")]
    pub type_: String ,
}

which would generate the following:

#[derive(DeriveColumn)]
pub enum Column {
    #[sea_orm(column_name = "type")]
    Type,
}

[DanielHZhang]

Would it be possible to also include a rename macro such as #[sea_orm(casing = "camelCase")] for DeriveColumn or DeriveEntityModel?

I know it's been discussed previously that SeaORM wants to avoid relying too much on macro magic, but I think it's a common pain point that database column names are in PascalCase or camelCase and currently there's no convenient way to remap them without writing the expanded entity structure.

The macro could look something like this:

#[derive(DeriveEntityModel)]
#[sea_orm(table_name = "Account", casing = "PascalCase")]
pub struct Model {
    #[sea_orm(column_name = "type", enum_name = "Type")]
    pub ty: String,
	pub first_name: String, // mapped to db column `FirstName`
	pub last_name: String, // mapped to db column `LastName`
}

[billy1624]

Hey @DanielHZhang, good suggestion. It's possible to add this feature.