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'))