def test_update_src(self):
filename = "kep.jpg"
from werkzeug.datastructures import FileStorage
image = FileStorage(filename=filename)
UserDAO.update_avatar("test", image)
usr = UserDAO.get_user_with_name("test")
self.assertEquals(usr.avatar_src, filename)
def test_update_src(self):
filename = "kep.jpg"
from werkzeug.datastructures import FileStorage
image = FileStorage(filename=filename)
UserDAO.update_avatar("test", image)
usr = UserDAO.get_user_with_name("test")
self.assertEquals(usr.avatar_src, filename)
def get_static_from_tour_guide_popularity(start_date, end_date):
"""
Return an descending ordered list from tourguide's tours popularity between dates.
You can find an example to call this method in testdatabase.py file.
:param start_date: String that represent a date like this: "2015-09-01"
:param end_date: same as start_date
:return:
"""
list_of_tours = TourDAO.get_list_of_tours_between_dates(
start_date, end_date)
d = dict()
for tour in list_of_tours:
if tour.tour_guide_id in d:
d[tour.
tour_guide_id] += RegistrationDAO.get_registration_count_by_tour_id(
tour.id)
else:
d[tour.
tour_guide_id] = RegistrationDAO.get_registration_count_by_tour_id(
tour.id)
return_list = []
for key, value in d.items():
return_list.append((UserDAO.get_user_by_id(key).fullname, value))
return_list = sorted(return_list,
key=StatisticDAO.get_key,
reverse=True)
return return_list
def get_static_from_tour_guide_popularity(start_date, end_date):
"""
Return an descending ordered list from tourguide's tours popularity between dates.
You can find an example to call this method in testdatabase.py file.
:param start_date: String that represent a date like this: "2015-09-01"
:param end_date: same as start_date
:return:
"""
list_of_tours = TourDAO.get_list_of_tours_between_dates(start_date, end_date)
d = dict()
for tour in list_of_tours:
if tour.tour_guide_id in d:
d[tour.tour_guide_id] += RegistrationDAO.get_registration_count_by_tour_id(tour.id)
else:
d[tour.tour_guide_id] = RegistrationDAO.get_registration_count_by_tour_id(tour.id)
return_list = []
for key, value in d.items():
return_list.append((UserDAO.get_user_by_id(key).fullname, value))
return_list = sorted(return_list, key=StatisticDAO.get_key, reverse=True)
return return_list
def test_update_experience_by_user(self):
UserDAO.update_experience("test", 4)
usr = UserDAO.get_user_with_name("test")
self.assertEquals(usr.experience_id, 4)
def test_update_email(self):
UserDAO.update_email("test", "*****@*****.**")
usr = UserDAO.get_user_with_name("test")
self.assertEquals(usr.email, "*****@*****.**")
def test_update_pwd(self):
print(UserDAO.update_pwd("test", "test1", "test1"))
usr = UserDAO.get_user_with_name("test")
self.assertEquals(True, check_password_hash(usr.password, "test1"))
def test_get_users_by_role(self):
print(UserDAO.get_user_by_role("Turavezeto"))
self.assertEquals(True, True)
def test_update_experience_by_user(self):
UserDAO.update_experience("test", 4)
usr = UserDAO.get_user_with_name("test")
self.assertEquals(usr.experience_id, 4)
def test_update_email(self):
UserDAO.update_email("test", "*****@*****.**")
usr = UserDAO.get_user_with_name("test")
self.assertEquals(usr.email, "*****@*****.**")
def test_update_pwd(self):
print(UserDAO.update_pwd("test", "test1", "test1"))
usr = UserDAO.get_user_with_name("test")
self.assertEquals(True, check_password_hash(usr.password, "test1"))
def test_get_users_by_role(self):
print(UserDAO.get_user_by_role("Turavezeto"))
self.assertEquals(True, True)
