config.py 1.5 KB

1234567891011121314151617181920212223242526272829303132333435
  1. from ..base import base
  2. from ..models import Config
  3. from flask import render_template, request, jsonify
  4. from sqlalchemy import asc
  5. from sqlalchemy import desc
  6. @base.route('/system/config/configKey/<configKey>', methods=['GET'])
  7. def sysconfig_get_value(configKey):
  8. data = Config.query.filter(Config.config_key == configKey).first()
  9. return jsonify({'code': 200, 'msg': data.config_value})
  10. @base.route('/system/config/list', methods=['GET'])
  11. def sys_config_list():
  12. filters = []
  13. if 'configName' in request.args:
  14. filters.append(Config.config_name.like('%' + request.args['configName'] + '%'))
  15. if 'configKey' in request.args:
  16. filters.append(Config.config_key.like('%' + request.args['configKey'] + '%'))
  17. if 'configType' in request.args:
  18. filters.append(Config.config_type.like('%' + request.args['configType'] + '%'))
  19. if 'params[beginTime]' in request.args and 'params[endTime]' in request.args:
  20. filters.append(Config.create_time > request.args['params[beginTime]'])
  21. filters.append(Config.create_time < request.args['params[endTime]'])
  22. page = request.args.get('pageNum', 1, type=int)
  23. rows = request.args.get('pageSize', 10, type=int)
  24. pagination = Config.query.filter(*filters).paginate(
  25. page, per_page=rows, error_out=False)
  26. config_list = pagination.items
  27. return jsonify({'msg': '操作成功', 'code': 200, 'rows': [config.to_json() for config in config_list], 'total': len(config_list)})