api_recent_change.py 1.3 KB

1234567891011121314151617181920212223242526272829303132
  1. from .tool.func import *
  2. def api_recent_change(num = 10):
  3. with get_db_connect() as conn:
  4. curs = conn.cursor()
  5. num = 50 if (1 if not num > 0 else num) > 50 else num
  6. repeat_ok = flask.request.args.get('repeat', '1')
  7. data_list = []
  8. admin = admin_check(6)
  9. get_title = ''
  10. curs.execute(db_change('select id, title from rc where type = "" order by date desc limit ?'), [num])
  11. for for_a in curs.fetchall():
  12. if repeat_ok == '1' or for_a[1] != get_title:
  13. get_title = for_a[1]
  14. curs.execute(db_change('select id, title, date, ip, send, leng, hide from history where id = ? and title = ?'), for_a)
  15. get_data = curs.fetchall()
  16. if get_data:
  17. get_data = list(get_data[0])
  18. if get_data[6] == '' or admin == 1:
  19. if admin == 1:
  20. data_list += get_data
  21. else:
  22. get_data[3] = ip_pas(get_data[3], 1)
  23. data_list += get_data
  24. else:
  25. data_list += [['', '', '', '', '', '', get_data[6]]]
  26. else:
  27. data_list += [['', '', '', '', '', '', '']]
  28. return flask.jsonify(data_list if data_list else {})