def signUpUserProvisionally(username, email, password, db_file_name):
# validation check
if len(validationCheck4InsertProvisionalUser(username, email,
password)) >= 1:
return False
# password to hash
auth_key = covert2AuthKeyFromPassword(password)
if auth_key == None:
print("Auth_key is None")
return False
# insert user provisionally to user db
email_confirm_pass = getEmailConfirmPass()
if dao.insertProvisionalUser2Db(username, email, auth_key,
email_confirm_pass, db_file_name) != True:
print("InsertProvisionalUser2Db was failed")
return False
# send email for sign up user
sendEmail4SignUpUser(username, email, email_confirm_pass)
logging.info("signUpUserProvisionally is success.")
return True
def registerUser(username, email, password, db_file_name):
validation_result = validateInput(username, email, password)
if len(validation_rs) >= 1:
for rs in validation_result:
logging.info(rs)
return False
auth = password2AuthKey(password)
if auth == None:
logging.info("Auth_key is None")
return False
confirm_token = getEmailConfirmToken()
if dao.insertProvisionalUser2Db(username, email, auth, confirm_token, db_file_name) != True:
logging.info("InsertProvisionalUser2Db was failed")
return False
if not sendEmail4SignUp(username, email, confirm_token):
logging.info("Failed to send Email")
return False
logging.info("signUpUserProvisionally is success.")
return True
test_user_db) == True)
assert (len(dao.select("SELECT * FROM test", test_user_db, False)) == 1)
print("Checking update test user db...")
assert (dao.update("UPDATE test SET name=? WHERE id=?", ["goro", 123],
test_user_db) == True)
assert (len(dao.select("SELECT * FROM test", test_user_db, False)) == 1)
assert (dao.select("SELECT * FROM test", test_user_db, False)[0][1] == "goro")
print("Checking delete a column test test db...")
assert (dao.delete("DELETE FROM test WHERE id=?", [123], test_user_db) == True)
assert (len(dao.select("SELECT * FROM test", test_user_db, False)) == 0)
print("Checking insert user provisionally into test user db...")
assert (dao.insertProvisionalUser2Db("name_test_1", "*****@*****.**",
"123abc456def",
"oneTimePassforUserEmailComfirm",
test_user_db) == True)
assert (dao.insertProvisionalUser2Db("name_test_2", "*****@*****.**",
"123abc456def",
"oneTimePassforUserEmailComfirm2",
test_user_db) == True)
assert (len(dao.select("SELECT * FROM provisionalUser", test_user_db,
False)) == 2)
assert (dao.select("SELECT * FROM provisionalUser", test_user_db,
False)[0][0] == 1)
assert (dao.select("SELECT * FROM provisionalUser", test_user_db,
False)[1][0] == 2)
assert (dao.select("SELECT * FROM provisionalUser", test_user_db,
False)[0][1] == "name_test_1")
assert (dao.select("SELECT * FROM provisionalUser", test_user_db,
False)[1][1] == "name_test_2")
import signUpService as ss
import dao
import os
ROOT_DIR = os.path.dirname(os.path.abspath(__file__))
test_user_db = "testUserDb"
if os.path.exists(ROOT_DIR + '/../db/{}.db'.format(test_user_db)):
os.remove(ROOT_DIR + '/../db/{}.db'.format(test_user_db))
print("Preparing user login...")
sample_auth_key = ss.covert2AuthKeyFromPassword("sample_password")
print("auth_key:" + sample_auth_key)
assert (dao.insertProvisionalUser2Db("login_test_user", "*****@*****.**",
sample_auth_key,
"oneTimePassforUserEmailComfirm",
test_user_db) == True)
assert (dao.isProvisionalUser("oneTimePassforUserEmailComfirm") == True)
assert (dao.signUp("oneTimePassforUserEmailComfirm") == True)
print("Complete preparing.")
print("Checking login...")
assert (ls.login("*****@*****.**",
"sample_password")["name"] == "login_test_user")
assert (ls.login("*****@*****.**",
"sample_password")["email"] == "*****@*****.**")
assert (ls.login("*****@*****.**", "sample_password") == False)
assert (ls.login("*****@*****.**", "fail_password") == False)
assert (ls.login("*****@*****.**", "fail_password") == False)
print("Finish all test.")