relay-knowledge 1.1.9

Graph-database-based knowledge graph project.
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

use rusqlite::Connection;

use crate::storage::StorageError;

pub(super) fn code_schema_migration_applied(
    connection: &Connection,
    name: &str,
) -> Result<bool, StorageError> {
    connection
        .query_row(
            "
            SELECT EXISTS (
                SELECT 1
                FROM code_repository_schema_migrations
                WHERE name = ?1
            )
            ",
            [name],
            |row| row.get::<_, bool>(0),
        )
        .map_err(StorageError::from)
}

pub(super) fn mark_code_schema_migration(
    connection: &Connection,
    name: &str,
) -> Result<(), StorageError> {
    connection.execute(
        "
        INSERT OR REPLACE INTO code_repository_schema_migrations (name, applied_at_ms)
        VALUES (?1, CAST(strftime('%s', 'now') AS INTEGER) * 1000)
        ",
        [name],
    )?;
    Ok(())
}

pub(super) fn table_has_columns(
    connection: &Connection,
    table: &str,
    required_columns: &[&str],
) -> Result<bool, StorageError> {
    let columns = table_columns(connection, table)?;
    Ok(required_columns
        .iter()
        .all(|required| columns.iter().any(|column| column == required)))
}

fn table_columns(connection: &Connection, table: &str) -> Result<Vec<String>, StorageError> {
    let mut statement = connection.prepare(&format!("PRAGMA table_info({table})"))?;
    let rows = statement.query_map([], |row| row.get::<_, String>(1))?;
    rows.collect::<Result<Vec<_>, _>>()
        .map_err(StorageError::from)
}