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)
