def set_new_temp_password(email):
encodePass = DBGeneral.select_where_email(
"password", "auth_user", Constants.Users.Admin.EMAIL)
# Fetch one user ID.
index = DBGeneral.select_where_email("id", "auth_user", email)
DBGeneral.update_where(
"ice_custom_user",
"temp_password",
encodePass,
"user_ptr_id",
index)
def get_not_seen_notifications_number_by_email(
user_email, is_negative=False):
user_id = DBGeneral.select_where_email(
"id", Constants.DBConstants.IceTables.USER_PROFILE, user_email)
notifications_number = DBGeneral.select_where_and(
Constants.DBConstants.Queries.COUNT,
Constants.DBConstants.IceTables.NOTIFICATION,
"user_id",
user_id,
"is_read",
"False",
1)
if is_negative:
counter = 0
while notifications_number != "0" and counter <= Constants.\
Dashboard.Avatar.Notifications.Count.RETRIES_NUMBER:
notifications_number = DBGeneral.select_where_and(
Constants.DBConstants.Queries.COUNT,
Constants.DBConstants.IceTables.NOTIFICATION,
"user_id",
user_id,
"is_read",
"False",
1)
time.sleep(1)
counter += 1
return notifications_number
def get_activation_url(email):
# Fetch one user ID.
uuid = DBUser.select_user_uuid(email)
# Fetch one user ID.
index = DBGeneral.select_where_email("id", "auth_user", email)
activation_token = DBGeneral.select_where(
"activation_token", "ice_custom_user", "user_ptr_id", index, 1)
# / activate /:userID /:token
activationUrl = settings.ICE_PORTAL_URL + '/#/activate/' + \
str(uuid) + '/' + str(activation_token)
logger.debug("activationUrl :" + activationUrl)
return activationUrl
def validations_for_user2(user_content, inviteEmail, vflist):
# Fetch one AT&T user ID.
engagement_id = DBGeneral.select_where("engagement_id", "ice_vf",
"name", vflist[0], 1)
engagement_manual_id = DBGeneral.select_where("engagement_manual_id",
"ice_engagement", "uuid",
engagement_id, 1)
engLeadEmail = DBUser.select_el_email(vflist[0])
user_content['engagement_uuid'] = engagement_id
user_content['el_email'] = engLeadEmail
uuid = DBGeneral.select_where_email("uuid", "ice_user_profile",
user_content['email'])
sponsor = [
ServiceProvider.MainServiceProvider, 'aaaaaa', inviteEmail,
'3058000000'
]
invitation_token = DBUser.select_invitation_token(
"invitation_token", "ice_invitation", "engagement_uuid",
engagement_id, inviteEmail, 1)
signUpURLforContact = DBUser.get_contact_signup_url(
invitation_token, uuid, sponsor[2], sponsor[1], sponsor[3],
sponsor[0])
APIUser.signup_invited_user(sponsor[0],
inviteEmail,
invitation_token,
signUpURLforContact,
user_content,
True,
wait_for_gitlab=False)
activationUrl2 = DBUser.get_activation_url(sponsor[2])
FEGeneral.re_open(activationUrl2) # Login with 2nd user #
engName = engagement_manual_id + ": " + vflist[0]
title_id = "clickable-" + engName
FEUser.login(inviteEmail, Constants.Default.Password.TEXT, title_id)
for vfName in vflist:
# Fetch one AT&T user ID.
engagement_id = DBGeneral.select_where("engagement_id", "ice_vf",
"name", vfName, 1)
engagement_manual_id = DBGeneral.select_where(
"engagement_manual_id", "ice_engagement", "uuid",
engagement_id, 1)
engName = engagement_manual_id + ": " + vfName
vf_left_nav_id = "clickable-" + engName
Click.id(vf_left_nav_id, wait_for_page=True)
def set_password_to_default(email):
encodePass = DBGeneral.select_where_email(
"password", "auth_user", Constants.Users.Admin.EMAIL)
DBGeneral.update_where(
"auth_user", "password", encodePass, "email", email)
def get_notification_id_by_email(userEmail):
uuid = DBGeneral.select_where_email(
"id", "ice_user_profile", userEmail)
notifIDs = DBGeneral.select_where(
"uuid", "ice_notification", "user_id", uuid, 0)
return notifIDs
