api_recent_discuss.py 729 B

12345678910111213141516171819
  1. from .tool.func import *
  2. def api_recent_discuss_2(conn, num, get_type):
  3. curs = conn.cursor()
  4. num = 50 if num > 50 else num
  5. data_list = []
  6. if get_type == 'stop':
  7. curs.execute(db_change("select title, sub, date, code, stop from rd where stop = 'O' order by date desc limit ?"), [num])
  8. elif get_type == 'all':
  9. curs.execute(db_change("select title, sub, date, code, stop from rd order by date desc limit ?"), [num])
  10. else:
  11. curs.execute(db_change("select title, sub, date, code, stop from rd where not stop = 'O' order by date desc limit ?"), [num])
  12. for i in curs.fetchall():
  13. data_list += [i]
  14. return flask.jsonify(data_list if data_list else {})