def delete(): if request.method == 'POST': data = request.get_json() record = Person.query.filter(Person.id == data["id"]).first() if record: db_session.delete(record) db_session.commit() return json.dumps({"status": "OK"}) return "Nothing here!"
def create(): if request.method == 'POST': data = request.get_json() first_name = data["first_name"] last_name = data["last_name"] dob = datetime.datetime.strptime(data["dob"], "%Y-%m-%d").date() zip_code = data["zip_code"] print first_name, last_name, dob, zip_code person = Person(first_name, last_name, dob, zip_code) db_session.add(person) db_session.commit() return json.dumps({"status": "OK"}) return "Nothing here!"
def update(): if request.method == 'POST': data = request.get_json() # the incoming dictionary contains the fields: id, field, value # id: row ID for the database entry we're editing # field: field in the record we're interested in updating # value: the new value to assign to the field record = Person.query.filter(Person.id == data["id"]).first() if record: # in the case of the date of birth field, we must first # convert to a Python date object if data["field"] == "dob": data["value"] = datetime.datetime.strptime(data["value"], "%Y-%m-%d").date() setattr(record, data["field"], data["value"]) db_session.commit() return "Nothing here!"