def add_members(): name = request.get_json(force=True)['name'] bio = request.get_json(force=True)['bio'] member = Member() member.name = name member.bio = bio db.session.add(member) db.session.commit() return jsonify("OK")
def add_members(mmbr_req: MemberRequest, db: Session = Depends(get_db)): """ Adds new Member to database via API. Email must be unique """ mmbr = Member() # personal mmbr.full_name = mmbr_req.full_name mmbr.nick_name = mmbr_req.nick_name mmbr.cur_status = mmbr_req.cur_status mmbr.cur_city = mmbr_req.cur_city mmbr.bio = mmbr_req.bio mmbr.communities = mmbr_req.communities # social mmbr.twitter_url = mmbr_req.twitter_url mmbr.github_url = mmbr_req.github_url mmbr.linkedin_url = mmbr_req.linkedin_url mmbr.whatsapp_num = mmbr_req.whatsapp_num mmbr.email = mmbr_req.email # skill mmbr.dom_1 = mmbr_req.dom_1 mmbr.dom_2 = mmbr_req.dom_2 mmbr.dom_3 = mmbr_req.dom_3 mmbr.dom_4 = mmbr_req.dom_4 mmbr.dom_5 = mmbr_req.dom_5 mmbr.dom_5 = mmbr_req.dom_5 mmbr.dom_6 = mmbr_req.dom_6 mmbr.dom_7 = mmbr_req.dom_7 mmbr.dom_8 = mmbr_req.dom_8 mmbr.dom_1skill = mmbr_req.dom_1skill mmbr.dom_1interest = mmbr_req.dom_1interest mmbr.dom_2skill = mmbr_req.dom_2skill mmbr.dom_2interest = mmbr_req.dom_2interest mmbr.dom_3skill = mmbr_req.dom_3skill mmbr.dom_3interest = mmbr_req.dom_3interest mmbr.dom_4skill = mmbr_req.dom_4skill mmbr.dom_4interest = mmbr_req.dom_4interest mmbr.dom_5skill = mmbr_req.dom_5skill mmbr.dom_5interest = mmbr_req.dom_5interest mmbr.dom_6skill = mmbr_req.dom_6skill mmbr.dom_6interest = mmbr_req.dom_6interest mmbr.dom_7skill = mmbr_req.dom_7skill mmbr.dom_7interest = mmbr_req.dom_7interest mmbr.dom_8skill = mmbr_req.dom_8skill mmbr.dom_8interest = mmbr_req.dom_8interest mmbr.secret_key = mmbr_req.secret_key dberror = None try: db.add(mmbr) db.commit() except Exception as e: dberror = e # todo: catch sql integrity error: unique mail return {"status": "success/failed", "dberror": dberror}