我正在使用 3.9 版的 python 并嘗試創建一個關鍵字搜索，用戶可以在其中輸入一串關鍵字，并且可以針對包含字串的資料庫查詢該字串。編譯沒有錯誤，一切都在運行，但查詢的結果不是我所期望的。它不是從描述列回傳包含與關鍵字相似的詞的所有行，而是以字串形式回傳查詢。
這是我的init .py 檔案：
import os
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_msearch import Search
...
app = Flask(__name__)
searched = Search(app)
searched.init_app(app)
searched.create_index(update=True)
MSEARCH_INDEX_NAME = os.path.join(app.root_path,'msearch')
MSEARCH_ENABLE = True
from .search import search as search_blueprint
app.register_blueprint(search_blueprint)
return app
這是我的models.py檔案
class Service (db.Model):
__searchable__ = ['description']
provider_id = db.Column(db.Integer, db.ForeignKey('provider.provider_id'), nullable=False)
service_id = db.Column(db.Integer, nullable=False, primary_key=True)
rating_avg = db.Column(db.Float(precision=2), nullable=False)
service_name = db.Column(db.String(20), nullable=False)
cost = db.Column(db.Float(precision=2), nullable=False)
description = db.Column(db.String(255), nullable=False)
category = db.Column(db.String(20), nullable=False)
def __repr__(self):
return 'String representation of Service'
這是我的 search.py?? 檔案：
search = Blueprint('search', __name__)
@search.route('/search')
def searching():
return render_template('search.html')
@search.route('/search', methods=['POST'])
def searching_post():
searchInput = request.form.get('searchInput')
results = Service.query.msearch(searchInput, fields= ['description'])
return render_template('result.html', results=results)
這是我的 search.html 模板檔案：
{% extends "base.html" %}
{% block content %}
<div class="column is-8 is-offset-2">
<h1 class ="title">
Enter keywords and minimum rating
</h1>
<div class="box">
<form method="POST" action="/search">
<div class="field">
<div class="form-group">
<input class="input is-large" type="text" name="searchInput" placeholder=" " autofocus="">
</div>
</div>
<button class="button is-block is-info is-large is-fullwidth">Search</button>
</form>
</div>
</div>
{% endblock %}
這是我在搜索欄中搜索任何內容時得到的結果：
Results: SELECT service.provider_id AS service_provider_id, service.service_id AS service_service_id, service.rating_avg AS service_rating_avg, service.service_name AS service_service_name, service.cost AS service_cost, service.description AS service_description, service.category AS service_category FROM service WHERE (service.description LIKE '%' || ? || '%')!
uj5u.com熱心網友回復：
msearch回傳一個Query物件，當你列印results變數時，你會看到它的字串表示——底層的 SQL 查詢。
要獲得實際結果，您需要“執行”查詢，例如
results = Service.query.msearch(searchInput, fields= ['description']).all()
以下方法呼叫也會導致底層查詢的執行：
results = Service.query.msearch(searchInput, fields= ['description']).first()
results = Service.query.msearch(searchInput, fields= ['description']).one()
results = Service.query.msearch(searchInput, fields= ['description']).one_or_none()
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/364836.html