this-me 0.1.6

Encrypted identity store CLI tool (this.me)
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

//this.me/src/migrate_schema.rs
// by suiGn 
use rusqlite::{Connection, Result as SqlResult};
pub fn migrate_schema(conn: &Connection) -> SqlResult<()> {
    // Table for identity metadata (keys encrypted locally)
    conn.execute(
        "CREATE TABLE IF NOT EXISTS me (
            username TEXT PRIMARY KEY,
            public_key TEXT NOT NULL,
            encrypted_private_key TEXT NOT NULL,
            created_at TEXT NOT NULL
        )",
        [],
    )?;
    // Table for registered keys (secrets)
    conn.execute(
        "CREATE TABLE IF NOT EXISTS keys (
            context_id TEXT PRIMARY KEY,
            username TEXT,
            type TEXT DEFAULT 'generic',
            public_address TEXT,
            created_at TEXT NOT NULL
        )",
        [],
    )?;

    // Table for "be" verb
    conn.execute(
        "CREATE TABLE IF NOT EXISTS be (
            context_id TEXT NOT NULL,
            key TEXT NOT NULL,
            value TEXT NOT NULL,
            timestamp TEXT NOT NULL
        )",
        [],
    )?;

    // Table for "have" verb
    conn.execute(
        "CREATE TABLE IF NOT EXISTS have (
            context_id TEXT NOT NULL,
            key TEXT NOT NULL,
            value TEXT NOT NULL,
            timestamp TEXT NOT NULL
        )",
        [],
    )?;

    // Table for "at" verb
    conn.execute(
        "CREATE TABLE IF NOT EXISTS at (
            context_id TEXT NOT NULL,
            key TEXT NOT NULL,
            value TEXT NOT NULL,
            timestamp TEXT NOT NULL
        )",
        [],
    )?;

    // Table for "relate" verb
    conn.execute(
        "CREATE TABLE IF NOT EXISTS relate (
            context_id TEXT NOT NULL,
            key TEXT NOT NULL,
            target TEXT NOT NULL,
            value TEXT,
            timestamp TEXT NOT NULL
        )",
        [],
    )?;

    // Table for "react" verb
    conn.execute(
        "CREATE TABLE IF NOT EXISTS react (
            context_id TEXT NOT NULL,
            key TEXT NOT NULL,
            target TEXT NOT NULL,
            emoji TEXT NOT NULL,
            timestamp TEXT NOT NULL
        )",
        [],
    )?;

    // Table for "arc" (Affinity–Reality–Communication)
    conn.execute(
        "CREATE TABLE IF NOT EXISTS arc (
            context_id TEXT NOT NULL,
            actor TEXT NOT NULL,
            target TEXT NOT NULL,
            affinity REAL DEFAULT 0.0,
            reality REAL DEFAULT 0.0,
            communication REAL DEFAULT 0.0,
            timestamp TEXT NOT NULL
        )",
        [],
    )?;

    // Table for "do" verb
    conn.execute(
        "CREATE TABLE IF NOT EXISTS do_ (
            context_id TEXT NOT NULL,
            key TEXT NOT NULL,
            value TEXT NOT NULL,
            timestamp TEXT NOT NULL
        )",
        [],
    )?;

    // Table for "communicate" verb
    conn.execute(
        "CREATE TABLE IF NOT EXISTS communicate (
            context_id TEXT NOT NULL,
            key TEXT NOT NULL,
            target TEXT NOT NULL,
            message TEXT NOT NULL,
            lang TEXT DEFAULT 'en',
            timestamp TEXT NOT NULL
        )",
        [],
    )?;

    Ok(())
}