summaryrefslogtreecommitdiff
path: root/web-server/opendc/models_old/rack_state.py
diff options
context:
space:
mode:
authorGeorgios Andreadis <info@gandreadis.com>2020-06-30 13:33:43 +0200
committerFabian Mastenbroek <mail.fabianm@gmail.com>2020-08-24 19:42:28 +0200
commitb9dcda0fb4bbb52ebd8a15acf324561a6d687eba (patch)
tree48ee0165d95593dd2760882f9caa23fd3db2584a /web-server/opendc/models_old/rack_state.py
parent9f87ab4bbab048b527585929135cab80fafd9ef9 (diff)
Remove old models
Diffstat (limited to 'web-server/opendc/models_old/rack_state.py')
-rw-r--r--web-server/opendc/models_old/rack_state.py63
1 files changed, 0 insertions, 63 deletions
diff --git a/web-server/opendc/models_old/rack_state.py b/web-server/opendc/models_old/rack_state.py
deleted file mode 100644
index 12e0f931..00000000
--- a/web-server/opendc/models_old/rack_state.py
+++ /dev/null
@@ -1,63 +0,0 @@
-from opendc.models_old.model import Model
-from opendc.util import database
-
-
-class RackState(Model):
- JSON_TO_PYTHON_DICT = {'RackState': {'rackId': 'rack_id', 'loadFraction': 'load_fraction', 'tick': 'tick'}}
-
- @classmethod
- def _from_database_row(cls, row):
- """Instantiate a RackState from a database row."""
-
- return cls(rack_id=row[0], load_fraction=row[1], tick=row[2])
-
- @classmethod
- def from_experiment_id(cls, experiment_id):
- """Query RackStates by their Experiment id."""
-
- rack_states = []
-
- statement = '''
- SELECT racks.id, avg(machine_states.load_fraction), machine_states.tick
- FROM racks
- JOIN machines ON racks.id = machines.rack_id
- JOIN machine_states ON machines.id = machine_states.machine_id
- WHERE machine_states.experiment_id = %s
- GROUP BY machine_states.tick, racks.id
- '''
- results = database.fetch_all(statement, (experiment_id, ))
-
- for row in results:
- rack_states.append(cls._from_database_row(row))
-
- return rack_states
-
- @classmethod
- def from_experiment_id_and_tick(cls, experiment_id, tick):
- """Query RackStates by their Experiment id."""
-
- rack_states = []
-
- statement = '''
- SELECT racks.id, avg(machine_states.load_fraction), machine_states.tick
- FROM racks
- JOIN machines ON racks.id = machines.rack_id
- JOIN machine_states ON machines.id = machine_states.machine_id
- WHERE machine_states.experiment_id = %s
- AND machine_states.tick = %s
- GROUP BY machine_states.tick, racks.id
- '''
- results = database.fetch_all(statement, (experiment_id, tick))
-
- for row in results:
- rack_states.append(cls._from_database_row(row))
-
- return rack_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 RackState."""
-
- if authorization_level in ['EDIT', 'OWN']:
- return False
-
- return True