使用 (where user_id=1) 时，我可以获得结果，但是当注入参数时，我得到了这样的回溯：“用户”对象不可迭代，任何将参数注入原始查询的想法，
我的意见.py：
class TransactionViews(viewsets.ViewSet):
def list(self, request):
user = get_object_or_404(User, pk=request.user.id)
queryset = Transaction.objects.raw("SELECT product.name, transaction.* from product inner join variant on product.id = variant.product_id inner join transactions_variants on variant.id = transactions_variants.variant_id inner join transaction on transactions_variants.transaction_id = transaction.id where user_id=%s",user)
serializer = TransactionSerializer(queryset, many=True)
return Response(serializer.data, status=200)
还有一个问题：
queryset = Transaction.objects.filter(user_id=user).exclude(deleted_at__isnull=False)
我如何将此“.exclude(deleted_at__isnull=False)”转换为我的原始查询（此排除是软删除的条件）
Traceback:
File "/usr/local/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner
34. response = get_response(request)
File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
126. response = self.process_exception_by_middleware(e, request)
File "/usr/local/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python3.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
54. return view_func(*args, **kwargs)
File "/usr/local/lib/python3.7/site-packages/rest_framework/viewsets.py" in view
116. return self.dispatch(request, *args, **kwargs)
File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in dispatch
495. response = self.handle_exception(exc)
File "/usr/local/lib/python3.7/site-packages/rest_framework/views.py" in handle_exception
455. self.raise_uncaught_exception(exc)
ibeautiful
相关分类