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 = []