def base_test_get_record(self, s):
r = Record(s, 'incident') # s is a SnowRestSession object
found = r.get('c1c535ba85f45540adf94de5b835cd43')
self.assertTrue(found)
self.assertEquals(r.number, 'INC0426232')
self.assertEquals(r.sys_id, 'c1c535ba85f45540adf94de5b835cd43')
self.assertEquals(r.sys_class_name, 'incident')
self.assertEquals(r.short_description, 'Test')
self.assertEquals(r.short_description.get_value(), 'Test')
self.assertEquals(r.short_description.get_display_value(), 'Test')
self.assertFalse(r.short_description.is_reference())
self.assertEquals(r.u_functional_element,
'ea56fb210a0a8c0a015a591ddbed3676')
self.assertEquals(r.u_functional_element.get_value(),
'ea56fb210a0a8c0a015a591ddbed3676')
self.assertEquals(r.u_functional_element.get_display_value(),
'IT Service Management Support')
self.assertTrue(r.u_functional_element.is_reference())
self.assertEquals(r.u_functional_element.get_referenced_table(),
'u_cmdb_ci_functional_services')
self.assertEquals(r.incident_state, '7')
self.assertEquals(r.incident_state.get_value(), '7')
self.assertEquals(r.incident_state.get_display_value(), 'Closed')
self.assertFalse(r.incident_state.is_reference())
def base_test_add_work_note(self, s):
r = Record(s, 'incident', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_add_work_note',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
found = t.get(r.sys_id)
self.assertTrue(found)
updated = t.add_work_note('New work note')
self.assertTrue(updated)
t2 = Task(s)
updated = t2.add_work_note('New work note 2', r.sys_id)
self.assertTrue(updated)
t3 = Task(s)
updated = t3.add_work_note('New work note 3', ('number', r.number))
self.assertTrue(updated)
# Visibility=CERN, and already closed
inc_list = inc_query.query(query_filter={
'u_functional_element': 'ea56fb210a0a8c0a015a591ddbed3676',
'u_visibility': 'cern',
'active': 'false'
})
# Same query with encoded query
inc_list = inc_query.query(
query_encoded="u_functional_element=ea56fb210a0a8c0a015a591ddbed3676^"
"u_visibility=cern^active=false")
for record in inc_list:
print record.number + " " + record.short_description
# Inserting a new Outage (without using the Outage class)
otg = Record(s, 'cmdb_ci_outage')
otg.u_publication_ssb = 'true'
otg.u_publication_c_report = 'true'
otg.short_description = 'Planned intervention in ServiceNow'
otg.u_service_element = 'e85a3f3b0a0a8c0a006a2912f2f352d1' # Service Element "ServiceNow"
otg.u_functional_element = '579fb3d90a0a8c08017ac8a1137c8ee6' # Functional Element "ServiceNow"
otg.type = 'planned'
otg.u_impact = 'degraded'
otg.begin = '2017-11-22 14:00:00' # UTC timezone
otg.end = '2017-11-22 15:00:00' # UTC timezone
otg.u_visibility = 'cern'
otg.u_description = "Description for the SSB"
otg.u_publication_start_date = '2017-11-22'
otg.u_publication_end_date = '2017-11-24'
otg.u_technical_description = "Description for C5 report"
otg.insert()
def base_test_insert_record(self, s):
# incident test
r = Record(
s,
'incident',
{
'short_description':
self.short_description_prefix + ' test_insert_record_1',
'u_business_service':
'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element':
'579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'comments': "Initial description"
})
self.assertTrue(r.get_can_insert())
inserted = r.insert()
r2 = Record(s, 'incident')
found = r2.get(r.sys_id)
self.assertTrue(inserted)
self.assertTrue(found)
self.assertEquals(r.number, r2.number)
self.assertEquals(r.short_description, r2.short_description)
self.assertEquals(r.u_business_service, r2.u_business_service)
self.assertEquals(r.u_functional_element, r2.u_functional_element)
self.assertEquals(r.comments, r2.comments)
# request test
r = Record(s, 'u_request_fulfillment')
self.assertTrue(r.get_can_insert())
r.short_description = self.short_description_prefix + ' test_insert_record_2'
r.u_business_service = 'e85a3f3b0a0a8c0a006a2912f2f352d1' # Service Element "ServiceNow"
r.u_functional_element = '579fb3d90a0a8c08017ac8a1137c8ee6' # Functional Element "ServiceNow"
r.comments = "Initial description"
inserted = r.insert()
r2 = Record(s, 'u_request_fulfillment')
found = r2.get(r.sys_id)
self.assertTrue(inserted)
self.assertTrue(found)
self.assertEquals(r.number, r2.number)
self.assertEquals(r.short_description, r2.short_description)
self.assertEquals(r.u_business_service, r2.u_business_service)
self.assertEquals(r.u_functional_element, r2.u_functional_element)
self.assertEquals(r.comments, r2.comments)
# cannot insert test
r = Record(s, 'task')
self.assertFalse(r.get_can_insert())
def base_test_update_record(self, s):
r = Record(
s,
'incident',
{ # s is a SnowRestSession object
'short_description':
self.short_description_prefix + ' test_update_record',
'u_business_service':
'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element':
'579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
r2 = Record(s, 'incident')
found = r2.get(('number', r.number))
self.assertTrue(found)
self.assertEquals(r.number, r2.number)
self.assertEquals(
r2.short_description,
self.short_description_prefix + ' test_update_record')
r2.watch_list = '*****@*****.**'
updated = r2.update()
self.assertTrue(updated)
r3 = Record(s, 'incident')
found = r3.get(('number', r.number))
self.assertTrue(found)
self.assertEquals(r3.watch_list, '*****@*****.**')
r4 = Record(s, 'incident')
r4.watch_list = '*****@*****.**'
updated = r4.update(r.sys_id)
self.assertTrue(updated)
r5 = Record(s, 'incident')
found = r5.get(('number', r.number))
self.assertTrue(found)
self.assertEquals(r5.watch_list, '*****@*****.**')
r6 = Record(s, 'incident')
r6.watch_list = '*****@*****.**'
updated = r6.update(('number', r.number))
self.assertTrue(updated)
r7 = Record(s, 'incident')
found = r7.get(('number', r.number))
self.assertTrue(found)
self.assertEquals(r7.watch_list, '*****@*****.**')
def base_test_task_insert(self, s):
# incident test
t = Task(s, 'incident', {
'short_description': self.short_description_prefix + ' test_insert_task_1',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
self.assertTrue(t.get_can_insert())
inserted = t.insert()
self.assertTrue(inserted)
self.assertTrue(t.sys_id is not None)
self.assertEquals(t.get_table_name(), 'incident')
self.assertEquals(t.sys_class_name, 'incident')
self.assertEquals(t.short_description, self.short_description_prefix + ' test_insert_task_1')
self.assertEquals(t.u_business_service, 'e85a3f3b0a0a8c0a006a2912f2f352d1')
self.assertEquals(t.u_functional_element, '579fb3d90a0a8c08017ac8a1137c8ee6')
self.assertEquals(t.assignment_group, 'd34218f3b4a3a4006d2153f17c76edff')
self.assertEquals(t.description, 'Initial description')
self.assertEquals(t.incident_state, '2')
r = Record(s, 'incident')
found = r.get(t.sys_id)
self.assertTrue(found)
self.assertEquals(r.sys_class_name, 'incident')
self.assertEquals(r.short_description, self.short_description_prefix + ' test_insert_task_1')
self.assertEquals(r.u_business_service, 'e85a3f3b0a0a8c0a006a2912f2f352d1')
self.assertEquals(r.u_functional_element, '579fb3d90a0a8c08017ac8a1137c8ee6')
self.assertEquals(r.assignment_group, 'd34218f3b4a3a4006d2153f17c76edff')
self.assertEquals(r.description, 'Initial description')
self.assertEquals(r.incident_state, '2')
# request test
t = Task(s, 'u_request_fulfillment')
t.short_description = self.short_description_prefix + ' test_insert_task_2'
t.u_business_service = 'e85a3f3b0a0a8c0a006a2912f2f352d1' # Service Element "ServiceNow"
t.u_functional_element = '579fb3d90a0a8c08017ac8a1137c8ee6' # Functional Element "ServiceNow"
t.assignment_group = 'd34218f3b4a3a4006d2153f17c76edff' # ServiceNow 4th line
t.comments = "Initial description"
inserted = t.insert()
self.assertTrue(t.get_can_insert())
self.assertTrue(inserted)
self.assertTrue(t.sys_id is not None)
self.assertEquals(t.get_table_name(), 'u_request_fulfillment')
self.assertEquals(t.sys_class_name, 'u_request_fulfillment')
self.assertEquals(t.short_description, self.short_description_prefix + ' test_insert_task_2')
self.assertEquals(t.u_business_service, 'e85a3f3b0a0a8c0a006a2912f2f352d1')
self.assertEquals(t.u_functional_element, '579fb3d90a0a8c08017ac8a1137c8ee6')
self.assertEquals(t.assignment_group, 'd34218f3b4a3a4006d2153f17c76edff')
self.assertEquals(t.description, 'Initial description')
self.assertEquals(t.u_current_task_state, '2')
r = Record(s, 'u_request_fulfillment')
found = r.get(t.sys_id)
self.assertTrue(found)
self.assertEquals(r.sys_class_name, 'u_request_fulfillment')
self.assertEquals(r.short_description, self.short_description_prefix + ' test_insert_task_2')
self.assertEquals(r.u_business_service, 'e85a3f3b0a0a8c0a006a2912f2f352d1')
self.assertEquals(r.u_functional_element, '579fb3d90a0a8c08017ac8a1137c8ee6')
self.assertEquals(r.assignment_group, 'd34218f3b4a3a4006d2153f17c76edff')
self.assertEquals(r.description, 'Initial description')
self.assertEquals(r.u_current_task_state, '2')
# insertion without specifying table test
t = Task(s)
self.assertFalse(t.get_can_insert())
self.assertRaises(SnowClientException, Task.insert, t)
def base_test_resolve(self, s):
# first test: insert an incident, get it, resolve it. No close code provided
r = Record(s, 'incident', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_resolve',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
found = t.get(r.sys_id)
self.assertTrue(found)
updated = t.resolve('Solution text')
self.assertTrue(updated)
r2 = Record(s, 'incident')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.incident_state, '6')
self.assertTrue(r2.state, '6')
self.assertTrue(r2.u_solution, 'Solution text')
self.assertTrue(r2.u_close_code, 'Restored')
self.assertTrue(r2.assigned_to, self.current_user)
# second test: insert an incident, resolve it providing the sys_id. No close code provided
r = Record(s, 'incident', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_resolve_2',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
updated = t.resolve('Solution text', key=r.sys_id)
self.assertTrue(updated)
r2 = Record(s, 'incident')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.incident_state, '6')
self.assertTrue(r2.state, '6')
self.assertTrue(r2.u_solution, 'Solution text')
self.assertTrue(r2.u_close_code, 'Restored')
self.assertTrue(r2.assigned_to, self.current_user)
# third test: insert an incident, resolve it providing the number. No close code provided
r = Record(s, 'incident', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_resolve_3',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
updated = t.resolve('Solution text', key=('number', r.number))
self.assertTrue(updated)
r2 = Record(s, 'incident')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.incident_state, '6')
self.assertTrue(r2.state, '6')
self.assertTrue(r2.u_solution, 'Solution text')
self.assertTrue(r2.u_close_code, 'Restored')
self.assertTrue(r2.assigned_to, self.current_user)
# fourth test: insert an incident, get it, resolve it. Provide a non-default close code
r = Record(s, 'incident', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_resolve_4',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
found = t.get(r.sys_id)
self.assertTrue(found)
updated = t.resolve('Solution text', 'Not Reproducible')
self.assertTrue(updated)
r2 = Record(s, 'incident')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.incident_state, '6')
self.assertTrue(r2.state, '6')
self.assertTrue(r2.u_solution, 'Solution text')
self.assertTrue(r2.u_close_code, 'Not Reproducible')
self.assertTrue(r2.assigned_to, self.current_user)
# fifth test: insert a request, get it, resolve it. No close code provided
r = Record(s, 'u_request_fulfillment', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_resolve',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
found = t.get(r.sys_id)
self.assertTrue(found)
updated = t.resolve('Solution text')
self.assertTrue(updated)
r2 = Record(s, 'u_request_fulfillment')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.u_current_task_state, '9')
self.assertTrue(r2.state, '6')
self.assertTrue(r2.u_solution, 'Solution text')
self.assertTrue(r2.u_close_code, 'Fulfilled')
self.assertTrue(r2.assigned_to, self.current_user)
# sixth test: insert a request, resolve it by providing the number. Provide a non-default close code
r = Record(s, 'u_request_fulfillment', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_resolve_2',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
updated = t.resolve('Solution text', 'Not authorised', ('number', r.number))
self.assertTrue(updated)
r2 = Record(s, 'u_request_fulfillment')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.u_current_task_state, '9')
self.assertTrue(r2.state, '6')
self.assertTrue(r2.u_solution, 'Solution text')
self.assertTrue(r2.u_close_code, 'Not authorised')
self.assertTrue(r2.assigned_to, self.current_user)
def base_test_take_in_progress(self, s):
# first test: insert an incident, get it, take it in progress
r = Record(s, 'incident', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_take_in_progress',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
found = t.get(r.sys_id)
self.assertTrue(found)
updated = t.take_in_progress()
self.assertTrue(updated)
r2 = Record(s, 'incident')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.incident_state, '3')
self.assertTrue(r2.state, '2')
self.assertTrue(r2.assigned_to, self.current_user)
# second test: insert an incident, take it in progress by providing the sys_id
r = Record(s, 'incident', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_take_in_progress_2',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
updated = t.take_in_progress(key=r.sys_id)
self.assertTrue(updated)
r2 = Record(s, 'incident')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.incident_state, '3')
self.assertTrue(r2.state, '2')
self.assertTrue(r2.assigned_to, self.current_user)
# third test: insert an incident, take it in progress by providing the number
r = Record(s, 'incident', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_take_in_progress_3',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
updated = t.take_in_progress(key=('number', r.number))
self.assertTrue(updated)
r2 = Record(s, 'incident')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.incident_state, '3')
self.assertTrue(r2.state, '2')
self.assertTrue(r2.assigned_to, self.current_user)
# fourth test: insert a request, get it, take it in progress
r = Record(s, 'u_request_fulfillment', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_take_in_progress_4',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
found = t.get(r.sys_id)
self.assertTrue(found)
updated = t.take_in_progress()
self.assertTrue(updated)
r2 = Record(s, 'u_request_fulfillment')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.u_current_task_state, '4')
self.assertTrue(r2.state, '2')
self.assertTrue(r2.assigned_to, self.current_user)
# fifth test: insert an request, take it in progress by providing the sys_id
r = Record(s, 'u_request_fulfillment', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_take_in_progress_5',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
updated = t.take_in_progress(key=r.sys_id)
self.assertTrue(updated)
r2 = Record(s, 'u_request_fulfillment')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.u_current_task_state, '4')
self.assertTrue(r2.state, '2')
self.assertTrue(r2.assigned_to, self.current_user)
# sixth test: insert an request, take it in progress by providing the number
r = Record(s, 'u_request_fulfillment', { # s is a SnowRestSession object
'short_description': self.short_description_prefix + ' test_take_in_progress_6',
'u_business_service': 'e85a3f3b0a0a8c0a006a2912f2f352d1', # Service Element "ServiceNow"
'u_functional_element': '579fb3d90a0a8c08017ac8a1137c8ee6', # Functional Element "ServiceNow"
'assignment_group': 'd34218f3b4a3a4006d2153f17c76edff', # ServiceNow 4th line
'comments': "Initial description"
})
inserted = r.insert()
self.assertTrue(inserted)
t = Task(s)
updated = t.take_in_progress(key=('number', r.number))
self.assertTrue(updated)
r2 = Record(s, 'u_request_fulfillment')
found = r2.get(r.sys_id)
self.assertTrue(found)
self.assertTrue(r2.u_current_task_state, '4')
self.assertTrue(r2.state, '2')
self.assertTrue(r2.assigned_to, self.current_user)