首页 \ 问答 \ 对于SQLAlchemy查询，如何将ilike搜索运算符与in_运算符结合使用？(For an SQLAlchemy query, how to combine ilike search operator with in_ operator?)

对于SQLAlchemy查询，如何将ilike搜索运算符与in_运算符结合使用？(For an SQLAlchemy query, how to combine ilike search operator with in_ operator?)

 我正在编写采用搜索栏输入的SQLAlchemy代码，并对我的PostgreSQL数据库运行查询。 为了允许拼写错误和名称片段，我使用了这个代码来实现：  
q = session.query(Detail).filter((Detail.sellers.ilike("%%%s%%" % (name_input)))).all()
 
 现在我正在尝试做同样的事情，但要检查具有多个输入值的列表names 。 我已经完成了这样的事情：  
q = session.query(Detail).filter((Detail.sellers.in_(names))
 
 但是，这需要完全匹配。 我想结合ilike操作符和in_操作符。 这可能吗？ 我试过了：  
q = session.query(Detail).filter((Detail.sellers.ilike.in_(names))
 
 这给出了以下追溯和错误：  
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
  return self.wsgi_app(environ, start_response)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
  response = self.make_response(self.handle_exception(e))
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1403, in handle_exception
  reraise(exc_type, exc_value, tb)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
  response = self.full_dispatch_request()
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
  rv = self.handle_user_exception(e)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
  reraise(exc_type, exc_value, tb)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
  rv = self.dispatch_request()
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
  return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/Tom/projects/land-records/repo/scripts/app.py", line 162, in search
  return query_db(names)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask_cache/__init__.py", line 537, in decorated_function
  rv = f(*args, **kwargs)
File "/Users/Tom/projects/land-records/repo/scripts/app.py", line 106, in query_db
  q = session.query(Detail).filter((Detail.sellers.ilike.in_(names))).all()

AttributeError: 'function' object has no attribute 'in_'

I am writing SQLAlchemy code that takes a search bar's input and runs a query against my PostgreSQL database. To allow for misspellings and name fragments, I had this code that did the trick: 
q = session.query(Detail).filter((Detail.sellers.ilike("%%%s%%" % (name_input)))).all()
 
Now I am trying to do the same thing, but to check against a list names that has multiple input values. I've accomplished that like so: 
q = session.query(Detail).filter((Detail.sellers.in_(names))
 
That requires exact matches, however. I would like to combine the ilike operator and the in_ operator. Is this possible? I've tried: 
q = session.query(Detail).filter((Detail.sellers.ilike.in_(names))
 
That gives the following traceback and error: 
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
  return self.wsgi_app(environ, start_response)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
  response = self.make_response(self.handle_exception(e))
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1403, in handle_exception
  reraise(exc_type, exc_value, tb)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
  response = self.full_dispatch_request()
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
  rv = self.handle_user_exception(e)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
  reraise(exc_type, exc_value, tb)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
  rv = self.dispatch_request()
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask/app.py", line 1461, in dispatch_request
  return self.view_functions[rule.endpoint](**req.view_args)
File "/Users/Tom/projects/land-records/repo/scripts/app.py", line 162, in search
  return query_db(names)
File "/Users/Tom/projects/land-records/lib/python2.7/site-packages/flask_cache/__init__.py", line 537, in decorated_function
  rv = f(*args, **kwargs)
File "/Users/Tom/projects/land-records/repo/scripts/app.py", line 106, in query_db
  q = session.query(Detail).filter((Detail.sellers.ilike.in_(names))).all()

AttributeError: 'function' object has no attribute 'in_'

原文：https://stackoverflow.com/questions/25366895

更新时间：2024-02-21 18:02

最满意答案

 解决您的问题的一种方法如下  
    $cols = '';
    $row = '';
    $data = [0, 1, 2];  //just a sample here

    // create all td tags at first based on your sample  
    foreach ($data as $value) {
        $cols .= Html::tag('td', 'rows' . $value, [
            'value' => $value,
        ]);
    }

    $row .= Html::tag('tr', $cols);  //then create a tr tag to include all td tags
    var_dump($row);
 
 Html::tag函数的第一个参数是标签名称，第二个参数是刚创建的标签内容，最后一个是附加到标签的attrs。  
 你遇到这个错误的原因是第二个参数需要是字符串类型，而你传递了一个数组，它应该是最后一个参数。 愿你帮忙。 

One way to solve your problem is as follows 
    $cols = '';
    $row = '';
    $data = [0, 1, 2];  //just a sample here

    // create all td tags at first based on your sample  
    foreach ($data as $value) {
        $cols .= Html::tag('td', 'rows' . $value, [
            'value' => $value,
        ]);
    }

    $row .= Html::tag('tr', $cols);  //then create a tr tag to include all td tags
    var_dump($row);
 
The first param of Html::tag function is the tag name, second one is the content inside the tag that you just created, last one is the attrs attached to the tag.  
The reason why you came accross that error is that the second param needs to be string type, while you passed an array, which should be the last param. May this you help.

对于SQLAlchemy查询，如何将ilike搜索运算符与in_运算符结合使用？(For an SQLAlchemy query, how to combine ilike search operator with in_ operator?)

最满意答案

相关问答

如何选择只有的，而不是使用jQuery？(How to select that has 's only, but not using jQuery?)[2023-10-23]

打破10 td's in set of 5 inside tr(Breaking 10 td's in set of 5 inside tr)[2023-03-15]

angularJS在ng-repeat中添加表行（TR） -(angularJS add table row (TR) inside an ng-repeat -)[2021-11-28]

Yii2：如何在一个TR内添加多个TD行？(Yii2: How to add multiple TD rows inside one TR?)[2023-02-13]

在每秒之后添加(Add after every second using)[2022-04-16]

如果在里面的回声中还有其他内容(If else inside my echo inside )[2022-06-26]

在一个TR中加上TD(Sum TD in one TR)[2022-08-15]

如果tr有td [rowspan](If tr has td[rowspan])[2024-02-25]

使用jQuery将替换为 (Replace with using jQuery)[2022-01-13]

从tr删除最后一个td(Remove last td from a tr)[2022-06-04]

相关文章

最新问答

对于SQLAlchemy查询，如何将ilike搜索运算符与in_运算符结合使用？(For an SQLAlchemy query, how to combine ilike search operator with in_ operator?)

最满意答案

相关问答

如何选择只有的，而不是使用jQuery？(How to select that has 's only, but not using jQuery?)[2023-10-23]

打破10 td's in set of 5 inside tr(Breaking 10 td's in set of 5 inside tr)[2023-03-15]

angularJS在ng-repeat中添加表行（TR） -(angularJS add table row (TR) inside an ng-repeat -)[2021-11-28]

Yii2：如何在一个TR内添加多个TD行？(Yii2: How to add multiple TD rows inside one TR?)[2023-02-13]

在每秒之后添加(Add after every second using)[2022-04-16]

如果在 里面的回声中还有其他内容(If else inside my echo inside )[2022-06-26]

在一个TR中加上TD(Sum TD in one TR)[2022-08-15]

如果tr有td [rowspan](If tr has td[rowspan])[2024-02-25]

使用jQuery将替换为 (Replace with using jQuery)[2022-01-13]

从tr删除最后一个td(Remove last td from a tr)[2022-06-04]

相关文章

最新问答

如果在里面的回声中还有其他内容(If else inside my echo inside )[2022-06-26]