def testMaxAccountsCreated(monkeypatch, capfd):
connection = sqlite3.connect("incollege_test.db")
cursor = connection.cursor()
db.initTables(cursor)
for i in range(10):
db.insertUser(cursor, f"username{i}", "password", f"first{i}", f"last{i}", 0, "01/01/2020")
users.createUser(cursor, connection)
out, err = capfd.readouterr() # Output should display max users created
assert out == "All permitted accounts have been created, please come back later\n"
assert db.getNumUsers(cursor) == 10
def testUserAlreadyExists(monkeypatch, capfd):
monkeypatch.setattr("sys.stdin", StringIO("username1\nusername2\nPassword1!\nfname\nlname\nN\n")) #after username1 is taken, pick a different uname and exit menu
connection = sqlite3.connect("incollege_test.db")
cursor = connection.cursor()
cursor.execute("DROP TABLE IF EXISTS Users") #delete tables to make sure no conflicts when running test multiple times
cursor.execute("DROP TABLE IF EXISTS user_settings")
cursor.execute("DROP TABLE IF EXISTS profile_page")
db.initTables(cursor)
db.insertUser(cursor, "username1", "password", "first", "last", 0, "01/01/2020")
users.createUser(cursor, connection)
out, err = capfd.readouterr()
assert "Sorry, that username has already been taken" in out
assert settings.currentState == states.loggedOut
def addUser():
data = request.json
returnValue = createUser(data)
if(returnValue == 1):
response.status = 201
return {"status": "successfully saved", "result" : returnValue}
else:
response.status = 200
return {"status": "some error occured", "result" : returnValue}
def addUser():
data = request.json
returnValue = createUser(data)
if (returnValue == 1):
response.status = 201
return {"status": "successfully saved", "result": returnValue}
else:
response.status = 200
return {"status": "some error occured", "result": returnValue}
def newUser():
data = request.get_json()
firstName = data['firstName']
lastName = data['lastName']
gender = data['gender']
number = data['number']
code = createUser(firstName, lastName, gender, number)
if code != -1:
return json.dumps({
'id': code,
'firstName': firstName,
'lastName': lastName,
'gender': gender,
'number': number,
'success': True
}), 200, {
'ContentType': 'application/json'
}
else:
return json.dumps({'success': False}), 400, {
'ContentType': 'application/json'
}
def createUser(username, group):
return users.createUser(username, group)
def create_user(username):
return U.createUser(username)