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 post(self): db_class = dbConnector.Database() try: sql = 'insert into employee_code values(%s, %s, %s, %s, %s, %s)' wb = load_workbook(path + filename, data_only=True) ws = wb['Sheet'] iter_rows = iter(ws.rows) next(iter_rows) for row in iter_rows: db_class.execute(sql, (row[0].value, row[1].value, row[2].value, row[3].value, row[4].value, row[5].value)) wb.close() db_class.commit() return {"status": "200", "message": "Data insert success..."} except Exception as e: logger.error_log(str(e)) finally: db_class.close() wb.close()
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 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()
logger.info_log("request get user list...") class HttpStatusResponse(Resource): @app.errorhandler(404) def notFoundError(self): return "[404] Page Not Found..." @app.errorhandler(400) def uncaughtError(self): return "[400] Bad request..." @app.errorhandler(401) def unauthorize(self): return "[401] Not unauthorized..." @app.errorhandler(500) def serverError(self): return "[500] Server Error..." if __name__ == '__main__': try: models.db.init_app(app) # 테이블 삭제 후 생성 models.db.drop_all() models.db.create_all() except Exception as e: logger.error_log(str(e)) app.run(host='127.0.0.1', port=5002, debug=True)