pdt 0.3.5

Asset store API with relation graphs, tagging, full-text search, multi-instance SQLite tenancy, OIDC auth and Cedar authorization
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
119
120
121
122
123
124
125

//! Database connection and operations

use anyhow::Result;
use mongodb::{
    options::{ClientOptions, Credential},
    Client, Collection, Database as MongoDatabase, IndexModel,
};

use crate::config::DatabaseConfig;
use crate::models::{Asset, AuditEntry, Collection as CollectionModel, Relation};

/// Database wrapper for MongoDB/DocumentDB operations
#[derive(Clone)]
pub struct Database {
    db: MongoDatabase,
}

impl Database {
    /// Connect to the database
    pub async fn connect(config: &DatabaseConfig) -> Result<Self> {
        let mut options = ClientOptions::parse(config.connection_string()).await?;

        // Set credentials
        options.credential = Some(
            Credential::builder()
                .username(config.username.clone())
                .password(config.password.clone())
                .source("admin".to_string())
                .build(),
        );

        let client = Client::with_options(options)?;

        // Verify connection
        client
            .database("admin")
            .run_command(bson::doc! { "ping": 1 })
            .await?;

        let db = client.database(&config.database);

        Ok(Database { db })
    }

    /// Get the assets collection
    pub fn assets(&self) -> Collection<Asset> {
        self.db.collection("assets")
    }

    /// Get the relations collection
    pub fn relations(&self) -> Collection<Relation> {
        self.db.collection("relations")
    }

    /// Get the collections collection
    pub fn collections(&self) -> Collection<CollectionModel> {
        self.db.collection("collections")
    }

    /// Get the audit entries collection
    pub fn audit(&self) -> Collection<AuditEntry> {
        self.db.collection("audit")
    }

    /// Create database indices
    pub async fn create_indices(&self) -> Result<()> {
        // Asset indices
        let asset_indices = vec![
            IndexModel::builder()
                .keys(bson::doc! { "tags.category": 1, "tags.value": 1 })
                .build(),
            IndexModel::builder()
                .keys(bson::doc! { "created_by": 1 })
                .build(),
            IndexModel::builder()
                .keys(bson::doc! { "deleted_at": 1 })
                .build(),
            IndexModel::builder()
                .keys(bson::doc! { "title": "text", "content": "text" })
                .build(),
        ];
        self.assets().create_indexes(asset_indices).await?;

        // Relation indices
        let relation_indices = vec![
            IndexModel::builder()
                .keys(bson::doc! { "from_asset_id": 1 })
                .build(),
            IndexModel::builder()
                .keys(bson::doc! { "to_asset_id": 1 })
                .build(),
            IndexModel::builder()
                .keys(bson::doc! { "relation_type": 1 })
                .build(),
        ];
        self.relations().create_indexes(relation_indices).await?;

        // Collection indices
        let collection_indices = vec![
            IndexModel::builder().keys(bson::doc! { "name": 1 }).build(),
            IndexModel::builder()
                .keys(bson::doc! { "asset_ids": 1 })
                .build(),
        ];
        self.collections()
            .create_indexes(collection_indices)
            .await?;

        // Audit indices
        let audit_indices = vec![
            IndexModel::builder()
                .keys(bson::doc! { "entity_type": 1, "entity_id": 1 })
                .build(),
            IndexModel::builder()
                .keys(bson::doc! { "user_id": 1 })
                .build(),
            IndexModel::builder()
                .keys(bson::doc! { "timestamp": -1 })
                .build(),
        ];
        self.audit().create_indexes(audit_indices).await?;

        Ok(())
    }
}