def update(id):
fetched_id = employees.fetch_user_id(id)
if fetched_id != None:
firstname = request.json['firstname']
lastname = request.json['lastname']
age = request.json['age']
skills = request.json['skills']
emp_address = request.json["address"]
emp_list = [firstname, lastname, age]
skill_obj = filter_skill_id(id)
address_obj = filter_address_id(id)
address_skill = filter_address_skill_id(id)
if emp_address == "":
fetched_id.firstname = firstname
fetched_id.lastname = lastname
fetched_id.age = age
skill_obj.tech = skills
updated_user = {
"firstname": firstname,
"lastname": lastname,
"age": age,
"skills": skills
}
return updated_user
elif skills == "":
fetched_id.firstname = firstname
fetched_id.lastname = lastname
fetched_id.age = age
fetched_id.emp_address = emp_address
updated_user = {
"firstname": firstname,
"lastname": lastname,
"age": age,
"address": emp_address
}
return updated_user
else:
fetched_id.firstname = firstname
fetched_id.lastname = lastname
fetched_id.age = age
skill_obj.tech = skills
fetched_id.emp_address = emp_address
updated_user = {
"firstname": firstname,
"lastname": lastname,
"age": age,
"skills": skills,
"address": emp_address
}
return updated_user
session.commit()
def get_user_address(emp_id, emp_address):
user_address = Address(emp_id=emp_id, emp_address=emp_address)
# return user_skill
session.add(user_address)
session.commit()
def get_user_skill(emp_id, tech1):
user_skill = Skills(emp_id=emp_id, tech=tech1)
# return user_skill
session.add(user_skill)
session.commit()
def get_user_details(firstname, lastname, age):
abc = Employee(firstname=firstname, lastname=lastname, age=age)
# return abc
session.add(abc)
session.commit()
def get_skill_address_data(emp_id, emp_address, tech1):
skill_address_data = Address_emp_id(emp_id=emp_id, emp_address=emp_address, tech=tech1)
session.add(skill_address_data)
session.commit()