forked from mtusi2026/mtusi2026lab2
102 lines
4.2 KiB
Python
102 lines
4.2 KiB
Python
"""Rollback на уровне хранилища с внедрённым сбоем (нужен прямой доступ к БД).
|
|
|
|
Сбой вызывается ПОСЛЕ того, как строки chats и chat_members уже вставлены
|
|
внутри транзакции. Проверяем, что в БД не осталось ни чата, ни участников.
|
|
|
|
Запуск внутри compose-сети (БД наружу не публикуется):
|
|
docker compose run --rm --no-deps -v "$PWD/student-tests:/app/student-tests:ro" \
|
|
api python -m unittest discover -s student-tests -p test_storage_rollback.py -v
|
|
Без DATABASE_URL/DATABASE_URL_FILE тест пропускается.
|
|
"""
|
|
import os
|
|
import sys
|
|
import unittest
|
|
import uuid
|
|
from pathlib import Path
|
|
|
|
sys.path.insert(0, str(Path(__file__).resolve().parents[1]))
|
|
|
|
HAS_DB = bool(os.environ.get("DATABASE_URL") or os.environ.get("DATABASE_URL_FILE"))
|
|
|
|
|
|
class InjectedFailure(RuntimeError):
|
|
pass
|
|
|
|
|
|
@unittest.skipUnless(HAS_DB, "DATABASE_URL is not configured")
|
|
class StorageRollbackTests(unittest.TestCase):
|
|
|
|
@classmethod
|
|
def setUpClass(cls):
|
|
from src.config import load_settings
|
|
from src.db import create_pool, wait_and_migrate
|
|
from src.security import hash_password
|
|
from src.storage import Storage
|
|
|
|
settings = load_settings()
|
|
wait_and_migrate(settings)
|
|
cls.pool = create_pool(settings)
|
|
cls.pool.wait(timeout=10)
|
|
cls.storage = Storage(cls.pool)
|
|
h = hash_password("Rollback-test-password")
|
|
cls.users = [
|
|
cls.storage.create_user("rbk_" + uuid.uuid4().hex[:12], "Rollback", h)
|
|
for _ in range(3)
|
|
]
|
|
|
|
@classmethod
|
|
def tearDownClass(cls):
|
|
cls.pool.close()
|
|
|
|
def count(self, sql, params):
|
|
with self.pool.connection() as conn:
|
|
return conn.execute(sql, params).fetchone()[0]
|
|
|
|
def test_failure_after_inserts_leaves_nothing(self):
|
|
title = "rollback-" + uuid.uuid4().hex
|
|
original = self.storage._insert_members
|
|
seen = {}
|
|
|
|
def insert_then_fail(conn, chat_id, member_ids):
|
|
original(conn, chat_id, member_ids)
|
|
# Внутри транзакции строки видны — значит вставка действительно была.
|
|
seen["chats"] = conn.execute("SELECT count(*) FROM chats WHERE title = %s", (title,)).fetchone()[0]
|
|
seen["members"] = conn.execute("SELECT count(*) FROM chat_members WHERE chat_id = %s", (chat_id,)).fetchone()[0]
|
|
seen["chat_id"] = chat_id
|
|
raise InjectedFailure("simulated crash between statements")
|
|
|
|
self.storage._insert_members = insert_then_fail
|
|
try:
|
|
with self.assertRaises(InjectedFailure):
|
|
self.storage.create_chat(title, [u.id for u in self.users])
|
|
finally:
|
|
self.storage._insert_members = original
|
|
|
|
self.assertEqual(seen["chats"], 1)
|
|
self.assertEqual(seen["members"], 3)
|
|
self.assertEqual(self.count("SELECT count(*) FROM chats WHERE title = %s", (title,)), 0)
|
|
self.assertEqual(self.count("SELECT count(*) FROM chat_members WHERE chat_id = %s", (seen["chat_id"],)), 0)
|
|
|
|
def test_no_orphan_chats_in_database(self):
|
|
orphans = self.count(
|
|
"SELECT count(*) FROM chats c WHERE NOT EXISTS "
|
|
"(SELECT 1 FROM chat_members m WHERE m.chat_id = c.id)", ())
|
|
self.assertEqual(orphans, 0)
|
|
|
|
def test_migrations_are_idempotent(self):
|
|
from src.config import load_settings
|
|
from src.db import apply_migrations
|
|
self.assertEqual(apply_migrations(load_settings()), [])
|
|
self.assertEqual(self.count("SELECT count(*) FROM schema_migrations WHERE version = %s", ("001_init",)), 1)
|
|
|
|
def test_passwords_stored_as_argon2id(self):
|
|
with self.pool.connection() as conn:
|
|
stored = conn.execute("SELECT password_hash FROM users WHERE id = %s",
|
|
(self.users[0].id,)).fetchone()[0]
|
|
self.assertTrue(stored.startswith("$argon2id$"), stored[:10])
|
|
self.assertNotIn("Rollback-test-password", stored)
|
|
|
|
|
|
if __name__ == "__main__":
|
|
unittest.main(verbosity=2)
|