def test_college_403_bad_creds():
    params = {"username":"student_coll1_1",
              "password":"thisiswrong"}

    r, data = test_helpers.server_get("/colleges/college-1", params)

    assert r.status == 403

def test_colleges_blueshirt():
    params = {"username": "blueshirt", "password": "blueshirt"}
    r, data = test_helpers.server_get("/colleges", params)
    print r.status
    print data
    assert r.status == 200
    assert len(json.loads(data)["colleges"]) == 2

 def test_user_get_valid_teacher_body(self):
     resp = helpers.server_get("/user/student_coll1_1", {"token":self.auth_hash})
     body = resp.read()
     print body
     hash = json.loads(body)
     self.assertEqual(hash["full_name"], "student1 student")
     self.assertEqual(hash["email"], "[email protected]")

def test_user_get_wrong_user():
    params = {"username":"teacher_coll2",
              "password":"noway",
              }

    r,data = test_helpers.server_get("/user/student_coll1_1", params)
    assert r.status == 403

def test_activate_wrong_code():
    pu = create_pending_user()
    pu.save()

    r,data = test_helpers.server_get("/activate/abc/bees")
    status = r.status
    assert status == 403, data

def test_colleges_no_user():
    params = {}

    r, data = test_helpers.server_get("/colleges", params)

    print r, data
    assert r.status == 403

def test_user_get_blueshirt_wrong_password():
    params = {"username":"blueshirt",
              "password":"a",
              }

    r,data = test_helpers.server_get("/user/blueshirt", params)

    assert r.status == 403

def test_user_get_other_can_view():
    params = {"username":"blueshirt",
              "password":"blueshirt",
              }

    r,data = test_helpers.server_get("/user/student_coll1_1", params)
    assert r.status == 200
    assert data.find("student_coll1_1") != -1

def test_college_blueshirt_can_see_any_college():
    params = {"username":"blueshirt",
              "password":"blueshirt"}

    r, data = test_helpers.server_get("/colleges/college-2", params)

    assert r.status == 200
    resp = json.loads(data)
    assert "users" not in resp.keys()

def test_user_teams():
    params = {"username":"student_coll1_1",
              "password":"cows",
              }

    r,data = test_helpers.server_get("/user/student_coll1_1", params)
    data = json.loads(data)

    assert r.status == 200
    assert ["team-ABC"] == data[u"teams"]

def test_user_colleges():
    params = {"username":"blueshirt",
              "password":"blueshirt",
              }

    r,data = test_helpers.server_get("/user/blueshirt", params)
    data = json.loads(data)

    assert r.status == 200
    assert "college-1" in data[u"colleges"]

def test_user_withdrawn_false():
    params = {"username":"teacher_coll2",
              "password":"noway",
              }

    r,data = test_helpers.server_get("/user/teacher_coll2", params)
    data = json.loads(data)

    assert r.status == 200
    assert not data['has_withdrawn']

    def test_user_post_set_email_email(self):
        args_hash = {}
        args_hash["token"] = self.auth_hash
        args_hash["email"] = "[email protected]" + str(random.randint(0,10000)) + ".com"
        resp = helpers.server_post("/user/student_coll2_2", args_hash)
        self.assertEqual(resp.status, 200)

        resp = helpers.server_get("/user/student_coll2_2", {"token":self.auth_hash})
        body = json.loads(resp.read())
        self.assertEqual(body["email"], args_hash["email"])

def test_user_get_self_wrong_case():
    """
    Tests that when a user auths with the wrong case,
    and requests the wrong case of username in the url,
    we still respond with the correctly cased data.
    """
    params = {"username":"Student_Coll1_1",
              "password":"cows"}
    r,data = test_helpers.server_get("/user/studenT_coll1_1", params)
    assert r.status == 200
    assert data.find("student_coll1_1") != -1

    def test_get_college_body(self):
        resp = helpers.server_get("/college", {"token":self.auth_hash})
        obj = json.loads(resp.read())
        self.assertTrue(obj.has_key("userids"))
        self.assertTrue("teacher_coll1" in obj["userids"])
        self.assertTrue("student_coll1_1" in obj["userids"])
        self.assertTrue("student_coll1_2" in obj["userids"])

        self.assertEqual(obj["college_name"], "college the first")
        self.assertTrue("team-ABC" in obj["teams"])
        self.assertTrue("team-DFE" in obj["teams"])

def test_user_properties_student():
    params = {"username":"student_coll1_1",
              "password":"cows",
              }

    r,data = test_helpers.server_get("/user/student_coll1_1", params)
    data = json.loads(data)

    assert r.status == 200
    assert data['is_student']
    assert not data['is_team_leader']
    assert not data['is_blueshirt']

    def test_verify_outdated_request(self):
        with sqlite_connect() as conn:
            cur = conn.cursor()
            statement = "INSERT INTO password_resets (username, requestor_username, request_time, verify_code) VALUES (?,?,?, ?)"
            days = config.getint('nemesis', 'password_reset_days')
            old = datetime.datetime.now() - datetime.timedelta(days = days + 2)
            arguments = ('abc', 'blueshirt', old.strftime('%Y-%m-%d %H:%M:%S'), 'bees')
            cur.execute(statement, arguments)
            conn.commit()

        r, data = test_helpers.server_get("/reset_password/abc/bees")
        self.assertEqual(410, r.status, data)

def test_verify_outdated_request():
    conn = test_helpers.sqlite_connect()
    cur = conn.cursor()
    statement = "INSERT INTO email_changes (username, new_email, request_time, verify_code) VALUES (?,?,?, ?)"
    old = datetime.datetime.now() - datetime.timedelta(days = 4)
    arguments = ('abc', '[email protected]', old.strftime('%Y-%m-%d %H:%M:%S'), 'bees')
    cur.execute(statement, arguments)
    conn.commit()

    r,data = test_helpers.server_get("/verify/abc/bees")
    status = r.status
    assert status == 410, data

def test_college_teacher_cant_see_blueshirt():

    params = {"username":"teacher_coll1",
              "password":"facebees"}

    r, data = test_helpers.server_get("/colleges/college-1", params)

    assert r.status == 200

    resp = json.loads(data)
    assert resp["name"] == "college the first"
    assert "blueshirt" not in set(resp["users"])

def test_college_teacher_can_see_students_and_self():
    params = {"username":"teacher_coll1",
              "password":"facebees"}

    r, data = test_helpers.server_get("/colleges/college-1", params)

    assert r.status == 200

    resp = json.loads(data)
    assert resp["name"] == "college the first"
    assert "teacher_coll1" in set(resp["users"])
    assert "student_coll1_1" in set(resp["users"])
    assert "student_coll1_2" in set(resp["users"])