def get(self): try: parser.add_argument('Date', type=str, help='admisstion date') params = parser.parse_args() logger.info_log("params : " + str(params)) sql = "select employee_name from Employee where employee_code = %s" convert_date = datetime.datetime.strptime(params['Date'], "%Y-%m-%d").date() rows = db_class.executeAll(sql, convert_date) logger.info_log("[User List Data] : " + str(rows)) return {"status" : "200", "message": "Data select success..."} except Exception as e: logger.error_log(str(e))
def patch(self): try: parser.add_argument('employee_code', type=str, help='Employee code') params = parser.parse_args() logger.info_log("params : " + str(params)) data = request.get_json(silent=True, force=True) logger.info_log("Request data : " + str(data)) sql = """\ update Employee set employee_name = %s, address = %s, salary = %s, phone_number = %s, where employee_code = %s """ rows = db_class.execute(sql, (data["employee_name"], data["address"], data["salary"], data["phone_number"], data["employee_code"])) db_class.commit() db_class.close() logger.info_log("commit complete") return {"status" : "200", "message": "Data update success..."} except Exception as e: logger.error_log(str(e)) finally: db_class.close()
def post(self): try: parser.add_argument('employee_code', type=str, help='employee code') parser.add_argument('employee_name', type=str, help='employee name') parser.add_argument('address', type=str, help='address') parser.add_argument('salary', type=str, help='salary') parser.add_argument('phone_number', type=str, help='phone_number') params = parser.parse_args() logger.info_log("params : " + str(params)) data = request.get_json(silent=True, force=True) logger.info_log("Request data : " + str(data)) sql = """\ insert into Employee (employee_code, employee_name, address, salary, phone_number, date) values ( %s, %s, %s, %s, %s, now()) """ rows = db_class.execute(sql, (data["employee_code"], data["employee_name"], data["address"], data["salary"], data["phone_number"])) db_class.commit() db_class.close() logger.info_log("commit complete") return {"status" : "200", "message": "Data insert success..."} except Exception as e: logger.error_log(str(e)) finally: db_class.close()
def delete(self): try: data = request.get_json(silent=True, force=True) logger.info_log("Request data : " + str(data)) sql = """\ delete from Employee where employee_code = %s """ rows = db_class.execute(sql, data["employee_code"]) db_class.commit() db_class.close() logger.info_log("commit complete") return {"status" : "200", "message": "Data delete success..."} except Exception as e: logger.error_log(str(e)) finally: db_class.close()
def job(): url = 'http://127.0.0.1:5002/api/v01/users' response = requests.get(url=url) logger.info_log("request get user list...")