def test_login_command(self):
fail_login, fail_password = "******", "test"
correct_login, correct_password = "******", "fx0507"
self.assertIsNone(SqlCommands.fetch_logins(fail_login, hash(fail_password)))
correct_user_properties = SqlCommands.fetch_logins(correct_login, hash(correct_password))
self.assertIsNotNone(correct_user_properties)
self.assertEqual(len(correct_user_properties), 4)
def test_create_delete_session(self):
device_id = '123-231-321'
SqlCommands.insert_new_session(3, device_id)
sessions = DatabaseConnection().fetch_query('select * from session where 1')
self.assertTrue(len(sessions) == 1)
SqlCommands.delete_session(device_id)
sessions = DatabaseConnection().fetch_query('select * from session where 1')
self.assertTrue(len(sessions) == 0)
def perform_callback(self, instance, *args, **kwargs):
if App.get_running_app().root.logged_user is None:
try:
imie, nazwisko, id, uprawnienia = self.database_query.result()
# App.get_running_app().root.logged_user = User(name=imie, user_id=id,
# permission=uprawnienia, lastname=nazwisko)
# App.get_running_app().root.choosen_user = App.get_running_app().root.logged_user
SqlCommands.insert_new_session(id, plyer.uniqueid.id)
Clock.schedule_once(lambda a: instance.check_device_session())
except:
Clock.schedule_once(instance.wrong_login)
def dispatch_incoming_notifications(self, *args):
notifications = SqlCommands.get_notifications(self.session_id)
for data, godzina, ilosc_os, operacja in notifications:
message, ticker = self.get_message_ticker(data, godzina, ilosc_os,
operacja)
icon_path = os.path.join(dirname(dirname(realpath(__file__))),
'adventureskiing', 'graphics', 'logo.png')
self.notifier.notify(title=ticker,
message=message,
app_name='ASy',
app_icon=icon_path,
ticker=ticker)
def test_user_creation_and_removal(self):
incorrect_name, incorrect_lastname, incorrect_login = "******", "Teter1", "Hihi$"
correct_name, correct_lastname, self.correct_login = "******", "Test", "Tester123"
self.assertFalse(SqlCommands.create_user(firstname=incorrect_name,
lastname=incorrect_lastname,
login=incorrect_login))
self.assertFalse(SqlCommands.create_user(firstname=correct_name,
lastname=incorrect_lastname,
login=incorrect_login))
self.assertFalse(SqlCommands.create_user(firstname=incorrect_name,
lastname=incorrect_lastname,
login=self.correct_login))
self.assertTrue(SqlCommands.create_user(firstname=correct_name,
lastname=correct_lastname,
login=self.correct_login))
name, lastname, uid, permissions = SqlCommands.fetch_logins(self.correct_login, hash(self.correct_login))
test_user = User(user_id=uid, permission=permissions, lastname=lastname, name=name)
self.assertTrue(SqlCommands.remove_user(test_user))
def check_device_session(self):
self.session_id = SqlCommands.get_session(plyer.uniqueid.id)
self.logged_user = SqlCommands.get_user_from_session(self.session_id) if self.session_id else None
self.choosen_user = self.logged_user
if self.logged_user:
self.__session_supervisor.start()
def fetch_users(self):
""" Cannot be a background task, to set it in action view properly!! """
self.assign_users(SqlCommands.get_all_users())