openNAMU__openNAMU/route/list_please.py

from .tool.func import *

async def list_please(arg_num = 1):
    with get_db_connect() as conn:
        curs = conn.cursor()

        sql_num = (arg_num * 50 - 50) if arg_num * 50 > 0 else 0

        div = '<ul>'

        curs.execute(db_change("select distinct title from back where type = 'no' limit ?, 50"), [sql_num])
        data_list = curs.fetchall()
        for data in data_list:
            div += '' + \
                '<li>' + \
                    '<a class="opennamu_not_exist_link" href="/w/' + url_pas(data[0]) + '">' + html.escape(data[0]) + '</a> ' + \
                '</li>' + \
            ''

        div += '</ul>' + await get_next_page_bottom('/list/document/need/{}', arg_num, data_list)

        return await render_template(
            await get_lang('need_document'),
            div,
            0,
            [['other', await get_lang('return')]]
        )