sbol-db-postgres 0.1.8

Postgres persistence layer for sbol-db.
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

use sbol_db_core::{DomainError, IriString};
use serde_json::Value;

use crate::repo::db_err;
use crate::PgPool;

#[derive(Clone)]
pub struct ProjectionEventRepository {
    _pool: PgPool,
}

#[derive(Clone, Debug)]
pub struct ProjectionEvent {
    pub event_type: String,
    pub subject_iri: Option<IriString>,
    pub graph_iri: Option<IriString>,
    pub payload: Value,
}

impl ProjectionEventRepository {
    pub fn new(pool: PgPool) -> Self {
        Self { _pool: pool }
    }

    pub async fn append(
        &self,
        conn: &mut sqlx::PgConnection,
        event: ProjectionEvent,
    ) -> Result<i64, DomainError> {
        use sqlx::Row;
        let row = sqlx::query(
            r#"
            INSERT INTO sbol_rdf_projection_events (event_type, subject_iri, graph_iri, payload)
            VALUES ($1, $2, $3, $4)
            RETURNING id
            "#,
        )
        .bind(event.event_type)
        .bind(event.subject_iri.as_ref().map(|i| i.as_str()))
        .bind(event.graph_iri.as_ref().map(|i| i.as_str()))
        .bind(event.payload)
        .fetch_one(&mut *conn)
        .await
        .map_err(db_err)?;
        let id: i64 = row.try_get("id").map_err(db_err)?;
        Ok(id)
    }
}