def _get_ids(self):
ids = []
rows = _session.execute("""
SELECT id FROM md_info WHERE name=%s AND tag=%s
""", (str(self.name), self.tag))
for r in rows:
ids.append(r[0])
return ids
def values(self):
if self._values is None:
start_time = time.time()
self._values = []
rows = _session.execute(cqlstatements._bound_statements['parameter_timeseries'].bind(
(self._name, self._tag, self._p,)))
for r in rows:
cyclestamp = cassandra.util.datetime_from_uuid1(r[4])
self._values.append([cyclestamp, _convert_object_from_cassandra(r[0], [r[1], r[2], r[3]])])
self._values = np.array(sorted(list(self._values), key=lambda x: x[0]))
print("Data queried in %f seconds." % (time.time()-start_time,))
return self._values
def value(self):
if self._value is None:
if kepler._cache_flag:
with kepler._thread_lock:
if not self._cycles._get_caching(self._p):
self._cycles._set_caching(self._p)
ParameterData.cachingThread(self._cycles, self._p).start()
r = _session.execute(
cqlstatements._bound_statements["parameter_data"].bind((self._name, self._tag, self._id, self._p))
)
r = r[0]
self._value = _convert_object_from_cassandra(r[0], [r[1], r[2], r[3]])
return self._value
def _get_devices(self):
id = self._ids[0]
rows = _session.execute("""
SELECT parameter, type FROM md_data WHERE name=%s AND tag=%s AND id=%s
""", (str(self.name), self.tag, id))
devices = {}
for r in rows:
p = r[0]
t = r[1]
if devices.get(p.device) is None:
devices[p.device] = {p.property: {p.field: t}}
else:
if devices[p.device].get(p.property) is None:
devices[p.device][p.property] = {p.field: t}
else:
devices[p.device][p.property][p.field] = t
return devices
