Files
mtusi2026lab2/tests/storage_regression.py

92 lines
3.8 KiB
Python

"""Run with .venv/bin/python tests/storage_regression.py against local test DB."""
import sys
import unittest
import uuid
from concurrent.futures import ThreadPoolExecutor
from datetime import timedelta
from pathlib import Path
from unittest.mock import patch
sys.path.insert(0, str(Path(__file__).resolve().parents[1]))
import app
import psycopg
import redis
class StorageRegression(unittest.TestCase):
@classmethod
def setUpClass(cls):
cls.store = app.Store()
cls.store.pool.open(wait=True)
cls.store.init()
@classmethod
def tearDownClass(cls):
cls.store.pool.close()
def setUp(self):
self.user = self.store.insert_user("reg_" + uuid.uuid4().hex[:20], "Regression", "test-password-123")
def tearDown(self):
with self.store.connect() as conn:
conn.execute("DELETE FROM chats WHERE id IN (SELECT chat_id FROM chat_members WHERE user_id = %s)", (self.user["id"],))
conn.execute("DELETE FROM users WHERE id = %s", (self.user["id"],))
def test_atomic_chat_rollback(self):
title = "rollback_" + uuid.uuid4().hex
with self.assertRaises(psycopg.errors.ForeignKeyViolation):
self.store.insert_chat(title, [self.user["id"], str(uuid.uuid4())], self.user["id"])
with self.store.connect() as conn:
self.assertEqual(conn.execute("SELECT count(*) FROM chats WHERE title = %s", (title,)).fetchone()[0], 0)
def test_registration_race(self):
username = "race_" + uuid.uuid4().hex[:20]
def register(_):
try:
return self.store.insert_user(username, "Race", "test-password-123")["id"]
except psycopg.errors.UniqueViolation:
return None
with ThreadPoolExecutor(max_workers=2) as executor:
results = list(executor.map(register, range(2)))
try:
self.assertEqual(sum(result is not None for result in results), 1)
finally:
with self.store.connect() as conn:
conn.execute("DELETE FROM users WHERE username = %s", (username,))
def test_equal_timestamp_pagination(self):
chat = self.store.insert_chat("Paging", [self.user["id"]], self.user["id"])
ids = sorted(str(uuid.uuid4()) for _ in range(7))
with self.store.connect() as conn:
for message_id in ids:
conn.execute("INSERT INTO messages(id, chat_id, sender_id, text, created_at) VALUES (%s,%s,%s,'same time',%s)",
(message_id, chat["id"], self.user["id"], "2026-01-01T00:00:00Z"))
cursor, actual = None, []
while True:
page = self.store.list_messages_for_chat(chat["id"], 2, cursor)
actual.extend(item["id"] for item in page["items"])
cursor = page["next_cursor"]
if cursor is None:
break
self.assertEqual(actual, ids)
def test_expired_db_session_overrides_live_cache(self):
session = self.store.create_session(self.user["id"], self.user["username"])
with self.store.connect() as conn:
conn.execute("UPDATE sessions SET expires_at = %s WHERE token = %s",
(self.store.utc_now() - timedelta(seconds=1), session["token"]))
self.assertIsNone(self.store.get_session_by_token(session["token"]))
def test_cache_unavailable_falls_back_to_db(self):
session = self.store.create_session(self.user["id"], self.user["username"])
try:
with patch.object(self.store, "cache_client", side_effect=redis.ConnectionError("offline")):
actual = self.store.get_session_by_token(session["token"])
self.assertEqual(actual["user_id"], self.user["id"])
finally:
self.store.delete_cached_session(session["token"])
if __name__ == "__main__":
unittest.main(verbosity=2)