support get column by string

[joebnb]

would sea orm support get column by string,this case often happen in table sort or filt something,current if i want implement sort func i should get :1. is ascend or descend 2.which column will be affect. i need write every query builder as :

fn get_column_type_by_name(column_name: &str) -> Option<Type> {
    let entity = Model::Entity;
    let column_type = match column_name {
        "id" => Some(Column::Id),
        "name" => Some(Column::Name),
        "email" => Some(Column::Email),
        _ => None,
    };
    column_type
}

fn main() {
    if let Some(column_type) = get_column_type_by_name("name") {
        println!("get column is: {:?}", column_type);
    }
}

if there have some function to drop in string and return a col type would be help full

expect

fn main() {
    if let Some(column_type) = entity:Column:get_column_by_name("name") { // direct return Some Column
        println!("get column is: {:?}", column_type);
    }
}

[tyt2y3]

Here it is!

sea-orm/src/entity/column.rs

Lines 513 to 537 in aa626fc

	#[test]
	fn test_col_from_str() {
	use std::str::FromStr;
	assert!(matches!(
	fruit::Column::from_str("id"),
	Ok(fruit::Column::Id)
	));
	assert!(matches!(
	fruit::Column::from_str("name"),
	Ok(fruit::Column::Name)
	));
	assert!(matches!(
	fruit::Column::from_str("cake_id"),
	Ok(fruit::Column::CakeId)
	));
	assert!(matches!(
	fruit::Column::from_str("cakeId"),
	Ok(fruit::Column::CakeId)
	));
	assert!(matches!(
	fruit::Column::from_str("does_not_exist"),
	Err(crate::ColumnFromStrErr(_))
	));
	}

[joebnb]

thanks for reply