# -*- coding: utf-8 -*-

def setup_ep_tests(web2py):
    """
        Adds the following to the db:
            A new user
            A new group
            Adds the user to the group
    """
    password = web2py.db.auth_user.password.validate('Password@1')[0]
    uid = 400
    gid = 400

    # Add user
    web2py.db.auth_user.insert(id=uid,
                               teacher=True,
                               first_name='openstudio',
                               last_name='ep test',
                               email='ep@openstudioproject.com',
                               password=password,
                               login_start='ep')
    # Add group
    web2py.db.auth_group.insert(id=gid,
                                role='ep test',
                                description='ep test')
    # Add user to group
    web2py.auth.add_membership(gid, uid)

    # Give read permissions for employee portal
    web2py.auth.add_permission(400, 'read', 'employee_portal', 0)

    web2py.db.commit()