Rust derive macro implement Create, Read, Update, and Delete (CRUD) methods base on sqlx.

Use

adding the following to your project's Cargo.toml:

[dependencies]
co-orm = { virsion = "0.2", features = ["mysql"] }
sqlx = { version = "0.7", features = ["mysql","runtime-tokio-native-tls"] }

[dev-dependencies]
tokio = { version = "1", features = ["macros"] }

• features: mysql, postgres, sqlite, mssql

Examples

use co_orm::{Crud, FromRow};
#[derive(Debug, Crud, FromRow)]
#[orm_rename = "users"] // rename table name
struct User {
    // #[orm_pk] // default first field is primary key
    #[orm_seq] // sequence field, insert will ignore this field
    pub id: u64,
    
    #[orm_by] // generate query_by_field,update_by_field,delete_by_field
    //#[orm_rename = "name"] // rename field name
    pub name: String,
    #[orm_update] // generate method update_xxx. 
    pub password: String,
    #[orm_ignore] // ignore field
    pub addr: Option<String>,
    // #[sqlx(default)]
    // pub age: i32,
}


pub async fn get_pool() -> Result<MySqlPool> {
    MySqlPoolOptions::new()
        .connect("mysql://root:password@192.168.1.199:3306/hello").await
}

#[tokio::test]
async fn test_query() {
    let pool=get_pool().await.unwrap();
    let u = User::get(&pool, 1).await.unwrap();
    println!("get {:?}", u);
    let u = User::get_by(&pool, "where id=1").await.unwrap();
    println!("get {:?}", u);
    
}

 #[derive(Crud)]
 get, get_by, qurery, query_by, update, delete, insert, insert_all.
 
 
 attributes:
 
 #[orm_pk]
 default first field is primary key or set.
 
 `#[orm_seq]`
 sequence field, auto increment. insert will ignore this field.
 
 #[orm_rename= "names"]
 rename table name or field name.
 default table name by struct name to_snake_case: UserDetail => user_detail.
 default field name by field name to_snake_case: UserDetail => user_detail.
 
 #[orm_ignore]
 ignore field.
 
 #[orm_update]
 generate method update_xxx. 
 
 #[orm_by]
 generate query_by_field,update_by_field,delete_by_field.

 #[derive(FromRow)]
 impl sqlx::FromRow trait.
 
 if use `#[derive(FromRow)]` macro, must use `#[derive(Crud)]` macro.
 
 if you don't want to use `#[derive(co_orm::FromRow)]` macro, 
 you can use `#[derive(sqlx::FromRow)]` macro or impl `sqlx::FromRow` trait.
 
 if using sqlx::FromRow, ignore field use `#[orm_ignore]` add `#[sql::defult]`  `#[sqlx(skip)]`.