def _get_time_query_delete(begin, end): output = "" if begin: output += " WHERE time >= '{}'".format(utils.isotime(begin)) if end: output += " AND " if output else " WHERE " output += "time < '{}'".format(utils.isotime(end)) return output
def _build_dataframes(self, points): dataframes = {} for point in points: point_type = point['type'] if point['time'] not in dataframes.keys(): dataframes[point['time']] = { 'period': { 'begin': point['time'], 'end': utils.isotime( utils.iso2dt(point['time']) + datetime.timedelta(seconds=self._period)), }, 'usage': {}, } usage = dataframes[point['time']]['usage'] if point_type not in usage.keys(): usage[point_type] = [] usage[point_type].append(self._point_to_dataframe_entry(point)) output = list(dataframes.values()) output.sort(key=lambda x: x['period']['begin']) return output
def _build_dataframes(self, points): dataframes = {} for point in points: point_type = point['type'] if point['time'] not in dataframes.keys(): dataframes[point['time']] = { 'period': { 'begin': point['time'], 'end': utils.isotime( utils.iso2dt(point['time']) + datetime.timedelta(seconds=self._period)), }, 'usage': {}, } usage = dataframes[point['time']]['usage'] if point_type not in usage.keys(): usage[point_type] = [] usage[point_type].append(self._point_to_dataframe_entry(point)) output = list(dataframes.values()) output.sort(key=lambda x: x['period']['begin']) return output
def _get_time_query(begin, end): return " WHERE time >= '{}' AND time < '{}'".format( utils.isotime(begin), utils.isotime(end))
def __get_tag_or_field(point, key): if key == 'time': return utils.isotime(point['time']) return point['tags'].get(key) or point['fields'].get(key)
def __get_tag_or_field(point, key): if key == 'time': return utils.isotime(point['time']) return point['tags'].get(key) or point['fields'].get(key)
def _get_time_query(begin, end): return " WHERE time >= '{}' AND time < '{}'".format( utils.isotime(begin), utils.isotime(end))