relay-knowledge 1.1.17

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
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

//! SQLite DDL for persisted code-graph facts.

use rusqlite::Connection;

use crate::storage::StorageError;

pub(in crate::storage::sqlite) fn initialize_schema(
    connection: &Connection,
) -> Result<(), StorageError> {
    connection.execute_batch(
        "
        DROP INDEX IF EXISTS code_symbols_lookup;
        DROP INDEX IF EXISTS code_references_lookup;
        DROP INDEX IF EXISTS code_chunks_lookup;

        CREATE TABLE IF NOT EXISTS code_files (
            source_scope TEXT NOT NULL,
            path TEXT NOT NULL,
            content_hash TEXT NOT NULL,
            language_id TEXT NOT NULL,
            parse_status TEXT NOT NULL,
            diagnostic TEXT,
            created_graph_version INTEGER NOT NULL,
            PRIMARY KEY (source_scope, path)
        );

        CREATE TABLE IF NOT EXISTS code_symbols (
            source_scope TEXT NOT NULL,
            path TEXT NOT NULL,
            symbol_id TEXT NOT NULL,
            name TEXT NOT NULL,
            kind TEXT NOT NULL,
            start_byte INTEGER NOT NULL,
            end_byte INTEGER NOT NULL,
            start_line INTEGER NOT NULL,
            end_line INTEGER NOT NULL,
            grammar_version TEXT NOT NULL,
            query_name TEXT NOT NULL,
            query_version TEXT NOT NULL,
            node_kind TEXT NOT NULL,
            capture_kind TEXT NOT NULL,
            created_graph_version INTEGER NOT NULL,
            PRIMARY KEY (source_scope, path, symbol_id),
            FOREIGN KEY (source_scope, path)
                REFERENCES code_files(source_scope, path)
                ON DELETE CASCADE
        );

        CREATE TABLE IF NOT EXISTS code_references (
            source_scope TEXT NOT NULL,
            path TEXT NOT NULL,
            reference_id TEXT NOT NULL,
            symbol_text TEXT NOT NULL,
            kind TEXT NOT NULL,
            start_byte INTEGER NOT NULL,
            end_byte INTEGER NOT NULL,
            start_line INTEGER NOT NULL,
            end_line INTEGER NOT NULL,
            resolution_state TEXT NOT NULL,
            target_symbol_id TEXT,
            grammar_version TEXT NOT NULL,
            query_name TEXT NOT NULL,
            query_version TEXT NOT NULL,
            node_kind TEXT NOT NULL,
            capture_kind TEXT NOT NULL,
            created_graph_version INTEGER NOT NULL,
            PRIMARY KEY (source_scope, path, reference_id),
            FOREIGN KEY (source_scope, path)
                REFERENCES code_files(source_scope, path)
                ON DELETE CASCADE
        );

        CREATE TABLE IF NOT EXISTS code_chunks (
            source_scope TEXT NOT NULL,
            path TEXT NOT NULL,
            chunk_id TEXT NOT NULL,
            content TEXT NOT NULL,
            start_byte INTEGER NOT NULL,
            end_byte INTEGER NOT NULL,
            start_line INTEGER NOT NULL,
            end_line INTEGER NOT NULL,
            grammar_version TEXT,
            query_name TEXT,
            query_version TEXT,
            node_kind TEXT,
            capture_kind TEXT,
            created_graph_version INTEGER NOT NULL,
            PRIMARY KEY (source_scope, path, chunk_id),
            FOREIGN KEY (source_scope, path)
                REFERENCES code_files(source_scope, path)
                ON DELETE CASCADE
        );

        CREATE TABLE IF NOT EXISTS code_chunk_symbols (
            source_scope TEXT NOT NULL,
            path TEXT NOT NULL,
            chunk_id TEXT NOT NULL,
            symbol_id TEXT NOT NULL,
            PRIMARY KEY (source_scope, path, chunk_id, symbol_id),
            FOREIGN KEY (source_scope, path, chunk_id)
                REFERENCES code_chunks(source_scope, path, chunk_id)
                ON DELETE CASCADE
        );

        CREATE INDEX IF NOT EXISTS code_symbols_lookup
            ON code_symbols(source_scope, name, path);
        CREATE INDEX IF NOT EXISTS code_references_lookup
            ON code_references(source_scope, symbol_text, target_symbol_id);
        CREATE INDEX IF NOT EXISTS code_chunks_lookup
            ON code_chunks(source_scope, path);
        ",
    )?;

    Ok(())
}

#[cfg(test)]
#[path = "mod_tests.rs"]
mod schema_tests;