envstash 0.1.12

Manage .env files across git branches with versioning, diffing, and optional encryption
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

use rusqlite::Connection;
use rusqlite_migration::{M, Migrations};

use crate::error::{Error, Result};

fn migrations() -> Migrations<'static> {
    Migrations::new(vec![M::up(
        "
        CREATE TABLE config (
            key   TEXT PRIMARY KEY,
            value TEXT NOT NULL
        );

        CREATE TABLE saves (
            id           INTEGER PRIMARY KEY AUTOINCREMENT,
            project_path TEXT    NOT NULL,
            file_path    TEXT    NOT NULL,
            branch       TEXT    NOT NULL DEFAULT '',
            commit_hash  TEXT    NOT NULL DEFAULT '',
            timestamp    TEXT    NOT NULL,
            content_hash TEXT    NOT NULL,
            hmac         TEXT    NOT NULL DEFAULT '',
            message      TEXT    NOT NULL DEFAULT ''
        );

        CREATE INDEX idx_saves_project_branch
            ON saves(project_path, branch);

        CREATE INDEX idx_saves_content_hash
            ON saves(content_hash);

        CREATE TABLE entries (
            id       INTEGER PRIMARY KEY AUTOINCREMENT,
            save_id  INTEGER NOT NULL REFERENCES saves(id) ON DELETE CASCADE,
            key      TEXT    NOT NULL,
            value    BLOB    NOT NULL,
            comment  BLOB    NOT NULL DEFAULT ''
        );

        CREATE INDEX idx_entries_save_id
            ON entries(save_id);
        ",
    )])
}

/// Run all pending migrations on the connection.
pub fn migrate(conn: &mut Connection) -> Result<()> {
    migrations()
        .to_latest(conn)
        .map_err(|e| Error::Migration(e.to_string()))
}