def doLogin(self, username, password): query = QSqlQuery() query.prepare("select id from qtapp_users where username = :username and password = :password") query.bindValue(":username", username) query.bindValue(":password", helper.computeHash(password)) query.exec_() if query.next(): return True return False
def doLogin(self, username, password): query = QSqlQuery() query.prepare( "select id from qtapp_users where username = :username and password = :password" ) query.bindValue(":username", username) query.bindValue(":password", helper.computeHash(password)) query.exec_() if query.next(): return True return False
def doSignUp(self, username, password): query = QSqlQuery() query.prepare("select id from qtapp_users where username = :username") query.bindValue(":username", username) query.exec_() if query.next(): return False query.prepare( "insert into qtapp_users(username, password) values(:username, :password)" ) query.bindValue(":username", username) query.bindValue(":password", helper.computeHash(password)) query.exec_() query.prepare("select id from qtapp_users where username = :username") query.bindValue(":username", username) query.exec_() if query.next(): return True return False
def testMd5(self): self.assertEqual(helper.computeHash("password"),"5f4dcc3b5aa765d61d8327deb882cf99")
def testMd5(self): self.assertEqual(helper.computeHash("password"), "5f4dcc3b5aa765d61d8327deb882cf99")