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_load_customers(cls):
""" Ensure that the delete_customers function deletes all customers"""
assert basic_operations.create_database()
assert basic_operations.get_active_customer_count() == 0
basic_operations.load_customers()
assert basic_operations.get_active_customer_count() > 0
basic_operations.delete_customers()
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_add_customer(cls):
""" Ensure can add a customer to the database """
assert basic_operations.create_database()
added_user = basic_operations.add_customer(0, 'jaimes', 'hernandez',
'101 Elliot Ave. SE',
'205-222-1111',
'*****@*****.**', True, 2000)
assert added_user['customer_id'] > 0
assert added_user['customer_status_id'] > 0
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_get_existing_customer(cls):
"""
Ensure that creating a customer that already exists
gets the existing customer
"""
assert basic_operations.create_database()
basic_operations.load_customers()
customer = basic_operations.create_or_get_customer(
1, '', '', '', '', '')
created_customer = basic_operations.create_or_get_customer(
0, customer.name, customer.last_name, customer.address,
customer.phone_number, customer.email)
assert customer.name == created_customer.name
assert customer.last_name == created_customer.last_name
assert customer.address == created_customer.address
assert customer.phone_number == created_customer.phone_number
assert customer.email == created_customer.email
found = basic_operations.search_customer(1)
assert len(found) == 1
basic_operations.delete_customers()
def test_search_customer_invalid(cls):
""" Ensure proper result when searching for invalid customer """
assert basic_operations.create_database()
assert basic_operations.search_customer(2) is None
def test_database_creation(self):
""" Create the database """
assert basic_operations.create_database()
basic_operations.DATABASE.connect()
assert not basic_operations.DATABASE.is_closed()
def test_list_inactive_customers(cls):
""" Ensure that active customer count is correct """
assert basic_operations.create_database()
basic_operations.load_customers()
assert len(basic_operations.list_inactive_customers()) > 0
basic_operations.delete_customers()
