实现搜索功能

墨蓝 2021-12-20 11:39 464阅读 0赞

1.准备视图函数search()

2.修改base.html 中搜索输入框所在的

1.  <form action="\{ \{ url\_for('search') \}\}" method="get">
2.  <input name="q" type="text" placeholder="请输入关键字">

div class="clearfloat">
    
             <form action="{
         { url_for('search') }}" method="get">
             <a href="{
         {url_for('index')}}">首页</a>
             <img src="w_02_08_00.png" >
             <a href="http://www.gzcc.cn/">收藏</a>
             <input name="q" type="text" placeholder="请输入关键字搜索">
             <button type="submit">搜索</button>
             <a href="{
         {url_for('login')}}">登录</a>
             <a href="{
         {url_for('zhuce')}}">注册</a>
             <a  href="{
         { url_for('logout') }}">注销</a>
             <a href="{
         { url_for('question') }}">发布问答</a>
    <img id="myOnOff" onclick="mySwitch()" src="http://www.runoob.com/images/pic_bulbon.gif" width="20px";>
              </form>
    
    </div>

3.完成视图函数search()

1.  获取搜索关键字 q = request.args.get('q’)
2.  条件查询 qu = Question.query.filter(Question.title.contains(q)).order\_by('-creat\_time’)
3.  加载查询结果： return render\_template('index.html', question=qu）

@app.route('/search/')
    @loginFirst
    def search():
        qu = request.args.get('q')
        ques = Question.query.filter(
            or_(
                 Question.title.contains(qu),
                Question.detail.contains(qu)
            )
        ).order_by('-creat_time')
        return render_template('index.html', question=ques)

4.组合条件查询 from sqlalchemy import or\_, and\_

示例：

Lobby.query.filter(

or\_(

and\_(

Lobby.id == Team.lobby\_id,

LobbyPlayer.team\_id == Team.id,

LobbyPlayer.player\_id == player.steamid

and\_(

Lobby.id == spectator\_table.c.lobby\_id,

spectator\_table.c.player\_id == player.steamid

)

[https://stackoverflow.com/questions/13370993/sqlalchemy-query-and-or-issue][https_stackoverflow.com_questions_13370993_sqlalchemy-query-and-or-issue]

转载于:https://www.cnblogs.com/gdlyzx/p/8075857.html

[https_stackoverflow.com_questions_13370993_sqlalchemy-query-and-or-issue]: https://stackoverflow.com/questions/13370993/sqlalchemy-query-and-or-issue