sqlx-crud is an extension to SQLx to derive Create, Read, Update, and Delete (CRUD) methods for a struct representing a table in a sqlx database.
use sqlx::FromRow;
use sqlx_crud::SqlxCrud;
#[derive(Debug, FromRow, SqlxCrud)]
struct User {
user_id: i32,
name: String,
}
if let Some(user) = User::by_id(&pool, 42) {
println!("Found user user_id=42: {:?}", user);
}Single Derive Macro for Structs
Methods to Create, Read, Update, and Delete Records
Primary Key and Table Name Inference
Table Metadata for Reuse
Internal and External Database ID Assignment
This removes much of the common, repetitive code needed when dealing with the typical CRUD operations.
sqlx-crud strives to do a few, narrowly defined things well in an effort to reduce 80% of the redundant code you might write for a database application when operating on a single table at a time. It provides mechanisms: Schema and Crud, to access and reuse the generated id, column, and query metadata. This can help with writing more complex queries outside of the single table CRUD paradigm, but its primary use case is for CRUD.
Installing sqlx-crud is similar to installing SQLx.
# Cargo.toml
[dependencies]
sqlx-crud = { version = "0", features = ["runtime-tokio-rustls"] }See the documentation for full usage instructions.
sqlx-crud uses the same features as SQLx runtime-* flags and are required because of
the dependency on SQLx.
You can find real-world examples under the examples directory.
Source code for sqlx-crud is available at https://www.github.com/treydempsey/sqlx-crud.
The doctests depend on SQLx and it's runtime-tokio-rustls and sqlite
features.
The tests can be run with:
$ cargo testDocumentation is hosted at sqlx-crud docs.
sqlx-crud does most of what I need it to do, however while packaging it for release to others I realized there are several improvements that could be made. Planned updates and major achievements are listed in MILESTONES.
sqlx-crud is licensed under the MIT license (see: LICENSE).