boxlite 0.9.1

Embeddable virtual machine runtime for secure, isolated code execution
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

//! Migration v2 → v3: Add name column to box_config.

use rusqlite::Connection;

use boxlite_shared::errors::{BoxliteError, BoxliteResult};

use super::{Migration, db_err};

pub(crate) struct AddNameColumn;

impl Migration for AddNameColumn {
    fn source_version(&self) -> i32 {
        2
    }
    fn target_version(&self) -> i32 {
        3
    }
    fn description(&self) -> &str {
        "Add name column to box_config"
    }

    fn run(&self, conn: &Connection, _home_dir: Option<&std::path::Path>) -> BoxliteResult<()> {
        db_err!(conn.execute_batch("ALTER TABLE box_config ADD COLUMN name TEXT;"))?;
        db_err!(conn.execute_batch(
            "CREATE UNIQUE INDEX IF NOT EXISTS idx_box_config_name_unique ON box_config(name);"
        ))?;
        db_err!(conn.execute_batch(
            "UPDATE box_config SET name = json_extract(json, '$.name') WHERE name IS NULL;"
        ))?;
        Ok(())
    }
}