An async ORM written in rust using the sqlx framework.

Welds

Welds is an async ORM written in rust using the sqlx framework.

Features

• Async for all.
• Support for multiple SQL databases (Mssql, MySql, Postgres, Sqlite)
• Written for ease of development. Features aren't hidden behind traits. Code should be simple to write, and simple to read.
• sqlx always available when you need to drop down to something lower level

Example Setup

```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 = "productid")] #[welds(primarykey)] pub id: i32, pub name: String, pub seller_id: Option, pub description: Option, pub price: Option, } ```

Example Usage

Basic Select

```rust 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?; ```

Basic Filter Across tables

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

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

Create And Update

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

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

Other Examples

• Basic CRUD
• Mapping Queries / Joining
• Bulk (Create/Update/Delete)
• Select Only Specific Columns
• Checking DB schema matches compiled structs

For more good examples check out the examples repo.