0

I am trying to do post request for below schema using flask-mongoAlchemy

class Sensors(db.Document):
    sensorName = db.StringField()
    sensorStatus = db.StringField()


class Camera(db.Document):
    cameraName = db.StringField()
    cameraStatus = db.StringField()

class Checkpoints(db.Document):
    checkPointName = db.StringField()

class Gateway(db.Document):
    sensors = db.ListField(db.DocumentField(Sensors), db_field='sensors')
    camera = db.ListField(db.DocumentField(Camera), db_field='camera')
    checkpoints = db.ListField(db.DocumentField(Checkpoints), db_field='checkpoints')

In the schema Gateway class contains the list of other three classes

Tried doing as shown below

@gateway_bp.route('/gateway',methods=['POST'])
def object_book():
    request_data = request.get_json()

    sensorsList=[]
    cameraList=[]
    checkList=[]

    for sensorObj in request_data['GateWay1']['sensors']:
        sensorsList.append(Sensors(sensorName=sensorObj['sensorName'],sensorStatus=sensorObj['sensorStatus']))
        gatewayObj=Gateway(sensors=sensorsList)

    for cameraObj in request_data['GateWay1']['camera']:
        cameraList.append(Camera(cameraName=cameraObj['cameraName'],cameraStatus=cameraObj['cameraStatus']))
        gatewayObj=Gateway(camera=cameraList)


    for checkListObj in request_data['GateWay1']['checkpoints']:
        checkList.append(Checkpoints(checkPointName=checkListObj['checkPointName']))
        gatewayObj=Gateway(checkpoints=checkList)

        gatewayObj.save()
        return 'Saved :)'

getting the error has

mongoalchemy.exceptions.MissingValueException

MissingValueException: sensors

sample payload

{

    "GateWay1": {
        "sensors": [{
            "sensorName": "s1",
            "sensorStatus": "green "
        }, {
            "sensorName": "s2",
            "sensorStatus": "red "
        }],
        "camera": [{
            "cameraName": "cam1",
            "cameraStatus": "live"
        }, {
            "cameraName": "cam2",
            "cameraStatus": "live"
        }],
        "checkpoints": [{
            "checkPointName": "chk1"
        }, {
            "checkPointName": "chk2"
        }]


    }


}

please help in saving the above json in mongodb using mongoAlchemy ,please point some sample repo where i can know more about flask-mongoAlchemy

dhana lakshmi
  • 847
  • 1
  • 12
  • 29

0 Answers0