mysql_to_mongo.py 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. from flask import Flask,request,jsonify
  2. import time
  3. import logging
  4. import traceback
  5. from common.database_dml import insert_data_into_mongo,get_data_fromMysql
  6. app = Flask('mysql_to_mongo——service')
  7. @app.route('/hello', methods=['POST'])
  8. def hello():
  9. return jsonify(message='Hello, World!')
  10. @app.route('/mysql_to_mongo', methods=['POST'])
  11. def data_join():
  12. # 获取程序开始时间
  13. start_time = time.time()
  14. result = {}
  15. success = 0
  16. print("Program starts execution!")
  17. try:
  18. args = request.values.to_dict()
  19. print('args',args)
  20. logger.info(args)
  21. df_mysql = get_data_fromMysql(args)
  22. insert_data_into_mongo(df_mysql, args)
  23. success = 1
  24. except Exception as e:
  25. my_exception = traceback.format_exc()
  26. my_exception.replace("\n","\t")
  27. result['msg'] = my_exception
  28. end_time = time.time()
  29. result['success'] = success
  30. result['args'] = args
  31. result['start_time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(start_time))
  32. result['end_time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(end_time))
  33. print("Program execution ends!")
  34. return result
  35. if __name__=="__main__":
  36. print("Program starts execution!")
  37. logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(name)s - %(levelname)s - %(message)s')
  38. logger = logging.getLogger("mysql_to_mongo")
  39. from waitress import serve
  40. serve(app, host="0.0.0.0", port=10095)
  41. print("server start!")