pipe-audit-core 0.1.8

Universal data validation and compliance audit engine
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

// src/validators/column/date_format.rs

use crate::validators::{ValidationReport, ValidationResult, Validator};
use chrono::NaiveDateTime;
use polars::prelude::*;

pub struct DateFormatValidator {
    pub format: String,
}

impl Validator for DateFormatValidator {
    fn name(&self) -> &'static str {
        "DateFormat"
    }

    fn validate(&self, df: &DataFrame, column_name: &str) -> ValidationResult<ValidationReport> {
        let series = df.column(column_name)?;

        if let Ok(utf8_chunked) = series.str() {
            let bad_count = utf8_chunked
                .into_iter()
                .filter(|opt_val| {
                    if let Some(val) = opt_val {
                        NaiveDateTime::parse_from_str(val, &self.format).is_err()
                    } else {
                        false // Null values don't fail a format match
                    }
                })
                .count();

            if bad_count > 0 {
                Ok(ValidationReport {
                    status: "fail",
                    details: Some(format!("bad_count={}, format={}", bad_count, self.format)),
                })
            } else {
                Ok(ValidationReport {
                    status: "pass",
                    details: None,
                })
            }
        } else {
            Ok(ValidationReport {
                status: "skipped",
                details: Some("column is not a string type".to_string()),
            })
        }
    }
}

#[cfg(test)]
mod tests {
    use super::*;

    fn make_str_df(values: &[Option<&str>]) -> DataFrame {
        let s = Series::new("col".into(), values.to_vec());
        DataFrame::new(vec![s.into()]).unwrap()
    }

    #[test]
    fn passes_when_all_values_match_format() {
        let df = make_str_df(&[Some("2024-01-01 12:00:00"), Some("1999-12-31 23:59:59")]);
        let validator = DateFormatValidator {
            format: "%Y-%m-%d %H:%M:%S".to_string(),
        };
        let report = validator.validate(&df, "col").unwrap();
        assert_eq!(report.status, "pass");
        assert!(report.details.is_none());
    }

    #[test]
    fn fails_when_some_values_do_not_match_format() {
        let df = make_str_df(&[
            Some("2024-01-01 12:00:00"),
            Some("not-a-date"),
            Some("2024/01/01 12:00:00"),
        ]);
        let validator = DateFormatValidator {
            format: "%Y-%m-%d %H:%M:%S".to_string(),
        };
        let report = validator.validate(&df, "col").unwrap();
        assert_eq!(report.status, "fail");
        assert!(report.details.unwrap().contains("bad_count=2"));
    }

    #[test]
    fn ignores_null_values() {
        let df = make_str_df(&[Some("2024-01-01 12:00:00"), None]);
        let validator = DateFormatValidator {
            format: "%Y-%m-%d %H:%M:%S".to_string(),
        };
        let report = validator.validate(&df, "col").unwrap();
        assert_eq!(report.status, "pass");
    }

    #[test]
    fn passes_on_empty_column() {
        let s: Series = Series::new("col".into(), Vec::<Option<&str>>::new());
        let df = DataFrame::new(vec![s.into()]).unwrap();
        let validator = DateFormatValidator {
            format: "%Y-%m-%d %H:%M:%S".to_string(),
        };
        let report = validator.validate(&df, "col").unwrap();
        assert_eq!(report.status, "pass");
    }

    #[test]
    fn skips_on_non_string_column() {
        let s = Series::new("col".into(), &[1, 2, 3]);
        let df = DataFrame::new(vec![s.into()]).unwrap();
        let validator = DateFormatValidator {
            format: "%Y-%m-%d %H:%M:%S".to_string(),
        };
        let report = validator.validate(&df, "col").unwrap();
        assert_eq!(report.status, "skipped");
        assert!(report.details.unwrap().contains("not a string"));
    }
}