def save_message(self, message):
message_uuid = uuid.UUID(message.id)
timestamp = date_time_utils.unix_timestamp_to_datetime(message.timestamp)
received = date_time_utils.unix_timestamp_to_datetime(message.received_timestamp)
values = {
"message_uuid" : message_uuid.bytes,
"message_uuid_text" : message.id,
"message_source" : message.source,
"message_type" : message.type,
"message_json" : json.dumps(message.data),
"message_timestamp" : timestamp,
"message_received" : received
}
self.__execute_insert(INSERT_MESSAGE_SQL, values)
def save_reading(self, message):
message_uuid = uuid.UUID(message.id)
timestamp = date_time_utils.unix_timestamp_to_datetime(message.timestamp)
data = message.data
reading_value = data["value"]
raw_value = data.get("raw", None)
units = data.get("units", None)
sensor_id = data.get("sesnor_id", message.source)
reading_type = message.type[len("event.device.sensor.reading."):]
values = {
"message_uuid" : message_uuid.bytes,
"device_id" : message.source,
"sensor_id" : sensor_id,
"reading_type" : reading_type,
"reading_value" : reading_value,
"raw_value" : raw_value,
"reading_units" : units,
"reading_timestamp" : timestamp
}
self.__execute_insert(INSERT_READING_SQL, values)
