1 files changed, 71 insertions, 0 deletions
diff --git a/web-server/opendc/models_old/machine_state.py b/web-server/opendc/models_old/machine_state.py
new file mode 100644
index 00000000..0e9f7dad
--- /dev/null
+++ b/web-server/opendc/models_old/machine_state.py
@@ -0,0 +1,71 @@
+from opendc.models_old.model import Model
+from opendc.util import database
+
+
+class MachineState(Model):
+    JSON_TO_PYTHON_DICT = {
+        'MachineState': {
+            'machineId': 'machine_id',
+            'temperatureC': 'temperature_c',
+            'inUseMemoryMb': 'in_use_memory_mb',
+            'loadFraction': 'load_fraction',
+            'tick': 'tick'
+        }
+    }
+
+    COLLECTION_NAME = 'machine_states'
+    COLUMNS = ['id', 'machine_id', 'experiment_id', 'tick', 'temperature_c', 'in_use_memory_mb', 'load_fraction']
+
+    COLUMNS_PRIMARY_KEY = ['id']
+
+    @classmethod
+    def _from_database_row(cls, row):
+        """Instantiate a MachineState from a database row (including tick from the TaskState)."""
+
+        return cls(machine_id=row[1], temperature_c=row[4], in_use_memory_mb=row[5], load_fraction=row[6], tick=row[3])
+
+    @classmethod
+    def from_experiment_id(cls, experiment_id):
+        """Query MachineStates by their Experiment id."""
+
+        machine_states = []
+
+        statement = 'SELECT * FROM machine_states WHERE experiment_id = %s'
+        results = database.fetch_all(statement, (experiment_id, ))
+
+        for row in results:
+            machine_states.append(cls._from_database_row(row))
+
+        return machine_states
+
+    @classmethod
+    def from_experiment_id_and_tick(cls, experiment_id, tick):
+        """Query MachineStates by their Experiment id and tick."""
+
+        machine_states = []
+
+        statement = 'SELECT * FROM machine_states WHERE experiment_id = %s AND machine_states.tick = %s'
+        results = database.fetch_all(statement, (experiment_id, tick))
+
+        for row in results:
+            machine_states.append(cls._from_database_row(row))
+
+        return machine_states
+
+    def read(self):
+        """Read this MachineState by also getting its tick."""
+
+        super(MachineState, self).read()
+
+        statement = 'SELECT tick FROM task_states WHERE id = %s'
+        result = database.fetch_one(statement, (self.task_state_id, ))
+
+        self.tick = result[0]
+
+    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 MachineState."""
+
+        if authorization_level in ['EDIT', 'OWN']:
+            return False
+
+        return True