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