CRUD Operations

AN5 ORM provides a clean, type-safe API for all CRUD operations tailored for Rust.


Client Setup

use an5_client::{An5Client, UserCreateInput, UserFindManyArgs};

let db = An5Client::from_env().await?;

1. Create

Create a Single Record

let user = db.user().create(UserCreateInput {
    email: "john@example.com".to_string(),
    name: Some("John Doe".to_string()),
}).await?;

Create Many Records

for input in vec![
    UserCreateInput { email: "alice@example.com".into(), name: Some("Alice".into()) },
    UserCreateInput { email: "bob@example.com".into(), name: Some("Bob".into()) },
] {
    db.user().create(input).await?;
}

2. Read

Find by Primary Key or Unique Field

let user = db.user().find_first(UserFindFirstArgs {
    where_clause: Some(UserWhereInput {
        email: Some(StringFilter { equals: Some("john@example.com".into()), ..Default::default() }),
        ..Default::default()
    }),
    ..Default::default()
}).await?;

Find Many Records with Filter & Sort

let users = db.user().find_many(UserFindManyArgs {
    where_clause: Some(UserWhereInput {
        is_active: Some(BoolFilter { equals: Some(true) }),
        email: Some(StringFilter { contains: Some("@example.com".into()), ..Default::default() }),
        ..Default::default()
    }),
    take: Some(10),
    ..Default::default()
}).await?;

3. Update

Update Single Record

let updated = db.user().update(UserUpdateArgs {
    where_clause: UserWhereInput { id: Some(StringFilter { equals: Some(user.id.clone()), ..Default::default() }), ..Default::default() },
    data: UserUpdateInput { name: Some("Johnny Doe".into()), ..Default::default() },
}).await?;

4. Delete

Delete Single Record

db.user().delete(UserWhereInput {
    id: Some(StringFilter { equals: Some(user.id.clone()), ..Default::default() }),
    ..Default::default()
}).await?;

Next Steps