openNAMU__openNAMU/route/main_search_deep.py

from .tool.func import *

def main_search_deep(name = 'Test', search_type = 'title', num = 1):
    with get_db_connect() as conn:
        curs = conn.cursor()

        if name == '':
            return redirect()

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

        div = ''
        if search_type == 'title':
            div += '<a href="/search_data/1/' + url_pas(name) + '">(' + load_lang('search_document_data') + ')</a>'
        else:
            div += '<a href="/search/1/' + url_pas(name) + '">(' + load_lang('search_document_name') + ')</a>'

        name_new = ''
        if re.search(r'^분류:', name):
            name_new = re.sub(r"^분류:", 'category:', name)
        elif re.search(r"^사용자:", name):
            name_new = re.sub(r"^사용자:", 'user:', name)
        elif re.search(r"^파일:", name):
            name_new = re.sub(r"^파일:", 'file:', name)

        if name_new != '':
            div += ' <a href="/search/1/' + url_pas(name_new) + '">(' + name_new + ')</a>'

        curs.execute(db_change("select title from data where title = ?"), [name])
        link_id = '' if curs.fetchall() else 'id="not_thing"'

        div += '''
            <ul class="opennamu_ul">
                <li>
                    <a ''' + link_id + ' href="/w/' + url_pas(name) + '">' + html.escape(name) + '''</a>
                </li>
            </ul>
            <hr class="main_hr">
            <ul class="opennamu_ul">
        '''

        if search_type == 'title':
            curs.execute(db_change("select title from data where title like ? order by title limit ?, 50"),
                ['%' + name + '%', sql_num]
            )
        else:
            curs.execute(db_change("select title from data where data like ? order by title limit ?, 50"),
                ['%' + name + '%', sql_num]
            )

        all_list = curs.fetchall()
        for data in all_list:
            div += '<li><a href="/w/' + url_pas(data[0]) + '">' + data[0] + '</a></li>'

        div += '</ul>'
        div += get_next_page_bottom('/search/{}/' + url_pas(name), num, all_list)

        return easy_minify(flask.render_template(skin_check(),
            imp = [name, wiki_set(), wiki_custom(), wiki_css(['(' + load_lang('search') + ')', 0])],
            data = div,
            menu = 0
        ))