def delete_from_sql(username):
try:
data = {'user': username}
sent_to_server(data, "Testsingup")
conn = db_connect.connect()
conn.execute("DELETE FROM Accounts WHERE username = ?;", (username, ))
except:
print("cant delete")
def test_get_user_in_delete(self):
data = {'User': self.username_admin, 'del': self.username}
result = website.sent_to_server(data, "DeleteUser")
assert result['status'] == 'success'
result = website.sent_to_server(data, "GetUsersToReturn")
for user in result['data']:
if user['User'] == self.username:
pass
def test_get_user_not_inside_delete(self):
data = {'User': self.username_admin, 'del': self.username}
result = website.sent_to_server(data, "DeleteUser")
assert result['status'] == 'success'
data = {'User': self.username_admin}
result = website.sent_to_server(data, "GetUsersToReturn")
assert result['status'] == 'success'
for user in result['data']:
if user['User'] == th.id_generator():
assert 1 == 2
pass
def setUp(self):
self.username = th.id_generator()
self.password = th.id_generator()
self.email = th.id_generator() + "@" + th.id_generator()
data = {
'User': self.username,
'Password': self.password,
'perm': "normal",
'Email': self.email
}
website.sent_to_server(data, "singup")
def tearDown(self):
print("start tear down")
th.logout(self.client_website)
data = {'user': self.username}
result = website.sent_to_server(data, "Testsingup")
assert result['status'] == 'success'
print("deleted " + self.username)
data = {'user': self.username_admin}
result = website.sent_to_server(data, "Testsingup")
assert result['status'] == 'success'
print("deleted " + self.username_admin)
def test_server_register_normal(self):
data = {
'User': self.username,
'Password': self.password,
'perm': "normal",
'Email': self.email
}
result = website.sent_to_server(data, "singup")
assert result['status'] == "success"
data = {'user': self.username}
result = website.sent_to_server(data, "Testsingup")
assert result['status'] == "success"
def test_get_user_to_delete(self):
data = {'User': self.username_admin}
result = website.sent_to_server(data, "GetUsersToDelete")
assert result['status'] == 'success'
for user in result['data']:
if user['User'] == self.username:
pass
def test_server_register_without_username(self):
data = {
'Email': self.email,
'Password': self.password,
'perm': "normal"
}
result = website.sent_to_server(data, "singup")
assert result['status'] == "failAndCrash"
def test_server_register_premision(self):
data = {
'User': self.username,
'Password': self.password,
'Email': self.email
}
result = website.sent_to_server(data, "singup")
assert result['status'] == "failAndCrash"
def test_server_register_hacker(self):
data = {
'User': self.username,
'Password': self.password,
'perm': th.id_generator(),
'Email': self.email
}
result = website.sent_to_server(data, "singup")
assert result['status'] == "hacker"
def setUp(self):
self.username_admin = th.id_generator()
self.password_admin = th.id_generator()
self.email_admin = th.id_generator() + "@" + th.id_generator()
data = {
'User': self.username_admin,
'Password': self.password_admin,
'perm': "normal",
'Email': self.email_admin
}
website.sent_to_server(data, "singup")
data = {
'User': '******',
'UserUpdate': self.username_admin,
'Permissions': "Admin"
}
website.sent_to_server(data, "SetPermissions")
self.username = th.id_generator()
self.password = th.id_generator()
self.email = th.id_generator() + "@" + th.id_generator()
data = {
'User': self.username,
'Password': self.password,
'perm': "normal",
'Email': self.email
}
website.sent_to_server(data, "singup")
def test_get_user_to_return_user_not_admin(self):
data = {'User': th.id_generator()}
result = website.sent_to_server(data, "GetUsersToReturn")
assert result['status'] == 'haven\'t Permissions'
def test_server_login_wrong_username(self):
data = {'user': th.id_generator(), 'pas': self.password}
result = website.sent_to_server(data, "singin")
assert result['status'] == "Ufail"
def tearDown(self):
data = {'user': self.username}
website.sent_to_server(data, "Testsingup")
data = {'user': self.username_admin}
website.sent_to_server(data, "Testsingup")
def test_server_login(self):
data = {'user': self.username, 'pas': self.password}
result = website.sent_to_server(data, "singin")
assert result['status'] == "success"
assert result['permissions'] == "normal"
def test_server_responds(self):
data = {'user': "******"}
result = website.sent_to_server(data, "test")
assert result['data'] is not None
def setUp(self):
print("start set up process")
self.app = website.Flask(__name__)
website.app.config.from_object('config.TestingConfig')
self.client_website = website.app.test_client()
print("finish set up web client")
self.username_admin = th.id_generator()
self.password_admin = th.id_generator()
self.email_admin = th.id_generator() + "@" + th.id_generator()
result = website.register(
self.username_admin,
generate_password_hash(self.password_admin,
method='pbkdf2:sha256',
salt_length=50), "normal", self.email_admin)
assert result is True
print("the user " + self.username_admin + " got register")
data = {
'User': '******',
'UserUpdate': self.username_admin,
'Permissions': "Admin"
}
result = website.sent_to_server(data, "SetPermissions")
assert result['status'] == 'success'
print("the user " + self.username_admin + " is admin")
self.username = th.id_generator()
self.password = th.id_generator()
self.email = th.id_generator() + "@" + th.id_generator()
result = website.register(
self.username,
generate_password_hash(self.password,
method='pbkdf2:sha256',
salt_length=50), "normal", self.email)
assert result is True
print("the user " + self.username + " got register")
data = {
'user': self.username_admin,
'UserName': self.username,
'ReasonForRequest': "test"
}
result = website.sent_to_server(data, "RequestPermissions")
assert result['status'] == 'success seve request'
print("the user " + self.username_admin +
" is asking for responsibility for " + self.username)
# accept the requset
data = {
'User': self.username_admin,
'requesting': self.username_admin,
'user': self.username,
'insert': True
}
result = website.sent_to_server(data, "AdminAnswers")
assert result['status'] == 'deleted this request and saved'
print("the user " + self.username_admin + " is responsible for " +
self.username)
def update_permission_in_sql(username, authority):
data = {'UserUpdate': username, 'Permissions': authority, 'User': '******'}
return sent_to_server(data, "SetPermissions")
def test_server_login_without_username(self):
data = {'pas': self.password}
result = website.sent_to_server(data, "singin")
assert result['status'] == "fail"