def test_modify_allocation_invalid(self):
userId = f.signUp("Amy", "12345")
groupId = f.createEmptyGroup("Group", userId)
orderId = f.createOrder(groupId, "Order", 5)
oriAmount = 124.3
itemId = f.createItem("item", 124.3, orderId)
prevAlloAmount = 110
curAlloAmount = 150
a_id = f.createAllocation(userId, itemId, prevAlloAmount)
check = f.modifyAllocatedAmount(a_id, curAlloAmount)
self.assertFalse(check)
result = q.selectAllByConditions(
"Allocations",
"allo_id = '%s'",
str(a_id),
)[0]
self.assertEqual(result['allo_amount'], prevAlloAmount)
self.assertEqual(
q.selectInfoByConditions(
"Items",
"left_amount",
"item_id = '%s'",
result['item_id'],
)[0]['left_amount'],
round(oriAmount - prevAlloAmount, 4),
)
def test_create_allocation_invalid(self):
# No exsiting allocation
self.assertEqual(
q.getNumOfRecordByConditions("Allocations", ),
0,
) #
userId = f.signUp("Amy", "12345")
groupId = f.createEmptyGroup("Group", userId)
orderId = f.createOrder(groupId, "Order", 5)
oriAmount = 124.3
itemId = f.createItem("item", oriAmount, orderId)
alloAmount = 150
a_id = f.createAllocation(userId, itemId, alloAmount)
result_list = q.selectInfoByConditions(
"Items",
"left_amount",
"item_id = '%s'",
itemId,
)
self.assertEqual(a_id, -1)
self.assertEqual(len(result_list), 1)
self.assertEqual(result_list[0]['left_amount'], oriAmount) # remains
numOfRecords = q.getNumOfRecordByConditions(
"Allocations",
"item_id = '%s' AND user_id = '%s'",
(itemId, userId),
)
self.assertEqual(numOfRecords, 0)
def test_delete_allocation(self):
userId = f.signUp("Amy", "12345")
groupId = f.createEmptyGroup("Group", userId)
orderId = f.createOrder(groupId, "Order", 5)
oriAmount = 124.3
itemId = f.createItem("item", 124.3, orderId)
alloAmount = 110
a_id = f.createAllocation(userId, itemId, alloAmount)
check = f.deleteAllocation(a_id)
self.assertTrue(check)
self.assertEqual(
q.getNumOfRecordByConditions(
"Allocations",
"allo_id = '%s'",
a_id,
),
0,
)
self.assertEqual(
q.selectInfoByConditions(
"Items",
"left_amount",
"item_id = '%s'",
itemId,
)[0]['left_amount'],
oriAmount,
)
def test_modify_item_amount(self):
groupId = f.createEmptyGroup("Group", f.signUp("Owner", "12345"))
orderId = f.createOrder(groupId, "Order", 5)
itemPrevAmount = 124.3
itemCurAmount_valid = 150
itemCurAmount_small = -34
itemCurAmount_Large = 1001
itemId = f.createItem("itemOld", 124.3, orderId)
check = f.modifyItemAmount(itemId, itemCurAmount_valid)
result_list = q.selectInfoByConditions(
"Items",
"left_amount",
"item_id = '%s'",
itemId,
)
self.assertTrue(check)
self.assertEqual(len(result_list), 1)
self.assertEqual(result_list[0]['left_amount'], itemCurAmount_valid)
f.modifyItemAmount(itemId, itemPrevAmount) # reset
# Too small
check = f.modifyItemAmount(itemId, itemCurAmount_small)
result_list = q.selectInfoByConditions(
"Items",
"left_amount",
"item_id = '%s'",
itemId,
)
self.assertFalse(check)
self.assertEqual(len(result_list), 1)
self.assertEqual(
result_list[0]['left_amount'],
itemPrevAmount,
) # remains
# Too large
check = f.modifyItemAmount(itemId, itemCurAmount_Large)
result_list = q.selectInfoByConditions(
"Items",
"left_amount",
"item_id = '%s'",
itemId,
)
self.assertFalse(check)
self.assertEqual(len(result_list), 1)
self.assertEqual(
result_list[0]['left_amount'],
itemPrevAmount,
) # remains
def test_delete_item(self):
groupId = f.createEmptyGroup("Group", f.signUp("Owner", "12345"))
orderId = f.createOrder(groupId, "Order", 5)
itemId = f.createItem("item1", 124.3, orderId)
f.deleteItem(itemId)
numOfRecords = q.getNumOfRecordByConditions(
"Items",
"item_id = '%s'",
itemId,
)
self.assertEqual(numOfRecords, 0)
def test_create_receipt(self):
# No exsiting receipt
self.assertEqual(q.getNumOfRecordByConditions("OrderReceipts"), 0)
groupId = f.createEmptyGroup("Group", f.signUp("Owner", "12345"))
orderId = f.createOrder(groupId, "Order", 5)
receiptIdx = 1
f.createReceipt(orderId, "abc.jpg", receiptIdx)
numOfRecords = q.getNumOfRecordByConditions(
"OrderReceipts",
" order_id = '%s' AND receipt_idx = '%s'",
(orderId, receiptIdx),
)
self.assertEqual(numOfRecords, 1)
def test_delete_order(self):
ownerId = f.signUp("Owner", "12345")
groupId = f.createEmptyGroup("Group", ownerId)
orderName = "Order0"
numOfItems = 5
orderId = f.createOrder(groupId, orderName, numOfItems)
f.deleteOrder(orderId)
numOfRecord = q.getNumOfRecordByConditions(
"Orders",
"order_id = '%s'",
str(orderId),
)
self.assertEqual(numOfRecord, 0)
def test_create_item(self):
# No exsiting receipt
self.assertEqual(q.getNumOfRecordByConditions("Items"), 0)
groupId = f.createEmptyGroup("Group", f.signUp("Owner", "12345"))
orderId = f.createOrder(groupId, "Order", 5)
itemName = "item1"
leftAmount = 124.3
itemId = f.createItem(itemName, leftAmount, orderId)
numOfRecords = q.getNumOfRecordByConditions(
"Items",
" order_id = '%s' AND item_name = '%s' AND left_amount = '%s'",
(orderId, itemName, leftAmount),
)
self.assertEqual(numOfRecords, 1)
self.assertEqual(itemId, 1)
def test_create_order(self):
ownerId = f.signUp("Owner", "12345")
groupId = f.createEmptyGroup("Group", ownerId)
orderName = "Order0"
numOfItems = 5
self.assertEqual(
q.getNumOfRecordByConditions("Orders", ),
0,
) # No exsiting group
orderId = f.createOrder(groupId, orderName, numOfItems)
result_list = q.selectAllByConditions("Orders")
self.assertEqual(len(result_list), 1)
self.assertEqual(result_list[0]['order_id'], 1)
self.assertEqual(result_list[0]['group_id'], groupId)
self.assertEqual(result_list[0]['order_name'], orderName)
self.assertEqual(result_list[0]['item_unres_num'], numOfItems)
def test_modify_item_name(self):
groupId = f.createEmptyGroup("Group", f.signUp("Owner", "12345"))
orderId = f.createOrder(groupId, "Order", 5)
itemOldName = "itemOld"
itemNewName = "itemNew"
itemId = f.createItem(itemOldName, 124.3, orderId)
check = f.modifyItemName(itemId, itemNewName)
result_list = q.selectInfoByConditions(
"Items",
"item_name",
"item_id = '%s'",
itemId,
)
self.assertTrue(check)
self.assertEqual(len(result_list), 1)
self.assertEqual(result_list[0]['item_name'], itemNewName)
def cruapi_models(table):
'''
:param table: model name on which the operation needs to be performed
:return: status code in case of post and put .. status code and data from tables in case of get call
Description: call the respective function as per table name and pass the json data to it
'''
if table is None or table not in ['sku', 'storage', 'order', 'orderline']:
data = {
'payload': {
'message': 'Undefined id or Table name'
},
'status_code':
300 # Indicates that the client must take some additional action in order to complete their request
}
return jsonify(data['payload']), data['status_code']
else:
if request.method == 'POST':
datadict = {
'skuid': request.json.get('skuid', None),
'product_name': request.json.get('product_name', None),
'storageid': request.json.get('storageid', None),
'stock': request.json.get('stock', None),
'customer_name': request.json.get('customer_name', None),
'orderid': request.json.get('orderid', None),
'orderlineid': request.json.get('orderlineid', None),
'quantity': request.json.get('quantity', None)
}
if table == 'sku':
data = functions.createSku(datadict)
elif table == 'storage':
data = functions.createStorage(datadict)
elif table == 'order':
data = functions.createOrder(datadict)
elif table == 'orderline':
data = functions.createOrderLine(datadict)
else:
data = {
'payload': {
'message': 'Invalid table name'
},
'status_code': 500
}
return jsonify(data['payload']), data['status_code']
if request.method == 'GET':
data = functions.fetchdata(table)
return jsonify(data['payload']), data['status_code']
if request.method == 'PUT':
datadict = {
'skuid': request.json.get('skuid', None),
'product_name': request.json.get('product_name', None),
'storageid': request.json.get('storageid', None),
'stock': request.json.get('stock', None),
'customer_name': request.json.get('customer_name', None),
'orderid': request.json.get('orderid', None),
'orderlineid': request.json.get('orderlineid', None),
'quantity': request.json.get('quantity', None)
}
if table == 'sku':
data = functions.updateSku(datadict)
elif table == 'storage':
data = functions.updateStorage(datadict)
elif table == 'order':
data = functions.updateOrder(datadict)
elif table == 'orderline':
data = functions.updateOrderLine(datadict)
else:
data = {
'payload': {
'message': 'Invalid table name'
},
'status_code': 500
}
return jsonify(data['payload']), data['status_code']
