MyEMS / myems

        resp.status = falcon.HTTP_200

        _ = id_

    @staticmethod

    def on_get(req, resp, id_):

        """Handles GET requests"""

        if 'API-KEY' not in req.headers or \

                not isinstance(req.headers['API-KEY'], str) or \

                len(str.strip(req.headers['API-KEY'])) == 0:

            access_control(req)

        else:

            api_key_control(req)

        if not id_.isdigit() or int(id_) <= 0:

            raise falcon.HTTPError(status=falcon.HTTP_400, title='API.BAD_REQUEST',

                                   description='API.INVALID_CONTROL_MODE_ID')

        cnx = mysql.connector.connect(**config.myems_system_db)

        cursor = cnx.cursor()

        query = (" SELECT id, name, uuid, is_active "

                 " FROM tbl_control_modes "

                 " WHERE id = %s ")

        cursor.execute(query, (id_,))

        row = cursor.fetchone()

        if row is None:

            cursor.close()

            cnx.close()

            raise falcon.HTTPError(status=falcon.HTTP_404, title='API.NOT_FOUND',

                                   description='API.CONTROL_MODE_NOT_FOUND')

        result = {"id": row[0], "name": row[1], "uuid": row[2], "is_active": bool(row[3]), 'times': list()}

        query = (" SELECT start_time_of_day, end_time_of_day, power_value "

                 " FROM tbl_control_modes_times "

                 " WHERE control_mode_id = %s  "

                 " ORDER BY id")

        cursor.execute(query, (result['id'],))

        rows_times = cursor.fetchall()

        if rows_times is not None and len(rows_times) > 0:

            for row_time in rows_times:

                start_time_of_day = str(row_time[0])

                parts = start_time_of_day.split(':')

                hour = parts[0].zfill(2)

                minute = parts[1].zfill(2) if len(parts) > 1 else '00'

                second = parts[2].zfill(2) if len(parts) > 2 else '00'

                start_time_of_day = f"{hour}:{minute}:{second}"

                end_time_of_day = str(row_time[1])

                parts = end_time_of_day.split(':')

                hour = parts[0].zfill(2)

                minute = parts[1].zfill(2) if len(parts) > 1 else '00'

                second = parts[2].zfill(2) if len(parts) > 2 else '00'

                end_time_of_day = f"{hour}:{minute}:{second}"

                meta_data = {"start_time_of_day": start_time_of_day,

                             "end_time_of_day": end_time_of_day,

                             "power_value": row_time[2]}

                result['times'].append(meta_data)

        cursor.close()

        cnx.close()

        resp.text = json.dumps(result)

class ControlModeImport:

        resp.status = falcon.HTTP_200

        _ = id_

    @staticmethod

    def on_get(req, resp, id_):

        """Handles GET requests"""

        if 'API-KEY' not in req.headers or \

                not isinstance(req.headers['API-KEY'], str) or \

                len(str.strip(req.headers['API-KEY'])) == 0:

            access_control(req)

        else:

            api_key_control(req)

        if not id_.isdigit() or int(id_) <= 0:

            raise falcon.HTTPError(status=falcon.HTTP_400, title='API.BAD_REQUEST',

                                   description='API.INVALID_CONTROL_MODE_ID')

        cnx = mysql.connector.connect(**config.myems_system_db)

        cursor = cnx.cursor()

        query = (" SELECT id, name, uuid, is_active "

                 " FROM tbl_control_modes "

                 " WHERE id = %s ")

        cursor.execute(query, (id_,))

        row = cursor.fetchone()

        if row is None:

            cursor.close()

            cnx.close()

            raise falcon.HTTPError(status=falcon.HTTP_404, title='API.NOT_FOUND',

                                   description='API.CONTROL_MODE_NOT_FOUND')

        result = {"id": row[0], "name": row[1], "uuid": row[2], "is_active": bool(row[3]), 'times': list()}

        query = (" SELECT start_time_of_day, end_time_of_day, power_value "

                 " FROM tbl_control_modes_times "

                 " WHERE control_mode_id = %s  "

                 " ORDER BY id ")

        cursor.execute(query, (result['id'],))

        rows_times = cursor.fetchall()

        if rows_times is not None and len(rows_times) > 0:

            for row_time in rows_times:

                start_time_of_day = str(row_time[0])

                parts = start_time_of_day.split(':')

                hour = parts[0].zfill(2)

                minute = parts[1].zfill(2) if len(parts) > 1 else '00'

                second = parts[2].zfill(2) if len(parts) > 2 else '00'

                start_time_of_day = f"{hour}:{minute}:{second}"

                end_time_of_day = str(row_time[1])

                parts = end_time_of_day.split(':')

                hour = parts[0].zfill(2)

                minute = parts[1].zfill(2) if len(parts) > 1 else '00'

                second = parts[2].zfill(2) if len(parts) > 2 else '00'

                end_time_of_day = f"{hour}:{minute}:{second}"

                meta_data = {"start_time_of_day": start_time_of_day,

                             "end_time_of_day": end_time_of_day,

                             "power_value": row_time[2]}

                result['times'].append(meta_data)

        cursor.close()

        cnx.close()

        resp.text = json.dumps(result)

    @staticmethod

    @user_logger