list_long_page.py 1.4 KB

1234567891011121314151617181920212223242526272829303132
  1. from .tool.func import *
  2. async def list_long_page(tool = 'long_page', arg_num = 1):
  3. with get_db_connect() as conn:
  4. curs = conn.cursor()
  5. sql_num = (arg_num * 50 - 50) if arg_num * 50 > 0 else 0
  6. div = '<ul>'
  7. select_data = 'desc' if tool == 'long_page' else 'asc'
  8. title = 'long_page' if tool == 'long_page' else 'short_page'
  9. curs.execute(db_change("select doc_name, set_data from data_set where set_name = 'length' and doc_rev = '' order by set_data + 0 " + select_data + " limit ?, 50"), [sql_num])
  10. n_list = curs.fetchall()
  11. for data in n_list:
  12. div += '<li>'
  13. div += data[1] + ' | <a href="/w/' + url_pas(data[0]) + '">' + html.escape(data[0]) + '</a>'
  14. curs.execute(db_change("select set_data from data_set where doc_name = ? and set_name = 'doc_type'"), [data[0]])
  15. db_data = curs.fetchall()
  16. if db_data and db_data[0][0] != '':
  17. div += ' | ' + db_data[0][0]
  18. div += '</li>'
  19. div += '</ul>' + get_next_page_bottom(conn, '/list/document/' + ('long' if title == 'long_page' else 'short') + '/{}', arg_num, n_list)
  20. return easy_minify(conn, flask.render_template(skin_check(conn),
  21. imp = [get_lang(conn, title), await wiki_set(), await wiki_custom(conn), wiki_css([0, 0])],
  22. data = div,
  23. menu = [['other', get_lang(conn, 'return')]]
  24. ))