aboutsummaryrefslogtreecommitdiff
path: root/tests/test_init.py
diff options
context:
space:
mode:
Diffstat (limited to 'tests/test_init.py')
-rw-r--r--tests/test_init.py145
1 files changed, 144 insertions, 1 deletions
diff --git a/tests/test_init.py b/tests/test_init.py
index f334c88..cff42f9 100644
--- a/tests/test_init.py
+++ b/tests/test_init.py
@@ -6,10 +6,13 @@
import subprocess
import sys
+from pathlib import Path
from flask import Flask
+from sqlalchemy import create_engine
-from webmentions_ssg import VERSION, huey
+from webmentions_ssg import VERSION, create_app, db, huey
+from webmentions_ssg.config import TestingConfig
from webmentions_ssg.net import is_http_url
@@ -47,3 +50,143 @@ assert webmentions_bp.name == 'webmentions'
[sys.executable, "-c", script], capture_output=True, text=True, check=False
)
assert result.returncode == 0, result.stderr
+
+
+def test_in_memory_sqlite_enforces_foreign_keys_without_wal(app: Flask) -> None:
+ with app.app_context():
+ with db.engine.connect() as connection:
+ assert connection.exec_driver_sql("PRAGMA foreign_keys").scalar() == 1
+ assert connection.exec_driver_sql("PRAGMA journal_mode").scalar() == "memory"
+
+
+def test_file_sqlite_enables_wal_and_foreign_keys(tmp_path: Path) -> None:
+ class FileSQLiteConfig(TestingConfig):
+ LOG_FILE = str(tmp_path / "sqlite-test.log")
+ SQLALCHEMY_DATABASE_URI = f"sqlite:///{tmp_path / 'test.db'}"
+
+ app = create_app(FileSQLiteConfig)
+ with app.app_context():
+ try:
+ with db.engine.connect() as connection:
+ assert connection.exec_driver_sql("PRAGMA foreign_keys").scalar() == 1
+ assert connection.exec_driver_sql("PRAGMA journal_mode").scalar() == "wal"
+ # Foreign-key enforcement must also apply to fresh pooled connections.
+ db.engine.dispose()
+ with db.engine.connect() as connection:
+ assert connection.exec_driver_sql("PRAGMA foreign_keys").scalar() == 1
+ assert connection.exec_driver_sql("PRAGMA journal_mode").scalar() == "wal"
+ finally:
+ db.engine.dispose()
+
+
+def test_sqlite_settings_apply_to_sqlite_binds(tmp_path: Path) -> None:
+ class SQLiteBindConfig(TestingConfig):
+ LOG_FILE = str(tmp_path / "bind-test.log")
+ SQLALCHEMY_BINDS = {"archive": f"sqlite:///{tmp_path / 'archive.db'}"}
+
+ app = create_app(SQLiteBindConfig)
+ with app.app_context():
+ try:
+ with db.engines["archive"].connect() as connection:
+ assert connection.exec_driver_sql("PRAGMA foreign_keys").scalar() == 1
+ assert connection.exec_driver_sql("PRAGMA journal_mode").scalar() == "wal"
+ finally:
+ db.engines["archive"].dispose()
+ db.engine.dispose()
+
+
+def test_sqlite_connect_event_works_without_flask(tmp_path: Path) -> None:
+ """SQLAlchemy's Engine connect event configures SQLite directly."""
+ engine = create_engine(f"sqlite:///{tmp_path / 'standalone.db'}")
+ try:
+ with engine.connect() as connection:
+ assert connection.exec_driver_sql("PRAGMA foreign_keys").scalar() == 1
+ assert connection.exec_driver_sql("PRAGMA journal_mode").scalar() == "wal"
+ finally:
+ engine.dispose()
+
+
+def test_sqlite_pragmas_can_be_tuned_per_app(tmp_path: Path) -> None:
+ """Custom settings take effect on fresh connections and survive disposal."""
+
+ class TunedSQLiteConfig(TestingConfig):
+ LOG_FILE = str(tmp_path / "tuned-test.log")
+ SQLALCHEMY_DATABASE_URI = f"sqlite:///{tmp_path / 'tuned.db'}"
+ SQLITE_PRAGMAS = {
+ "foreign_keys": False,
+ "journal_mode": "DELETE",
+ "busy_timeout": 9000,
+ "trusted_schema": False,
+ "synchronous": "NORMAL",
+ "cache_size": -8192,
+ "wal_autocheckpoint": 250,
+ "journal_size_limit": 65536,
+ }
+
+ app = create_app(TunedSQLiteConfig)
+ with app.app_context():
+ try:
+ for _ in range(2):
+ with db.engine.connect() as connection:
+ for pragma, expected in (
+ ("foreign_keys", 0),
+ ("journal_mode", "delete"),
+ ("busy_timeout", 9000),
+ ("trusted_schema", 0),
+ ("synchronous", 1),
+ ("cache_size", -8192),
+ ("wal_autocheckpoint", 250),
+ ("journal_size_limit", 65536),
+ ):
+ assert (
+ connection.exec_driver_sql(f"PRAGMA {pragma}").scalar()
+ == expected
+ )
+ db.engine.dispose()
+ finally:
+ db.engine.dispose()
+
+
+def test_in_memory_sqlite_skips_file_only_pragmas(tmp_path: Path) -> None:
+ class MemorySQLiteConfig(TestingConfig):
+ LOG_FILE = str(tmp_path / "memory-test.log")
+ SQLITE_PRAGMAS = {
+ "journal_mode": "WAL",
+ "wal_autocheckpoint": 333,
+ "journal_size_limit": 65536,
+ "cache_size": -4096,
+ }
+
+ app = create_app(MemorySQLiteConfig)
+ with app.app_context():
+ try:
+ with db.engine.connect() as connection:
+ assert connection.exec_driver_sql("PRAGMA journal_mode").scalar() == "memory"
+ assert connection.exec_driver_sql("PRAGMA cache_size").scalar() == -4096
+ assert connection.exec_driver_sql("PRAGMA wal_autocheckpoint").scalar() == 1000
+ finally:
+ db.engine.dispose()
+
+
+def test_sqlite_pragma_settings_also_apply_to_binds(tmp_path: Path) -> None:
+ class TunedBindConfig(TestingConfig):
+ LOG_FILE = str(tmp_path / "bind-tuned-test.log")
+ SQLITE_PRAGMAS = {"busy_timeout": 1234, "cache_size": -2048}
+ SQLALCHEMY_BINDS = {"archive": f"sqlite:///{tmp_path / 'archive-tuned.db'}"}
+
+ app = create_app(TunedBindConfig)
+ with app.app_context():
+ try:
+ with db.engines["archive"].connect() as connection:
+ assert connection.exec_driver_sql("PRAGMA busy_timeout").scalar() == 1234
+ assert connection.exec_driver_sql("PRAGMA cache_size").scalar() == -2048
+ finally:
+ db.engines["archive"].dispose()
+ db.engine.dispose()
+
+
+def test_sqlite_connect_listener_does_not_touch_other_dbapis() -> None:
+ from webmentions_ssg.extensions import set_sqlite_pragmas
+
+ # Non-SQLite DB-API connections bypass the listener completely.
+ set_sqlite_pragmas(object(), object())