11 releases (4 breaking)
new 0.5.0-rc.3 | Mar 28, 2025 |
---|---|
0.5.0-rc.2 | Mar 27, 2025 |
0.4.3-rc | Feb 6, 2025 |
0.4.2-rc | Jan 30, 2025 |
0.1.2 | Jun 19, 2024 |
#599 in Database interfaces
25 downloads per month
Used in russenger
34KB
438 lines
Rusql Alchemy
Rusql Alchemy is Django ORM like library for Rust
Why ?
Just for fun! XD
Sqlite
Setup .env
file
DATABASE_URL=sqlite://<dabasase.db>
Setup Cargo.toml
[dependencies.rusql-alchemy]
git = "https://github.com/j03-dev/rusql-alchemy"
branch= "main"
features = ["sqlite"] # the default features is sqlite
field
use rusql_alchemy::prelude::*;
#[derive(Debug, field, FromRow)]
struct User {
#[field(primary_key=true, auto=true)]
id: Integer,
#[field(unique=true)]
name: String,
age: Integer,
#[field(default="user")]
role: String
}
Postgres
Setup .env
file
DATABASE_URL=postgres://<user>:<password>@<hostname>/<dbname>
Setup Cargo.toml
[dependencies.rusql-alchemy]
git = "https://github.com/j03-dev/rusql-alchemy"
branch="main"
default-features = false
features = ["postgres"]
field: In postgres primary key should be Serial
type
use rusql_alchemy::prelude::*;
#[derive(field, FromRow, Debug, Default)]
struct User_ {
#[field(primary_key=true)]
id: Serial,
#[field(unique=true)]
name: String,
email: Option<String>,
age: Integer,
#[field(default="user")]
role: String,
weight: Float,
}
Migrate
use anyhow::Result;
use rusql_alchemy::prelude::*;
#[tokio::main]
async fn main() -> Result<()> {
let database = Database::new().await?;
database.migrate().await?;
Ok(())
}
Query
Insert
use anyhow::Result;
use rusql_alchemy::prelude::*;
#[tokio::main]
async fn main() -> Result<()> {
let conn = Database::new().await?.conn;
User_ {
name: "johnDoe".to_string(),
password: "p455w0rd".to_string(),
age: 18,
weight: 60.0,
..Default::default()
}
.save(&conn)
.await;
let users = User_::all(&conn).await;
println!("{:#?}", users);
User_::create(
kwargs!(
name = "joe",
email = "24nomeniavo@gmail.com",
password = "strongpassword",
age = 19,
weight = 80.1
),
&conn,
)
.await;
}
Select
use rusql_alchemy::prelude::*;
#[tokio::main]
async fn main() {
let conn = config::db::Database::new().await.conn;
let users = User_::all(&conn).await;
println!("{:#?}", users);
let user = User_::get(
kwargs!(email == "24nomeniavo@gmail.com").and(kwargs!(password == "strongpassword")),
&conn,
).await;
println!("{:#?}", user);
let users = User_::filter(kwargs!(age <= 18), &conn).await;
println!("{:#?}", users);
}
Update
use rusql_alchemy::prelude::*;
use anyhow::Result;
#[tokio::main]
async fn main() -> Result<()> {
let conn = Database::new().await?.conn;
if let Some(mut user) = User_::get(
kwargs!(email == "24nomeniavo@gmail.com").and(kwargs!(password == "strongpassword")),
&conn,
)
.await
{
user.role = "admin".into();
user.update(&conn).await;
}
}
Delete
use rusql_alchemy::prelude::*;
#[tokio::main]
async fn main() {
let conn = Database::new().await.conn;
if let Some(user) = User_::get(kwargs!(role == "admin"), &conn).await {
user.delete(&conn).await; // delete one
}
let users = User_::all(&conn).await;
users.delete(&conn).await; // delete all
}
Dependencies
~11–27MB
~424K SLoC