things3-core 1.2.0

Core library for Things 3 database access and data models
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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149

use criterion::{black_box, criterion_group, criterion_main, BenchmarkId, Criterion, Throughput};
use things3_core::test_utils::create_test_database;
use things3_core::{CreateTaskRequest, ThingsDatabase};
use tokio::runtime::Runtime;

fn create_test_db_with_data(task_count: usize) -> (tempfile::NamedTempFile, ThingsDatabase) {
    let rt = Runtime::new().unwrap();
    let temp_file = tempfile::NamedTempFile::new().unwrap();
    let db_path = temp_file.path().to_path_buf();

    let db = rt.block_on(async {
        create_test_database(&db_path).await.unwrap();
        let db = ThingsDatabase::new(&db_path).await.unwrap();

        // Insert test tasks
        for i in 0..task_count {
            let request = CreateTaskRequest {
                title: format!("Cache Test Task {}", i),
                notes: Some(format!("Task for cache benchmarking {}", i)),
                deadline: None,
                start_date: None,
                project_uuid: None,
                area_uuid: None,
                parent_uuid: None,
                tags: None,
                task_type: None,
                status: None,
            };
            db.create_task(request).await.unwrap();
        }

        db
    });

    (temp_file, db)
}

fn bench_cache_cold_read(c: &mut Criterion) {
    let mut group = c.benchmark_group("cache_cold_read");
    group.warm_up_time(std::time::Duration::from_secs(2));
    let rt = Runtime::new().unwrap();

    for size in [100, 500, 1000].iter() {
        group.throughput(Throughput::Elements(*size as u64));

        group.bench_with_input(BenchmarkId::from_parameter(size), size, |b, &size| {
            b.iter_batched(
                || {
                    // Setup: create fresh database (cold cache)
                    create_test_db_with_data(size)
                },
                |(_temp, db)| {
                    // Benchmark: first read (cache miss)
                    rt.block_on(async {
                        let tasks = db.get_inbox(Some(size)).await.unwrap();
                        black_box(tasks);
                    });
                },
                criterion::BatchSize::SmallInput,
            );
        });
    }

    group.finish();
}

fn bench_cache_warm_read(c: &mut Criterion) {
    let mut group = c.benchmark_group("cache_warm_read");
    group.warm_up_time(std::time::Duration::from_secs(2));
    let rt = Runtime::new().unwrap();

    for size in [100, 500, 1000].iter() {
        group.throughput(Throughput::Elements(*size as u64));

        let (_temp, db) = create_test_db_with_data(*size);

        // Warm up the cache
        rt.block_on(async {
            let _ = db.get_inbox(Some(*size)).await.unwrap();
        });

        group.bench_with_input(BenchmarkId::from_parameter(size), size, |b, &size| {
            b.to_async(&rt).iter(|| async {
                // Benchmark: subsequent reads (cache hit)
                let tasks = db.get_inbox(Some(size)).await.unwrap();
                black_box(tasks);
            });
        });
    }

    group.finish();
}

fn bench_cache_hit_rate(c: &mut Criterion) {
    let mut group = c.benchmark_group("cache_hit_rate");
    group.warm_up_time(std::time::Duration::from_secs(2));
    let rt = Runtime::new().unwrap();

    let (_temp, db) = create_test_db_with_data(1000);

    // Warm up cache with initial reads
    rt.block_on(async {
        let _ = db.get_inbox(Some(100)).await.unwrap();
        let _ = db.get_today(Some(100)).await.unwrap();
        let _ = db.search_tasks("Test").await.unwrap();
    });

    group.bench_function("mixed_queries", |b| {
        b.to_async(&rt).iter(|| async {
            // Mix of cached and uncached queries
            let inbox = db.get_inbox(Some(50)).await.unwrap();
            let today = db.get_today(Some(50)).await.unwrap();
            let search = db.search_tasks("Cache").await.unwrap();
            black_box((inbox, today, search));
        });
    });

    group.finish();
}

fn bench_cache_eviction(c: &mut Criterion) {
    let mut group = c.benchmark_group("cache_eviction");
    group.warm_up_time(std::time::Duration::from_secs(2));
    let rt = Runtime::new().unwrap();

    let (_temp, db) = create_test_db_with_data(5000);

    group.bench_function("large_dataset_queries", |b| {
        b.to_async(&rt).iter(|| async {
            // Query different subsets to trigger cache eviction
            for i in 0..10 {
                let query = format!("Task {}", i * 100);
                let results = db.search_tasks(&query).await.unwrap();
                black_box(results);
            }
        });
    });

    group.finish();
}

criterion_group!(
    benches,
    bench_cache_cold_read,
    bench_cache_warm_read,
    bench_cache_hit_rate,
    bench_cache_eviction
);
criterion_main!(benches);