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 get_tours(start_date, end_date):
"""
Return a list of tuple.
Tuple contains a name and number of registered member. The return list is ordered.
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_id_list_of_tours_by_date(
start_date, end_date)
d = dict()
for name, id in list_of_tours:
d[id] = RegistrationDAO.get_registration_count_by_tour_id(id)
return_list = []
for name, id in list_of_tours:
return_list.append((name, d[id]))
return_list = sorted(return_list,
key=StatisticDAO.get_key,
reverse=True)
return return_list
def get_tours(start_date, end_date):
"""
Return a list of tuple.
Tuple contains a name and number of registered member. The return list is ordered.
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_id_list_of_tours_by_date(start_date, end_date)
d = dict()
for name, id in list_of_tours:
d[id] = RegistrationDAO.get_registration_count_by_tour_id(id)
return_list = []
for name, id in list_of_tours:
return_list.append((name, d[id]))
return_list = sorted(return_list, key=StatisticDAO.get_key, reverse=True)
return return_list
def test_setPrice(self):
t = Tour("ABC", 3, 2)
t.id = 1
t.price = 3000
l = [t]
self.assertEquals(TourDAO.set_prices(l), True)
def test_delete_tour(self):
print(TourDAO.delete_tour(2))
self.assertEquals(True, True)
def test_delay_tour(self):
print(TourDAO.delay_tour(1, "2016-09-01 00:00", "2016-10-01 00:00"))
self.assertEquals(True, True)
def test_get_list_of_Tour(self):
l = TourDAO.get_id_list_of_tours_by_date("2015-12-01", "2016-04-01")
for x in l:
print(x)
self.assertEquals(True, True)
def test_setPrice(self):
t = Tour("ABC", 3, 2)
t.id = 1
t.price = 3000
l = [t]
self.assertEquals(TourDAO.set_prices(l), True)
def test_delete_tour(self):
print(TourDAO.delete_tour(2))
self.assertEquals(True, True)
def test_delay_tour(self):
print(TourDAO.delay_tour(1, "2016-09-01 00:00", "2016-10-01 00:00"))
self.assertEquals(True, True)
def test_get_list_of_Tour(self):
l = TourDAO.get_id_list_of_tours_by_date("2015-12-01", "2016-04-01")
for x in l:
print(x)
self.assertEquals(True, True)