Exemple #1
0
def postnote():
    """Add user note to db"""
    # try to get record matching pet apiid, request contains data sent with POST
    query_resp = Pet.query.filter(Pet.api_id == request.json["apiid"]).first()

    # if entry does not exist then query_resp = None, create / add record to db
    if query_resp is None:
        query_resp = Pet(
            username=session["username"],
            peteval=request.json["note"],
            api_id=request.json["apiid"],
        )
    else:
        # if entry exists in db, make changes to peteval
        query_resp.peteval = request.json["note"]

    # add new record -or- update existing record
    db.session.add(query_resp)
    db.session.commit()

    # return 204 NO CONTENT
    return "", 204