实现搜索功能

1.准备视图函数search()

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

<form action="{{ url_for('search') }}" method="get">

<input name="q" type="text" placeholder="请输入关键字">

<div style="padding: 0 500px 50px 450px;" >
    <form action="{{ url_for('search') }}" method="get" class="bs-example bs-example-form" role="form">
            <div class="col-lg-6">
                <div class="input-group">
                    <input name="q" type="text" class="form-control" placeholder="请输入关键字">
                    <span class="input-group-btn">
                        <button class="btn btn-default" type="submit">
                            搜索
                        </button>
                    </span>
                </div><!-- /input-group -->
            </div><!-- /.col-lg-6 -->
    </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')
def search():
   qu=request.args.get('q')
   ques=Question.query.filter(Question.title.contains(qu)).order_by('-creat_time')
   return  render_template('shouye.html',question=ques)

4.组合条件查询
from sqlalchemy import or_, and_

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

运行结果为：