sbol-db-postgres 0.1.0

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
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

use sbol::ValidationReport;
use sbol_db_core::{DomainError, GraphId, Severity, ValidationRunId, ValidationStatus};
use sqlx::Row;
use uuid::Uuid;

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

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

#[derive(Debug, Clone)]
pub struct RecordedValidation {
    pub run_id: ValidationRunId,
    pub status: ValidationStatus,
    pub issue_count: usize,
}

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

    /// Record a validation run plus all of its findings. Run inside the
    /// caller's transaction.
    #[allow(clippy::too_many_arguments)]
    pub async fn record_run(
        &self,
        conn: &mut sqlx::PgConnection,
        target_iri: &str,
        graph_id: Option<GraphId>,
        validator_name: &str,
        validator_version: Option<&str>,
        ruleset: &str,
        report: &ValidationReport,
    ) -> Result<RecordedValidation, DomainError> {
        let status = classify(report);
        let run_row = sqlx::query(
            r#"
            INSERT INTO sbol_validation_runs (
                target_iri, graph_id, validator_name, validator_version,
                ruleset, status, finished_at, summary
            ) VALUES ($1, $2, $3, $4, $5, $6, now(), $7)
            RETURNING id
            "#,
        )
        .bind(target_iri)
        .bind(graph_id.map(|d| d.0))
        .bind(validator_name)
        .bind(validator_version)
        .bind(ruleset)
        .bind(status.as_db_str())
        .bind(serde_json::json!({
            "issue_count": report.issues().len(),
            "error_count": report.errors().count(),
            "warning_count": report.warnings().count(),
        }))
        .fetch_one(&mut *conn)
        .await
        .map_err(db_err)?;
        let run_id: Uuid = run_row.try_get("id").map_err(db_err)?;

        for issue in report.issues() {
            let severity = match issue.severity {
                sbol::Severity::Warning => Severity::Warning,
                sbol::Severity::Error => Severity::Error,
                _ => Severity::Warning,
            };
            let subject_iri = issue.subject.as_iri().map(|i| i.as_str().to_owned());
            sqlx::query(
                r#"
                INSERT INTO sbol_validation_findings (
                    validation_run_id, severity, rule_id, message, subject_iri, path
                ) VALUES ($1, $2, $3, $4, $5, $6)
                "#,
            )
            .bind(run_id)
            .bind(severity.as_db_str())
            .bind(issue.rule)
            .bind(&issue.message)
            .bind(subject_iri)
            .bind(issue.property)
            .execute(&mut *conn)
            .await
            .map_err(db_err)?;
        }

        Ok(RecordedValidation {
            run_id: ValidationRunId(run_id),
            status,
            issue_count: report.issues().len(),
        })
    }
}

fn classify(report: &ValidationReport) -> ValidationStatus {
    if report.has_errors() {
        ValidationStatus::Failed
    } else if report.warnings().next().is_some() {
        ValidationStatus::Warning
    } else {
        ValidationStatus::Passed
    }
}