imessage-db 0.1.0

Read-only rusqlite access layer for the macOS iMessage chat.db schema.
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

/// Value transformers that convert raw SQLite values to Rust types.
///
/// - BooleanTransformer: integer 0/1 → bool
/// - DateTransformer: Apple timestamp → Unix ms (Option<i64>)
/// - ReactionTypeTransformer: reaction integer → string name
use imessage_core::dates::apple_to_unix_ms;

/// Convert a SQLite integer (0/1) to a boolean.
pub fn bool_from_db(val: i64) -> bool {
    val != 0
}

/// Convert an Apple timestamp from the iMessage DB to Unix epoch milliseconds.
/// Returns `None` if the value is 0 or null (meaning "not set").
pub fn date_from_db(val: i64) -> Option<i64> {
    apple_to_unix_ms(val)
}

/// Convert Unix epoch milliseconds to an Apple timestamp for DB queries.
pub fn date_to_db(unix_ms: i64) -> i64 {
    imessage_core::dates::unix_ms_to_apple(unix_ms)
}

/// Map of reaction integer IDs to their string names.
pub fn reaction_type_from_db(val: i64) -> Option<String> {
    match val {
        0 => None,
        1000 => Some("sticker".to_string()),
        2000 => Some("love".to_string()),
        2001 => Some("like".to_string()),
        2002 => Some("dislike".to_string()),
        2003 => Some("laugh".to_string()),
        2004 => Some("emphasize".to_string()),
        2005 => Some("question".to_string()),
        2006 => Some("emoji".to_string()),
        2007 => Some("sticker-tapback".to_string()),
        3000 => Some("-love".to_string()),
        3001 => Some("-like".to_string()),
        3002 => Some("-dislike".to_string()),
        3003 => Some("-laugh".to_string()),
        3004 => Some("-emphasize".to_string()),
        3005 => Some("-question".to_string()),
        3006 => Some("-emoji".to_string()),
        3007 => Some("-sticker-tapback".to_string()),
        other => Some(other.to_string()),
    }
}

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

    #[test]
    fn bool_from_db_values() {
        assert!(!bool_from_db(0));
        assert!(bool_from_db(1));
        assert!(bool_from_db(42)); // any non-zero is true
    }

    #[test]
    fn date_transform_zero_is_none() {
        assert_eq!(date_from_db(0), None);
    }

    #[test]
    fn date_transform_positive_value() {
        // 1 second after Apple epoch = APPLE_EPOCH_MS + 1000
        let raw = 1000 * 1_000_000; // 1000ms * multiplier
        let result = date_from_db(raw);
        assert_eq!(result, Some(978_307_200_000 + 1000));
    }

    #[test]
    fn reaction_type_known_values() {
        assert_eq!(reaction_type_from_db(0), None);
        assert_eq!(reaction_type_from_db(2000), Some("love".to_string()));
        assert_eq!(reaction_type_from_db(2001), Some("like".to_string()));
        assert_eq!(reaction_type_from_db(3000), Some("-love".to_string()));
    }

    #[test]
    fn reaction_type_emoji_and_sticker() {
        assert_eq!(reaction_type_from_db(2006), Some("emoji".to_string()));
        assert_eq!(
            reaction_type_from_db(2007),
            Some("sticker-tapback".to_string())
        );
        assert_eq!(reaction_type_from_db(3006), Some("-emoji".to_string()));
        assert_eq!(
            reaction_type_from_db(3007),
            Some("-sticker-tapback".to_string())
        );
    }

    #[test]
    fn reaction_type_unknown_passthrough() {
        assert_eq!(reaction_type_from_db(9999), Some("9999".to_string()));
    }
}