def test_school_classcards_get_json(client, web2py): """ Are the class cards returned correctly? """ populate_api_users(web2py) populate_school_classcards(web2py, 2) url = base_url + '/api/school_classcards_get.json?user=test&key=test' page = urllib.urlopen(url).read() json = sj.loads(page) classcard = web2py.db.school_classcards(1) assert json['data'][0]['Name'] == classcard.Name
def test_school_classcards_get_json(client, web2py): """ Are the class cards returned correctly? """ populate_api_users(web2py) populate_school_classcards(web2py, 2) url = base_url + '/api/school_classcards_get.json?user=test&key=test' with urllib.request.urlopen(url) as page: content = page.read().decode('utf-8') json = sj.loads(content) classcard = web2py.db.school_classcards(1) assert json['data'][0]['Name'] == classcard.Name
def test_school_teachers_get_json(client, web2py): """ Are the teachers returned correctly? """ from populate_os_tables import populate_auth_user_teachers populate_api_users(web2py) populate_auth_user_teachers(web2py) url = base_url + '/api/school_teachers_get.json?user=test&key=test' page = urllib.urlopen(url).read() json = sj.loads(page) teacher = web2py.db.auth_user(2) assert json['data'][0]['Name'] == teacher.full_name
def test_school_subscriptions_get_json(client, web2py): """ Are the subscriptions returned correctly? """ populate_api_users(web2py) populate_school_subscriptions(web2py) url = base_url + '/api/school_subscriptions_get.json?user=test&key=test' page = urllib.urlopen(url).read() json = sj.loads(page) subscription = web2py.db.school_subscriptions(1) subscription_price = web2py.db.school_subscriptions_price(1) assert json['data'][0]['Name'] == subscription.Name assert json['data'][0]['Price'] == subscription_price.Price
def test_school_teachers_get_json(client, web2py): """ Are the teachers returned correctly? """ from populate_os_tables import populate_auth_user_teachers populate_api_users(web2py) populate_auth_user_teachers(web2py) url = base_url + '/api/school_teachers_get.json?user=test&key=test' with urllib.request.urlopen(url) as page: content = page.read().decode('utf-8') json = sj.loads(content) teacher = web2py.db.auth_user(2) assert json['data'][0]['Name'] == teacher.full_name
def test_school_subscriptions_get_json(client, web2py): """ Are the subscriptions returned correctly? """ populate_api_users(web2py) populate_school_subscriptions(web2py) url = base_url + '/api/school_subscriptions_get.json?user=test&key=test' with urllib.request.urlopen(url) as page: content = page.read().decode('utf-8') json = sj.loads(content) subscription = web2py.db.school_subscriptions(1) subscription_price = web2py.db.school_subscriptions_price(1) assert json['data'][0]['Name'] == subscription.Name assert json['data'][0]['Price'] == subscription_price.Price
def populate_schedule(web2py): """ Sets up a class and API user to test with """ populate_api_users(web2py) web2py.db.auth_user.insert(id=2, first_name='Edwin', last_name='van de Ven', email='*****@*****.**', teacher=True) web2py.db.auth_user.insert(first_name='Pietje', last_name='Puk', email='*****@*****.**', teacher=True) web2py.db.auth_user.insert(first_name='Aimee', last_name='Garcias', email='*****@*****.**', teacher=True) web2py.db.school_classtypes.insert(Name='Mysore', Link='http://www.openstudioproject.com', Description='Description here', AllowAPI=True) web2py.db.school_classtypes.insert(Name='Led class', AllowAPI=True) web2py.db.school_classtypes.insert(Name='Private', AllowAPI=False) web2py.db.school_locations.insert(Name="Sittard", AllowAPI=True) web2py.db.school_locations.insert(Name="Maastricht", AllowAPI=False) web2py.db.school_levels.insert(Name='Level 1') # Monday class + teachers web2py.db.classes.insert(school_locations_id=1, school_classtypes_id=1, school_levels_id=1, Week_day=1, Starttime='06:00:00', Endtime='09:00:00', Startdate='2014-01-01', Enddate='', Maxstudents=20, AllowAPI=True) web2py.db.classes_teachers.insert(classes_id=1, auth_teacher_id=2, auth_teacher_id2=3, Startdate='2014-01-01') # Tuesday class + teachers web2py.db.classes.insert(school_locations_id=2, school_classtypes_id=2, school_levels_id=1, Week_day=2, Starttime='06:00:00', Endtime='09:00:00', Startdate='2014-01-01', Enddate='', Maxstudents=20, AllowAPI=True) web2py.db.classes_teachers.insert(classes_id=2, auth_teacher_id=2, auth_teacher_id2=3, Startdate='2014-01-01') web2py.db.classes_otc.insert( classes_id=1, ClassDate='2014-01-13', auth_teacher_id=4, teacher_role=1, auth_teacher_id2=3, teacher_role2=1 ) # web2py.db.classes_subteachers.insert(classes_id=1, # ClassDate='2014-01-13', # auth_teacher_id=4, # auth_teacher_id2=3) web2py.db.classes_otc.insert( classes_id=1, ClassDate='2014-01-20', Status='cancelled' ) # web2py.db.classes_cancelled.insert(classes_id=1, # ClassDate='2014-01-20') web2py.db.school_holidays.insert(Description='Carnavals vakantie', Startdate='2014-01-27', Enddate='2014-01-30', Classes=True) web2py.db.school_holidays_locations.insert( school_holidays_id = 1, school_locations_id = 1 ) web2py.db.commit()