def reactivate_homegroup(homegroup_id): rowcount = db.reactivate_homegroup(homegroup_id) print(db.find_homegroup(homegroup_id)[6]) # if the member is not active if db.find_homegroup(homegroup_id)[6] == 0: flash("Homegroup Reactivated!") return redirect(url_for('get_homegroups'))
def deactivate_homegroup(homegroup_id): rowcount = db.deactivate_homegroup(homegroup_id) # if the member is not active if not db.find_homegroup(homegroup_id)['is_active']: flash("Homegroup Deactivated!") return redirect(url_for('get_homegroups'))
def get_homegroup_members(homegroup_id): current_homegroup = db.find_homegroup(homegroup_id) homegroup_members = db.get_homegroup_members(homegroup_id) list = [] for member in homegroup_members: list.append(member["email"]) list2 = "" for item in list: list2 = list2 + ", " + item return render_template('homegroup_members.html', homegroup=db.get_homegroup_members(homegroup_id), currentHomegroup=current_homegroup, homegroupEmails=db.get_homegroup_emails(homegroup_id), emails=list2)
def test_add_homegroup(self): """Make sure we can add a new homegroup""" row_count = db.create_homegroup('Test HomeGroup', 'Test Location', 'Test Description', None, None) self.assertEqual(row_count, 1) homegroup_id = db.recent_homegroup()['id'] test_hg = db.find_homegroup(homegroup_id) self.assertIsNotNone(test_hg) self.assertEqual(test_hg['Name'], 'Test HomeGroup') self.assertEqual(test_hg['Location'], 'Test Location') self.assertEqual(test_hg['Description'], 'Test Description')
def test_edit_homegroup(self): """Make sure we can edit a homegroup""" row_count = db.create_homegroup('Fake', 'Fake Location', 'Fake Description', None, None) homegroup_id = db.recent_homegroup()['id'] row_count = db.edit_homegroup(homegroup_id, 'Test HomeGroup', 'Test Location', 'Test Description', None, None) test_hg = db.find_homegroup(homegroup_id) self.assertIsNotNone(test_hg) self.assertEqual(test_hg['Name'], 'Test HomeGroup') self.assertEqual(test_hg['Location'], 'Test Location') self.assertEqual(test_hg['Description'], 'Test Description')
def edit_homegroup(homegroup_id): row = db.find_homegroup(homegroup_id) hg_form = CreateHomeGroupForm(name=row['name'], description=row['description'], location=row['location'], latitude=row['latitude'], longitude=row['longitude']) if request.method == "POST" and hg_form.validate(): name = hg_form.name.data description = hg_form.description.data location = hg_form.location.data latitude = hg_form.latitude.data longitude = hg_form.longitude.data print(latitude) print(longitude) rowcount = db.edit_homegroup(homegroup_id, name, location, description, latitude, longitude) if (rowcount == 1): flash("Home Group updated!") if (current_user.role == 'admin'): return redirect(url_for('get_homegroups')) return redirect(url_for('homegroup', homegroup_id=homegroup_id)) return render_template('edit_homegroup.html', form=hg_form)
def view_attendance(homegroup_id): homegroup = db.find_homegroup(homegroup_id) attendance_count = db.get_homegroup_attendance_counts(homegroup_id) return render_template('view_attendance.html', currentHomegroup=homegroup, attendance_count=attendance_count, myHomegroup=homegroup_id, records=db.get_attendance_dates(homegroup_id))
def homegroup(homegroup_id): homegroup = db.find_homegroup(homegroup_id) attendance_count = db.get_homegroup_attendance_counts(homegroup_id) return render_template('homegroup.html', currentHomegroup=homegroup, attendance_count=attendance_count)