"""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)