sqlorm 0.8.2

An ergonomic and type-safe ORM for database interactions
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118

//! # Basic SQLOrm Example
//!
//! This example demonstrates the basic usage of SQLOrm with PostgreSQL.
//! Run with: `cargo run --example basic --features="postgres uuid extra-traits"`

use chrono::{DateTime, Utc};
use serde::{Deserialize, Serialize};
use sqlorm::prelude::*;
use sqlorm::sqlx::Executor;
use sqlorm::table;

use uuid::Uuid;

pub async fn create_test_db() -> Pool {
    let base_url = "postgres://test:test@localhost:5432/".to_string();

    let admin_pool = Pool::connect(&base_url).await.unwrap();

    let db_name = format!("test_db_{}", Uuid::new_v4().to_string().replace("-", ""));
    admin_pool
        .execute(format!(r#"CREATE DATABASE "{}""#, db_name).as_str())
        .await
        .expect("Failed to create test database");

    let mut test_db_url = base_url.clone();
    if let Some(idx) = test_db_url.rfind('/') {
        test_db_url.replace_range(idx + 1.., &db_name);
    }

    Pool::connect(&test_db_url)
        .await
        .expect("Failed to connect to test database")
}
// Define a simple User entity
#[table(name = "user")]
#[derive(Debug, Clone, Serialize, Deserialize, Default)]
pub struct User {
    #[sql(pk)]
    pub id: i64,
    #[sql(unique)]
    pub email: String,
    pub username: String,
    pub first_name: String,
    pub last_name: String,
    #[sql(timestamp(created_at, chrono::Utc::now()))]
    pub created_at: DateTime<Utc>,
    #[sql(timestamp(updated_at, chrono::Utc::now()))]
    pub updated_at: DateTime<Utc>,
}

impl User {
    pub fn new(email: &str, username: &str, first_name: &str, last_name: &str) -> Self {
        Self {
            email: email.to_string(),
            username: username.to_string(),
            first_name: first_name.to_string(),
            last_name: last_name.to_string(),
            ..Default::default()
        }
    }
}

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let pool = create_test_db().await;

    // Create the users table
    sqlorm::sqlx::query(
        r#"
        CREATE TABLE IF NOT EXISTS "user" (
            id BIGSERIAL PRIMARY KEY,
            email VARCHAR NOT NULL UNIQUE,
            username VARCHAR NOT NULL UNIQUE,
            first_name VARCHAR NOT NULL,
            last_name VARCHAR NOT NULL,
            created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
            updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
        )
    "#,
    )
    .execute(&pool)
    .await?;

    println!("Created users table");

    // Create and save a new user
    let user = User::new("alice@example.com", "alice", "Alice", "Smith")
        .save(&pool)
        .await?;

    println!("Created user: {:?}", user);

    // Find the user by ID
    let found_user = User::find_by_id(&pool, user.id)
        .await?
        .expect("User should exist");

    println!("Found user by ID: {:?}", found_user);

    // Update the user
    let mut updated_user = found_user;
    updated_user.username = "alice_updated".to_string();
    let updated_user = updated_user.save(&pool).await?;

    println!("Updated user: {:?}", updated_user);

    // Query users with filtering
    let users_named_alice = User::query()
        .filter(User::FIRST_NAME.eq("Alice".to_string()))
        .fetch_all(&pool)
        .await?;

    println!("Users named Alice: {:?}", users_named_alice);

    println!("Basic example completed successfully!");

    Ok(())
}