实现搜索功能

• 准备视图函数search()
• 修改base.html 中搜索输入框所在的
  1. <form action="{{ url_for('search') }}" method="get">
  2.    <input name="q" type="text" placeholder="请输入关键字">
• 完成视图函数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）
• 组合条件查询 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         )     ) )

 <form action="{{ url_for('search') }}"method="get">
            <li><input type="text" name="search" class="form-control" style="width: 200px"></li>
            <button type="submit" class="btn btn-default">搜索</button>
        </form>

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