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/assignment.py | 240 ---------------------------------------------- 1 file changed, 240 deletions(-) delete mode 100644 jb/managers/assignment.py (limited to 'jb/managers/assignment.py') diff --git a/jb/managers/assignment.py b/jb/managers/assignment.py deleted file mode 100644 index 2740aee..0000000 --- a/jb/managers/assignment.py +++ /dev/null @@ -1,240 +0,0 @@ -from datetime import datetime, timezone - -from psycopg import sql -from pydantic import NonNegativeInt, PositiveInt - -from jb.managers.base import PostgresManager -from jb.models.assignment import Assignment, AssignmentStub -from jb.models.definitions import AssignmentStatus - - -class AssignmentManager(PostgresManager): - - def create_stub(self, stub: AssignmentStub) -> None: - assert stub.id is None - data = stub.to_postgres() - query = sql.SQL(""" - INSERT INTO mtwerk_assignment - (amt_assignment_id, amt_worker_id, status, - created_at, modified_at, hit_id) - VALUES - (%(amt_assignment_id)s, %(amt_worker_id)s, %(status)s, - %(created_at)s, %(modified_at)s, %(hit_id)s) - RETURNING id; - """) - - with self.pg_config.make_connection() as conn, conn.cursor() as c: - c.execute(query, data) - pk = c.fetchone()["id"] # type: ignore - conn.commit() - stub.id = pk - - def create(self, assignment: Assignment) -> None: - # Typically this is NOT used (we'd create the stub when HIT is - # accepted, then update it once the assignment is submitted), however - # there may be cases where an assignment is submitted and the stub - # was never created (probably due to error/downtime/baddie). - - assert assignment.id is None - data = assignment.to_postgres() - query = sql.SQL(""" - INSERT INTO mtwerk_assignment - (amt_assignment_id, amt_worker_id, status, - created_at, modified_at, hit_id, - auto_approval_time, accept_time, submit_time, - approval_time, rejection_time, requester_feedback, - tsid) - VALUES - (%(amt_assignment_id)s, %(amt_worker_id)s, %(status)s, - %(created_at)s, %(modified_at)s, %(hit_id)s, - %(auto_approval_time)s, %(accept_time)s, %(submit_time)s, - %(approval_time)s, %(rejection_time)s, %(requester_feedback)s, - %(tsid)s) - RETURNING id; - """) - - with self.pg_config.make_connection() as conn, conn.cursor() as c: - c.execute(query, data) - pk = c.fetchone()["id"] # type: ignore - conn.commit() - assignment.id = pk - - def get_stub(self, amt_assignment_id: str) -> AssignmentStub: - res = self.pg_config.execute_sql_query( - """ - SELECT ma.id, ma.hit_id, - ma.amt_assignment_id, ma.amt_worker_id, - ma.status, ma.created_at, ma.modified_at, - mh.amt_hit_id - FROM mtwerk_assignment ma - JOIN mtwerk_hit mh ON ma.hit_id = mh.id - WHERE amt_assignment_id = %(amt_assignment_id)s - LIMIT 1; - """, - params={"amt_assignment_id": amt_assignment_id}, - ) - assert len(res) == 1 - return AssignmentStub.model_validate(res[0]) - - def get_stub_if_exists(self, amt_assignment_id: str) -> AssignmentStub | None: - try: - return self.get_stub(amt_assignment_id=amt_assignment_id) - except AssertionError: - return None - - def get(self, amt_assignment_id: str) -> Assignment: - res = self.pg_config.execute_sql_query( - query=""" - SELECT mh.amt_hit_id, ma.id, ma.amt_assignment_id, - ma.amt_worker_id, ma.status, ma.auto_approval_time, - ma.accept_time, ma.submit_time, ma.approval_time, - ma.rejection_time, ma.requester_feedback, - ma.created_at, ma.modified_at, ma.tsid, ma.hit_id - FROM mtwerk_assignment ma - JOIN mtwerk_hit mh ON ma.hit_id = mh.id - WHERE amt_assignment_id = %(amt_assignment_id)s - LIMIT 1; - """, - params={"amt_assignment_id": amt_assignment_id}, - ) - assert len(res) == 1 - return Assignment.model_validate(res[0]) - - def update_answer(self, assignment: Assignment) -> None: - # We're assuming a stub already exists - # The assignment was submitted, but we haven't made a decision yet - now = datetime.now(tz=timezone.utc) - data = { - "status": assignment.status.value, - "submit_time": assignment.submit_time, - "auto_approval_time": assignment.auto_approval_time, - "tsid": assignment.tsid, - "amt_assignment_id": assignment.amt_assignment_id, - "modified_at": now, - } - query = sql.SQL(""" - UPDATE mtwerk_assignment - SET submit_time = %(submit_time)s, - auto_approval_time = %(auto_approval_time)s, - status = %(status)s, - tsid = %(tsid)s, - modified_at = %(modified_at)s - WHERE amt_assignment_id = %(amt_assignment_id)s - """) - # We force this to fail if the assignment doesn't already exist in the db - with self.pg_config.make_connection() as conn, conn.cursor() as c: - c.execute(query, data) - assert c.rowcount == 1, f"Expected 1 row, got {c.rowcount}" - conn.commit() - - def reject(self, assignment: Assignment) -> None: - assert assignment.status == AssignmentStatus.Rejected - assert assignment.rejection_time is not None - assert assignment.approval_time is None - assert assignment.requester_feedback is not None - now = datetime.now(tz=timezone.utc) - data = { - "status": assignment.status.value, - "submit_time": assignment.submit_time, - "rejection_time": assignment.rejection_time, - "requester_feedback": assignment.requester_feedback, - "amt_assignment_id": assignment.amt_assignment_id, - "auto_approval_time": assignment.auto_approval_time, - "accept_time": assignment.accept_time, - "modified_at": now, - } - query = sql.SQL(""" - UPDATE mtwerk_assignment - SET submit_time = %(submit_time)s, - rejection_time = %(rejection_time)s, - status = %(status)s, - requester_feedback = %(requester_feedback)s, - auto_approval_time = %(auto_approval_time)s, - accept_time = %(accept_time)s, - modified_at = %(modified_at)s - WHERE amt_assignment_id = %(amt_assignment_id)s - """) - # We force this to fail if the assignment doesn't already exist in the db - with self.pg_config.make_connection() as conn, conn.cursor() as c: - c.execute(query, data) - assert c.rowcount == 1, f"Expected 1 row, got {c.rowcount}" - conn.commit() - - def approve(self, assignment: Assignment) -> None: - assert assignment.status == AssignmentStatus.Approved - # # We can override a rejection and the rejection time is not None - # assert assignment.rejection_time is None - assert assignment.approval_time is not None - assert assignment.requester_feedback is not None - now = datetime.now(tz=timezone.utc) - data = { - "status": assignment.status.value, - "submit_time": assignment.submit_time, - "approval_time": assignment.approval_time, - "requester_feedback": assignment.requester_feedback, - "amt_assignment_id": assignment.amt_assignment_id, - "auto_approval_time": assignment.auto_approval_time, - "accept_time": assignment.accept_time, - "modified_at": now, - } - query = sql.SQL(""" - UPDATE mtwerk_assignment - SET submit_time = %(submit_time)s, - approval_time = %(approval_time)s, - status = %(status)s, - requester_feedback = %(requester_feedback)s, - auto_approval_time = %(auto_approval_time)s, - accept_time = %(accept_time)s, - modified_at = %(modified_at)s - WHERE amt_assignment_id = %(amt_assignment_id)s - """) - # We force this to fail if the assignment doesn't already exist in the db - with self.pg_config.make_connection() as conn, conn.cursor() as c: - c.execute(query, data) - assert c.rowcount == 1, f"Expected 1 row, got {c.rowcount}" - conn.commit() - - def missing_tsid_count( - self, amt_worker_id: str, lookback_hrs: PositiveInt = 24 - ) -> NonNegativeInt: - """ - Look at this user's previous N hrs of submitted assignments. - Count how many assignments they have submitted without a tsid. - """ - res = self.pg_config.execute_sql_query( - query=""" - SELECT COUNT(1) AS c - FROM mtwerk_assignment - WHERE amt_worker_id = %(amt_worker_id)s - AND submit_time > NOW() - (%(lookback_interval)s)::interval - AND tsid IS NULL; - """, - params={ - "amt_worker_id": amt_worker_id, - "lookback_interval": f"{lookback_hrs} hour", - }, - ) - return int(res[0]["c"]) # type: ignore - - def rejected_count( - self, amt_worker_id: str, lookback_hrs: int = 24 - ) -> NonNegativeInt: - """ - Look at this user's previous N hrs of submitted assignments. - Count how many rejected assignments they have. - """ - res = self.pg_config.execute_sql_query( - query=""" - SELECT COUNT(1) AS c - FROM mtwerk_assignment - WHERE amt_worker_id = %(amt_worker_id)s - AND submit_time > NOW() - (%(lookback_interval)s)::interval - AND status = %(status)s; - """, - params={ - "amt_worker_id": amt_worker_id, - "lookback_interval": f"{lookback_hrs} hour", - "status": AssignmentStatus.Rejected.value, - }, - ) - return int(res[0]["c"]) # type: ignore -- cgit v1.2.3