首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >如何对JSONB内容运行Flask-restless过滤器查询

如何对JSONB内容运行Flask-restless过滤器查询
EN

Stack Overflow用户
提问于 2016-12-30 02:39:50
回答 0查看 374关注 0票数 1

我在尝试对JSONB对象中包含的数据执行无瓶无休止api查询时遇到了问题。我猜这是因为底层查询不知道如何转换数据字段,所以它不知道如何正确生成查询,但我不确定。

执行ajax搜索时运行的查询:

代码语言:javascript
复制
http://192.168.163.129:1080/api/subscribers?page=1&results_per_page=10&q={"filters":[{"name":"data","op":"has","val":{"name":"full_name","op":"eq","val":"%Steve%"}}],"order_by":[{"field":"created","direction":"asc"}]}

这是我在运行查询时得到的回溯。

代码语言:javascript
复制
2016-12-29 22:26:33,068 - app - ERROR - mapper
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask_restless/views.py", line 1172, in _search
    result = search(self.session, self.model, search_params)
  File "/usr/local/lib/python2.7/dist-packages/flask_restless/search.py", line 587, in search
    query = create_query(session, model, search_params, _ignore_order_by)
  File "/usr/local/lib/python2.7/dist-packages/flask_restless/search.py", line 549, in create_query
    _ignore_order_by)
  File "/usr/local/lib/python2.7/dist-packages/flask_restless/search.py", line 480, in create_query
    filters = [create_filt(model, filt) for filt in search_params.filters]
  File "/usr/local/lib/python2.7/dist-packages/flask_restless/search.py", line 438, in _create_filter
    return create_op(model, fname, filt.operator, val, relation)
  File "/usr/local/lib/python2.7/dist-packages/flask_restless/search.py", line 411, in _create_operation
    return opfunc(field, argument, fieldname)
  File "/usr/local/lib/python2.7/dist-packages/flask_restless/search.py", line 106, in <lambda>
    'has': lambda f, a, fn: f.has(_sub_operator(f, a, fn)),
  File "/usr/local/lib/python2.7/dist-packages/flask_restless/search.py", line 37, in _sub_operator
    submodel = model.property.mapper.class_
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 833, in __getattr__
    return self._fallback_getattr(key)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 811, in _fallback_getattr
    raise AttributeError(key)
AttributeError: mapper

接口代码:

代码语言:javascript
复制
manager.create_api(Subscribers, methods=['GET'], results_per_page=10,
                   preprocessors=dict(GET_SINGLE=[subscribers_preprocessor],
                                      GET_MANY=[subscribers_preprocessor]))

预处理器是一个简单的身份验证处理器。

你知道如何正确格式化过滤器以过滤JSONB postgres字段吗?

EN

回答

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/41385406

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档