postgresql 字段解析失败

[xiaoshumiao6]

字段类型： tstzrange

错误日志

Traceback (most recent call last):
  File "/opt/venv4archery/lib/python3.9/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/opt/venv4archery/lib/python3.9/site-packages/django/contrib/auth/decorators.py", line 23, in _wrapped_view
    return view_func(request, *args, **kwargs)
  File "/opt/archery/sql/query.py", line 200, in query
    json.dumps(
  File "/opt/venv4archery/lib/python3.9/site-packages/simplejson/__init__.py", line 398, in dumps
    return cls(
  File "/opt/venv4archery/lib/python3.9/site-packages/simplejson/encoder.py", line 296, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "/opt/venv4archery/lib/python3.9/site-packages/simplejson/encoder.py", line 378, in iterencode
    return _iterencode(o, 0)
  File "/opt/archery/common/utils/extend_json_encoder.py", line 90, in default
    return super(ExtendJSONEncoderFTime, self).default(obj)
  File "/opt/venv4archery/lib/python3.9/site-packages/simplejson/encoder.py", line 272, in default
    raise TypeError('Object of type %s is not JSON serializable' %
TypeError: Object of type DateTimeTZRange is not JSON serializable

[LeoQuote]

欢迎 pr,可以直接改文件试试 extend_json_encoder.py

[xiaoshumiao6]

修复代码如下：

    def default(self, obj):
        try:
            if isinstance(obj, psycopg2._range.DateTimeTZRange):
                return obj.lower.isoformat(" ") + "--" + obj.upper.isoformat(" ")
            elif isinstance(obj, datetime):
                return obj.isoformat(" ")
            else:
                return convert(obj)

[LeoQuote]

可以直接pr，谢谢

[LeoQuote]

fixed by #2597