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}
