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 invite_team_member(user_content):
r1 = None
postURL = settings.ICE_EM_URL + '/v1/engmgr/invite-team-members/'
logger.debug("Post invite user URL: " + postURL)
headers = dict() # Create header for post request.
headers['Content-type'] = 'application/json'
headers['Authorization'] = user_content['session_token']
data = dict() # Create JSON data for post request.
data['email'] = Helper.rand_string(
'randomString') + "@" + ServiceProvider.email
data['eng_uuid'] = user_content['engagement_uuid']
list_data = []
list_data.append(data)
try:
r1 = requests.post(postURL,
json=list_data,
headers=headers,
verify=False)
Helper.internal_assert_boolean(r1.status_code, 200)
logger.debug("Invite sent successfully to email " + data['email'])
invite_token = DBGeneral.select_where_and(
"invitation_token", "ice_invitation", "email", data['email'],
"engagement_uuid", user_content['engagement_uuid'], 1)
invite_url = settings.ICE_PORTAL_URL + "/#/signUp?invitation=" + \
invite_token + "&email=" + data['email']
logger.debug("Invitation URL is: " + invite_url)
return data['email'], invite_token, invite_url
except BaseException:
if r1 is None:
logger.error("Failed to invite team member.")
else:
logger.error("POST request failed to invite team member, " +
"see response >>> %s %s" %
(r1.status_code, r1.reason))
raise
def remove_vfc(user_content):
vf_id = DBGeneral.select_where("uuid", "ice_vf", "name",
user_content['vfName'], 1)
djoni_uuid = None
counter = 0
while not djoni_uuid and counter <= Constants.DBConstants.\
RETRIES_NUMBER:
time.sleep(session.wait_until_time_pause_long)
djoni_uuid = DBGeneral.select_where_and("uuid", "ice_vfc", "vf_id",
vf_id, "name", "djoni", 1)
logger.debug("Checklist state not changed yet (%s of %s)" %
(counter, Constants.DBConstants.RETRIES_NUMBER))
counter += 1
logger.debug("VFC_UUID was successfully selecteded : " + djoni_uuid +
", and was verified over the DB")
Wait.text_by_id(Constants.Dashboard.DetailedView.VFC.ID + "djoni",
"djoni (loka)",
wait_for_page=True)
Wait.text_by_id(Constants.Dashboard.DetailedView.VFC.ID + "djoni2",
"djoni2 (loka2)",
wait_for_page=True)
Click.id(Constants.Dashboard.DetailedView.VFC.ID + "djoni",
wait_for_page=True)
Click.id(Constants.Dashboard.DetailedView.VFC.Remove.ID + djoni_uuid,
wait_for_page=True)
def update_decisions(checklistUuid, checklistName):
checklistTempid = DBGeneral.select_where("template_id",
"ice_checklist", "name",
checklistName, 1)
checklistLineItems = DBGeneral.select_where_and(
"uuid", "ice_checklist_line_item", "line_type", "auto",
"template_id", checklistTempid, 0)
for lineItem in checklistLineItems:
setParametrType2 = "peer_review_value"
setParametrValue2 = "approved"
whereParametrType2 = "lineitem_id"
whereParametrValue2 = lineItem
DBGeneral.update_where_and("ice_checklist_decision",
"review_value", checklistUuid,
"approved", "checklist_id",
setParametrType2, setParametrValue2,
whereParametrType2, whereParametrValue2)
def select_el_email(vfName):
try:
# Fetch one AT&T user ID.
engagement_id = DBVirtualFunction.select_eng_uuid(vfName)
engagement_manual_id = DBGeneral.select_where(
"engagement_manual_id", "ice_engagement", "uuid",
engagement_id, 1)
reviewer_id = DBGeneral.select_where(
"reviewer_id",
"ice_engagement",
"engagement_manual_id",
engagement_manual_id,
1)
engLeadEmail = DBGeneral.select_where_and(
"email", "ice_user_profile", "id", reviewer_id, "role_id",
"2", 1)
return engLeadEmail
# If failed - count the failure and add the error to list of errors.
except BaseException:
errorMsg = "select_el_email FAILED "
raise Exception(errorMsg, "select_el_email")
def add_contact(user_content):
r1 = None
postURL = settings.ICE_EM_URL + '/v1/engmgr/add-contact/'
logger.debug("Post invite vendor contact URL: " + postURL)
headers = dict() # Create header for post request.
headers['Content-type'] = 'application/json'
headers['Authorization'] = user_content['session_token']
data = dict() # Create JSON data for post request.
data['company'] = user_content['vendor_uuid']
data['email'] = Helper.rand_string(
'randomString') + "@" + ServiceProvider.email
data['eng_uuid'] = user_content['engagement_uuid']
data['full_name'] = Helper.rand_string('randomString')
data['phone_number'] = "+1201" + Helper.rand_string("randomNumber", 6)
try:
r1 = requests.post(postURL,
json=data,
headers=headers,
verify=False)
Helper.internal_assert_boolean(r1.status_code, 200)
logger.debug("Invite sent successfully to email " + data['email'])
invite_token = DBGeneral.select_where_and(
"invitation_token", "ice_invitation", "email", data['email'],
"engagement_uuid", user_content['engagement_uuid'], 1)
invite_url = settings.ICE_PORTAL_URL + "/#/signUp?invitation=" +\
invite_token + "&email=" + data['email'] +\
"&full_name=" + data['full_name'] + \
"&phone_number=" + data['phone_number'] + "&company=" + \
data['company'] + "&is_contact_user=true"
logger.debug("Invitation URL is: " + invite_url)
return data['email'], invite_token, invite_url
except BaseException:
if r1 is None:
logger.error("Failed to invite vendor contact.")
else:
logger.error(
"POST request failed to invite vendor contact, " +
"see response >>> %s %s \n %s" %
(r1.status_code, r1.reason, str(r1.content, 'utf-8')))
raise
