async def add_team_member(ack, say, command, logger):
try:
team_member_id = get_user_id(command["text"])
duplicate = Employee.query.filter(
Employee.slack_id == team_member_id).all()
if not duplicate:
url = f"{slack_api}/users.profile.get?token={slack_token}&user={team_member_id}"
response = requests.get(url)
team_member_profile = response.json()
new_uifw_team_member = Employee(
team_member_id,
team_member_profile["profile"]["real_name"],
team_member_profile["profile"]["image_original"],
team_member_profile["profile"]["title"],
)
new_uifw_team_member.insert()
slackbot_response = f"{team_member_profile['profile']['real_name']} has been added to UIFW"
else:
if len(duplicate) > 1:
name = duplicate[0].name
else:
name = duplicate.name
slackbot_response = f"{name} is already a member of UIFW"
# Acknowledge command request
await ack()
await say(slackbot_response)
except Exception as e:
logger.error(f"Error adding team member: {e}")
def load_values():
conn = mysql.connect()
cursor = conn.cursor()
print('\n\nINITIALIZING DB\n\n')
query1 = """
INSERT INTO department_lookup (token, department)
VALUES (%s,%s)"""
for i, dept in enumerate(client.departments):
cursor.execute(query1, (dept.token, client.DEPARTMENT_LIST[i]))
print(dept.token + client.DEPARTMENT_LIST[i] + ' has been inserted.',
file=stderr)
emp = Employee(cursor, conn, immediate_commit=False)
for e in client.employees:
emp.insert(e.token, e.first_name, e.last_name, e.parent_token)
print(e.token + 'h has been inserted.', file=stderr)
desc = "My primary role is managing different banking sectors involved in asset management, sanctioning loans, " \
"mortgages, investments, and account operations. I oversee the efficient day to day processes as well as " \
"preparing forecasts and reports to drive the overall success of our clients and the department. "
man = Manager(cursor, conn, immediate_commit=False)
for dept in client.DEPARTMENT_LIST:
man.insert(client.MANAGERS[dept]['email'],
client.MANAGERS[dept]['pass'],
client.MANAGERS[dept]['first_name'],
client.MANAGERS[dept]['last_name'], 'Sr. Division Manager',
desc, client.MANAGERS[dept]['manager_dept_FK'],
client.MANAGERS[dept]['gender'])
trans = Transaction(cursor, conn, immediate_commit=False)
for t in client.transactions:
if t.recipient_user_token is None:
trans.insert(
t.sender_business_token,
t.recipient_business_token,
Transaction.current_time(t.created_time),
t.amount,
)
else:
trans.insert(
t.sender_business_token,
t.recipient_user_token,
Transaction.current_time(t.created_time),
t.amount,
)
conn.commit()
conn.close()
simulate_startup()
session['db_init'] = True
create_background_scheduler()
def create_form_submission():
form = CreateForm(request.form)
try:
e_id = request.form['e_id']
if Employee.query.get(e_id) is not None:
flash('Employee with ' + str(e_id) + ' aready exists.')
elif int(request.form['hourly_rate']) < 0:
flash('Hourly Rate has to be greater than 0')
else:
name = request.form['name']
hourly_rate = request.form['hourly_rate']
new_employee = Employee(e_id, name, hourly_rate)
Employee.insert(new_employee)
flash('Employee ' + name + ' was successfully added!')
except Exception as e:
print(e)
return redirect(url_for('create_form'))
