1 files changed, 49 insertions, 0 deletions
diff --git a/opendc/models/task_state.py b/opendc/models/task_state.py
new file mode 100644
index 00000000..6569ec79
--- /dev/null
+++ b/opendc/models/task_state.py
@@ -0,0 +1,49 @@
+from opendc.models.model import Model
+from opendc.util import database
+
+class TaskState(Model):
+
+    JSON_TO_PYTHON_DICT = {
+        'TaskState': {
+            'id': 'id',
+            'taskId': 'task_id',
+            'experimentId': 'experiment_id',
+            'tick': 'tick',
+            'flopsLeft': 'flops_left'
+        }
+    }
+
+    TABLE_NAME = 'task_states'
+
+    COLUMNS = ['id', 'task_id', 'experiment_id', 'tick', 'flops_left']
+    COLUMNS_PRIMARY_KEY = ['id']
+
+    @classmethod
+    def from_experiment_id_and_tick(cls, experiment_id, tick):
+        """Query Task States by their Experiment id and tick."""
+
+        task_states = []
+
+        statement = 'SELECT * FROM task_states WHERE experiment_id = ? AND tick = ?'
+        results = database.fetchall(statement, (experiment_id, tick))
+
+        for row in results:
+            task_states.append(
+                cls(
+                    id = row[0],
+                    task_id = row[1],
+                    experiment_id = row[2],
+                    tick = row[3],
+                    flops_left = row[4]
+                )
+            )
+
+        return task_states
+
+    def google_id_has_at_least(self, google_id, authorization_level):
+        """Return True if the Use rhas at least the given auth level over this TaskState."""
+
+        if authorization_level in ['EDIT', 'OWN']:
+            return False
+
+        return True