api_recent_change.py 1.1 KB

123456789101112131415161718192021222324252627
  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'))
  11. for i in curs.fetchall():
  12. if repeat_ok == '1' or i[1] != get_title:
  13. get_title = i[1]
  14. curs.execute(db_change('select id, title, date, ip, send, leng, hide from history where id = ? and title = ?'), i)
  15. get_data = curs.fetchall()
  16. if get_data:
  17. if get_data[0][6] == '' or admin == 1:
  18. data_list += get_data
  19. else:
  20. data_list += [['', '', '', '', '', '', get_data[0][6]]]
  21. else:
  22. data_list += [['', '', '', '', '', '', '']]
  23. return flask.jsonify(data_list if data_list else {})