实现搜索功能

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