core.controlmode.ControlModeExport.on_get()

Complexity

Conditions

14

Size

Total Lines	60
Code Lines	45

Duplication

Lines	60
Ratio	100 %

Importance

Changes

0

import uuid
    @staticmethod

This code seems to be duplicated in your project.

    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)