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))