diff options
| author | Benedikt Peetz <benedikt.peetz@b-peetz.de> | 2026-03-19 05:02:59 +0100 |
|---|---|---|
| committer | Benedikt Peetz <benedikt.peetz@b-peetz.de> | 2026-03-19 05:02:59 +0100 |
| commit | f12fe4777ac6b333c5b5d9970c62a47befde11c6 (patch) | |
| tree | 0a0351c01b823532c9bae655f454a253f6b56c4a | |
| parent | fix(rocie-server/storage/migrate): Avoid querying `config` table before it ex... (diff) | |
| download | server-f12fe4777ac6b333c5b5d9970c62a47befde11c6.zip | |
chore(rocie-server/storage/config): Rename `config` table to `rocie-config`
| -rw-r--r-- | crates/rocie-server/src/storage/migrate/sql/0->1.sql | 6 | ||||
| -rw-r--r-- | crates/rocie-server/src/storage/sql/get/config/mod.rs | 2 | ||||
| -rw-r--r-- | crates/rocie-server/src/storage/sql/insert/config/mod.rs | 4 |
3 files changed, 7 insertions, 5 deletions
diff --git a/crates/rocie-server/src/storage/migrate/sql/0->1.sql b/crates/rocie-server/src/storage/migrate/sql/0->1.sql index 8f99322..dd7ce5f 100644 --- a/crates/rocie-server/src/storage/migrate/sql/0->1.sql +++ b/crates/rocie-server/src/storage/migrate/sql/0->1.sql @@ -179,9 +179,11 @@ CREATE TABLE txn_log ( operation TEXT NOT NULL ) STRICT; -CREATE TABLE config ( +CREATE TABLE rocie_config ( -- Make it impossible to insert more than one value here. id INTEGER PRIMARY KEY NOT NULL CHECK (id = 0), use_defaults INTEGER NOT NULL CHECK (use_defaults = 1 OR use_defaults = 0) ) STRICT; -INSERT INTO config (id, use_defaults) VALUES (0, 0); + +INSERT INTO rocie_config (id, use_defaults) +VALUES (0, 0); diff --git a/crates/rocie-server/src/storage/sql/get/config/mod.rs b/crates/rocie-server/src/storage/sql/get/config/mod.rs index eb8be86..92f39c2 100644 --- a/crates/rocie-server/src/storage/sql/get/config/mod.rs +++ b/crates/rocie-server/src/storage/sql/get/config/mod.rs @@ -7,7 +7,7 @@ impl Config { let record = query!( " SELECT use_defaults - FROM config + FROM rocie_config WHERE id = 0 " ) diff --git a/crates/rocie-server/src/storage/sql/insert/config/mod.rs b/crates/rocie-server/src/storage/sql/insert/config/mod.rs index 8c81feb..597e633 100644 --- a/crates/rocie-server/src/storage/sql/insert/config/mod.rs +++ b/crates/rocie-server/src/storage/sql/insert/config/mod.rs @@ -20,7 +20,7 @@ impl Transactionable for Operation { Operation::UseDefault { value, .. } => { query!( " - UPDATE config + UPDATE rocie_config SET use_defaults = ? WHERE id = 0 ", @@ -38,7 +38,7 @@ impl Transactionable for Operation { Operation::UseDefault { old_value, .. } => { query!( " - UPDATE config + UPDATE rocie_config SET use_defaults = ? WHERE id = 0 ", |