From ff31029e732dd56743690dc608f535163a0548ff Mon Sep 17 00:00:00 2001 From: Georgios Andreadis Date: Thu, 25 Jun 2020 14:48:24 +0200 Subject: Experiment --- opendc/models/task_duration.py | 39 --------------------------------------- 1 file changed, 39 deletions(-) delete mode 100644 opendc/models/task_duration.py (limited to 'opendc/models/task_duration.py') diff --git a/opendc/models/task_duration.py b/opendc/models/task_duration.py deleted file mode 100644 index ad6459ab..00000000 --- a/opendc/models/task_duration.py +++ /dev/null @@ -1,39 +0,0 @@ -from opendc.models.model import Model -from opendc.util import database - - -class TaskDuration(Model): - JSON_TO_PYTHON_DICT = {'TaskDuration': {'taskId': 'task_id', 'duration': 'duration'}} - - @classmethod - def _from_database_row(cls, row): - """Instantiate a RoomState from a database row.""" - - return cls(task_id=row[0], duration=row[1]) - - @classmethod - def from_experiment_id(cls, experiment_id): - """Query RoomStates by their Experiment id.""" - - room_states = [] - - statement = ''' - SELECT task_id, MAX(tick) - MIN(tick) as duration FROM task_states - WHERE experiment_id = %s - GROUP BY task_id - ''' - - results = database.fetch_all(statement, (experiment_id, )) - - for row in results: - room_states.append(cls._from_database_row(row)) - - return room_states - - def google_id_has_at_least(self, google_id, authorization_level): - """Return True if the User has at least the given auth level over this TaskDuration.""" - - if authorization_level in ['EDIT', 'OWN']: - return False - - return True -- cgit v1.2.3