esetres 0.1.4

A self hosted file storage server.
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

use rusqlite::Connection;
use tokio::task;

pub mod schema;

const MIGRATION: &str = r#"
    CREATE TABLE IF NOT EXISTS tokens (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        name TEXT NOT NULL UNIQUE,
        bucket_scope TEXT NOT NULL,
        access TEXT NOT NULL, -- read / write / full
        token TEXT NOT NULL
    )
"#;

pub async fn migrate() -> Result<(), Box<dyn std::error::Error>> {
    if let Err(_) = tokio::fs::read_dir("./db").await {
        tokio::fs::create_dir("./db").await?;
    }

    task::spawn_blocking(move || -> rusqlite::Result<()> {
        let conn = connect()?;

        conn.execute_batch(MIGRATION)?;

        Ok(())
    })
    .await??;

    Ok(())
}

pub fn connect() -> rusqlite::Result<Connection> {
    Ok(Connection::open("./db/database.db")?)
}