welds's logo

功能介绍

• 对异步的全面支持
• 支持多种数据库：包括（Mssql, MySql, Postgres, Sqlite）
• 简单易使用，没有过多的高级抽象
• 可以使用更加低级的sqlx接口

使用介绍

创建rust结构体

#[derive(Debug, sqlx::FromRow, WeldsModel)]
#[welds(db(Postgres))]
//#[welds(db(Postgres, Mssql, Mysql, Sqlite))]
#[welds(schema= "inventory", table = "products")]
#[welds(BelongsTo(seller, super::people::People, "seller_id"))]
pub struct Product {
    #[sqlx(rename = "product_id")]
    #[welds(primary_key)]
    pub id: i32,
    pub name: String,
    pub seller_id: Option,
    pub description: Option,
    pub price: Option,
}

语句执行

1. 基础查询

let url = "postgres://postgres:password@localhost:5432";
let pool = welds::connection::connect_postgres(url).await.unwrap();

let products = Product::where_col(|p| p.price.equal(3.50)).run(&pool).await?;

2. 按照条件进行查询

let conn = welds::connection::connect_mssql(url).await.unwrap();

let sellers = Product::where_col(|product| product.price.equal(3.50))
	.map_query(|product| product.seller )
	.where_col(|seller| seller.name.ilike("%Nessie%") )
	.run(&conn).await?;

3. 创建和更新

let conn = welds::connection::connect_sqlite(url).await.unwrap();

let mut cookies = Product::new();
cookies.name = "cookies".to_owned();
// Creates the product cookie
cookies.save.await(&conn)?; 
cookies.description = "Yum".to_owned();
// Updates the Cookies
cookies.save.await(&conn)?;

CRUD生成工具

1. 执行安装命令cargo install welds-cli --version '0.1.6-alpha'
2. 生成数据库表定义,首先定义数据库链接export DATABASE_URL=postgres://postgres:password@localhost:5432
3. 执行命令welds update,生成welds.yaml文件，格式如下：

tables:
- schema: public
  name: orders
  manual_update: false
  model: null
  type: table
  columns:
  - db_name: id
    db_type: int8
    model_name: id
    is_null: false
    primary_key: true
    writeable: true
  - ...

4. 最后执行命令welds generate，生成rust代码