Files
mtusi2026lab2/tests/transaction_rollback.py
2026-11-10 23:47:45 +03:00

90 lines
2.9 KiB
Python

#!/usr/bin/env python3
import subprocess
import uuid
from client import Client, Failure, arguments, check, run
TRIGGER = "grade4_fail_member_insert"
FUNCTION = "grade4_fail_member_insert_fn"
def psql(sql, capture=False):
return subprocess.run(
[
"docker",
"compose",
"exec",
"-T",
"postgres",
"psql",
"-U",
"messenger",
"-d",
"messenger",
"-v",
"ON_ERROR_STOP=1",
"-At",
"-c",
sql,
],
check=True,
stdout=subprocess.PIPE if capture else subprocess.DEVNULL,
stderr=subprocess.DEVNULL,
text=True,
).stdout if capture else ""
def cleanup():
result = psql(
"DROP TRIGGER IF EXISTS " + TRIGGER + " ON chat_members; "
"DROP FUNCTION IF EXISTS " + FUNCTION + "(); "
"SELECT count(*) FROM pg_trigger "
"WHERE tgrelid = 'public.chat_members'::regclass "
"AND tgname = '" + TRIGGER + "' AND NOT tgisinternal",
capture=True,
)
check(result.strip().splitlines()[-1:] == ["0"], "rollback test trigger cleanup failed")
def main():
args = arguments("Force a failure during chat membership insert and verify transaction rollback")
client = Client(args.base_url, args.ca_file)
actor = client.user("rollback")
other = client.user("rollback_member")
title = "rollback-" + uuid.uuid4().hex
setup_sql = (
"DROP TRIGGER IF EXISTS " + TRIGGER + " ON chat_members; "
"DROP FUNCTION IF EXISTS " + FUNCTION + "(); "
"CREATE FUNCTION " + FUNCTION + "() RETURNS trigger LANGUAGE plpgsql AS $$ "
"BEGIN IF EXISTS (SELECT 1 FROM chat_members WHERE chat_id = NEW.chat_id) "
"THEN RAISE EXCEPTION 'injected rollback test'; END IF; "
"RETURN NEW; END $$; "
"CREATE TRIGGER " + TRIGGER
+ " BEFORE INSERT ON chat_members FOR EACH ROW EXECUTE FUNCTION "
+ FUNCTION + "(); "
"SELECT count(*) FROM pg_trigger WHERE tgrelid = 'public.chat_members'::regclass "
"AND tgname = '" + TRIGGER + "' AND tgenabled = 'O'"
)
try:
setup_result = psql(setup_sql, capture=True).strip().splitlines()
check(setup_result and setup_result[-1] == "1", "rollback test trigger was not installed")
client.call(
"POST",
"/api/v1/chats",
expected=503,
actor=actor,
body={"title": title, "member_ids": [actor["id"], other["id"]]},
)
count = psql(
"SELECT count(*) FROM chats WHERE title = '" + title + "'",
capture=True,
).strip()
check(count == "0", "failed chat creation left a partial chat row")
finally:
cleanup()
print("PASS: injected membership failure rolled back the chat transaction")
if __name__ == "__main__":
run(main)