grepdown-lib 0.1.0

Core library for grepdown: SQLite-backed Markdown indexing, FTS5 search, and link-graph traversal
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

use crate::error::Result;
use rusqlite::Connection;

const MIGRATIONS: &[(&str, &str)] = &[
    ("0001_init", include_str!("migrations/0001_init.sql")),
    (
        "0002_tags_fts",
        include_str!("migrations/0002_tags_fts.sql"),
    ),
    (
        "0003_link_graph",
        include_str!("migrations/0003_link_graph.sql"),
    ),
    (
        "0004_drop_metadata",
        include_str!("migrations/0004_drop_metadata.sql"),
    ),
    (
        "0005_lint_versioning",
        include_str!("migrations/0005_lint_versioning.sql"),
    ),
    (
        "0006_broken_links",
        include_str!("migrations/0006_broken_links.sql"),
    ),
    (
        "0007_drop_link_type",
        include_str!("migrations/0007_drop_link_type.sql"),
    ),
    (
        "0008_content_hash_blob",
        include_str!("migrations/0008_content_hash_blob.sql"),
    ),
    (
        "0009_headings",
        include_str!("migrations/0009_headings.sql"),
    ),
    (
        "0010_add_anchor_to_links",
        include_str!("migrations/0010_add_anchor_to_links.sql"),
    ),
];

pub fn bootstrap(conn: &Connection) -> Result<()> {
    conn.execute_batch("CREATE TABLE IF NOT EXISTS schema_migrations (version INTEGER PRIMARY KEY, applied_at INTEGER NOT NULL DEFAULT (unixepoch()));")?;
    let current: i64 = conn.query_row(
        "SELECT COALESCE(MAX(version), 0) FROM schema_migrations",
        [],
        |r| r.get(0),
    )?;

    for (i, (_name, sql)) in MIGRATIONS.iter().enumerate() {
        let version = (i + 1) as i64;
        if version > current {
            conn.execute_batch(sql)?;
            log::info!("Applied migration: {}", _name);
        }
    }

    Ok(())
}