From c2a74e7472beace631fcab24986d83326e4c5dd7 Mon Sep 17 00:00:00 2001 From: Arslaan Pathan Date: Thu, 16 Jul 2026 19:37:14 +1200 Subject: Almost done with voting!! --- src/db.py | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'src/db.py') diff --git a/src/db.py b/src/db.py index b971a13..f1ae4f6 100644 --- a/src/db.py +++ b/src/db.py @@ -168,3 +168,11 @@ async def get_user_vote(deployment_id: int, voter_id: str): async def get_vote_counts(deployment_id: int): votes = await get_votes(deployment_id) return len(votes["approve"]), len(votes["reject"]) + +async def update_voting_message_ts(deployment_id: int, message_ts: str): + async with aiosqlite.connect(DB_PATH) as db: + await db.execute( + "UPDATE Deployments SET voting_message_ts = ? WHERE id = ?", + (message_ts, deployment_id) + ) + await db.commit() -- cgit v1.2.3