def deactivate_member(member_id): rowcount = db.deactivate_member(member_id) print(db.find_member(member_id)['is_active']) # if the member is not active if db.find_member(member_id)['is_active'] == '0': flash("Member Deactivated!") return redirect(url_for('all_members'))
def reactivate_member(member_id): rowcount = db.reactivate_member(member_id) print(db.find_member(member_id)[9]) # if the member is not active if db.find_member(member_id)[9] == 0: flash("Member Reactivated!") return redirect(url_for('all_members'))
def test_edit_member(self): """Make sure we can edit an existing member.""" member_status = self.create_test_member() self.assertEqual(member_status['rowcount'], 1) member_id = member_status['id'] test_member = db.find_member(member_id) self.assertIsNotNone(test_member) test_member['first_name'] = 'Edited' test_member['email'] = '*****@*****.**' test_member['phone_number'] = '555-1234' test_member['join_date'] = '2017-03-24' row_count = db.edit_member(test_member) self.assertEqual(row_count, 1) self.bounce_db_connection() edited_member = db.find_member(member_id) self.assertIsNotNone(edited_member) self.assertEqual(edited_member['first_name'], 'Edited') self.assertEqual(edited_member['last_name'], 'Member') self.assertEqual(edited_member['email'], '*****@*****.**') self.assertEqual(edited_member['phone_number'], '555-1234') self.assertEqual(edited_member['gender'], 'F') self.assertEqual(edited_member['birthday'], '2001-12-25') self.assertEqual(edited_member['baptism_status'], True) self.assertEqual(edited_member['join_date'], '2017-03-24') self.assertEqual(edited_member['is_active'], True)
def test_add_member(self): """Make sure we can add a new member.""" row_count = db.create_member('*****@*****.**', 'FirstName', 'LastName', 'pass') self.assertEqual(row_count, 1) test_member = db.find_member('*****@*****.**') self.assertIsNotNone(test_member) self.assertEqual(test_member['first_name'], 'FirstName') self.assertEqual(test_member['last_name'], 'LastName')
def add_member_to_homegroup(homegroup_id, member_id): inactive_homegroup_members = db.get_homegroup_inactive_members(homegroup_id) new = 'Y' for members in inactive_homegroup_members: print(members['member_id']) if int (members['member_id']) == int(member_id): new = 'N' db.reactive_homegroup_member(homegroup_id, member_id) print(new) if new == 'Y': db.add_member_to_homegroup(homegroup_id, member_id) member = db.find_member(member_id) flash ("Member {} added to homegroup".format(member['first_name'] + " " + member['last_name'])) return redirect (url_for('get_homegroup_members', homegroup_id = homegroup_id))
def test_update_member(self): """Add and then update a member.""" row_count = db.create_member('*****@*****.**', 'FirstName', 'LastName', 'pass') self.assertEqual(row_count, 1) row_count = db.update_member('*****@*****.**', 'NewFirstName', 'LastName', 'newpass') self.assertEqual(row_count, 1) test_member = db.find_member('*****@*****.**') self.assertIsNotNone(test_member) self.assertEqual(test_member['first_name'], 'NewFirstName') self.assertEqual(test_member['last_name'], 'LastName')
def system_notify_member(member_id, num_misses): homegroup_id = db.find_member_homegroup(member_id)['homegroup_id'] leader = db.find_homegroup_leader(homegroup_id) email = db.find_member(member_id)['email'] email_list = [] email_list.append(email) leader_email = leader['email'] leader_phone = leader['phone_number'] leader_name = leader['first_name'] + ' ' + leader['last_name'] email_html = render_template('notify_member_email.html', num_misses = num_misses, leader_name = leader_name, leader_phone = leader_phone, leader_email = leader_email ) msg = Message( 'System Reminder: Missing meetings', sender='*****@*****.**', recipients=email_list, html=email_html) mail.send(msg)
def test_add_member(self): """Make sure we can add a new member.""" member_status = self.create_test_member() self.assertEqual(member_status['rowcount'], 1) self.bounce_db_connection() test_member = db.find_member(member_status['id']) self.assertIsNotNone(test_member) self.assertEqual(test_member['first_name'], 'New') self.assertEqual(test_member['last_name'], 'Member') self.assertEqual(test_member['email'], '*****@*****.**') self.assertEqual(test_member['phone_number'], '555-1212') self.assertEqual(test_member['gender'], 'F') self.assertEqual(test_member['birthday'], '2001-12-25') self.assertEqual(test_member['baptism_status'], True) self.assertEqual(test_member['join_date'], '2018-03-24')
def test_add_member(self): """Make sure we can add a new user""" row_count = db.create_member("Ryley", "Hoekert", "*****@*****.**", "7192009832", "Female", "Never", 1, 0, "9/12/16") self.assertEqual(row_count, 1) member_id = db.recent_member()['id'] test_hg = db.find_member(member_id) self.assertIsNotNone(test_hg) self.assertEqual(test_hg['first_name'], 'Ryley') self.assertEqual(test_hg['last_name'], 'Hoekert') self.assertEqual(test_hg['email'], '*****@*****.**') self.assertEqual(test_hg['phone_number'], '7192009832') self.assertEqual(test_hg['gender'], 'Female') self.assertEqual(test_hg['birthday'], 'Never') self.assertEqual(test_hg['baptism_status'], 1) self.assertEqual(test_hg['join_date'], '9/12/16')
def test_edit_member(self): """Make sure we can edit a homegroup""" row_count = db.create_member("Seth", "Gerald", "*****@*****.**", "922", "Male", "Christmas", 0, 0, "2/3/09") member_id = db.recent_member()['id'] row_count = db.edit_member(member_id, 'First', 'Last', '*****@*****.**', "2", "Male", "Easter", 1, 1, "2/3/09") test_hg = db.find_member(member_id) self.assertIsNotNone(test_hg) self.assertEqual(test_hg['first_name'], 'First') self.assertEqual(test_hg['last_name'], 'Last') self.assertEqual(test_hg['email'], '*****@*****.**') self.assertEqual(test_hg['phone_number'], '2') self.assertEqual(test_hg['gender'], 'Male') self.assertEqual(test_hg['birthday'], 'Easter') self.assertEqual(test_hg['baptism_status'], 1) self.assertEqual(test_hg['join_date'], '2/3/09')
def edit_member(member_id): if (int(current_user.member_id )== int(member_id)): heading_text = 'Edit My Info' else: heading_text = 'Edit Member' row = db.find_member(member_id) member_form = CreateMemberForm(first_name=row['first_name'], last_name=row['last_name'], email=row['email'], phone_number=row['phone_number'], gender=row['gender'], baptism_status=row['baptism_status'], marital_status=row['marital_status']) birthday_form = row['birthday'] join_date_form = row['join_date'] ## to do add validators back!!! and member_form.validate() if request.method == "POST" : first_name = member_form.first_name.data last_name = member_form.last_name.data email = member_form.email.data phone_number = member_form.phone_number.data gender = member_form.gender.data birthday = request.form['Birthday'] baptism_status = member_form.baptism_status.data marital_status = member_form.marital_status.data join_date = request.form['JoinDate'] rowcount = db.edit_member(member_id, first_name, last_name, email, phone_number, gender, birthday, baptism_status, marital_status, join_date) if (rowcount == 1): flash("Member {} Updated!".format(member_form.first_name.data)) if (current_user.role == 'admin'): return redirect(url_for('all_members')) else: homegroup_id = db.find_member_homegroup(member_id)['homegroup_id'] return redirect(url_for('get_homegroup_members', homegroup_id = homegroup_id)) return render_template('edit_member.html', heading_text = heading_text, form=member_form, bDay=birthday_form, joinDay=join_date_form)
def create_user(member_id): allRoles = db.find_roles() roleList = [] email_list = [] for role in allRoles: roleList.append((role["id"], role["role"])) member = db.find_member(member_id) email = member['email'] user_form = UserForm() user_form.role.choices = roleList homegroups = db.get_all_homegroups() homegroup_list = [] for homegroup in homegroups: homegroup_list.append((homegroup['id'], homegroup['name'])) user_form.homegroups.choices = homegroup_list if user_form.validate_on_submit(): email_list.append(email) password = user_form.password.data pw_hash = bcrypt.generate_password_hash(password).decode('utf-8') db.create_user(member_id, pw_hash, user_form.role.data) user = db.find_user(email) email_html = render_template('user_account_email.html', email=email, password=password, user_id=user['id']) msg = Message( 'User account created for Verbo Velocity', sender='*****@*****.**', recipients=email_list, html=email_html) mail.send(msg) if user_form.homegroups.data is not None: homegroupId = user_form.homegroups.data user_id = db.find_user(email)['id'] db.add_leader_to_homegroup(user_id, homegroupId) flash('User Created') return redirect(url_for('all_members')) return render_template('create_user.html', form=user_form, email = email)
def reactivate_member(member_id): rowcount = db.reactivate_member(member_id) if db.find_member(member_id)['is_active'] == '1': flash("Member Reactivated!") return redirect(url_for('all_members'))