def login():
url = "http://localhost:3000/login"
driver.get(url)
driver.maximize_window()
# get values from user to enter in the fields
actual_name = "chaitra@br.com"
actual_pwd = "123456"
time.sleep(5)
driver.find_element(By.XPATH, "//input[@name='email']").send_keys(actual_name)
driver.find_element(By.XPATH, "//input[@name='password']").send_keys(actual_pwd)
username = actual_name
password = actual_pwd
time.sleep(10)
# Execute a query to retrieve the salted and hashed password for the specified user
query = f"SELECT salted_hash_of_password FROM websocket_authentication_details WHERE email_id = %s and is_active " \
f"= true "
cursor.execute(query, (username,))
result = cursor.fetchone()
try:
if result:
stored_password_hash = result[0]
user_input_password = password.encode('utf-8')
# Verify the user's input password against the stored hash
if bcrypt.checkpw(user_input_password, stored_password_hash.encode('utf-8')):
query1 = f"SELECT permissions_json FROM websocket_permissions_details where email_id = %s"
cursor.execute(query1, (username,))
rows = cursor.fetchall()
# Check for the keys present in Db for password verified user
unique_keys = set()
for row in rows:
json_data = row[0]
if json_data:
unique_keys.update(json_data.keys())
unique_keys_list = list(unique_keys)
# check if the user has the below keys in order to login
values_to_check = ["data_permissions", "permit_actions"]
for value in values_to_check:
if value in unique_keys_list:
try:
driver.find_element(By.XPATH, "//button[text()='Login']").click()
time.sleep(3)
val = key_check(username)
progress(val)
document_path = "D:/testfolder/test.dat"
order_blotter(document_path)
except NoSuchElementException:
print(" ")
else:
print("wrong pass")
driver.find_element(By.XPATH, "//button[text()='Login']").click()
time.sleep(5)
else:
print("user details not found")
driver.find_element(By.XPATH, "//button[text()='Login']").click()
time.sleep(3)
except Exception as e:
print("An unexpected error occurred:", e)
cursor.close()
conn.close()
try:
if "Wrong email or password." in driver.page_source:
print("Wrong pass or username. Retry with correct login creds")
driver.refresh()
else:
print("Login successful")
except Exception as e:
print("An unexpected error occurred:", e)
time.sleep(10)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter