datasources-sqlite 0.1.24

SQLite datasource provider
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

use chrono::{TimeZone, Utc};
use datasources::{
    Casing, CRUDRepository, CRUDRepositoryOptions, ChangeCasingMapper, Connection,
    Row, Schema, Value,
};
use std::collections::HashMap;
use std::sync::Arc;

use crate::connection::SqliteConnection;

#[tokio::test]
async fn omits_null_datetime_and_version() {
    let conn = Arc::new(SqliteConnection::new(Some(":memory:".into())));
    conn.open().await.unwrap();
    datasources_tests::apply_schema(conn.as_ref(), "null-write-item")
        .await
        .unwrap();
    let mut options = CRUDRepositoryOptions::default();
    options.entity = "Item".into();
    options.entity_mapper = Some(std::sync::Arc::new(ChangeCasingMapper::new(Casing::Pascal, Casing::Snake)));
    options.property_mappings = Some(std::sync::Arc::new(ChangeCasingMapper::new(Casing::Pascal, Casing::Snake)));
    options.ids = vec!["Id".into()];
    options.schema = Schema::new(HashMap::from([
        ("Id".into(), "integer".into()),
        ("Name".into(), "string".into()),
        ("Created".into(), "datetime".into()),
        ("Version".into(), "binary".into()),
    ]));
    let repo = CRUDRepository::<Row>::new(conn, options).unwrap();
    let mut omitted = Row::new();
    omitted.insert("Name".into(), Value::from("ada"));
    omitted.insert("Created".into(), Value::Null);
    omitted.insert("Version".into(), Value::Null);
    let omitted = repo.create(omitted).await.unwrap();
    assert!(matches!(omitted.get("Id"), Some(Value::Int(id)) if *id > 0));
    let stored = repo
        .read_single_by_id(omitted.get("Id").unwrap())
        .await
        .unwrap()
        .unwrap();
    let mut renamed = stored.clone();
    renamed.insert("Name".into(), Value::from("ada-v2"));
    let updated = repo.update(renamed).await.unwrap();
    assert_eq!(updated.rows_affected, 1);
    let kept = repo
        .read_single_by_id(omitted.get("Id").unwrap())
        .await
        .unwrap()
        .unwrap();
    let created = Utc.with_ymd_and_hms(2024, 6, 1, 0, 0, 0).unwrap();
    let mut explicit = Row::new();
    explicit.insert("Name".into(), Value::from("grace"));
    explicit.insert("Created".into(), Value::DateTime(created));
    explicit.insert("Version".into(), Value::Binary(vec![9, 9]));
    let explicit = repo.create(explicit).await.unwrap();
    assert!(matches!(explicit.get("Id"), Some(Value::Int(id)) if *id > 0));
    let written = repo
        .read_single_by_id(explicit.get("Id").unwrap())
        .await
        .unwrap()
        .unwrap();

    assert_eq!(
        stored.get("Created"),
        Some(&Value::DateTime(
            Utc.with_ymd_and_hms(2020, 1, 1, 0, 0, 0).unwrap()
        ))
    );
    assert_eq!(stored.get("Version"), Some(&Value::Binary(vec![1, 2])));
    assert_eq!(kept.get("Name"), Some(&Value::from("ada-v2")));
    assert_eq!(kept.get("Created"), stored.get("Created"));
    assert_eq!(kept.get("Version"), stored.get("Version"));
    assert_eq!(written.get("Created"), Some(&Value::DateTime(created)));
    assert_eq!(written.get("Version"), Some(&Value::Binary(vec![9, 9])));
}