forked from mtusi2026/mtusi2026lab2
92 lines
3.8 KiB
Python
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)
|