8000 gh-135386: Fix "unable to open database file" errors on readonly DB by GeneralK1ng · Pull Request #135566 · python/cpython · GitHub
[go: up one dir, main page]
Skip to content

gh-135386: Fix "unable to open database file" errors on readonly DB #135566

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
wants to merge 12 commits into
base: main
Choose a base branch
from
Open

gh-135386: Fix "unable to open database file" errors on readonly DB #135566

Changes from 1 commit
Commits
Show all changes
12 commits
Select commit Hold shift + click to select a range
761f178
Fix: add immutable=1 flag for read-only SQLite access to avoid WAL/SH…
GeneralK1ng Jun 16, 2025
3e3a3ba
gh-135386: Fix dbm.sqlite3 readonly open error by using immutable=1
blurb-it[bot] Jun 16, 2025
7f988dd
Add test: readonly sqlite db without wal/shm (skip on Windows)
GeneralK1ng Jun 17, 2025
775683e
optimize(code): Update Lib/dbm/sqlite3.py
GeneralK1ng Jun 23, 2025
66899ff
optimize(code): update Lib/dbm/sqlite3.py
GeneralK1ng Jun 23, 2025
4561075
Test: make read-only dbm.sqlite3 test compatible with Windows
GeneralK1ng Jun 23, 2025
7c40be3
Refactor: remove unused _readonly flag, simplify readonly WAL/SHM test
GeneralK1ng Jun 24, 2025
759f218
Remove unused import
GeneralK1ng Jun 24, 2025
73d9e24
Test: add read-only directory and file tests for dbm.sqlite3
GeneralK1ng Jul 9, 2025
c4c8065
Test: improve read-only filesystem tests for dbm.sqlite3 per review f…
GeneralK1ng Jul 9, 2025
b586fc3
Fix test and avoid unclosed DB connection.
GeneralK1ng Jul 9, 2025
bd405f2
Skip platform-dependent write failure tests in readonly directory
GeneralK1ng Jul 9, 2025
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Test: make read-only dbm.sqlite3 test compatible with Windows
  • Loading branch information
@GeneralK1ng
GeneralK1ng committed Jun 23, 2025
commit 4561075b3acab2506d34b7c769336a6fb513a5d7
21 changes: 14 additions & 7 deletions Lib/test/test_dbm_sqlite3.py
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -1,3 +1,4 @@
import stat
import os
import sys
import unittest
Expand Down Expand Up @@ -90,22 +91,28 @@ def test_readonly_keys(self):
def test_readonly_iter(self):
self.assertEqual([k for k in self.db], [b"key1", b"key2"])

@unittest.skipIf(sys.platform.startswith("win"), "incompatible with Windows file locking")
def test_readonly_open_without_wal_shm(self):
wal_path = self.filename + "-wal"
shm_path = self.filename + "-shm"

for suffix in wal_path, shm_path:
try:
os.remove(suffix)
except FileNotFoundError:
pass
os_helper.unlink(suffix)

os.chmod(self.filename, 0o444)
try:
self.db.close()
except Exception:
pass

with dbm_sqlite3.open(self.filename, "r") as db:
os.chmod(self.filename, stat.S_IREAD)

db = dbm_sqlite3.open(self.filename, "r")
try:
self.assertEqual(db[b"key1"], b"value1")
self.assertEqual(db[b"key2"], b"value2")
finally:
db.close()

os.chmod(self.filename, stat.S_IWRITE)


class ReadWrite(_SQLiteDbmTests):
Expand Down
Loading
0