def get(self, id):
s = Borrowbook()
try:
res = s.search(id)
if res:
return jsonify(res)
return make_response(jsonify({"message": "Ticket not found"}), 404)
except Exception as e:
return make_response(jsonify({"message": str(e)}), 400)
def delete(self):
s = Borrowbook()
query = request.args
try:
res = s.deleteInfo(query.get("id"))
if res:
return jsonify(res)
return make_response(jsonify({"message": "OK"}), 200)
except Exception as e:
return make_response(jsonify({"message": str(e)}), 400)
def put(self):
query = request.get_json()
try:
id_ = Borrowbook.updateInfo(**query)
if id_:
res = Borrowbook.get_detail(id_)
return make_response(jsonify({"data": res}), 200)
return make_response(jsonify({"message": "ok"}), 201)
except Exception as e:
return make_response(jsonify({"message": str(e)}), 400)
def test_create(self):
user1 = {
"id_user": 1,
"id_book": 3,
"date": "2020-12-09",
"price": 45000
}
self.assertTrue(Borrowbook.createInfo(**user1))
def test_update2(self):
user2 = {
"id_user": 4,
"id_book": 7,
"date": "2020-04-05",
"price": 45000
}
self.assertTrue(Borrowbook.updateInfo(**user2))
def test_update(self):
user1 = {
"id_user": 3,
"id_book": 3,
"date": "2019-11-17",
"price": 23000
}
self.assertTrue(Borrowbook.updateInfo(**user1))
def test_create2(self):
user2 = {
"id_user": 5,
"id_book": 7,
"date": "2019-05-17",
"price": 34000
}
self.assertTrue(Borrowbook.createInfo(**user2))
def get(self):
query = request.args
try:
res = Borrowbook.get_detail(query.get("id"))
if res:
return jsonify(res)
return make_response(jsonify({"message": " Not Found"}), 404)
except Exception as e:
return make_response(jsonify({"message": str(e)}), 400)
def get(self):
query = request.args
try:
res = Borrowbook.get_list(**query)
if res:
return jsonify(res)
return make_response(jsonify({"message": "Info not found"}), 404)
except Exception as e:
return make_response(jsonify({"message": str(e)}), 400)
def test_get_list10(self):
user10 = {
"keyword": "g",
"page_size": 5,
"page_index": 1,
"from_price": 2000,
"to_price": 100000,
"from_date": "2019-01-01",
"to_date": "2020-12-22",
"order_field": "date"
}
self.assertTrue(Borrowbook.get_list(**user10))
def test_get_list11(self):
user11 = {
"keyword": "v",
"page_size": 3,
"page_index": 0,
"from_price": 1000,
"to_price": 90000,
"from_date": "2019-01-08",
"to_date": "2019-12-22",
"order_field": "price"
}
self.assertTrue(Borrowbook.get_list(**user11))
def get(self):
query = request.args
#page = request.args.get('page', 1, type=int)
#query1 = request.args.get("pagesize")
#query2 = request.args.get("pageindex")
try:
res = Borrowbook.get_list(query.get("keyword"))
if res:
return jsonify(res)
return make_response(jsonify({"message": "Info not found"}), 404)
except Exception as e:
return make_response(jsonify({"message": str(e)}), 400)
def test_get_list(self):
self.assertTrue(Borrowbook.get_list(**user1))
self.assertTrue(Borrowbook.get_list(**user2))
self.assertTrue(Borrowbook.get_list(**user3))
self.assertTrue(Borrowbook.get_list(**user4))
self.assertTrue(Borrowbook.get_list(**user5))
self.assertTrue(Borrowbook.get_list(**user6))
self.assertTrue(Borrowbook.get_list(**user7))
self.assertTrue(Borrowbook.get_list(**user8))
self.assertTrue(Borrowbook.get_list(**user9))
self.assertTrue(Borrowbook.get_list(**user10))
self.assertTrue(Borrowbook.get_list(**user11))
def test_get_detail(self):
self.assertTrue(Borrowbook.get_detail(2))
self.assertTrue(Borrowbook.get_detail(4))
def test_search(self):
self.assertTrue(Borrowbook.search(2))
self.assertTrue(Borrowbook.search(1))
def test_delete(self):
self.assertTrue(Borrowbook.deleteInfo(2))
self.assertTrue(Borrowbook.deleteInfo(4))
def test_update(self):
self.assertTrue(Borrowbook.updateInfo(**user14))
self.assertTrue(Borrowbook.updateInfo(**user15))
def test_get_list7(self):
user7 = {"keyword": "a", "from_date": "2019-01-01"}
self.assertTrue(Borrowbook.get_list(**user7))
def test_get_list4(self):
user4 = {"keyword": "v", "from_price": 2000}
self.assertTrue(Borrowbook.get_list(**user4))
def test_get_list(self):
with library_mysql.atomic() as txn:
Borrowbook.get_list(**user1)
Borrowbook.get_list(**user2)
Borrowbook.get_list(**user3)
Borrowbook.get_list(**user4)
Borrowbook.get_list(**user5)
Borrowbook.get_list(**user6)
Borrowbook.get_list(**user7)
Borrowbook.get_list(**user8)
Borrowbook.get_list(**user9)
Borrowbook.get_list(**user10)
Borrowbook.get_list(**user11)
txn.rollback()
def test_get_detail(self):
with library_mysql.atomic() as txn:
Borrowbook.get_detail(7)
Borrowbook.get_detail(10)
txn.rollback()
def test_search(self):
with library_mysql.atomic() as txn:
Borrowbook.search(2)
Borrowbook.search(1)
txn.rollback()
def test_update(self):
with library_mysql.atomic() as txn:
Borrowbook.updateInfo(**user14)
Borrowbook.updateInfo(**user15)
txn.rollback()
def test_get_list5(self):
user5 = {"keyword": "a", "to_price": 60000}
self.assertTrue(Borrowbook.get_list(**user5))
def test_get_list6(self):
user6 = {"keyword": "v", "order_field": "price"}
self.assertTrue(Borrowbook.get_list(**user6))
def test_create(self):
self.assertTrue(Borrowbook.createInfo(**user12))
self.assertTrue(Borrowbook.createInfo(**user13))
from librarymanage.models.borrowbook import Borrowbook
a = Borrowbook()
user10 = {"keyword":"g",
"page_size":1,
"page_index":1,
"from_price":2000,
"to_price":100000,
"from_date":"2019-01-01",
"to_date":"2020-12-22",
"order_field":"date"}
h = a.get_list(**user10)
print(h)
def test_create(self):
with library_mysql.atomic() as txn:
Borrowbook.createInfo(**user12)
Borrowbook.createInfo(**user13)
txn.rollback()
def test_delete(self):
with library_mysql.atomic() as txn:
Borrowbook.deleteInfo(2)
Borrowbook.deleteInfo(4)
txn.rollback()
def test_get_list8(self):
user8 = {"keyword": "h", "to_date": "2020-01-01"}
self.assertTrue(Borrowbook.get_list(**user8))
