| 242 | } |
| 243 | |
| 244 | static sqlite3 *settings_open(const char *cache) { |
| 245 | if (!cache || !cache[0] || strlen(cache) + 12 >= SETTINGS_PATH_CAP) |
| 246 | return NULL; |
| 247 | char canonical[SETTINGS_PATH_CAP]; |
| 248 | if (!canonical_cache_path(cache, canonical, true)) |
| 249 | return NULL; |
| 250 | cbm_config_t *base = cbm_config_open(canonical); |
| 251 | if (!base) |
| 252 | return NULL; |
| 253 | cbm_config_close(base); |
| 254 | char path[SETTINGS_PATH_CAP]; |
| 255 | if (snprintf(path, sizeof(path), "%s/_config.db", canonical) >= (int)sizeof(path)) |
| 256 | return NULL; |
| 257 | sqlite3 *db = NULL; |
| 258 | if (sqlite3_open(path, &db) != SQLITE_OK) { |
| 259 | if (db) |
| 260 | sqlite3_close(db); |
| 261 | return NULL; |
| 262 | } |
| 263 | cbm_runtime_settings_wait_for_writers(db); |
| 264 | const char *schema = |
| 265 | "BEGIN IMMEDIATE;" |
| 266 | "CREATE TABLE IF NOT EXISTS runtime_settings(key TEXT PRIMARY KEY,value TEXT NOT NULL);" |
| 267 | "CREATE TABLE IF NOT EXISTS runtime_settings_revision(id INTEGER PRIMARY KEY " |
| 268 | "CHECK(id=1),revision INTEGER NOT NULL);" |
| 269 | "INSERT OR IGNORE INTO runtime_settings_revision VALUES(1,0);" |
| 270 | "CREATE TRIGGER IF NOT EXISTS settings_insert AFTER INSERT ON runtime_settings BEGIN " |
| 271 | "UPDATE runtime_settings_revision SET revision=revision+1 WHERE id=1; END;" |
| 272 | "CREATE TRIGGER IF NOT EXISTS settings_update AFTER UPDATE ON runtime_settings BEGIN " |
| 273 | "UPDATE runtime_settings_revision SET revision=revision+1 WHERE id=1; END;" |
| 274 | "CREATE TRIGGER IF NOT EXISTS settings_delete AFTER DELETE ON runtime_settings BEGIN " |
| 275 | "UPDATE runtime_settings_revision SET revision=revision+1 WHERE id=1; END;" |
| 276 | "CREATE TRIGGER IF NOT EXISTS config_settings_insert AFTER INSERT ON config BEGIN UPDATE " |
| 277 | "runtime_settings_revision SET revision=revision+1 WHERE id=1; END;" |
| 278 | "CREATE TRIGGER IF NOT EXISTS config_settings_update AFTER UPDATE ON config BEGIN UPDATE " |
| 279 | "runtime_settings_revision SET revision=revision+1 WHERE id=1; END;" |
| 280 | "CREATE TRIGGER IF NOT EXISTS config_settings_delete AFTER DELETE ON config BEGIN UPDATE " |
| 281 | "runtime_settings_revision SET revision=revision+1 WHERE id=1; END;COMMIT;"; |
| 282 | if (sqlite3_exec(db, schema, NULL, NULL, NULL) != SQLITE_OK) { |
| 283 | sqlite3_close(db); |
| 284 | return NULL; |
| 285 | } |
| 286 | return db; |
| 287 | } |
| 288 | |
| 289 | static bool read_value(sqlite3 *db, const setting_t *setting, char out[SETTINGS_VALUE_CAP]) { |
| 290 | if (!db) |
no test coverage detected