def service_now():
# Let's pass the values from a form
settings = get_settings('settings.yaml')
if request.method == 'GET':
sn_url = settings['cw_sn_server_url']
sn_api_user = settings['cw_sn_user_name']
sn_api_user_password = settings['cw_sn_user_password']
sn_client_id = settings['cw_sn_client_id']
sn_client_secret = settings['cw_sn_client_secret']
return render_template('servicenow.html',
sn_client_id=sn_client_id,
sn_client_secret=sn_client_secret,
sn_api_user_password=sn_api_user_password,
sn_api_user=sn_api_user,
sn_url=sn_url)
else:
url = request.form['sn_url'].strip()
auth_token = get_auth_token(settings)
user_json = get_single_user(url, auth_token, 'scurry')
print(user_json)
user_name = user_json['result'][0]['name']
user_email = 'place_holder'
return render_template('servicenow.html',
user_sn_name=user_name,
user_name=user_name,
user_email=user_email)
def uem_calls():
settings = get_settings('settings.yaml')
if request.method == "GET":
uem_oauth_url = settings['uem_oauth_endpoint']
uem_client_id = settings['uem_oauth_client_id']
uem_client_secret = settings['uem_oauth_client_secret']
return render_template('uem.html',
uem_oauth_url=uem_oauth_url,
uem_client_id=uem_client_id,
uem_client_secret=uem_client_secret)
else:
uem_oauth_url = request.form['uem_oauth_url'].strip()
uem_client_id = request.form['uem_client_id'].strip()
uem_client_secret = settings['uem_oauth_client_secret']
oauth_token = get_uem_oauth_token(uem_oauth_url, uem_client_id,
uem_client_secret)
uem_users = get_uem_users(oauth_token)
return render_template('uem.html',
uem_oauth_url=uem_oauth_url,
uem_client_id=uem_client_id,
uem_client_secret=uem_client_secret,
uem_users=uem_users)
def add_service_now_users(filename):
file_to_process = get_file_path(filename)
delimiter = '\t'
with open(file_to_process, 'r') as csv_sample_line:
first_line = csv_sample_line.readline()
if first_line.find(',') > -1:
delimiter = ','
settings = get_settings()
auth_token = get_auth_token(settings)
total_successful = 0
with open(file_to_process, newline='') as user_file:
user_reader = csv.reader(user_file, delimiter=delimiter)
for row in user_reader:
first_name = row[0]
last_name = row[1]
user_name = first_name[0:1].lower() + last_name.lower()
email_address = user_name + '@vmwareex.com'
success = create_sn_user(settings, auth_token, first_name, last_name, email_address, user_name)
if success == 0:
total_successful = total_successful + 1
return total_successful
def get_authorization_header():
settings = get_settings('sendgrid_settings.yaml')
sendgrid_api_key = settings['sendgrid_api_key']
bearer_token = 'Bearer ' + sendgrid_api_key
return bearer_token
def test_get_settings(self):
settings = get_settings('settings.yaml')
self.assertEqual('default', settings['sn_tenant_to_use'])
def test_create_sn_user(self):
settings = get_settings('settings.yaml')
auth_token = get_auth_token(settings)
have_success = create_sn_user(settings, auth_token, 'Doug', 'Lange',
'*****@*****.**', 'dlange')
self.assertEqual(0, have_success)
def test_get_sn_auth_token(self):
settings = get_settings('settings.yaml')
auth_token = get_auth_token(settings)
auth_token_size = len(auth_token)
self.assertEqual(86, auth_token_size)