From 671a7b1b02503cfa5c9aecd40c27a0c2729a285b Mon Sep 17 00:00:00 2001 From: stuppie Date: Wed, 4 Nov 2026 12:11:03 -0600 Subject: strip out AMT --- jb/managers/bonus.py | 51 --------------------------------------------------- 1 file changed, 51 deletions(-) delete mode 100644 jb/managers/bonus.py (limited to 'jb/managers/bonus.py') diff --git a/jb/managers/bonus.py b/jb/managers/bonus.py deleted file mode 100644 index b649103..0000000 --- a/jb/managers/bonus.py +++ /dev/null @@ -1,51 +0,0 @@ -from typing import Any - -from psycopg import sql - -from jb.managers.base import PostgresManager -from jb.models.bonus import Bonus - - -class BonusManager(PostgresManager): - - def create(self, bonus: Bonus) -> None: - assert bonus.id is None - data = bonus.to_postgres() - query = sql.SQL(""" - INSERT INTO mtwerk_bonus - (payout_event_id, amt_worker_id, amount, grant_time, assignment_id, reason) - VALUES ( - %(payout_event_id)s, - %(amt_worker_id)s, - %(amount)s, - %(grant_time)s, - ( - SELECT id - FROM mtwerk_assignment - WHERE amt_assignment_id = %(amt_assignment_id)s - LIMIT 1 - ), - %(reason)s - ) - RETURNING id, assignment_id; - """) - - with self.pg_config.make_connection() as conn, conn.cursor() as c: - c.execute(query, data) - res = c.fetchone() - conn.commit() - bonus.id = res["id"] # type: ignore - bonus.assignment_id = res["assignment_id"] # type: ignore - - def filter(self, amt_assignment_id: str) -> list[Bonus]: - res: list[Any] = self.pg_config.execute_sql_query( - """ - SELECT mb.*, ma.amt_assignment_id - FROM mtwerk_bonus mb - JOIN mtwerk_assignment ma ON ma.id = mb.assignment_id - WHERE amt_assignment_id = %(amt_assignment_id)s; - """, - params={"amt_assignment_id": amt_assignment_id}, - ) - - return [Bonus.from_postgres(data=x) for x in res] -- cgit v1.2.3