def test_read_store_manager_appointments(self):
result_dic = (DataAccessFacade.get_instance()).read_store_manager_appointments(["appointee_username",
"store_name",
"appointer_username"],
["EDIT_INV", "DEL_OWNER"]) \
['response']
result_tup = [
(sma['appointee_username'].username, sma['store_name'].store_name,
sma['appointer_username'].username, sma['can_edit_inventory'],
sma['can_delete_owner']) for sma in result_dic
]
self.assertListEqual(result_tup,
[('Anna', "Eytan's store", 'Eytan', True, False)])
result_dic = (DataAccessFacade.get_instance()).read_store_manager_appointments(["appointee_username",
"store_name",
"appointer_username"],
["EDIT_INV", "DEL_OWNER"],
appointee_username="******") \
['response']
result_tup = [
(sma['appointee_username'].username, sma['store_name'].store_name,
sma['appointer_username'].username, sma['can_edit_inventory'],
sma['can_delete_owner']) for sma in result_dic
]
self.assertListEqual(result_tup,
[('Anna', "Eytan's store", 'Eytan', True, False)])
def test_read_statistics(self):
result = (DataAccessFacade.get_instance()).read_statistics(
[], date=self.__today_without_hour)['response']
self.assertListEqual([{
'date':
datetime(datetime.now().year,
datetime.now().month,
datetime.now().day, 0, 0),
'guests':
0,
'subscribers':
0,
'store_managers':
0,
'owners':
0,
'system_managers':
0
}], result)
# Nothing to read
result = (DataAccessFacade.get_instance()).read_statistics(
[], date=datetime(1212,
datetime.now().month,
datetime.now().day))['response']
self.assertListEqual([], result)
def test_delete_users(self):
UserData.get_instance().delete = MagicMock(return_value=0)
self.assertEqual(0, DataAccessFacade.get_instance().delete_users())
UserData.get_instance().delete = MagicMock(return_value=1)
self.assertEqual(1, DataAccessFacade.get_instance().delete_users())
UserData.get_instance().delete = MagicMock(return_value=2)
self.assertEqual(2, DataAccessFacade.get_instance().delete_users())
def test_write_statistic(self):
result = (DataAccessFacade.get_instance()).write_statistic(
datetime(2020, 12, 12), 1, 2, 3, 4, 5)
self.assertTrue(result)
self.assertGreater(
len((DataAccessFacade.get_instance()).read_statistics(
[], guests=1)['response']), 0)
result = DataAccessFacade.get_instance().write_statistic()['response']
self.assertFalse(result)
def test_write_user(self):
UserData.get_instance().write = MagicMock(return_value=0)
self.assertEqual(
0,
DataAccessFacade.get_instance().write_user("eytan", "password"))
UserData.get_instance().write = MagicMock(return_value=1)
self.assertEqual(
1,
DataAccessFacade.get_instance().write_user("eytan", "password"))
def test_delete_products_in_baskets(self):
result = (DataAccessFacade.get_instance()).delete_products_in_baskets(
username="******")['response']
self.assertTrue(result)
self.assertEqual(
len((DataAccessFacade.get_instance()).read_products_in_baskets(
[], username="******")['response']), 0)
result = (DataAccessFacade.get_instance()).delete_products_in_baskets(
username="******")['response']
self.assertTrue(result)
def test_update_statistics(self):
result = (DataAccessFacade.get_instance()).update_statistics(
old_date=self.__today_without_hour, new_guests=3)['response']
self.assertTrue(result)
self.assertGreater(
len((DataAccessFacade.get_instance()).read_statistics(
[], guests=3)['response']), 0)
result = (DataAccessFacade.get_instance()).update_statistics(
old_date=self.__today_without_hour)['response']
self.assertFalse(result)
def test_update_products_in_baskets(self):
result = (DataAccessFacade.get_instance()).update_products_in_baskets(
old_username="******", new_username="******")['response']
self.assertTrue(result)
self.assertGreater(
len((DataAccessFacade.get_instance()).read_products_in_baskets(
[], username="******")['response']), 0)
result = (DataAccessFacade.get_instance()).update_products_in_baskets(
old_username="******")['response']
self.assertFalse(result)
def test_delete_statistics(self):
result = (DataAccessFacade.get_instance()).delete_statistics(
date=self.__today_without_hour)['response']
self.assertTrue(result)
self.assertEqual(
len((DataAccessFacade.get_instance()).read_statistics(
[], date=self.__today_without_hour)['response']), 0)
# Nothing to delete
result = (DataAccessFacade.get_instance()).delete_statistics(
date=self.__today_without_hour)['response']
self.assertTrue(result)
def test_update_users(self):
UserData.get_instance().update = MagicMock(return_value=0)
self.assertEqual(
0,
DataAccessFacade.get_instance().update_users(
new_username="******"))
UserData.get_instance().update = MagicMock(return_value=1)
self.assertEqual(1, DataAccessFacade.get_instance().update_users())
UserData.get_instance().update = MagicMock(return_value=2)
self.assertEqual(2, DataAccessFacade.get_instance().update_users())
def test_write_store(self):
result = (DataAccessFacade.get_instance()).write_store(
"not Eytan's store", "Eytan")['response']
self.assertTrue(result)
self.assertGreater(
len(
(DataAccessFacade.get_instance()).read_stores(
[],
store_name="not Eytan's store",
founder_username="******")['response']), 0)
result = (DataAccessFacade.get_instance()).write_store(
"Anna's store", "not Anna")['response']
self.assertFalse(result)
class RegressionTestsRunner:
# Build test suit
suite = unittest.TestSuite()
loader = unittest.TestLoader()
# add individual tests to the test suite for version 1
# suite.addTest(loader.loadTestsFromTestCase(SystemManagerRoleTests_V1))
# suite.addTest(loader.loadTestsFromTestCase(SubscriberRoleTests_V1))
# suite.addTest(loader.loadTestsFromTestCase(StoreOwnerOrManagerTests_V1))
# suite.addTest(loader.loadTestsFromTestCase(GuestRoleTests_V1))
if not ("testing" in rel_path):
raise ReferenceError(
"The Data Base is not the testing data base.\n"
"\t\t\t\tPlease go to src.main.DataAccessLayer.ConnectionProxy.RealDb.rel_path\n"
"\t\t\t\t and change rel_path to test_rel_path.\n"
"\t\t\t\tThanks :D")
# pass runner the suite and run it
runner = unittest.TextTestRunner(verbosity=2)
runner.run(suite)
(DataAccessFacade.get_instance()).delete_purchases()
# (DataAccessFacade.get_instance()).delete_discount_policies()
(DataAccessFacade.get_instance()).delete_statistics()
(DataAccessFacade.get_instance()).delete_store_owner_appointments()
(DataAccessFacade.get_instance()).delete_products_in_baskets()
(DataAccessFacade.get_instance()).delete_products()
(DataAccessFacade.get_instance()).delete_store_manager_appointments()
(DataAccessFacade.get_instance()).delete_stores()
(DataAccessFacade.get_instance()).delete_users()
def test_update_store_owner_appointments(self):
result = (DataAccessFacade.get_instance()).update_store_owner_appointments(old_appointee_username="******",
new_appointee_username="******") \
['response']
self.assertTrue(result)
self.assertEqual(
len((
DataAccessFacade.get_instance()).read_store_owner_appointments(
appointee_username="******")['response']), 1)
result = (
DataAccessFacade.get_instance()).update_store_owner_appointments(
old_appointee_username="******")['response']
self.assertFalse(result)
def test_write_store_owner_appointment(self):
result = (
DataAccessFacade.get_instance()).write_store_owner_appointment(
"Anna", "Eytan's store", "Eytan")
self.assertTrue(result)
self.assertGreater(
len((
DataAccessFacade.get_instance()).read_store_owner_appointments(
[], appointee_username="******")['response']), 0)
result = (
DataAccessFacade.get_instance()).write_store_owner_appointment(
"Anna", "Eytan's store", "Eytan")['response']
self.assertFalse(result)
def test_delete_stores(self):
(DataAccessFacade.get_instance()).write_store("not Eytan's store",
"Eytan")
# valid
result = (DataAccessFacade.get_instance()
).delete_stores("not Eytan's store")['response']
self.assertTrue(result)
self.assertListEqual([], (DataAccessFacade.get_instance()).read_stores(
[], "not Eytan's store")['response'])
# delete nothing
result = (DataAccessFacade.get_instance()
).delete_stores("not Eytan's store")['response']
self.assertTrue(result)
def test_read_products_in_baskets(self):
(DataAccessFacade.get_instance()).write_products_in_basket(
"Eytan", "Eytan's store", "Eytan's product", 12)
result = (DataAccessFacade.get_instance()).read_products_in_baskets(
[], "Eytan", product_name="Eytan's product")['response']
self.assertEqual(
result[0], {
'username': '******',
'store_name': "Eytan's store",
'product_name': "Eytan's product",
'amount': 12
})
result = (DataAccessFacade.get_instance()).read_products_in_baskets(
[], "Eytan", product_name="Eytans product")['response']
self.assertListEqual([], result)
def test_read_users(self):
UserData.get_instance().read = MagicMock(return_value=[])
self.assertListEqual([], DataAccessFacade.get_instance().read_users())
UserData.get_instance().read = MagicMock(
return_value=[{
"username": "******",
"password": "******",
"is_system_manager": False
}])
self.assertListEqual([{
"username": "******",
"password": "******",
"is_system_manager": False
}],
DataAccessFacade.get_instance().read_users())
def test_update_stores(self):
# update
result = \
(DataAccessFacade.get_instance()).update_stores("Eytan's store", new_founder_username="******")[
'response']
self.assertEqual(1, result)
post_cond_result = [
(e['store_name'], e['founder_username'].username)
for e in (DataAccessFacade.get_instance()
).read_stores([], store_name="Eytan's store")['response']
]
self.assertListEqual([("Eytan's store", "System manager")],
post_cond_result)
result = (DataAccessFacade.get_instance()).update_stores()['response']
self.assertFalse(result)
def tearDown(self) -> None:
(DataAccessFacade.get_instance()).delete_purchases()
# (DataAccessFacade.get_instance()).delete_discount_policies()
(DataAccessFacade.get_instance()).delete_statistics()
(DataAccessFacade.get_instance()).delete_store_owner_appointments()
(DataAccessFacade.get_instance()).delete_products_in_baskets()
(DataAccessFacade.get_instance()).delete_products()
(DataAccessFacade.get_instance()).delete_store_manager_appointments()
(DataAccessFacade.get_instance()).delete_stores()
(DataAccessFacade.get_instance()).delete_users()
def test_update_products(self):
result = (DataAccessFacade.get_instance()).update_products(
new_amount=20)['response']
self.assertTrue(result)
self.assertListEqual(
(DataAccessFacade.get_instance()).read_products(['amount'
])['response'],
[{
'amount': 20
}])
result = (DataAccessFacade.get_instance()).update_products(
old_store_name="Eytan's store",
old_product_name="Eytan's product",
new_amount=11)['response']
self.assertTrue(result)
self.assertListEqual(
(DataAccessFacade.get_instance()).read_products(['amount'
])['response'],
[{
'amount': 11
}])
result = (DataAccessFacade.get_instance()).update_products(
old_amount=20, new_amount=13)['response']
self.assertTrue(result)
self.assertListEqual((DataAccessFacade.get_instance()).read_products(
['amount'], amount=13)['response'], [])
result = (DataAccessFacade.get_instance()).update_products(
old_amount=20)['response']
self.assertFalse(result)
def test_delete_store_manager_appointments(self):
(DataAccessFacade.get_instance()).write_user("Boss Anna", "password")
DataAccessFacade.get_instance().write_store_manager_appointment(
"Boss Anna", "Eytan's store", "Eytan",
["EDIT_INV", "WATCH_PURCHASE_HISTORY"])
# valid
result = (DataAccessFacade.get_instance()).delete_store_manager_appointments(permissions_lst=
["EDIT_INV",
"WATCH_PURCHASE_HISTORY"]) \
['response']
self.assertTrue(result)
self.assertListEqual([], (DataAccessFacade.get_instance()).read_store_manager_appointments([],
[],
"Boss Anna") \
['response'])
# nothing to delete
result = (DataAccessFacade.get_instance()).delete_store_manager_appointments(permissions_lst=
["EDIT_INV",
"WATCH_PURCHASE_HISTORY"]) \
['response']
self.assertTrue(result)
self.assertListEqual([], (DataAccessFacade.get_instance()).read_store_manager_appointments([],
[],
"Boss Anna") \
['response'])
def test_delete_purchases(self):
(DataAccessFacade.get_instance()).write_purchase(
"Lady Anna", "Eytan's store", 12, self.__today_with_hour,
[{
"product_name": "Eytan's product",
"product_price": 12,
"amount": 1
}])
result = (DataAccessFacade.get_instance()).delete_purchases(
username="******", product_name="Eytan's product")
self.assertTrue(result)
self.assertEqual(
len((DataAccessFacade.get_instance()).read_purchases(
[], username="******",
product_name="Eytan's product")['response']), 0)
self.assertGreaterEqual(
len((DataAccessFacade.get_instance()).read_purchases(
[], product_name="Eytan's product")['response']), 1)
def test_update_store_manager_appointments(self):
result = (
DataAccessFacade.get_instance()).update_store_manager_appointments(
old_appointee_username="******",
new_permissions_lst=[
"EDIT_INV", "DEL_OWNER", "WATCH_PURCHASE_HISTORY"
])['response']
self.assertTrue(result)
self.assertEqual(len((DataAccessFacade.get_instance()).read_store_manager_appointments([], [],
permissions_lst= \
[
"WATCH_PURCHASE_HISTORY"])
['response']), 1)
result = (
DataAccessFacade.get_instance()).update_store_manager_appointments(
old_appointee_username="******")['response']
self.assertFalse(result)
def test_write_product(self):
# valid
result = DataAccessFacade.get_instance().write_product(
"not Eytan's product", "Eytan's store", 12.12, "not Eytan's", 12,
0)['response']
self.assertTrue(result)
lst = (DataAccessFacade.get_instance()).read_products(
[], "not Eytan's product")['response']
self.assertEqual(len(lst), 1)
# invalid
result = DataAccessFacade.get_instance().write_product(
"not Eytan's product", "Eytan's store", 12.12, "not Eytan's", 12,
0)['response']
self.assertFalse(result)
self.assertEqual(
len((DataAccessFacade.get_instance()).read_products(
[], "not Eytan's product")['response']), 1)
def test_read_products(self):
result_lst = (DataAccessFacade.get_instance()).read_products(
[], "Eytan's product")['response']
res = [(result['product_name'], result['store_name'].store_name,
result['price'], result['category'], result['amount'],
result['purchase_type']) for result in result_lst]
for r in res:
self.assertEqual(
("Eytan's product", "Eytan's store", 12.12, "Eytan's", 12, 0),
r)
result = (DataAccessFacade.get_instance()).read_products(
["product_name"], "Eytan's product")['response']
for i in result:
self.assertEqual(i['product_name'], "Eytan's product")
result = (DataAccessFacade.get_instance()).read_products(
["product_ame"], "Eytan's product")['response']
self.assertEqual([], result)
def test_write_purchase(self):
result = (DataAccessFacade.get_instance()).write_purchase(
"Lady Anna", "Eytan's store", 12, self.__today_with_hour,
[{
"product_name": "Eytan's product",
"product_price": 12,
"amount": 1
}])
self.assertTrue(result['response'])
x = (DataAccessFacade.get_instance()).read_purchases(
username="******")['response']
self.assertGreater(len(x), 0)
result = (DataAccessFacade.get_instance()).write_purchase(
"Anna", "Eytan's store", 240, self.__today_with_hour,
[{
"product_name": "Eytan's product",
"product_price": 12,
"amount": 20
}])
self.assertFalse(result['response'])
def test_write_user(self):
# Insert 1 with default is_sys_man
result = (DataAccessFacade.get_instance()).write_user(
"Yarin", "Yarin's password")['response']
self.assertTrue(result)
self.assertGreater(
len((DataAccessFacade.get_instance()).read_users(
[], "Yarin", "Yarin's password")['response']), 0)
# Insert 1 with is_sys_man
result = (DataAccessFacade.get_instance()).write_user(
"Yarin2", "Yarin's password", True)['response']
self.assertTrue(result)
self.assertGreater(
len((DataAccessFacade.get_instance()).read_users(
[], "Yarin2", "Yarin's password")['response']), 0)
# Invalid - pk already exist
result = (DataAccessFacade.get_instance()).write_user(
"Yarin", "Eytan")['response']
self.assertFalse(result)
def test_delete_users(self):
# delete specific user
result = (DataAccessFacade.get_instance()).delete_users(
username="******")['response']
self.assertTrue(result)
# insert new user
(DataAccessFacade.get_instance()).write_user("Yarin2",
"Yarin's password", True)
# delete several users
result = (DataAccessFacade.get_instance()).delete_users(
is_system_manager=True)['response']
self.assertTrue(result)
# insert new users
(DataAccessFacade.get_instance()).write_user("Yarin",
"Yarin's password", True)
(DataAccessFacade.get_instance()).write_user("Yarin2",
"Yarin's password", False)
# composite constraint
result = (DataAccessFacade.get_instance()).delete_users(
password="******", is_system_manager=False)
self.assertTrue(result)
def test_read_stores(self):
(DataAccessFacade.get_instance()).write_store("not Eytan's store",
"Eytan")
result = (DataAccessFacade.get_instance()).read_stores(
[], founder_username="******")['response']
new_result = [(e['store_name'], e['founder_username'].username)
for e in result]
self.assertListEqual([("Eytan's store", "Eytan"),
("not Eytan's store", "Eytan")], new_result)
result = (DataAccessFacade.get_instance()).read_stores(
["store_name"], founder_username="******")['response']
self.assertListEqual([{
"store_name": "Eytan's store"
}, {
"store_name": "not Eytan's store"
}], result)
result = (DataAccessFacade.get_instance()).read_stores(
["storename"], founder_username="******")['response']
self.assertFalse(result)
def test_write_store_manager_appointment(self):
(DataAccessFacade.get_instance()).write_user("Boss Anna", "password")
result = DataAccessFacade.get_instance(
).write_store_manager_appointment(
"Boss Anna", "Eytan's store", "Eytan",
["EDIT_INV", "CLOSE_STORE"])['response']
self.assertTrue(result)
managers = [
man['appointee_username'].username
for man in (DataAccessFacade.get_instance()
).read_store_manager_appointments(
["appointee_username"],
appointee_username="******")['response']
]
self.assertListEqual(["Boss Anna"], managers)
# invalid
result = DataAccessFacade.get_instance(
).write_store_manager_appointment(
"Boss Anna", "Eytan's store", "Anna",
["EDIT_INV", "CLOSE_STORE"])['response']
self.assertFalse(result)