MyEMS / myems

        resp.location = '/virtualpowerplants/' + str(new_id)

class VirtualPowerPlantClone:

    def __init__(self):

        pass

    @staticmethod

    def on_options(req, resp, id_):

        _ = req

        resp.status = falcon.HTTP_200

        _ = id_

    @staticmethod

    @user_logger

    def on_post(req, resp, id_):

        admin_control(req)

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

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

                                   description='API.INVALID_VIRTUAL_POWER_PLANT_ID')

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

        cursor = cnx.cursor()

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

                 "        cost_center_id, balancing_price_point_id, svg_id, description "

                 " FROM tbl_virtual_power_plants "

                 " WHERE id = %s ")

        cursor.execute(query, (id_,))

        row = cursor.fetchone()

        if row is None:

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

                                   description='API.VIRTUAL_POWER_PLANT_NOT_FOUND')

        else:

            meta_result = {"id": row[0],

                           "name": row[1],

                           "uuid": row[2],

                           "cost_center_id": row[3],

                           "balancing_price_point_id": row[4],

                           "svg_id": row[5],

                           "description": row[6]}

            timezone_offset = int(config.utc_offset[1:3]) * 60 + int(config.utc_offset[4:6])

            if config.utc_offset[0] == '-':

                timezone_offset = -timezone_offset

            new_name = (str.strip(meta_result['name']) +

                        (datetime.utcnow() + timedelta(minutes=timezone_offset)).isoformat(sep='-', timespec='seconds'))

            add_values = (" INSERT INTO tbl_virtual_power_plants "

                          "    (name, uuid, cost_center_id, balancing_price_point_id, svg_id, description) "

                          " VALUES (%s, %s, %s, %s, %s, %s) ")

            cursor.execute(add_values, (new_name,

                                        str(uuid.uuid4()),

                                        meta_result['cost_center_id'],

                                        meta_result['balancing_price_point_id'],

                                        meta_result['svg_id'],

                                        meta_result['description']))

            new_id = cursor.lastrowid

            cnx.commit()

            cursor.close()

            cnx.close()

            resp.status = falcon.HTTP_201

            resp.location = '/virtualpowerplants/' + str(new_id)

        resp.status = falcon.HTTP_204

class EnergyStorageContainerClone:

    def __init__(self):

        pass

    @staticmethod

    def on_options(req, resp, id_):

        _ = req

        resp.status = falcon.HTTP_200

        _ = id_

    @staticmethod

    @user_logger

    def on_post(req, resp, id_):

        """Handles POST requests"""

        admin_control(req)

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

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

                                   description='API.INVALID_ENERGY_STORAGE_CONTAINER_ID')

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

        cursor = cnx.cursor()

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

                 "        rated_capacity, rated_power, contact_id, cost_center_id, description "

                 " FROM tbl_energy_storage_containers "

                 " WHERE id = %s ")

        cursor.execute(query, (id_,))

        row = cursor.fetchone()

        if row is None:

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

                                   description='API.ENERGY_STORAGE_CONTAINER_NOT_FOUND')

        else:

            meta_result = {"id": row[0],

                           "name": row[1],

                           "uuid": row[2],

                           "rated_capacity": row[3],

                           "rated_power": row[4],

                           "contact_id": row[5],

                           "cost_center_id": row[6],

                           "description": row[7]}

            timezone_offset = int(config.utc_offset[1:3]) * 60 + int(config.utc_offset[4:6])

            if config.utc_offset[0] == '-':

                timezone_offset = -timezone_offset

            new_name = str.strip(meta_result['name']) + \

                (datetime.utcnow() + timedelta(minutes=timezone_offset)).isoformat(sep='-', timespec='seconds')

            add_values = (" INSERT INTO tbl_energy_storage_containers "

                          "    (name, uuid, rated_capacity, rated_power, contact_id, "

                          "     cost_center_id, description) "

                          " VALUES (%s, %s, %s, %s, %s, %s, %s) ")

            cursor.execute(add_values, (new_name,

                                        str(uuid.uuid4()),

                                        meta_result['rated_capacity'],

                                        meta_result['rated_power'],

                                        meta_result['contact_id'],

                                        meta_result['cost_center_id'],

                                        meta_result['description']))

            new_id = cursor.lastrowid

            cnx.commit()

            cursor.close()

            cnx.close()

            resp.status = falcon.HTTP_201

            resp.location = '/energystoragecontainers/' + str(new_id)

class EnergyStorageContainerExport:

    def __init__(self):