def authenticateUser(username, password, dbLoginInfo): user = None dataConnection = ScrumblesData.ScrumblesData(dbLoginInfo) dataConnection.connect() result = dataConnection.getData( Query.getUserByUsernameAndPassword(username, password)) dataConnection.close() if result == (): logging.warning('Login Failed for %s' % username) raise Exception('Invalid USERNAME PASSWORD combo') else: user = username logging.info('%s Successfully logged in' % username) return user
def loginButtonClickedBypassDev(self): username = "******" #self.usernameEntry.get() password = "******" #self.passwordEntry.get() loggedInUserName = None dbLoginInfo = ScrumblesData.DataBaseLoginInfo("login.txt") try: loggedInUserName = authenticateUser(username, password, dbLoginInfo) except OperationalError as e: logging.exception('Login Failed') messagebox.showerror('Login Failed', str(e)) self.destroy() exit() except Exception as error: logging.warning('Failed login %s' % username) messagebox.showerror('Invalid Login', 'Username and Password do not match') return loggedInUserName self.destroy() return loggedInUserName
from data.ScrumblesData import * from data.ScrumblesObjects import * username = '******' password = '******' dbLoginInfo = DataBaseLoginInfo("login.txt") dataConnection = ScrumblesData(dbLoginInfo) dataConnection.connect() users = dataConnection.getData(Query.getAllUsers) sprints = dataConnection.getData(Query.getAllSprints) cards = dataConnection.getData(Query.getAllCards) comments = dataConnection.getData(Query.getAllComments) result = dataConnection.getData( Query.getUserByUsernameAndPassword(username, password)) if result == (): userID = 'cannot authenticate user' else: userID = result[0]['UserID'] dataConnection.close() for user in users: print('User ID\t\t', user['UserID']) print('Name\t\t', user['UserName']) print('Email\t\t', user['UserEmailAddress']) print('Password\t', user['UserPassword']) print('Role\t\t', user['UserRole'])
from data import ScrumblesData, ScrumblesObjects def printUserDetails(user): print(user.userID) print(user.userName) print(user.userEmailAddress) print(user.userRole) print() login_info = ScrumblesData.DataBaseLoginInfo() login_info.userID = 'test_user' login_info.password = '******' login_info.ipaddress = '173.230.136.241' login_info.defaultDB = 'test' dataConnection = ScrumblesData.ScrumblesData(login_info) dataConnection.connect() userTable = dataConnection.getData(ScrumblesData.Query.getAllUsersQuery) dataConnection.close() listOfAllUsers = [] for row in userTable: user = ScrumblesObjects.User(row) listOfAllUsers.append(user) for user in listOfAllUsers: printUserDetails(user)
for user in dataBlock.users: userNames.append(user.userName) for user in userNames: userListBox.insert(tk.END, user) def updateItemList(): print('update Item List') itemNames.clear() itemListBox.delete(0, tk.END) for item in dataBlock.items: itemNames.append(item.itemTitle) for Item in itemNames: itemListBox.insert(tk.END, Item) dataBlock = ScrumblesData.DataBlock() dataBlock.packCallback(updateUserList) dataBlock.packCallback(updateItemList) updateUserList() updateItemList() userListBox.pack() itemListBox.pack() root.mainloop() dataBlock.shutdown() dataBlock.listener.stop()
from data import ScrumblesData, ScrumblesObjects ScrumblesUser_username = '******' ScrumblesUser_password = '******' dbLoginInfo = ScrumblesData.DataBaseLoginInfo('login.txt') dataConnection = ScrumblesData.ScrumblesData(dbLoginInfo) dataConnection.connect() getAllUsersQuery = ScrumblesData.Query.getAllUsers getAllSprintsQuery = ScrumblesData.Query.getAllSprints getAllItemsQuery = ScrumblesData.Query.getAllCards getAllCommentsQuery = ScrumblesData.Query.getAllComments ## Test retrieval of Remote SQL Data allUsersQueryResult = dataConnection.getData(getAllUsersQuery) allSprintsQueryResult = dataConnection.getData(getAllSprintsQuery) allItemsQueryResult = dataConnection.getData(getAllItemsQuery) allCommentsQueryResult = dataConnection.getData(getAllCommentsQuery) dataConnection.close() assert len(allUsersQueryResult) >= 0 assert len(allSprintsQueryResult) >= 0 assert len(allItemsQueryResult) >= 0 assert len(allCommentsQueryResult) >= 0 print('Data Download Successful') listOfUsers = []