api_recent_change.py 682 B

123456789101112131415161718192021
  1. from .tool.func import *
  2. def api_recent_change_2(conn):
  3. curs = conn.cursor()
  4. num = int(number_check(flask.request.args.get('num', '10')))
  5. num = 50 if (1 if not num > 0 else num) > 50 else num
  6. data_list = []
  7. curs.execute(db_change('select id, title from rc order by date desc'))
  8. for i in curs.fetchall():
  9. curs.execute(db_change('' + \
  10. 'select id, title, date, ip, send, leng, hide from history ' + \
  11. 'where id = ? and title = ? ' + \
  12. 'order by date desc' + \
  13. ''), i)
  14. data_list += curs.fetchall()
  15. if data_list:
  16. return flask.jsonify(data_list)
  17. else:
  18. return flask.jsonify({})