Summer MyBatis

Summer MyBatis is an ORM framework based on rust language and mybatis framework. It is used to simplify development. Developers do not need to pay attention to complex SQL. They can carry out business development through dynamic SQL dialect. It can save your time. In addition, its speed is very fast.

Features:

• Cross platform support (linux, macos, windows)
• No Runtimes，No Garbage Collection
• Powerful and flexible where conditional wrapper.
• Support multiple database drivers (mssql, mysql, postgres, sqlite).
• Support asynchronous operation with tokio.
• Structure automatic serialization and deserialization.

Getting Started

• Step1. Add mybatis dependency

  rust serde = { version = "1", features = ["derive"] } rbson = "2.0" tokio = { version = "1.18.2", features = ["full"] } mybatis = { version = "1.0.2"}

• Step2. Create a structure corresponding to the database table and map the method

  ```rust use mybatis::crud::CRUD; use mybatis::mybatissql::stringutil::tosnakename; use mybatis::crud::CRUDTable; use mybatis::mybatis::Mybatis; use mybatis::snowflake::SNOWFLAKE; use serde::{Serialize, Deserialize};

  [derive(Debug, Serialize, Deserialize)]

  pub struct Pets { pub id: Option, pub name: Option, pub birthday: Option, pub delete_flag: Option, }

  impl CRUDTable for Pets {

  fn tablename() -> String { let typename = std::any::typename::(); let mut name = typename.tostring(); let names: Vec<&str> = name.split("::").collect(); name = names.get(names.len() - 1).unwrapor(&"").to_string();

    to_snake_name(&name)
  

  }

  fn tablecolumns() -> String { String::from("id,name,birthday,deleteflag") }

  } ```

• Next, you can do some database business operations

  ```rust /// /// Save a single object ///

  [tokio::test]

  async fn save_pets() { let mybatis = Mybatis::new();

  mybatis.link("mysql://root:passw0rd@localhost:3306/test").await.unwrap();

  let id = SNOWFLAKE.generate(); let cat = Pets { id: Some(id.tostring()), name: Some("Cindy".tostring()), birthday: Some(mybatis::DateTimeNative::now()), delete_flag: Some(0), };

  mybatis.save(&cat,&[]).await; }

  /// /// Batch insert multiple objects ///

  [tokio::test]

  async fn savebatchpets() { let mybatis = Mybatis::new();

  mybatis.link("mysql://root:passw0rd@localhost:3306/test").await.unwrap();

  let cat = Pets { id: Some(SNOWFLAKE.generate().tostring()), name: Some("Tom".tostring()), birthday: Some(mybatis::DateTimeNative::now()), delete_flag: Some(0), };

  let dog = Pets { id: Some(SNOWFLAKE.generate().tostring()), name: Some("Jerry".tostring()), birthday: Some(mybatis::DateTimeNative::now()), delete_flag: Some(0), };

  mybatis.save_batch(&vec![cat, dog],&[]).await; }

  /// /// Query multiple results and return dynamic array ///

  [tokio::test]

  async fn queryallpets() { let mybatis = Mybatis::new();

  mybatis.link("mysql://root:passw0rd@localhost:3306/test").await.unwrap();

  let result: Vec = mybatis.fetch_list().await.unwrap(); println!("result: {:?}", result); }

  /// /// Query a single object according to the specified field and return Option