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