2
0

api_bbs_w_post.py 809 B

1234567891011121314151617181920212223242526
  1. from .tool.func import *
  2. def api_bbs_w_post(sub_code = ''):
  3. sub_code_split = sub_code.split('-')
  4. if len(sub_code_split) < 2:
  5. sub_code_split = ['', '']
  6. with get_db_connect() as conn:
  7. curs = conn.cursor()
  8. curs.execute(db_change('select set_name, set_data, set_code from bbs_data where set_id = ? and set_code = ?'), [sub_code_split[0], sub_code_split[1]])
  9. db_data = curs.fetchall()
  10. if not db_data:
  11. return flask.jsonify({})
  12. else:
  13. temp_id = ''
  14. temp_dict = {}
  15. for for_a in db_data:
  16. if temp_id != for_a[2]:
  17. temp_id = for_a[2]
  18. temp_dict['code'] = for_a[2]
  19. temp_dict[for_a[0]] = for_a[1]
  20. return flask.jsonify(temp_dict)