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
- Advanced Queries - In-depth filtering, pagination, and aggregation
- Relations & Joins - One-to-many and many-to-many relations
- Database Providers - Provider dialect specifics
- Client Languages - Complete language runtime specifications