raisfast 0.2.20

The last backend you'll ever need. Rust-powered headless CMS with built-in blog, ecommerce, wallet, payment and 4 plugin engines.
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

//! Audit log data model and database queries

use serde::{Deserialize, Serialize};
#[cfg(feature = "export-types")]
use ts_rs::TS;

use crate::errors::app_error::AppResult;
use crate::types::snowflake_id::SnowflakeId;
use crate::utils::tz::Timestamp;

/// Full database row for an audit log entry
#[cfg_attr(feature = "export-types", derive(TS))]
#[derive(Debug, Serialize, Deserialize, Clone, sqlx::FromRow)]
pub struct AuditEntry {
    pub id: SnowflakeId,
    pub tenant_id: Option<String>,
    pub actor_id: Option<SnowflakeId>,
    pub actor_role: Option<String>,
    pub action: String,
    pub subject: String,
    pub subject_id: Option<String>,
    pub detail: Option<String>,
    pub ip_address: Option<String>,
    pub user_agent: Option<String>,
    pub created_at: Timestamp,
}

/// Insert an audit log entry
pub async fn insert(pool: &crate::db::Pool, entry: &AuditEntry) -> AppResult<()> {
    raisfast_derive::crud_insert!(
        pool,
        "audit_log",
        [
            "id" => entry.id,
            "actor_id" => entry.actor_id,
            "actor_role" => &entry.actor_role,
            "action" => &entry.action,
            "subject" => &entry.subject,
            "subject_id" => &entry.subject_id,
            "detail" => &entry.detail,
            "ip_address" => &entry.ip_address,
            "user_agent" => &entry.user_agent,
            "created_at" => entry.created_at
        ],
        tenant: entry.tenant_id.as_deref()
    )?;
    Ok(())
}

/// Paginated query for audit logs
pub async fn find_paginated(
    pool: &crate::db::Pool,
    tenant_id: Option<&str>,
    action: Option<&str>,
    actor_id: Option<i64>,
    page: i64,
    page_size: i64,
) -> AppResult<(Vec<AuditEntry>, i64)> {
    let result = raisfast_derive::crud_query_paged!(
        pool, AuditEntry,
        table: "audit_log",
        where: AND(("tenant_id", tenant_id), ("action", action), ("actor_id", actor_id)),
        order_by: "created_at DESC",
        page: page,
        page_size: page_size
    );
    Ok(result)
}

/// Find an audit log entry by ID
pub async fn find_by_id(pool: &crate::db::Pool, id: SnowflakeId) -> AppResult<AuditEntry> {
    raisfast_derive::crud_find_one!(pool, "audit_log", AuditEntry, where: ("id", id))
        .map_err(Into::into)
}