api_recent_change.py 600 B

123456789101112131415161718
  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('select id, title, date, ip, send, leng, hide from history where id = ? and title = ?'), i)
  10. data_list += curs.fetchall()
  11. if data_list:
  12. return flask.jsonify(data_list)
  13. else:
  14. return flask.jsonify({})