实现搜索功能

1.准备视图函数search()

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

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

<div class="search">
    <form action="{{ url_for('search') }}" method="get">
        <input name="q" type="text" name="search" style="width:300px;">
        <button type="submit" ><img src="{{ url_for('static',filename='image/search.png') }}" width="14" height="14"></button>
    </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）

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
        )
    )
)

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