flask sqlalchemy执行sql查询错误

Question

你能帮我解决这个错误吗？

2017-08-05 18:54:18,421 INFOsqlalchemy.engine.base.Engine（4L，）2017-08-05 18:54:18,424 INFOsqlalchemy.engine.base.Engine COMMIT127.0.0.1--[05/Aug/2017 18:54:18]"GET/HTTP/1.1"200-127.0.0.1 - - [05/Aug/2017 18:54:19]"GET /static/img/markers_shadow.pngHTTP/1.1"404-127.0.0.1--[05/Aug/2017 18:54:19]"GET /static/fonts/glyphicons-halflings-regular.woff2HTTP/1.1"404-127.0.0.1--[05/Aug/2017 18:54:19]"GET /static/fonts/glyphicons-halflings-regular.woffHTTP/1.1"404-127.0.0.1-[05/Aug/2017 18:54:19]"GET /static/fonts/glyphicons-halflings-regular.ttfHTTP/1.1"404-[2017-08-05 18:54:23,162]应用程序中的错误：异常 /auth/search[GET]Traceback（最近的调用最后）： File"/home/alaoui/Documents/ProjetHandy/venv-handy/lib/python2.7/site-包/flask/app.py"，第1988行，wsgi_app响应=self.full_dispatch_request（）File"/home/alaoui/Documents/ProjetHandy/venv-handy/lib/python2.7/site-包/flask/app.py"，第1641行，full_dispatch_requestrv=self.handle_user_exception（e）File"/Home/alaoui/Documents/ProjetHandy/venv-handy/lib/python2.7/site-包/烧瓶/app.py"，第1544行，handle_user_exception（exc_type，exc_value，tb）File"/home/alaoui/Documents/ProjetHandy/venv-handy/lib/python2.7/site-包/烧瓶/app.py"，第1639行，full_dispatch_requestrv=self.dispatch_request（）File"/home/alaoui/Documents/ProjetHandy/venv-handy/lib/python2.7/site-pack/flask/app.py"，第1625行，dispatch_request返回self.view_functionsrule. endpoint File"/home/alaoui/Documents/ProjetHandy/handy_2/app/auth/view. py"，第194行，在search_handymanhandyman=User.find_handymans（search_query）File"/home/alaoui/Documents/ProjetHandy/handy_2/app/模型. py"，第88行，在find_handymanscursor=db.会期.执行（sql）File"/home/alaoui/Documents/ProjetHandy/venv-handy/lib/python2.7/site-包/sqlalChemy/orm/范围. py"，第157行，在do返回getattr文件"/home/alaoui/Documents/ProjetHandy/venv-handy/lib/python2.7/site-包/sqlalChemy/orm/session. py"，第1101行，在执行子句=表达式中。_literal_as_text（子句）文件"/home/alaoui/Documents/ProjetHandy/venv-handy/lib/python2.7/site-包/sqlalChemy/sql/elements. py"，第4238行，在_literal_as_text“代替”%type（元素）ArgumentError： SQL表达式对象或字符串预期，得到类型的对象代替

model.py：

    @staticmethod
def find_users(query):
    search_job = str(query)

    sql ="""SELECT first_name,last_name, email, phone, image, diplome, latitude, longitude, description
    FROM users, jobs
    WHERE users.id_job = jobs.id
    AND jobs.description = %s
           """, [search_job]
    cursor = db.session.execute(sql )

    # Returns a list of product tuples
    return cursor.fetchall()

意见。py:

    @auth.route('/search' )
def search_user():
    search_query = request.args.get('query')
    users = User.find_users(search_query)

    return render_template("home/search_results.html",
                           query=search_query,
                           users=users)

家html:

 <form class="navbar-form navbar-left" action="{{url_for('auth.search_user') }}">
                        <div class="form-group">
                          <input type="text" class="form-control" name="query" placeholder="Search">
                          <input type="hidden" name="index" value="All">
                        </div>
                        <button type="submit" class="btn btn-default">Search</button>
                      </form>

这就是我用来执行这个请求的所有代码，你知道吗。非常感谢。

注：当我给一个值在我的模型字体它的工作。

乔布斯。description=%s-带有-

Answer 1

这是我在models.py的解决方案，它的工作原理：）

@staticmethod
def find_handymans(query):
    search_job = str(query)

    sql_query =text("SELECT first_name,last_name, email, user_type,  phone, image, diplome, latitude, longitude, description FROM users, jobs WHERE users.id_job = jobs.id AND jobs.description = :x ")
    cursor = db.session.execute(sql_query,{'x' : search_job})

    # Returns a list of product tuples
    return cursor.fetchall()