def test_searchBytickets_wrong_column(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result = search_engine.search_by_tickets(conn, 'wrong column', '34')
self.assertIsNotNone(conn)
self.assertEqual(len(result), 0)
conn.close()
def test_createDataBase_one(self):
conn = database.create_data_base(["test.json"])
cursor = conn.execute(
"SELECT name FROM sqlite_master WHERE type='table';")
result = cursor.fetchall()[0][0]
self.assertIsNotNone(conn)
self.assertEqual(result, 'test')
conn.close()
def test_searchByTickets_assignee_id(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result = search_engine.search_by_tickets(conn, 'assignee_id', '24')
self.assertIsNotNone(conn)
self.assertEqual(result[0]['_id'],
'436bf9b0-1147-4c0a-8439-6f79833bff5b')
self.assertEqual(result[0]['user_name'], 'Elma Castro')
self.assertEqual(result[0]['organization_name'], 'Zentry')
conn.close()
def test_searchByTickets_empty_description(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result = search_engine.search_by_tickets(conn, 'description')
self.assertIsNotNone(conn)
self.assertEqual(result[0]['_id'],
'4cce7415-ef12-42b6-b7b5-fb00e24f9cc1')
self.assertEqual(result[0]['user_name'], 'Josefa Mcfadden')
self.assertEqual(result[0]['organization_name'], 'Xylar')
conn.close()
def test_searchByUser_role(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2 = search_engine.search_by_user(
conn, 'role', 'admin')
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '1')
self.assertEqual(result_1[0]['name'], 'Francisca Rasmussen')
self.assertEqual(result_1[0]['organization_name'], 'Multron')
conn.close()
def test_searchByUser_suspended(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2 = search_engine.search_by_user(
conn, 'suspended', False)
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '2')
self.assertEqual(result_1[0]['name'], 'Cross Barlow')
self.assertEqual(result_1[0]['organization_name'], 'Qualitern')
conn.close()
def test_searchByUser_email(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2 = search_engine.search_by_user(
conn, 'email', '*****@*****.**')
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '2')
self.assertEqual(result_1[0]['name'], 'Cross Barlow')
self.assertEqual(result_1[0]['organization_name'], 'Qualitern')
conn.close()
def test_searchByUser_last_login_at(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2 = search_engine.search_by_user(
conn, 'last_login_at', '2013-08-04T01:03:27 -10:00')
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '1')
self.assertEqual(result_1[0]['name'], 'Francisca Rasmussen')
self.assertEqual(result_1[0]['organization_name'], 'Multron')
conn.close()
def test_searchByUser_tags(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2 = search_engine.search_by_user(
conn, 'tags',
["Springville", "Sutton", "Hartsville/Hartley", "Diaperville"])
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '1')
self.assertEqual(result_1[0]['name'], 'Francisca Rasmussen')
self.assertEqual(result_1[0]['organization_name'], 'Multron')
conn.close()
def test_searchByTickets_subject(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result = search_engine.search_by_tickets(
conn, 'subject', 'A Catastrophe in Micronesia')
self.assertIsNotNone(conn)
self.assertEqual(result[0]['_id'],
'1a227508-9f39-427c-8f57-1b72f3fab87c')
self.assertEqual(result[0]['subject'], 'A Catastrophe in Micronesia')
self.assertEqual(result[0]['user_name'], 'Prince Hinton')
self.assertEqual(result[0]['organization_name'], 'Quilk')
conn.close()
def test_searchByUser_verified(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2 = search_engine.search_by_user(
conn, 'verified', True)
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '1')
self.assertEqual(result_1[0]['name'], 'Francisca Rasmussen')
self.assertEqual(result_1[0]['organization_name'], 'Multron')
self.assertEqual(result_1[-1]['_id'], '75')
self.assertEqual(result_1[-1]['name'], 'Catalina Simpson')
self.assertEqual(result_1[-1]['organization_name'], 'Multron')
conn.close()
def test_searchByOrganization_created_at(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2, result_3 = search_engine.search_by_organization(
conn, 'created_at', '2016-07-23T09:48:02 -10:00')
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '106')
self.assertEqual(result_1[0]['name'], 'Qualitern')
self.assertEqual(result_1[0]['external_id'],
'2355f080-b37c-44f3-977e-53c341fde146')
self.assertEqual(result_2[0][1], 'A Nuisance in Greece')
self.assertEqual(result_3[0][1], 'Cross Barlow')
conn.close()
def test_searchByUser_locale(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2 = search_engine.search_by_user(
conn, 'locale', 'en-AU')
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '1')
self.assertEqual(result_1[0]['name'], 'Francisca Rasmussen')
self.assertEqual(result_1[0]['organization_name'], 'Multron')
self.assertEqual(result_1[-1]['_id'], '74')
self.assertEqual(result_1[-1]['name'], 'Melissa Bishop')
self.assertEqual(result_1[-1]['organization_name'], 'Isotronic')
conn.close()
def test_searchByOrganization_tags(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2, result_3 = search_engine.search_by_organization(
conn, 'tags', ["Nolan", "Rivas", "Morse", "Conway"])
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '106')
self.assertEqual(result_1[0]['name'], 'Qualitern')
self.assertEqual(result_1[0]['external_id'],
'2355f080-b37c-44f3-977e-53c341fde146')
self.assertEqual(result_2[0][1], 'A Nuisance in Greece')
self.assertEqual(result_3[0][1], 'Cross Barlow')
conn.close()
def test_searchByUser_active(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2 = search_engine.search_by_user(
conn, 'active', False)
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '3')
self.assertEqual(result_1[0]['name'], 'Ingrid Wagner')
self.assertEqual(result_1[0]['organization_name'], 'Xylar')
self.assertEqual(result_1[-1]['_id'], '75')
self.assertEqual(result_1[-1]['name'], 'Catalina Simpson')
self.assertEqual(result_1[-1]['organization_name'], 'Multron')
conn.close()
def test_searchByTickets_tags(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result = search_engine.search_by_tickets(conn, 'tags', [
"Ohio", "Pennsylvania", "American Samoa",
"Northern Mariana Islands"
])
self.assertIsNotNone(conn)
self.assertEqual(result[0]['_id'],
'436bf9b0-1147-4c0a-8439-6f79833bff5b')
self.assertEqual(result[0]['user_name'], 'Elma Castro')
self.assertEqual(result[0]['organization_name'], 'Zentry')
conn.close()
def test_searchByOrganization_url(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2, result_3 = search_engine.search_by_organization(
conn, 'url', 'http://initech.zendesk.com/api/v2'
'/organizations/106.json')
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '106')
self.assertEqual(result_1[0]['name'], 'Qualitern')
self.assertEqual(result_1[0]['external_id'],
'2355f080-b37c-44f3-977e-53c341fde146')
self.assertEqual(result_2[0][1], 'A Nuisance in Greece')
self.assertEqual(result_3[0][1], 'Cross Barlow')
conn.close()
def test_searchByUser_user_id(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2 = search_engine.search_by_user(conn, '_id', '75')
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '75')
self.assertEqual(result_1[0]['name'], 'Catalina Simpson')
self.assertEqual(result_1[0]['organization_id'], '119')
self.assertEqual(result_1[0]['organization_name'], 'Multron')
self.assertEqual(tuple(result_2[0])[1], 'A Problem in Switzerland')
self.assertEqual(
tuple(result_2[1])[1],
'A Problem in Svalbard and Jan Mayen Islands')
conn.close()
def test_searchByTickets_via(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result = search_engine.search_by_tickets(conn, 'via', 'web')
self.assertIsNotNone(conn)
self.assertEqual(result[0]['_id'],
'436bf9b0-1147-4c0a-8439-6f79833bff5b')
self.assertEqual(result[0]['user_name'], 'Elma Castro')
self.assertEqual(result[0]['organization_name'], 'Zentry')
self.assertEqual(result[-1]['_id'],
'59d803f6-a9cd-448c-a6bd-91ce9f044305')
self.assertEqual(result[-1]['user_name'], 'Key Mendez')
self.assertEqual(result[-1]['organization_name'], 'Comtext')
conn.close()
def test_searchByTickets_has_incidents(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result = search_engine.search_by_tickets(conn, 'has_incidents', False)
self.assertIsNotNone(conn)
self.assertEqual(result[0]['_id'],
'436bf9b0-1147-4c0a-8439-6f79833bff5b')
self.assertEqual(result[0]['user_name'], 'Elma Castro')
self.assertEqual(result[0]['organization_name'], 'Zentry')
self.assertEqual(result[-1]['_id'],
'50f3fdbd-f8a6-481d-9bf7-572972856628')
self.assertEqual(result[-1]['user_name'], 'Geneva Poole')
self.assertEqual(result[-1]['organization_name'], 'Strezzö')
conn.close()
def test_searchByTickets_priority(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result = search_engine.search_by_tickets(conn, 'priority', 'high')
self.assertIsNotNone(conn)
self.assertEqual(result[0]['_id'],
'436bf9b0-1147-4c0a-8439-6f79833bff5b')
self.assertEqual(result[0]['user_name'], 'Elma Castro')
self.assertEqual(result[0]['organization_name'], 'Zentry')
self.assertEqual(result[-1]['_id'],
'50dfc8bc-31de-411e-92bf-a6d6b9dfa490')
self.assertEqual(result[-1]['user_name'], 'Charlene Coleman')
self.assertEqual(result[-1]['organization_name'], 'Plasmos')
conn.close()
def test_searchByTickets_description(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result = search_engine.search_by_tickets(
conn, 'description',
'Nostrud ad sit velit cupidatat laboris ipsum nisi amet laboris ex '
'exercitation amet et proident. Ipsum fugiat aute dolore tempor '
'nostrud velit ipsum.')
self.assertIsNotNone(conn)
self.assertEqual(result[0]['_id'],
'436bf9b0-1147-4c0a-8439-6f79833bff5b')
self.assertEqual(result[0]['user_name'], 'Elma Castro')
self.assertEqual(result[0]['organization_name'], 'Zentry')
conn.close()
def test_searchByOrganization_details(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2, result_3 = search_engine.search_by_organization(
conn, 'details', 'Artisân')
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '106')
self.assertEqual(result_1[0]['name'], 'Qualitern')
self.assertEqual(result_1[0]['external_id'],
'2355f080-b37c-44f3-977e-53c341fde146')
self.assertEqual(result_1[-1]['_id'], '114')
self.assertEqual(result_1[-1]['name'], 'Isotronic')
self.assertEqual(result_1[-1]['external_id'],
'49c97d6a-f1ec-422e-aabe-8a429e81e656')
conn.close()
def test_searchByOrganization_shared_tickets(self):
conn = database.create_data_base(
["users.json", "organizations.json", "tickets.json"])
result_1, result_2, result_3 = search_engine.search_by_organization(
conn, 'shared_tickets', False)
self.assertIsNotNone(conn)
self.assertEqual(result_1[0]['_id'], '101')
self.assertEqual(result_1[0]['name'], 'Enthaze')
self.assertEqual(result_1[0]['external_id'],
'9270ed79-35eb-4a38-a46f-35725197ea8d')
self.assertEqual(result_1[-1]['_id'], '125')
self.assertEqual(result_1[-1]['name'], 'Strezzö')
self.assertEqual(result_1[-1]['external_id'],
'42a1a845-70cf-40ed-a762-acb27fd606cc')
conn.close()
def run_application():
# Messages
welcome = '\n\nWelcome to Zendesk Search'
information_text_1 = 'Type "quit" to exit at any time, Press "Enter" to continue\n'
information_text_2 = '\t\tSelect search options:\n\t\t* Press 1 to search\n\t\t* Press 2 to view a list of ' \
'searchable field\n\t\t* Type "quit" to exit\n '
information_text_3 = '\t\tSelect table:\n\t\t* Select 1 users\n\t\t* Select 2 organizations\n\t\t* Select 3 ' \
'tickets\n '
# Data base initialization
json_files = ["users.json", "organizations.json", "tickets.json"]
connection = create_data_base(json_files)
# Start our application
print(f'{welcome}')
command = input(information_text_1)
# Exit any time
while not command == 'quit':
# Client press "Enter"
if command == '':
# Exit any time
while not command == 'quit':
# Display options
command = input(information_text_2)
# Selected Search option
if command == '1':
# Exit any time
while not command == 'quit':
# Display table options
command = input(information_text_3)
# Selected users table
if command == '1':
# Enter search column
search_attr = input('Enter search term\n')
# Enter search value
search_value = input('Enter search value\n')
# Searching
search_by_user(connection, search_attr,
search_value)
# Selected organizations table
elif command == '2':
# Enter search column
search_attr = input('Enter search term\n')
# Enter search value
search_value = input('Enter search value\n')
# Searching
search_by_organization(connection, search_attr,
search_value)
# Selected tickets table
elif command == '3':
# Enter search column
search_attr = input('Enter search term\n')
# Enter search value
search_value = input('Enter search value\n')
# Searching
search_by_tickets(connection, search_attr,
search_value)
# Selected Searchable field list option
elif command == '2':
searchable_fields(connection)
else:
command = input(information_text_1)
# Close connection and free up the memory
connection.close()
print('Good Bye')
