def test_close_registrations(self): system = EMS() user = system.get_user('4119998') seminar = (1,0,'Test Seminar',4119993,'Testing','2018-12-10 22:00:00','UNSW','2019-01-01 22:00:00','2019-01-30 22:00:00','2018-12-1 22:00:00',1,100,0) dbInserter.insert_Seminar(seminar) session1 = (1,'Hi','Tommy','Hi',50,0,1,0) dbInserter.insert_Session(session1) session2 = (2,'Bye','Tommy','Bye',50,0,1,0) dbInserter.insert_Session(session2) test_sess = system.get_event('Session', 1) with pytest.raises(Exception) as e_info: updated = system.update_attendees('register', test_sess, 'Session', user.email) test_sess = system.get_event('Session',1) self.assertEqual(test_sess.noAttendees, 0) session_list = dbHandler.select_all_products("Session") self.assertEqual(session_list[0], session1)
def test_full_register_seminar(self): system = EMS() user = system.get_user('6119988') seminar = (1,1,'Test Seminar',4119993,'Testing','2018-12-10 22:00:00','UNSW','2019-01-01 22:00:00','2019-01-30 22:00:00','2018-12-1 22:00:00',1,100,100) dbInserter.insert_Seminar(seminar) session1 = (1,'Hi','Tommy','Hi',50,50,1,1) dbInserter.insert_Session(session1) session2 = (2,'Bye','Tommy','Bye',50,50,1,1) dbInserter.insert_Session(session2) test_sess = system.get_event('Session', 1) self.assertTrue(system.update_attendees('register', test_sess, 'Session', user.email) == 0) test_sess = system.get_event('Session',1) self.assertEqual(test_sess.noAttendees, 50) session1 = (1,'Hi','Tommy','Hi',50,50,1,1) session_list = dbHandler.select_all_products("Session") self.assertEqual(session_list[0], session1) seminar_registration = dbHandler.select_products("User_Seminar", "Email", "*****@*****.**") self.assertTrue(seminar_registration == []) session_registration = dbHandler.select_products("User_Session", "Email", "*****@*****.**") self.assertTrue(session_registration == [])
def test_active_register_seminar(self): system = EMS() user = system.get_user('6119988') date_format = "%Y-%m-%d %H:%M:%S" yesterday = str(datetime.strftime(datetime.now() - timedelta(1), date_format)) tomorrow = str(datetime.strftime(datetime.now() + timedelta(1), date_format)) seminar = (1,1,'Test Seminar',4119993,'Testing','2018-12-10 22:00:00','UNSW',yesterday,tomorrow,'2018-12-1 22:00:00',1,100,0) dbInserter.insert_Seminar(seminar) session = (1,'Hi','Tommy','Hi',50,0,1,1) dbInserter.insert_Session(session) session = (2,'Bye','Tommy','Bye',50,0,1,1) dbInserter.insert_Session(session) test_sess = system.get_event('Session', 1) with pytest.raises(Exception) as e_info: updated = system.update_attendees('register', test_sess, 'Session', user.email) seminar_registration = dbHandler.select_all_products("User_Seminar") self.assertEqual(seminar_registration, []) session_registration = dbHandler.select_all_products("User_Session") self.assertEqual(session_registration, [])