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