def test_end_to_end(cls):
""" Lifecyle End To End Test """
basic_operations.create_database()
assert os.path.exists(basic_operations.DATABASE_NAME)
basic_operations.add_customer(0,
'jaimes',
'hernandez',
'101 Elliot Ave. SE',
'205-222-1111',
'*****@*****.**',
True,
2000)
assert basic_operations.search_customer(1)
assert basic_operations.update_customer_credit(1, 2000)
results = basic_operations.search_customer_status(1)
for result in results:
assert int(result['customer_id']) == 1
assert result['status']
assert int(result['credit_limit']) == 2000
assert basic_operations.update_customer_credit(1, 3000)
results = basic_operations.search_customer_status(1)
for result in results:
assert int(result['customer_id']) == 1
assert result['status']
assert int(result['credit_limit']) == 3000
assert int(basic_operations.list_active_customers()) > 0
assert basic_operations.delete_customer(1)
assert int(basic_operations.list_active_customers()) == 0
basic_operations.delete_database()
assert not os.path.exists(basic_operations.DATABASE_NAME)
def test_list_active_customer(cls):
""" Ensure can list all active customers from the database """
assert basic_operations.create_database()
basic_operations.add_customer(0, 'jaimes', 'hernandez',
'101 Elliot Ave. SE', '205-222-1111',
'*****@*****.**', True, 2000)
assert int(basic_operations.get_active_customer_count()) == 1
basic_operations.delete_customers()
def test_search_customer_valid(cls):
""" Ensure can search a customer to the database """
assert basic_operations.create_database()
basic_operations.add_customer(0, 'jaimes', 'hernandez',
'101 Elliot Ave. SE', '205-222-1111',
'*****@*****.**', True, 2000)
assert basic_operations.search_customer(1)
basic_operations.delete_customers()
def test_update_customer_credit_invalid(cls):
"""
Ensure can update an invalid customer's credit in the database fails
"""
assert basic_operations.create_database()
basic_operations.add_customer(0, 'jaimes', 'hernandez',
'101 Elliot Ave. SE', '205-222-1111',
'*****@*****.**', True, 2000)
assert not basic_operations.update_customer_credit(10, 3000)
result = basic_operations.search_customer_status(10)
assert len(result) == 0
basic_operations.delete_customers()
def test_delete_customer_invalid(cls):
""" Ensure can delete a customer from the database """
assert basic_operations.create_database()
basic_operations.add_customer(0, 'jaimes', 'hernandez',
'101 Elliot Ave. SE', '205-222-1111',
'*****@*****.**', True, 2000)
before = basic_operations.get_active_customer_count()
assert before > 0
basic_operations.delete_customer(10)
after = basic_operations.get_active_customer_count()
assert before == after
basic_operations.delete_customers()
def test_update_customer_credit_valid(cls):
""" Ensure can update an active customer's credit in the database """
assert basic_operations.create_database()
basic_operations.add_customer(0, 'jaimes', 'hernandez',
'101 Elliot Ave. SE', '205-222-1111',
'*****@*****.**', True, 2000)
assert basic_operations.update_customer_credit(1, 3000)
results = basic_operations.search_customer_status(1)
for result in results:
assert int(result['customer_id']) == 1
assert result['status']
assert int(result['credit_limit']) == 3000
basic_operations.delete_customers()
def test_add_customer_with_id(cls):
""" Ensure can add a customer to the database with id """
assert basic_operations.create_database()
added_user = basic_operations.add_customer(0, 'jaimes', 'hernandez',
'101 Elliot Ave. SE',
'205-222-1111',
'*****@*****.**', True, 2000)
added_user = basic_operations.add_customer(1, 'jaimes', 'hernandez',
'101 Elliot Ave. SE',
'205-222-1111',
'*****@*****.**', True, 2000)
assert added_user['customer_id'] == 1
assert added_user['customer_status_id'] == 1
basic_operations.delete_customers()
