terrariumEngine.py

# -*- coding: utf-8 -*-
from hardware.webcam.rpilive_webcam import terrariumRPILiveWebcam
import terrariumLogging

logger = terrariumLogging.logging.getLogger(__name__)
sensorLogger = terrariumLogging.logging.getLogger("terrariumSensor")
relayLogger = terrariumLogging.logging.getLogger("terrariumRelay")
buttonLogger = terrariumLogging.logging.getLogger("terrariumButton")
webcamLogger = terrariumLogging.logging.getLogger("terrariumWebcam")
enclosureLogger = terrariumLogging.logging.getLogger("terrariumEnclosure")
weatherLogger = terrariumLogging.logging.getLogger("terrariumWeather")

import threading
import time
import datetime
import os
import psutil
import subprocess
import re
import pyfiglet
import copy
import statistics
import sdnotify
import gettext

from concurrent import futures
from pathlib import Path
from time import sleep
from packaging.version import Version
from pyfancy.pyfancy import pyfancy

from pony import orm
from terrariumDatabase import init as init_db, db, Setting, Sensor, Relay, Button, Webcam, Enclosure
from terrariumWebserver import terrariumWebserver
from terrariumCalendar import terrariumCalendar
from terrariumUtils import terrariumUtils, terrariumAsync, terrariumCache
from terrariumEnclosure import terrariumEnclosure
from terrariumArea import terrariumArea
from terrariumCloud import TerrariumMerossCloud

from weather import terrariumWeather
from hardware.sensor import terrariumSensor, terrariumSensorLoadingException
from hardware.relay import terrariumRelay, terrariumRelayLoadingException, terrariumRelayUpdateException
from hardware.button import terrariumButton, terrariumButtonLoadingException
from hardware.webcam import terrariumWebcam, terrariumWebcamLoadingException

from terrariumNotification import terrariumNotification


# https://docs.python.org/3/library/gettext.html#deferred-translations
def N_(message):
    return message


class terrariumEngine(object):
    __ENGINE_LOOP_TIMEOUT = 30.0  # in seconds
    __VERSION_UPDATE_CHECK_TIMEOUT = 1  # in days

    def __init__(self, version):
        self.starttime = time.time()
        # Default system units
        self.units = {
            N_("temperature"): "C",
            N_("distance"): "cm",
            N_("altitude"): "cm",
            N_("pressure"): "hPa",
            N_("humidity"): "%",
            N_("moisture"): "%",
            N_("conductivity"): "mS",
            N_("ph"): "pH",
            N_("light"): "lux",
            N_("uva"): "µW/cm²",
            N_("uvb"): "µW/cm²",
            N_("uvi"): "",
            N_("fertility"): "µS/cm",
            N_("co2"): "ppm",
            N_("volume"): "L",
            # New version... should replace 'volume'
            N_("water_volume"): "L",
            N_("watertank"): "L",
            N_("windspeed"): "kmh",
            N_("water_flow"): "L/m",
            N_("wattage"): "W",
            N_("powerusage"): "kWh",
        }

        self.__engine = {
            "exit": threading.Event(),
            "thread": None,
            "logtail": None,
            "too_late": 0,
            "systemd": sdnotify.SystemdNotifier(),
            "asyncio": terrariumAsync(),
            "cache": terrariumCache(),
        }

        # Create a salt for encryption. And set it as environment variable
        salt = terrariumUtils.get_script_data("grep -i serial /proc/cpuinfo").decode().strip()
        salt = salt.split(":")[1].strip()
        os.environ["SALT"] = salt

        self.meross_cloud = None

        self.version = version
        self.latest_version = None
        self.update_available = False
        self.weather = None
        # Dirty hack... :(
        self.device = Path("/proc/device-tree/model").read_text().rstrip("\x00")
        init_db(self.version)

        # Send message that startup is ready..... else the startup will wait until done.... can take more then 1 minute
        self.__engine["systemd"].notify("READY=1")
        self.running = True

        # Make the first round of logging visible to the console, as this is the startup
        old_log_level = terrariumLogging.logging.getLogger().handlers[0].level
        terrariumLogging.logging.getLogger().handlers[0].setLevel(terrariumLogging.logging.INFO)
        startup_message = f"Starting up TerrariumPI {self.version} on a {self.device} ..."
        logger.info(startup_message)

        # Load settings. This will also load the weather data if available
        self.load_settings()

        # Notification system
        self.notification = terrariumNotification(self)
        self.notification.engine = self
        self.notification.load_services()
        self.notification.broadcast(startup_message, startup_message, self.settings["profile_image"])

        # Load Web server, as we need it for websocket communication (even when the web server is not yet started)
        self.webserver = terrariumWebserver(self)

        # Loading calendar
        self.calendar = terrariumCalendar()

        # Caching total power and water usage
        start = time.time()
        self.relays = {}
        logger.info("Start loading total power and water usage")
        self.get_power_usage_water_flow(True)
        logger.info(f"Loaded total power and water usage in {time.time()-start:.2f} seconds.")

        # Loading the sensors
        start = time.time()
        logger.info("Loading existing sensors from database.")
        self.__load_existing_sensors()

        logger.info("Scanning for new sensors ...")
        self.scan_new_sensors()
        logger.info(f"Loaded {len(self.sensors)} sensors in {time.time()-start:.2f} seconds.")

        # Loading relays
        start = time.time()
        logger.info("Loading existing relays from database.")
        self.__load_existing_relays()

        logger.info("Scanning for new relays ...")
        self.scan_new_relays()
        logger.info(f"Loaded {len(self.relays)} relays in {time.time()-start:.2f} seconds.")

        # Loading buttons....
        start = time.time()
        logger.info("Loading existing buttons from database.")
        self.__load_existing_buttons()
        logger.info(f"Loaded {len(self.buttons)} buttons in {time.time()-start:.2f} seconds.")

        # Loading webcams
        start = time.time()
        logger.info("Loading existing webcams from database.")
        self.__load_existing_webcams()
        logger.info(f"Loaded {len(self.webcams)} webcams in {time.time()-start:.2f} seconds.")

        # Loading enclosures and areas
        start = time.time()
        logger.info("Loading existing enclosures from database.")
        self.__load_existing_enclosures()
        logger.info(f"Loaded {len(self.enclosures)} enclosures in {time.time()-start:.2f} seconds.")

        self.environment = None

        self.motd()

        startup_message = f'TerrariumPI {self.version} is up and running at address: http://{self.settings["host"]}:{self.settings["port"]} in {time.time()-self.starttime:.2f} seconds.'
        logger.info(startup_message)
        self.notification.broadcast(startup_message, startup_message, self.settings["profile_image"])

        # Return console logging back to 'normal'
        terrariumLogging.logging.getLogger().handlers[0].setLevel(old_log_level)
        self.__engine["logtail"] = threading.Thread(target=self.__log_tailing)
        self.__engine["thread"] = threading.Thread(target=self.__engine_loop)

        self.__engine["logtail"].start()
        self.__engine["thread"].start()

        # Start the web server. This will be ending by pressing Ctrl-C or sending kill -INT {PID}
        self.webserver.start()

        # Stop Terrarium engine
        if self.running:
            self.stop()

    def restart(self):
        def sigint_process():
            # If running with the service, it should restart automatically after 5 sec.
            terrariumUtils.get_script_data(f"sleep 1; kill -INT {os.getpid()} &")

        threading.Timer(2, sigint_process).start()
        logger.warning(f'Restarting TerrariumPI {self.settings["version"]} now!')
        return True

    def reboot(self):
        def sigint_process():
            terrariumUtils.get_script_data("sleep 1; sudo reboot &")

        threading.Timer(2, sigint_process).start()
        logger.warning(f'Rebooting TerrariumPI {self.settings["version"]} now!')
        return True

    def shutdown(self):
        def sigint_process():
            terrariumUtils.get_script_data("sleep 1; sudo shutdown &")

        threading.Timer(2, sigint_process).start()
        logger.warning(f'Shutting down TerrariumPI {self.settings["version"]} now!')
        return True

    @property
    def available_languages(self):
        languages = []
        for language_file in Path("locales/").glob("**/*.po"):
            language = language_file.read_text()
            language_code = (
                re.search('^"Language: (?P<language>[^<"]+)', language, re.MULTILINE)
                .group("language")
                .strip()
                .replace("\\n", "")
                .strip()
            )
            language_name = (
                re.search('^"Language-Team: (?P<language>[^<"]+)', language, re.MULTILINE)
                .group("language")
                .strip()
                .replace("\\n", "")
                .strip()
            )

            if "" == language_name or "none" == language_name:
                language_name = language_code

            languages.append({"id": language_code, "name": language_name})

        return sorted(languages, key=lambda l: l["name"])

    @property
    def active_language(self):
        return self.settings["language"].replace("-", "_")

    # -=NEW=-
    def load_settings(self):
        start = time.time()
        logger.debug("Loading settings")
        # Store settings first locally, and replace the active settings with the new settings
        settings = {}
        with orm.db_session():
            for setting in Setting.select():
                setting = setting.to_dict()

                if terrariumUtils.is_float(setting["value"]):
                    settings[setting["id"]] = float(setting["value"])
                elif setting["value"].lower() in ["true", "false", "on", "off", "1", "0"]:
                    settings[setting["id"]] = terrariumUtils.is_true(setting["value"])
                elif setting["id"].lower() in ["power_price", "water_price"]:
                    settings[setting["id"]] = (
                        float(setting["value"]) if terrariumUtils.is_float(setting["value"]) else 0.0
                    )
                else:
                    settings[setting["id"]] = setting["value"]

                logger.debug(f"Loaded setting: {setting['id']} with value: {setting['value']}")

        settings["exclude_ids"] = [] if "" == settings["exclude_ids"] else settings["exclude_ids"].split(",")
        # Force port number to an int.....
        settings["port"] = int(settings["port"])

        # Set meross login into the current bash environment
        # But first check if the credentials have changed.
        meross_login = (
            os.environ.get("MEROSS_EMAIL", None) != settings["meross_cloud_username"]
            or os.environ.get("MEROSS_PASSWORD", None) != settings["meross_cloud_password"]
        )
        os.environ["MEROSS_EMAIL"] = settings["meross_cloud_username"]
        os.environ["MEROSS_PASSWORD"] = settings["meross_cloud_password"]

        # Make sure we use PiGPIO daemon for PWM
        # Pin factories: https://gpiozero.readthedocs.io/en/latest/api_pins.html
        # rgpio should be the coming factory for Raspberry PI 5 https://github.com/gpiozero/gpiozero/pull/1129
        os.environ["GPIOZERO_PIN_FACTORY"] = "rgpio" if terrariumUtils.isRaspberryPI5() else "pigpio"

        # Add some extra non DB settings
        settings["version"] = self.version
        # Load device information
        settings["device"] = self.device

        # Load the languages. Make a copy of the original, so we can reuse this value easier.
        settings["languages"] = copy.copy(self.available_languages)

        # Custom favicon
        favicon = Path("media/favicon.ico")
        settings["favicon"] = "/media/favicon.ico" if favicon.exists() else "/favicon.ico"

        if settings["profile_image"] == "":
            settings["profile_image"] = "public/img/terrariumpi.jpg"

        # Set unit values
        self.units["temperature"] = (
            "C"
            if "celsius" == settings["temperature_indicator"]
            else ("F" if "fahrenheit" == settings["temperature_indicator"] else "K")
        )
        self.units["heating"] = self.units["temperature"]
        self.units["cooling"] = self.units["temperature"]
        self.units["distance"] = "cm" if "cm" == settings["distance_indicator"] else "inch"
        self.units["altitude"] = self.units["distance"]
        self.units["volume"] = (
            "L"
            if "l" == settings["water_volume_indicator"]
            else ("UKGall" if "ukgall" == settings["water_volume_indicator"] else "USGall")
        )
        self.units["water_flow"] = self.units["volume"] + "/m"
        self.units["watertank"] = self.units["volume"]

        if "km/h" == settings["wind_speed_indicator"]:
            if "cm" == settings["distance_indicator"]:
                self.units["windspeed"] = "km/h"
            elif "inch" == settings["distance_indicator"]:
                self.units["windspeed"] = "mph"

        elif "m/s" == settings["wind_speed_indicator"]:
            if "cm" == settings["distance_indicator"]:
                self.units["windspeed"] = "m/s"
            elif "inch" == settings["distance_indicator"]:
                self.units["windspeed"] = "f/s"

        elif "m/h" == settings["wind_speed_indicator"]:
            self.units["windspeed"] = "mph"

        elif "beaufort" == settings["wind_speed_indicator"]:
            self.units["windspeed"] = "Bf"
            # https://stackoverflow.com/questions/60001991/how-to-convert-windspeed-between-beaufort-scale-and-m-s-and-vice-versa-in-javasc

        # Replace active settings with the new settings
        self.settings = settings
        logger.info(f"Loaded {len(settings)} settings in {time.time()-start:.2f} seconds.")

        # Loading active language
        try:
            gettext.translation("terrariumpi", "locales/", languages=[self.active_language]).install()
            logger.info(f"Loaded language '{self.active_language}'.")
        except:
            logger.warning(f"Translation '{self.active_language}' does not exists! Falling back on English (US).")
            gettext.translation("terrariumpi", "locales/", languages=["en_US"]).install()

        # Loading git data
        gitversion = None
        if Path(".gitversion").exists():
            gitversion = Path(".gitversion").read_text().strip()
            gitversion = None if gitversion == "" else gitversion

        if gitversion is None and Path(".git").exists():
            gitversion = str(terrariumUtils.get_script_data("git rev-parse HEAD").decode("utf-8")).strip()

        self.settings["gitversion"] = gitversion

        # Old dark mode conversion #852
        if str(self.settings["auto_dark_mode"]).lower() == "true":
            self.settings["auto_dark_mode"] = "on"
        elif str(self.settings["auto_dark_mode"]).lower() == "false":
            self.settings["auto_dark_mode"] = "off"

        # Loading weather
        if "weather_source" in self.settings:
            if "" != self.settings["weather_source"]:
                try:
                    start = time.time()
                    self.weather = terrariumWeather(self.settings["weather_source"], self.units, self.active_language)
                    weatherLogger.info(
                        f'Loaded weather data from source {self.settings["weather_source"]} in {time.time()-start:.2f} seconds'
                    )
                except Exception as ex:
                    weatherLogger.error(f"Loading exception: {ex}")

            elif self.weather is not None:
                start = time.time()
                self.weather.address = self.settings["weather_source"]
                # Force an update, due to maybe changing speed units or temperature.... lazy fix... :(
                self.weather.update()
                weatherLogger.info(
                    f'Updated weather source data to {self.settings["weather_source"]} in {time.time()-start:.2f} seconds'
                )

        # Loading Meross cloud
        if "" != settings["meross_cloud_username"] and "" != settings["meross_cloud_password"] and meross_login:
            logger.info("Loading Meross cloud connection.")
            if self.meross_cloud is not None:
                logger.info("Stopping existing Meross cloud connection.")
                self.meross_cloud.stop()

            self.meross_cloud = TerrariumMerossCloud(
                settings["meross_cloud_username"],
                settings["meross_cloud_password"],
            )

    # -=NEW=-
    def __update_checker(self):
        # Set the initial update to 1970 if this is the first update check.
        # Else the attribute __last_update_check is known
        try:
            assert self.__last_update_check
        except Exception:
            self.__last_update_check = datetime.datetime.fromtimestamp(0)

        if datetime.datetime.now() - self.__last_update_check > datetime.timedelta(
            days=terrariumEngine.__VERSION_UPDATE_CHECK_TIMEOUT
        ):
            version_data = terrariumUtils.get_remote_data(
                "https://api.github.com/repos/theyosh/TerrariumPI/releases/latest", json=True
            )
            if version_data is None:
                logger.warning("Unable to get the latest version information from Github. Will check next round.")
                return False

            self.latest_version = version_data["tag_name"]
            self.update_available = Version(self.version) < Version(self.latest_version)
            self.__last_update_check = datetime.datetime.now()

            return self.update_available

        return False

    # -=NEW=-
    def add(self, item):
        if isinstance(item, terrariumButton):
            self.buttons[item.id] = item

        elif isinstance(item, terrariumRelay):
            self.relays[item.id] = item

        elif isinstance(item, terrariumSensor):
            self.sensors[item.id] = item

        elif isinstance(item, terrariumWebcam):
            self.webcams[item.id] = item

        elif isinstance(item, terrariumEnclosure):
            self.enclosures[item.id] = item

        elif isinstance(item, terrariumArea):
            self.enclosures[item.enclosure.id].add(item)

        return item

    def update(self, item, **data):
        update_ok = False

        if issubclass(item, terrariumButton):
            self.buttons[data["id"]].address = data["address"]
            self.buttons[data["id"]].name = data["name"]
            if "calibration" in data:
                self.buttons[data["id"]].calibrate(data["calibration"])

            update_ok = True

        elif issubclass(item, terrariumRelay):
            if data["id"] not in self.relays:
                return self.add(item)

            self.relays[data["id"]].address = data["address"]
            self.relays[data["id"]].name = data["name"]
            self.relays[data["id"]].calibrate(data.get("calibration", {}))

            update_ok = True

        elif issubclass(item, terrariumSensor):
            self.sensors[data["id"]].address = data["address"]
            self.sensors[data["id"]].name = data["name"]
            update_ok = True

        elif issubclass(item, terrariumWebcam):
            self.webcams[data["id"]].address = data["address"]
            self.webcams[data["id"]].name = data["name"]

            self.webcams[data["id"]].resolution = (int(data["width"]), int(data["height"]))
            self.webcams[data["id"]].rotation = data["rotation"]
            self.webcams[data["id"]].awb = data["awb"]

            if isinstance(self.webcams[data["id"]], terrariumRPILiveWebcam):
                logger.info(f'Stopping webcam {self.webcams[data["id"]].name}')
                self.webcams[data["id"]].stop()
                sleep(0.2)
                self.webcams[data["id"]].load_hardware()
                logger.info(f'Started webcam {self.webcams[data["id"]].name} with new configuration.')

            update_ok = True

        elif issubclass(item, terrariumEnclosure):
            update_ok = True

        elif issubclass(item, terrariumArea):
            self.enclosures[data["enclosure"]].areas[data["id"]].name = data["name"]
            self.enclosures[data["enclosure"]].areas[data["id"]].mode = data["mode"]
            self.enclosures[data["enclosure"]].areas[data["id"]].load_setup(data["setup"])

            update_ok = True

        return update_ok

    def delete(self, item, item_id, sub_id=None):
        delete_ok = False

        if issubclass(item, terrariumButton):
            if item_id in self.buttons:
                self.buttons[item_id].stop()
                del self.buttons[item_id]
            delete_ok = True

        elif issubclass(item, terrariumRelay):
            if item_id in self.relays:
                self.relays[item_id].stop()
                del self.relays[item_id]
            delete_ok = True

        elif issubclass(item, terrariumSensor):
            if item_id in self.sensors:
                self.sensors[item_id].stop()
                del self.sensors[item_id]
            delete_ok = True

        elif issubclass(item, terrariumWebcam):
            if item_id in self.webcams:
                self.webcams[item_id].stop()
                del self.webcams[item_id]
            delete_ok = True

        elif issubclass(item, terrariumArea):
            self.enclosures[sub_id].delete(item_id)
            delete_ok = True

        return delete_ok

    # Private/internal functions
    # -=NEW=-
    def __load_existing_sensors(self):
        self.sensors = {}
        with orm.db_session():
            for sensor in Sensor.select(lambda s: s.id not in self.settings["exclude_ids"]).order_by(Sensor.address):
                start = time.time()
                if sensor.id not in self.sensors:
                    sensorLogger.debug(f"Loading {sensor}.")
                    try:
                        self.add(terrariumSensor(sensor.id, sensor.hardware, sensor.type, sensor.address, sensor.name))
                        if "chirp" == sensor.hardware.lower():
                            # We need some moisture calibration for a Chirp sensor
                            self.sensors[sensor.id].calibrate(sensor.calibration)

                    except terrariumSensorLoadingException as ex:
                        sensorLogger.error(f"Error loading {sensor} with error: {ex}.")
                        continue

                else:
                    sensorLogger.debug(f"Updated already loaded {self.sensors[sensor.id]}.")
                    # Update existing sensor with new address
                    self.sensors[sensor.id].address = sensor.address

                # Take a measurement from the sensor
                value = self.sensors[sensor.id].update()
                if value is None:
                    logger.warning(
                        f"{self.sensors[sensor.id]} had problems reading a new value during startup in {time.time()-start:.2f} seconds. Will be updated in the next round."
                    )

                elif not sensor.limit_min <= value <= sensor.limit_max:
                    sensorLogger.warning(
                        f"Measurement for sensor {self.sensors[sensor.id]} of {value:.2f}{self.units[sensor.type]} is outside valid range {sensor.limit_min:.2f}{self.units[sensor.type]} to {sensor.limit_max:.2f}{self.units[sensor.type]} during startup in {time.time()-start:.2f} seconds. Will be updated in the next round."
                    )

                else:
                    # Store the new measurement value in the database
                    sensor.update(value)
                    sensorLogger.info(
                        f"Loaded sensor {self.sensors[sensor.id]} with value {value:.2f}{self.units[sensor.type]} in {time.time()-start:.2f} seconds."
                    )

    # -=NEW=-
    def scan_new_sensors(self):
        for sensor in terrariumSensor.scan_sensors():
            if sensor.id not in self.settings["exclude_ids"] and sensor.id not in self.sensors:
                start = time.time()
                sensorLogger.debug(f"Found new sensor {sensor}")
                action = "Added new"
                value = sensor.update()

                with orm.db_session():
                    try:
                        # First try to see if the Sensor does exist based on ID (means address change)
                        new_sensor = Sensor[sensor.id]
                        new_sensor.address = sensor.address
                        action = "Updated existing"
                    except orm.core.ObjectNotFound:
                        # Store new sensor in database
                        new_sensor = Sensor(
                            id=sensor.id,
                            hardware=sensor.HARDWARE,
                            type=sensor.sensor_type,
                            name=sensor.name,
                            address=sensor.address,
                        )

                    # Create a new sensor data entry, so we have at least one sensor value
                    new_sensor.update(value)

                # Store the hardware sensor in memory, so we can benefit from the shared cached data for sensors with multiple sensor types
                self.add(sensor)

                sensorLogger.info(
                    f"{action} new sensor {new_sensor} to database with value {value:.2f}{self.units[sensor.type]} in {time.time()-start:.2f} seconds."
                )
            else:
                reason = "excluded" if sensor.id in self.settings["exclude_ids"] else "already loaded"
                sensorLogger.debug(f"Ignored sensor {sensor} because it is {reason}.")

    def _update_sensors(self):
        sensors = []
        with orm.db_session():
            # Get all loaded sensors ordered by hardware address
            sensors = sorted(
                Sensor.select(lambda s: s.id in self.sensors.keys() and not s.id in self.settings["exclude_ids"])[:],
                key=lambda item: item.address,
            )

        for sensor in sensors:
            with orm.db_session():
                current_value = sensor.value

            start = time.time()

            if "css811" == sensor.hardware.lower():
                calibration = {"temperature": [], "humidity": []}
                for calibration_sensor in sensor.calibration["ccs811_compensation_sensors"]:
                    if calibration_sensor in self.sensors:
                        calibration_sensor = self.sensors[calibration_sensor]
                        if calibration_sensor.type in calibration:
                            calibration[calibration_sensor.type].append(calibration_sensor.value)

                calibration["temperature"] = (
                    None if len(calibration["temperature"]) == 0 else statistics.mean(calibration["temperature"])
                )
                calibration["humidity"] = (
                    None if len(calibration["humidity"]) == 0 else statistics.mean(calibration["humidity"])
                )

                self.sensors[sensor.id].calibrate(calibration["temperature"], calibration["humidity"])

            new_value = self.sensors[sensor.id].update(self.sensors[sensor.id].erratic > 0)
            measurement_time = time.time() - start
            if new_value is None:
                sensorLogger.warning(
                    f"Could not take a new measurement from sensor {self.sensors[sensor.id]}. Tried for {measurement_time:.2f} seconds. Skipping this update."
                )
                continue

            # Convert some values like temperature and distance ...
            if "temperature" == sensor.type.lower():
                if "fahrenheit" == self.settings["temperature_indicator"]:
                    new_value = terrariumUtils.to_fahrenheit(new_value)
                elif "kelvin" == self.settings["temperature_indicator"]:
                    new_value = terrariumUtils.to_kelvin(new_value)

            elif "distance" == sensor.type.lower():
                if "inch" == self.settings["distance_indicator"]:
                    new_value = terrariumUtils.to_inches(new_value)

            # We have a valid reading from the hardware sensor. Now increase/decrease with the offset
            new_value += sensor.offset

            if not sensor.limit_min <= new_value <= sensor.limit_max:
                sensorLogger.warning(
                    f"Measurement for sensor {self.sensors[sensor.id]} of {new_value:.2f}{self.units[sensor.type]} is outside valid range {sensor.limit_min:.2f}{self.units[sensor.type]} to {sensor.limit_max:.2f}{self.units[sensor.type]}. Skipping this update."
                )
                continue

            if current_value is not None and sensor.max_diff != 0 and abs(current_value - new_value) > sensor.max_diff:
                self.sensors[sensor.id].erratic += 1
                if self.sensors[sensor.id].erratic < 5:
                    sensorLogger.warning(
                        f"Sensor {self.sensors[sensor.id]} has an erratic({self.sensors[sensor.id].erratic}) measurement of value {new_value:.2f}{self.units[sensor.type]} compared to old value {current_value:.2f}{self.units[sensor.type]}. The difference of {abs(current_value - new_value):.2f}{self.units[sensor.type]} is more than max allowed difference of {sensor.max_diff:.2f}{self.units[sensor.type]} and will be ignored."
                    )
                    new_value = current_value
                else:
                    sensorLogger.warning(
                        f"After {self.sensors[sensor.id].erratic} erratic measurements the new value {new_value:.2f}{self.units[sensor.type]} is promoted to the current value for sensor {sensor}."
                    )
                    self.sensors[sensor.id].erratic = 0
            else:
                self.sensors[sensor.id].erratic = 0

            if new_value is not None:
                with orm.db_session():
                    Sensor[sensor.id].update(new_value)
                    sensor_data = sensor.to_dict()

                db_time = (time.time() - start) - measurement_time

                sensor_data["unit"] = self.units[sensor.type]
                sensor_data["type"] = sensor.type
                self.webserver.websocket_message(
                    "sensor",
                    {
                        field: sensor_data[field]
                        for field in [
                            "id",
                            "value",
                            "error",
                            "alarm_min",
                            "alarm_max",
                            "limit_min",
                            "limit_max",
                            "alarm",
                            "unit",
                            "type",
                            "name",
                        ]
                    },
                )

                # Notification message
                self.notification.message("sensor_update", sensor_data)

                if new_value != current_value:
                    self.notification.message("sensor_change", sensor_data)

                if sensor_data["alarm"]:
                    self.notification.message("sensor_alarm", sensor_data)

                sensorLogger.info(
                    f"Updated sensor {self.sensors[sensor.id]} with new value {new_value:.2f}{self.units[sensor.type]} in {measurement_time+db_time:.2f} seconds."
                )
                sensorLogger.debug(
                    f"Updated sensor {self.sensors[sensor.id]} with new value {new_value:.2f}{self.units[sensor.type]}. M: {measurement_time:.2f} sec, DB:{db_time:.2f} sec."
                )

            # A small sleep between sensor measurement to get a bit more responsiveness of the system
            sleep(0.1)

        for sensor_type, avg_data in self.sensor_averages.items():
            avg_data["id"] = sensor_type
            self.webserver.websocket_message("sensor", avg_data)

        return True

    @property
    def sensor_averages(self):
        start = time.time()
        data = {}

        with orm.db_session():
            for sensor in Sensor.select(lambda s: s.exclude_avg == False and not s.id in self.settings["exclude_ids"]):
                if sensor.type not in data:
                    data[sensor.type] = {
                        "value": 0.0,
                        "count": 0.0,
                        "error": 0,
                        "alarm_min": 0.0,
                        "alarm_max": 0.0,
                        "limit_min": 0.0,
                        "limit_max": 0.0,
                    }

                if sensor.error or sensor.value is None:
                    data[sensor.type]["error"] += 1
                    continue

                data[sensor.type]["value"] += sensor.value
                data[sensor.type]["alarm_min"] += sensor.alarm_min
                data[sensor.type]["alarm_max"] += sensor.alarm_max
                data[sensor.type]["limit_min"] += sensor.limit_min
                data[sensor.type]["limit_max"] += sensor.limit_max

                data[sensor.type]["count"] += 1.0

        averages = {}
        for sensor_type, sensor_data in data.items():
            count = sensor_data["count"]
            if count == 0:
                continue

            del sensor_data["count"]
            error = sensor_data["error"] > 0
            del sensor_data["error"]

            averages[sensor_type] = {}
            for part, value in sensor_data.items():
                averages[sensor_type][part] = value / count

            averages[sensor_type]["error"] = error
            averages[sensor_type]["alarm"] = (
                not averages[sensor_type]["alarm_min"]
                <= averages[sensor_type]["value"]
                <= averages[sensor_type]["alarm_max"]
            )
            averages[sensor_type]["unit"] = self.units[sensor_type]

        logger.debug(f"Calculated sensor averages in {time.time()-start:.2f} seconds.")
        return averages

    @property
    def sensor_types_loaded(self):
        # start = time.time()
        data = []
        with orm.db_session():
            for sensor in Sensor.select(
                lambda s: s.id in self.sensors.keys() and not s.id in self.settings["exclude_ids"]
            ):
                if sensor.type not in data:
                    data.append(sensor.type)

        data = [{"id": sensor_type, "value": sensor_type} for sensor_type in data]
        return data

    def __load_existing_relays(self):
        self.relays = {}

        with orm.db_session():
            # TODO: Fix Meross better!!  and r.hardware != 'meross'
            for relay in Relay.select(lambda r: r.id not in self.settings["exclude_ids"]).order_by(Relay.address):
                start = time.time()
                if relay.id not in self.relays:
                    relayLogger.debug(f"Loading {relay}.")
                    try:
                        self.add(
                            terrariumRelay(
                                relay.id,
                                relay.hardware,
                                relay.address,
                                relay.name,
                                relay.calibration,
                                callback=self.callback_relay,
                            )
                        )

                        # Set the relay back to the old state
                        last_value = relay.value
                        # If we do not have a last value, try to get one from the relay
                        if last_value is None:
                            # If no state info available, then asume off
                            last_value = self.relays[relay.id].update() or terrariumRelay.OFF

                        # Restore the state of the relay
                        self.relays[relay.id].set_state(last_value, True)
                    except terrariumRelayLoadingException as ex:
                        relayLogger.error(f"Error loading relay {relay} with error: {ex}.")
                        continue

                # Take a measurement from the relay
                value = self.relays[relay.id].update()
                if value is None:
                    relayLogger.warning(
                        f"Relay {relay} had problems reading a new value during startup in {time.time()-start:.2f} seconds. Will be updated in the next round."
                    )
                else:
                    # Force a the new measurement value in the database
                    relay.update(value, True)
                    relayLogger.info(f"Loaded relay {relay} value {value:.2f} in {time.time()-start:.2f} seconds.")

    def scan_new_relays(self):
        for relay in terrariumRelay.scan_relays(callback=self.callback_relay):
            if relay.id not in self.settings["exclude_ids"] and relay.id not in self.relays:
                relayLogger.debug(f"Found new relay {relay}")
                action = "Added new"
                value = relay.update()
                if value is None:
                    # Not able to make a readout
                    continue

                with orm.db_session():
                    try:
                        # First try to see if the Relay does exist based on ID (means address change)
                        new_relay = Relay[relay.id]
                        new_relay.address = relay.address
                        action = "Updated existing"
                    except orm.core.ObjectNotFound:
                        # Store new relay in database
                        new_relay = Relay(id=relay.id, hardware=relay.HARDWARE, name=relay.name, address=relay.address)

                    # Create a new relay data entry, so we have at least one relay value
                    new_relay.update(value)

                # Store the hardware relay in memory, so we can benefit from the shared cached data for relays with multiple relay types
                self.add(relay)
                relayLogger.info(f"{action} relay {new_relay} to database with current value {value:.2f}.")
            else:
                relayLogger.debug(
                    "Ignored relay {} because it is {}.".format(
                        relay, "excluded" if relay.id in self.settings["exclude_ids"] else "already loaded"
                    )
                )

    def _update_relays(self):
        # Force an update every 60 minutes. This will make the graphs work better...
        force_update = int(time.time()) % (60 * 60) <= terrariumEngine.__ENGINE_LOOP_TIMEOUT

        force_totals = False

        relays = []
        with orm.db_session():
            # Get all loaded relays ordered by hardware address
            relays = sorted(
                Relay.select(lambda r: r.id in self.relays.keys() and not r.id in self.settings["exclude_ids"])[:],
                key=lambda item: item.address,
            )

        for relay in relays:
            with orm.db_session():
                current_value = relay.value

            start = time.time()
            try:
                new_value = self.relays[relay.id].update()
            except terrariumRelayUpdateException:
                pass

            measurement_time = time.time() - start

            if new_value is None:
                relayLogger.warning(
                    f"Could not take a new measurement from relay {relay}. Tried for {measurement_time:.2f} seconds. Skipping this update."
                )
                continue

            with orm.db_session():
                Relay[relay.id].update(new_value, force_update)
                relay_data = relay.to_dict()

            db_time = (time.time() - start) - measurement_time
            self.webserver.websocket_message("relay", {"id": relay.id, "value": new_value})

            relayLogger.info(
                f"Updated relay {relay} with new value {new_value:.2f} in {measurement_time+db_time:.2f} seconds."
            )
            relayLogger.debug(
                f"Updated relay {relay} with new value {new_value:.2f}. M: {measurement_time:.2f} sec, DB:{db_time:.2f} sec."
            )

            # Notification message
            self.notification.message("relay_update", relay_data)

            if new_value != current_value:
                self.notification.message("relay_change", relay_data)
                if not force_totals:
                    force_totals = new_value == 0

            # A small sleep between sensor measurement to get a bit more responsiveness of the system
            sleep(0.1)

        self.send_websocket_totals(force_totals)

    def toggle_relay(self, relay, action="toggle", duration=0):
        ok = False

        # Convert the action to an int value
        if "on" == action:
            action = terrariumRelay.ON
        elif "off" == action:
            action = terrariumRelay.OFF
        elif "toggle" == action:
            action = terrariumRelay.OFF if relay.value != terrariumRelay.OFF else terrariumRelay.ON
        else:
            action = int(action)

        # Toggle the switch, will return ok = true when succeeded
        ok = self.relays[relay.id].set_state(action)
        return ok

    def callback_relay(self, relay, state):
        # First send websocket message before updating database
        self.webserver.websocket_message("relay", {"id": relay, "value": state})

        # Update database
        with orm.db_session():
            relay = Relay[relay]
            relay.update(state)
            relay_data = relay.to_dict()

        orm.commit()

        # Update enclosure states to reflect the new relay states
        if self.__engine["thread"] is not None and self.__engine["thread"].is_alive() and hasattr(self, "enclosures"):
            self._update_enclosures(True)

        orm.commit()

        # Notification message
        self.notification.message("relay_toggle", relay_data)

        # Forcing new update when relay goes off. New 'on' period can be calculated
        self.send_websocket_totals(int(state) == 0)

    def __load_existing_buttons(self):
        self.buttons = {}

        with orm.db_session():
            for button in Button.select(lambda b: b.id not in self.settings["exclude_ids"]).order_by(Button.address):
                start = time.time()
                if button.id not in self.buttons:
                    buttonLogger.debug(f"Loading {button}.")
                    try:
                        new_button = self.add(
                            terrariumButton(button.id, button.hardware, button.address, button.name, self.button_action)
                        )
                        if button.calibration is not None:
                            new_button.calibrate(button.calibration)

                    except terrariumButtonLoadingException as ex:
                        buttonLogger.error(f"Error loading {button} with error: {ex.message}.")
                        continue

                else:
                    buttonLogger.debug(f"Updated already loaded {button}.")
                    # Update existing button with new address
                    self.buttons[button.id].address = button.address

                # Take a measurement from the button
                value = self.buttons[button.id].update()
                if value is None:
                    buttonLogger.warning(
                        f"{button} had problems reading a new value during startup in {time.time()-start:.2f} seconds. Will be updated in the next round."
                    )
                else:
                    # Store the new measurement value in the database
                    button.update(value)
                    buttonLogger.info(f"Loaded {button} value {value:.2f} in {time.time()-start:.2f} seconds.")

    def _update_buttons(self):
        # Force an update every hour. This will make the graphs work better...
        force_update = int(time.time()) % (60 * 60) <= terrariumEngine.__ENGINE_LOOP_TIMEOUT

        buttons = []
        with orm.db_session():
            # Get all loaded buttons ordered by hardware address
            buttons = sorted(
                Button.select(lambda b: b.id in self.buttons.keys() and not b.id in self.settings["exclude_ids"])[:],
                key=lambda item: item.address,
            )

        for button in buttons:
            with orm.db_session():
                current_value = button.value

            start = time.time()
            new_value = self.buttons[button.id].update()
            measurement_time = time.time() - start

            if new_value is None:
                buttonLogger.warning(
                    f"Could not take a new measurement from {button}. Tried for {measurement_time:.2f} seconds. Skipping this update."
                )
                continue

            with orm.db_session():
                Button[button.id].update(new_value, force_update)
                button_data = button.to_dict()

            db_time = (time.time() - start) - measurement_time

            buttonLogger.info(
                f"Updated {button} with new value {new_value:.2f} in {measurement_time+db_time:.2f} seconds."
            )
            buttonLogger.debug(
                f"Updated {button} with new value {new_value:.2f}. M: {measurement_time:.2f} sec, DB:{db_time:.2f} sec."
            )

            # Notification message
            self.notification.message("button_update", button_data)

            if new_value != current_value:
                self.notification.message("button_change", button_data)

            # A small sleep between sensor measurement to get a bit more responsiveness of the system
            sleep(0.1)

    def load_doors(self):
        doors = []
        with orm.db_session():
            # Get all loaded buttons ordered by hardware address
            for button in Button.select(
                lambda b: b.id in self.buttons.keys()
                and b.enclosure is not None
                and not b.id in self.settings["exclude_ids"]
            ):
                doors.append(button.to_dict())

        return doors

    # TODO: DB Optimization
    def button_action(self, button, state):
        with orm.db_session():
            button = Button[button]
            button.update(state, True)
            button_data = button.to_dict()

        # Update the button state on the button page
        self.webserver.websocket_message("button", button_data)

        # Notification message
        self.notification.message("button_action", button_data)

    def __load_existing_webcams(self):
        self.webcams = {}

        with orm.db_session():
            for webcam in Webcam.select(lambda w: w.id not in self.settings["exclude_ids"]).order_by(Webcam.address):
                start = time.time()
                if webcam.id not in self.webcams:
                    webcamLogger.debug(f"Loading {webcam}.")
                    try:
                        self.add(
                            terrariumWebcam(
                                webcam.id,
                                webcam.hardware,
                                webcam.address,
                                webcam.name,
                                int(webcam.width),
                                int(webcam.height),
                                webcam.rotation,
                                webcam.awb,
                            )
                        )

                    except terrariumWebcamLoadingException as ex:
                        webcamLogger.error(f"Error loading {webcam} with error: {ex.message}.")
                        continue

                else:
                    webcamLogger.debug(f"Updated already loaded {webcam}.")
                    # Update existing webcam with new address
                    self.webcams[webcam.id].address = webcam.address

                # # Take a shot from the webcam
                relays = (
                    []
                    if webcam.flash is None
                    else [self.relays[relay.id] for relay in webcam.flash if not relay.manual_mode]
                )
                self.webcams[webcam.id].update(relays)

                webcamLogger.info(f"Loaded {webcam} in {time.time()-start:.2f} seconds.")

    def _update_webcams(self):
        def __process_webcam(self, webcam, current_state, relays):
            start = time.time()
            if self.webcams[webcam.id].update(relays) == False:
                return

            # TODO: Move this code to the webcam itself and pass through variable 'current_state'

            # Check archiving/motion settings
            if webcam.archive["state"] not in ["disabled", ""]:
                # Check light status
                if webcam.archive["light"] not in ["ignore", ""] and current_state != webcam.archive["light"]:
                    webcamLogger.debug(
                        f'Webcam {webcam} will not archive based on light state: {current_state} vs {webcam.archive["light"]}'
                    )
                    webcamLogger.info(f"Updated webcam {webcam} in {time.time()-start:.2f} seconds.")
                    return

                # Check door status
                if webcam.archive["door"] not in ["ignore", ""]:
                    # Default state is that the doors are closed....
                    current_state = (
                        "close"
                        if webcam.enclosure is None or self.enclosures[webcam.enclosure.id].door_closed
                        else "open"
                    )

                    if webcam.archive["door"] != current_state:
                        webcamLogger.debug(
                            f'Webcam {webcam} will not archive based on door state: {current_state} vs {webcam.archive["door"]}'
                        )
                        webcamLogger.info(f"Updated webcam {webcam} in {time.time()-start:.2f} seconds.")
                        return

                if "motion" == webcam.archive["state"]:
                    newImage = self.webcams[webcam.id].motion_capture(
                        webcam.motion["frame"],
                        int(webcam.motion["threshold"]),
                        int(webcam.motion["area"]),
                        webcam.motion["boxes"],
                    )
                    if newImage:
                        self.__environment.notification.message(
                            "webcam_motion", webcam.to_dict(), [self.webcams[webcam.id].last_archived_image]
                        )

                else:
                    newImage = self.webcams[webcam.id].archive(int(webcam.archive["state"]))
                    if newImage:
                        self.__environment.notification.message(
                            "webcam_archive", webcam.to_dict(), [self.webcams[webcam.id].last_archived_image]
                        )

            webcamLogger.info(f"Updated webcam {webcam} in {time.time()-start:.2f} seconds.")

        with futures.ThreadPoolExecutor() as pool:
            with orm.db_session():
                # Get all loaded webcam ordered by hardware address
                for webcam in sorted(
                    Webcam.select(lambda w: w.id in self.webcams.keys() and not w.id in self.settings["exclude_ids"])[
                        :
                    ],
                    key=lambda item: item.address,
                ):
                    # Get the current light state first, as processing new image could take 10 sec. In that period the lights could have been turned on,
                    # where the picture is taken when the lights are off.
                    current_state = (
                        "on" if webcam.enclosure is None or self.enclosures[webcam.enclosure.id].lights_on else "off"
                    )
                    # Set the flash relays if selected
                    relays = (
                        []
                        if webcam.flash is None
                        else [self.relays[relay.id] for relay in webcam.flash if not relay.manual_mode]
                    )
                    # Start update in parallel
                    pool.submit(__process_webcam, self, webcam, current_state, relays)

    def __load_existing_enclosures(self):
        self.enclosures = {}

        with orm.db_session():
            for enclosure in Enclosure.select(lambda e: e.id not in self.settings["exclude_ids"]):
                start = time.time()
                if enclosure.id not in self.enclosures:
                    enclosureLogger.debug(f"Loading {enclosure}.")

                    # TODO: Sensors should be database entities... so query them when needed in the area it selfs
                    new_enclosure = self.add(
                        terrariumEnclosure(
                            str(enclosure.id),
                            enclosure.name,
                            self,
                            [door.id for door in enclosure.doors],
                            list(enclosure.areas),
                        )
                    )

                else:
                    enclosureLogger.debug(f"Updated already loaded {enclosure}.")
                    # Update existing enclosure with new setup....?

                new_enclosure.update()
                enclosureLogger.info(f"Loaded {enclosure} in {time.time()-start:.2f} seconds.")

    def _update_enclosures(self, read_only=False):
        with orm.db_session():
            for enclosure in Enclosure.select():
                if str(enclosure.id) not in self.enclosures or str(enclosure.id) in self.settings["exclude_ids"]:
                    continue

                start = time.time()
                area_states = self.enclosures[str(enclosure.id)].update(read_only)
                for area in enclosure.areas:
                    area_state = area_states.get(str(area.id), None)
                    if area_state:
                        area.state = area_state

                measurement_time = time.time() - start

                enclosureLogger.info(f"Updated {enclosure} in {measurement_time:.2f} seconds.")
                enclosureLogger.debug(f"Updated {enclosure}. M: {measurement_time:.2f} sec.")

    def __engine_loop(self):
        logger.info(f"Starting engine updater with {terrariumEngine.__ENGINE_LOOP_TIMEOUT:.2f} seconds interval.")
        # A small sleep here, will make the webinterface start directly. Else we have to wait till the first update run is done :(
        sleep(0.25)
        prev_delay = 0

        while not self.__engine["exit"].is_set():
            self.__engine["systemd"].notify("WATCHDOG=1")

            logger.info(
                f"Starting a new update round with {len(self.sensors)} sensors, {len(self.relays)} relays, {len(self.buttons)} buttons and {len(self.webcams)} webcams."
            )
            start = time.time()

            # Weather data
            if self.weather is not None:
                self.weather.update()

            # System stats (needs weather update)
            self.webserver.websocket_message("systemstats", self.system_stats())

            # Run updates in parallel and wait till all done
            with futures.ThreadPoolExecutor() as pool:
                pool.submit(self._update_sensors)
                pool.submit(self._update_relays)
                pool.submit(self._update_buttons)
                pool.submit(self._update_webcams)
                pool.submit(self.__update_checker)

            # Run encounter/environment updates
            self._update_enclosures()

            self.motd()

            # Cleanup hanging bluetooth helper scripts....
            terrariumUtils.kill_bluetooth_helper_processes()

            duration = time.time() - start
            time_left = terrariumEngine.__ENGINE_LOOP_TIMEOUT - duration

            if time_left > 0.0:
                logger.info(
                    f"Engine update done in {duration:.2f} seconds. Waiting for {time_left:.2f} seconds for the next round."
                )
                # Here we wait....
                self.__engine["exit"].wait(max(0, time_left - prev_delay))
                # Reset the delay from last round to zero.
                prev_delay = 0
                # Clear the 'too late counter'
                self.__engine["too_late"] = 0

            else:
                self.__engine["too_late"] += 1
                prev_delay = abs(time_left)
                message = f"Engine update took {duration:.2f} seconds. That is {prev_delay:.2f} seconds short."
                logger.warning(message)

                message_data = {
                    "message": message,
                    "time_short": prev_delay,
                    "update_duration": duration,
                    "loop_timeout": terrariumEngine.__ENGINE_LOOP_TIMEOUT,
                    "times_late": self.__engine["too_late"],
                }
                self.notification.message("system_update_warning", message_data)

                if self.__engine["too_late"] > 30:
                    message = f'Engine can\'t keep up. For {self.__engine["too_late"]} times it could not finish in {terrariumEngine.__ENGINE_LOOP_TIMEOUT} seconds.'
                    logger.error(message)
                    message_data["message"] = message
                    self.notification.message("system_update_error", message_data)

        logger.info("Stopped main engine thread")

    def motd(self):
        start = time.time()
        # Enable translations
        _ = terrariumUtils.get_translator(self.active_language)

        motd_data = {}

        # Default left padding
        padding = 2 * " "
        # Longest text lines first...
        tmp = self.system_stats()

        motd_data["uptime"] = terrariumUtils.format_uptime(tmp["uptime"])
        motd_data["system_load"] = str(tmp["load"]["absolute"])[1:-1]
        motd_data["system_load_alarm"] = tmp["load"]["absolute"][0] > 1.0

        motd_data["cpu_temperature"] = f'{tmp["cpu_temperature"]} {self.units["temperature"]}'
        motd_data["cpu_temperature_alarm"] = tmp["cpu_temperature"] > 50

        motd_data["storage"] = (
            f'{terrariumUtils.format_filesize(tmp["storage"]["used"])}({ tmp["storage"]["used"] / tmp["storage"]["total"] * 100:.2f}%) used of total {terrariumUtils.format_filesize(tmp["storage"]["total"])}'
        )
        motd_data["memory"] = (
            f'{terrariumUtils.format_filesize(tmp["memory"]["used"])}({ tmp["memory"]["used"] / tmp["memory"]["total"] * 100:.2f}%) used of total {terrariumUtils.format_filesize(tmp["memory"]["total"])}'
        )

        system_stats = []
        system_stats.append({"title": _("Up time") + ":", "value": motd_data["uptime"], "alarm": False})

        system_stats.append(
            {
                "title": _("System load") + ":",
                "value": motd_data["system_load"],
                "alarm": motd_data["system_load_alarm"],
            }
        )

        system_stats.append(
            {
                "title": _("CPU Temperature") + ":",
                "value": motd_data["cpu_temperature"],
                "alarm": motd_data["cpu_temperature_alarm"],
            }
        )

        system_stats.append({"title": _("Storage") + ":", "value": motd_data["storage"], "alarm": False})

        system_stats.append({"title": _("Memory") + ":", "value": motd_data["memory"], "alarm": False})
        system_title_length = max([len(line["title"]) for line in system_stats])
        system_value_length = max([len(line["value"]) for line in system_stats])

        avg_title_length = 0
        avg_value_length = 0
        avg_unit_length = 0

        # Get the sensors averages sorted on type name
        tmp = self.sensor_averages
        averages = []
        if len(tmp) > 0:
            for avg_type in self.sensor_averages:
                motd_data[f"average_{avg_type}"] = tmp[avg_type]["value"]
                motd_data[f"average_{avg_type}_unit"] = self.units[avg_type]
                motd_data[f"average_{avg_type}_alarm"] = (
                    not tmp[avg_type]["alarm_min"] <= tmp[avg_type]["value"] <= tmp[avg_type]["alarm_max"]
                )

                averages.append(
                    {
                        "title": _("average {sensor_type}").format(sensor_type=_(avg_type)).capitalize() + ":",
                        "value": "{:.2f}".format(motd_data[f"average_{avg_type}"]),
                        "unit": motd_data[f"average_{avg_type}_unit"],
                        "alarm": motd_data[f"average_{avg_type}_alarm"],
                    }
                )

            averages = sorted(averages, key=lambda k: k["title"])

            # Get the lengths of all the texts for the text alignment
            avg_title_length = max([len(line["title"]) for line in averages])
            avg_value_length = max([len(line["value"]) for line in averages])
            avg_unit_length = max([len(line["unit"]) for line in averages])

        # Start creating the average MOTD lines
        motd_averages = ""
        for line_counter in range(max([len(averages), len(system_stats)])):
            empty_avg = line_counter >= len(averages)
            empty_stats = line_counter >= len(system_stats)
            # Add default padding
            motd_averages += padding

            # Add the average title name
            motd_averages += (
                avg_title_length * " " if empty_avg else averages[line_counter]["title"].ljust(avg_title_length, " ")
            )
            # Add the average value with or without alarm color
            motd_averages += " "
            motd_averages += (
                avg_value_length * " "
                if empty_avg
                else ((avg_value_length - len(averages[line_counter]["value"])) * " ")
                + (
                    averages[line_counter]["value"]
                    if not averages[line_counter]["alarm"]
                    else pyfancy().yellow(averages[line_counter]["value"]).get()
                )
            )
            # Add the average unit type with or without alarm color
            motd_averages += " "
            motd_averages += (
                avg_unit_length * " "
                if empty_avg
                else (
                    averages[line_counter]["unit"]
                    if not averages[line_counter]["alarm"]
                    else pyfancy().yellow(averages[line_counter]["unit"]).get()
                )
                + ((avg_unit_length - len(averages[line_counter]["unit"])) * " ")
            )

            # Add system stats
            motd_averages += "  "
            motd_averages += "" if empty_stats else system_stats[line_counter]["title"].ljust(system_title_length, " ")
            # Add the system value with or without alarm color
            motd_averages += " "
            motd_averages += (
                ""
                if empty_stats
                else (
                    system_stats[line_counter]["value"]
                    if not system_stats[line_counter]["alarm"]
                    else pyfancy().yellow(system_stats[line_counter]["value"]).get()
                )
            )

            motd_averages += "\n"

        # Generate ascii art title in color
        figlet = pyfiglet.Figlet(font="doom")
        title = self.settings["title"]

        if "PI" in title:
            split_pos = title.find("PI")

            # This is the red part ( PI )
            title_part2 = figlet.renderText(title[split_pos : split_pos + 2]).split("\n")

            if split_pos == 0:
                title_part1 = [""] * len(title_part2)
                title_part3 = figlet.renderText(title[split_pos + 2 :]).split("\n")

            elif split_pos == len(title) - 2:
                title_part1 = figlet.renderText(title[0:split_pos]).split("\n")
                title_part3 = [""] * len(title_part2)

            else:
                title_part1 = figlet.renderText(title[0:split_pos]).split("\n")
                title_part3 = figlet.renderText(title[split_pos + 2 :]).split("\n")

        else:
            title_part1 = figlet.renderText(title).split("\n")
            title_part2 = [""] * len(title_part1)
            title_part3 = [""] * len(title_part1)

        # Get the lengths of all the texts for the text alignment (before adding colors, as they are counted for the length also)
        max_title_length = (
            max([len(line) for line in title_part1])
            + max([len(line) for line in title_part2])
            + max([len(line) for line in title_part3])
            + 1
        )
        max_line_length = (
            avg_title_length + avg_value_length + avg_unit_length + system_title_length + system_value_length + 4
        )
        title_padding = int((max_line_length - max_title_length) / 3) * " "

        motd_title = ""
        for counter, _dummy in enumerate(title_part2):
            if (
                "" == title_part1[counter].strip()
                and "" == title_part2[counter].strip()
                and "" == title_part3[counter].strip()
            ):
                continue

            motd_title += padding + title_padding
            motd_title += pyfancy().green(title_part1[counter]).get()
            motd_title += pyfancy().red(title_part2[counter]).get()
            motd_title += pyfancy().green(title_part3[counter]).get()
            motd_title += "\n"

        # Current version and update message
        update_available = (
            False if self.latest_version is None else Version(self.version) < Version(self.latest_version)
        )
        motd_version = "{}: {}{}".format(
            _("Version"), self.version, (f" / {self.latest_version}" if update_available else "")
        )
        version_length = len(motd_version)
        version_padding = (int(max_line_length * 0.66) - version_length) * " "

        if update_available:
            motd_version = pyfancy().yellow(motd_version).get()

        motd_version = padding + version_padding + motd_version + "\n"

        if update_available:
            motd_version += (
                padding
                + pyfancy()
                .yellow(
                    _("A new version ({version}) is available!").format(version=self.latest_version)
                    + " https://github.com/theyosh/TerrariumPI/releases"
                )
                .get()
                + "\n"
            )

        # Relays
        relays = []
        relay_averages = {"power": {"current": 0, "max": 0}, "flow": {"current": 0, "max": 0}}
        with orm.db_session():
            for relay in Relay.select(
                lambda r: r.id in self.relays.keys() and not r.id in self.settings["exclude_ids"]
            ):
                relay_averages["power"]["current"] += relay.current_wattage
                relay_averages["power"]["max"] += relay.wattage

                relay_averages["flow"]["current"] += relay.current_flow
                relay_averages["flow"]["max"] += relay.flow

                if not relay.is_on:
                    continue

                relay_title = f"{padding}{relay.name}"
                if relay.is_dimmer:
                    relay_title += f" ({relay.value:.0f}%)"

                relays.append(
                    {
                        "title": f"{relay_title}  ",
                        "power": f'{relay.current_wattage:.2f} {_("Watt")},',
                        "flow": f'{relay.current_flow:.2f} {self.units["water_flow"]}',
                    }
                )

        relays = sorted(relays, key=lambda k: k["title"])

        # TODO: Optimize variable usage here

        motd_data["current_watt"] = relay_averages["power"]["current"] + float(self.settings["pi_wattage"])
        motd_data["max_watt"] = relay_averages["power"]["max"] + float(self.settings["pi_wattage"])
        motd_data["current_flow"] = relay_averages["flow"]["current"]
        motd_data["max_flow"] = relay_averages["flow"]["max"]
        motd_data["relays_active"] = len(relays)

        current_watt = relay_averages["power"]["current"]
        max_watt = relay_averages["power"]["max"]

        current_flow = relay_averages["flow"]["current"]
        max_flow = relay_averages["flow"]["max"]

        relays_active = len(relays)
        relay_title_left = len(_("Current active relays") + f" {relays_active}/{len(self.relays)}  ")
        relay_title_right = len(
            f"{current_watt:.2f}/{max_watt:.2f} "
            + _("Watt")
            + f', {current_flow:.2f}/{max_flow:.2f} {self.units["water_flow"]}'
        )
        relay_title_padding = 0

        motd_relays = ""
        if relays_active > 0:
            # Get the max column width values based on the text length
            relay_title_length = max([len(line["title"]) for line in relays])
            relay_power_length = max([len(line["power"]) for line in relays])
            relay_flow_length = max([len(line["flow"]) for line in relays])

            # If the length of the title is longer then the max relay line, increase the relay title length for more padding
            if relay_title_left + relay_title_right > relay_title_length + relay_power_length + relay_flow_length:
                relay_title_length += (
                    (relay_title_left + relay_title_right)
                    - (relay_title_length + relay_power_length + relay_flow_length)
                    + 2
                )

            # Add the active relays to the list
            for relay in relays:
                motd_relays += (
                    relay["title"].ljust(relay_title_length, " ")
                    + " "
                    + relay["power"].rjust(relay_power_length, " ")
                    + " "
                    + relay["flow"].rjust(relay_flow_length, " ")
                    + "\n"
                )

            motd_relays = (
                padding + ((relay_title_length + relay_power_length + relay_flow_length) * "-") + "\n" + motd_relays
            )

            # Adjust the padding/spacing based on the length of the relay text lines
            relay_title_padding = (
                (relay_title_length + relay_power_length + relay_flow_length)
                - (relay_title_left + relay_title_right)
                - 2
            )

            # Add colors to the values
            if relays_active > 0:
                relays_active = pyfancy().green(f"{relays_active}").get()
                current_watt = pyfancy().green(f"{current_watt:.2f}").get()
                current_flow = pyfancy().blue(f"{current_flow:.2f}").get()

        motd_relays = (
            padding
            + _("Current active relays")
            + f" ({relays_active}/{len(self.relays)})  "
            + (relay_title_padding * " ")
            + f'{current_watt}/{max_watt:.2f} {_("Watt")}, {current_flow}/{max_flow:.2f} {self.units["water_flow"]}'
            + "\n"
            + motd_relays
        )

        if self.__engine["too_late"] > 30:
            motd_relays += "\n"
            motd_relays += (2 * padding) + pyfancy().red(
                f'Engine can\'t keep up! For {self.__engine["too_late"]} times it could not finish in {terrariumEngine.__ENGINE_LOOP_TIMEOUT} seconds.'
            ).get()
            motd_relays += "\n"
            motd_relays += (3 * padding) + pyfancy().red("Please check your setup and hardware!").get()
            motd_relays += "\n"

        # Last update line
        last_update = _("last update").capitalize()
        motd_last_update = (3 * padding) + pyfancy().blue(
            f"{last_update}: {datetime.datetime.now():%A, %d-%m-%Y %H:%M:%S}"
        ).get()

        motd_file = Path("motd.sh")
        with motd_file.open("w") as motdfile:
            motdfile.write("#!/bin/bash\n")
            motdfile.write('echo "')
            motdfile.write(motd_title.replace("`", "\`") + "\n")
            motdfile.write(motd_version + "\n")
            motdfile.write(motd_averages + "\n")
            motdfile.write(motd_relays + "\n")
            motdfile.write(motd_last_update + "\n")
            motdfile.write('"')

        motd_file.chmod(0o755)

        logger.info(f"Message of the Day generated in {time.time()-start:.2f} seconds")

        # Send notification message
        self.notification.message("system_summary", motd_data)

    def __log_tailing(self):
        logger.info("Starting log tailing.")
        with subprocess.Popen(
            ["tail", "-F", terrariumLogging.logging.getLogger().handlers[1].baseFilename],
            stdout=subprocess.PIPE,
            stderr=subprocess.PIPE,
            text=True,
        ) as self.__logtail_process:
            for line in self.__logtail_process.stdout:
                self.webserver.websocket_message("logline", line.strip())

        logger.info("Stopped log tailing.")
        if self.running:
            self.stop()

    def stop(self):
        if not self.running:
            return

        terrariumLogging.logging.getLogger().handlers[0].setLevel(terrariumLogging.logging.INFO)
        logger.info(f"Stopping TerrariumPI {self.version} ...")

        self.running = False
        self.__engine["exit"].set()

        # Wait till the engine is done, when it was updating the sensors
        self.__logtail_process.terminate()

        try:
            self.__engine["thread"].join()
        except Exception:
            pass

        try:
            self.__engine["logtail"].join()
        except Exception:
            pass

        for enclosure in self.enclosures:
            self.enclosures[enclosure].stop()
            logger.info(f"Stopped {self.enclosures[enclosure]}")

        for button in self.buttons:
            self.buttons[button].stop()
            logger.info(f"Stopped {self.buttons[button]}")

        for sensor in self.sensors:
            self.sensors[sensor].stop()
            logger.info(f"Stopped {self.sensors[sensor]}")

        for relay in self.relays:
            self.relays[relay].stop()
            logger.info(f"Stopped {self.relays[relay]}")

        for webcam in self.webcams:
            self.webcams[webcam].stop()
            logger.info(f"Stopped {self.webcams[webcam]}")

        if self.meross_cloud is not None:
            self.meross_cloud.stop()

        shutdown_message = f"Stopped TerrariumPI {self.version} after running for {terrariumUtils.format_uptime(time.time()-self.starttime)}. Bye bye."
        self.notification.broadcast(shutdown_message, shutdown_message, self.settings["profile_image"])
        self.notification.stop()

        self.__engine["asyncio"].stop()

        logger.info(shutdown_message)

    def replace_hardware_calender_event(self, switch_id, device, reminder_amount, reminder_period):
        # Two events:
        # 1. When it happened
        # 2. Reminder for next time

        current_time = datetime.date.today()
        switch = self.power_switches[switch_id]
        switch.set_last_hardware_replacement()
        self.config.save_power_switch(switch.get_data())
        self.calendar.create_event(
            switch_id,
            "{} hardware replacement".format(switch.get_name()),
            "Replaced '{}' at power switch {}".format(device, switch.get_name()),
            None,
            current_time,
        )

        reminder = None
        try:
            if "days" == reminder_period:
                reminder = datetime.timedelta(days=int(reminder_amount))
            elif "weeks" == reminder_period:
                reminder = datetime.timedelta(days=(int(reminder_amount) * 7))
            elif "months" == reminder_period:
                reminder = datetime.timedelta(days=(int(reminder_amount) * 30))
            elif "years" == reminder_period:
                reminder = datetime.timedelta(days=(int(reminder_amount) * 365))
        except Exception as ex:
            print(ex)

        if reminder is not None:
            current_time += reminder
            self.calendar.create_event(
                switch_id,
                "Reminder {} hardware replacement".format(switch.get_name()),
                "Replace '{}' at power switch {}".format(device, switch.get_name()),
                None,
                current_time,
            )

    # End Calendar part

    def get_audio_playing(self, socket=False):
        data = self.__audio_player.get_current_state()

        if socket:
            self.__send_message({"type": "player_indicator", "data": data})
        else:
            return data

    # End audio part

    # Environment part
    def get_environment(self, parameters=[], socket=False):
        filter = None
        if len(parameters) > 0 and parameters[0] is not None:
            filter = parameters[0]

        data = self.environment.get_data()

        if filter is not None and filter in data:
            data = {filter: data[filter]}

        if socket:
            self.__send_message({"type": "environment", "data": data})
        else:
            return {"environment": data}

    def get_environment_config(self):
        return self.environment.get_config()

    def set_environment_config(self, data):
        self.environment.load_environment(data)
        return self.config.save_environment(self.environment.get_config())

    # End Environment part

    # Profile part
    def get_profile_config(self):
        data = self.config.get_profile()
        if os.path.isfile("description.txt"):
            with open("description.txt", "r") as description_file:
                data["description"] = description_file.read()

        return data

    # Notifications part
    def get_notifications_config(self):
        return self.notification.get_config()

    def set_notifications(self, data):
        return self.notification.set_config(data)

    # End notifications part

    # System functions part
    def authenticate(self, username, password):
        return username == self.settings.get("username", None) and terrariumUtils.check_password(
            password, self.settings.get("password", None)
        )

    def send_websocket_totals(self, force=False, background=False):
        if not background:
            threading.Thread(target=self.send_websocket_totals, args=(force, True)).start()
        else:
            if force:
                # Only send relay changes first
                data = self.get_power_usage_water_flow(False, False)
                self.webserver.websocket_message("power_usage_water_flow", data)

            # Get all data, probably have to refresh cache
            data = self.get_power_usage_water_flow(force)
            self.webserver.websocket_message("power_usage_water_flow", data)

    def system_stats(self):
        start = time.time()
        storage = psutil.disk_usage("/")
        memory = psutil.virtual_memory()
        # Reading temperature through psutil results in a very high load in combination with gevent.... Just reading from disk is way faster.....
        # This is a Raspberry Pi ONLY solution
        cpu_temp = float(Path("/sys/class/thermal/thermal_zone0/temp").read_text().strip()) / 1000.0
        data = {
            "uptime": (datetime.datetime.now() - datetime.datetime.fromtimestamp(psutil.boot_time())).total_seconds(),
            "load": {
                "percentage": [round(x / psutil.cpu_count() * 100, 2) for x in psutil.getloadavg()],
                "absolute": [round(x, 2) for x in psutil.getloadavg()],
            },
            "cpu_temperature": cpu_temp,
            "memory": {"total": memory.total, "used": memory.total - memory.available, "free": memory.available},
            "storage": {"total": storage.total, "used": storage.used, "free": storage.free},
            "is_day": True if self.weather is None else self.weather.is_day,
        }
        logger.debug("Loaded system stats {} seconds.".format(time.time() - start))
        return data

    def get_power_usage_water_flow(self, force=False, totals=True):
        data = {
            "power": {
                "current": float(self.settings["pi_wattage"]),
                "max": float(self.settings["pi_wattage"]),
            },
            "flow": {
                "current": 0.0,
                "max": 0.0,
            },
        }

        if totals:
            total = self.total_power_and_water_usage(force)

            data["power"]["duration"] = total["duration"]
            # Total power is converted from watt/s in kWh
            data["power"]["total"] = total["total_watt"] / 3600.0 / 1000.0
            # Price is entered as cents per kWh
            data["power"]["costs"] = data["power"]["total"] * self.settings["power_price"]

            data["flow"]["duration"] = total["duration"]
            data["flow"]["total"] = total["total_flow"]
            # Total water costs is in L
            data["flow"]["costs"] = data["flow"]["total"] * self.settings["water_price"]

        with orm.db_session():
            for relay in Relay.select(
                lambda r: r.id in self.relays.keys() and not r.id in self.settings["exclude_ids"]
            ):
                data["power"]["current"] += relay.current_wattage
                data["power"]["max"] += relay.wattage

                data["flow"]["current"] += relay.current_flow
                data["flow"]["max"] += relay.flow

        return data

    def total_power_and_water_usage(self, force=False, background=False, thread_return=None):
        cacheKey = "total_power_water"
        totals = self.__engine["cache"].get_data(cacheKey, max_age=60 if force else None)

        if not background:

            if totals is None or force:
                new_data = [None]
                totals_thread = threading.Thread(target=self.total_power_and_water_usage, args=(force, True, new_data))

                if self.__engine["cache"].set_running(cacheKey):
                    # Give other relays some time to toggle
                    sleep(1)
                    totals_thread.start()

                    if totals is None:
                        totals_thread.join()
                        totals = new_data[0]

                elif totals is None:
                    # Thread is already running, but we have no data... we have to wait ...
                    while totals is None:
                        sleep(1)
                        totals = self.__engine["cache"].get_data(cacheKey, max_age=60 if force else None)

        else:
            # We are using total() vs sum() as total() will always return a number. https://sqlite.org/lang_aggfunc.html#sumunc
            with orm.db_session():
                data = db.select(
                    """SELECT
                        TOTAL(total_wattage) AS wattage,
                        TOTAL(total_flow)    AS flow,
                        IFNULL((JulianDay(MAX(off)) - JulianDay(MIN(`on`))) * 24 * 60 * 60,0) AS duration
                        FROM (
                            SELECT
                            RH1.relay     as relay,
                            RH1.timestamp as `on`,
                            RH2.timestamp as off,
                            (JulianDay(RH2.timestamp)-JulianDay(RH1.timestamp))   * 24 * 60 * 60                        AS duration_in_seconds,
                            ((JulianDay(RH2.timestamp)-JulianDay(RH1.timestamp))  * 24 * 60 * 60)         * RH1.wattage AS total_wattage,
                            (((JulianDay(RH2.timestamp)-JulianDay(RH1.timestamp)) * 24 * 60 * 60) / 60.0) * RH1.flow    AS total_flow
                            FROM RelayHistory AS RH1
                            LEFT JOIN RelayHistory AS RH2
                                ON RH2.relay = RH1.relay
                                AND RH2.timestamp = (SELECT MIN(timestamp) FROM RelayHistory WHERE timestamp > RH1.timestamp AND relay = RH1.relay)
                            WHERE RH1.value > 0
                        )"""
                )

                totals = {"total_watt": data[0][0], "total_flow": data[0][1], "duration": data[0][2]}
                thread_return[0] = totals
                self.__engine["cache"].set_data(cacheKey, totals, 3600)
                self.__engine["cache"].clear_running(cacheKey)

        return totals