| 564 | } |
| 565 | |
| 566 | static bool leave_hot_journal(const char *cache, const char *update_sql) { |
| 567 | char db_path[512], journal_path[512], db_copy[512], journal_copy[512]; |
| 568 | snprintf(db_path, sizeof(db_path), "%s/_config.db", cache); |
| 569 | snprintf(journal_path, sizeof(journal_path), "%s/_config.db-journal", cache); |
| 570 | snprintf(db_copy, sizeof(db_copy), "%s/snapshot.db", cache); |
| 571 | snprintf(journal_copy, sizeof(journal_copy), "%s/snapshot.journal", cache); |
| 572 | sqlite3 *writer = NULL; |
| 573 | bool ok = sqlite3_open(db_path, &writer) == SQLITE_OK && |
| 574 | sqlite3_exec(writer, "PRAGMA cache_size=1; BEGIN IMMEDIATE; CREATE TABLE spill(x BLOB)", |
| 575 | NULL, NULL, NULL) == SQLITE_OK && |
| 576 | sqlite3_exec(writer, update_sql, NULL, NULL, NULL) == SQLITE_OK; |
| 577 | for (int i = 0; ok && i < 64; i++) |
| 578 | ok = sqlite3_exec(writer, "INSERT INTO spill VALUES(randomblob(8192))", NULL, NULL, NULL) == |
| 579 | SQLITE_OK; |
| 580 | ok = ok && copy_file(db_path, db_copy) && copy_file(journal_path, journal_copy); |
| 581 | if (writer) { |
| 582 | (void)sqlite3_exec(writer, "ROLLBACK", NULL, NULL, NULL); |
| 583 | sqlite3_close(writer); |
| 584 | } |
| 585 | ok = ok && journal_is_hot(journal_copy) && copy_file(db_copy, db_path) && |
| 586 | copy_file(journal_copy, journal_path); |
| 587 | remove(db_copy); |
| 588 | remove(journal_copy); |
| 589 | return ok; |
| 590 | } |
| 591 | |
| 592 | /* The hot journal made every later start fail with "could not load saved |
| 593 | * runtime settings", permanently: a read-only connection cannot roll it back. */ |
no test coverage detected