在用dicts列表而不是查询集填充django-tables2之后，如何过滤它

Question

我有一个从MongoDB获取的dict列表。然后，我在views.py中填充django-tables2表，并在我的模板index.html中呈现它

在视图.py中

from django.shortcuts import render
from .tables import generateTable
from django_tables2 import RequestConfig
import pymongo
import pandas as pd
import json
client = pymongo.MongoClient("<mongodb url>")
db = client["stocks"]
col = db["company_stocks"]
the_rows = col.find({}, {'_id': False})
pandas_dataframe = pd.DataFrame(list(the_rows), columns=['Date', 'Open', 'High', 'Low', 'Close', 'Volume', 'Name'])
json_fomatted = pandas_dataframe.to_json(orient='records')
data = []
data = json.loads(json_fomatted)
def index(request):
table = generateTable(data)
RequestConfig(request).configure(table)
context = {'stocks_table': table }
return render(request, "home_app/index.html", context)

表格.py

import django_tables2 as tables
from .models import Stocks
class generateTable(tables.Table):
Date = tables.Column()
Open = tables.Column()
High = tables.Column()
Low = tables.Column()
Close = tables.Column()
Volume = tables.Column()
Name = tables.Column()

urls.py

urlpatterns = [
# Uncomment the next line to enable the admin:
path('admin/', admin.site.urls),
url(r'^$', home_app.views.index, name='index'),
url(r'^home$', home_app.views.index, name='home'),
]

index.html

{% load render_table from django_tables2 %}
{% render_table stocks_table 'django_tables2/bootstrap.html' %}

结果是这个

现在我正试图用django过滤器过滤表格，但运气不好

我发现的是如何过滤用查询集而不是dicts列表填充的数据

我的过滤尝试：

视图.py

...
from .models import Stocks
...
def index(request):
table = generateTable(data)
RequestConfig(request).configure(table)
#with this line
myFilter = stockFilter(request.GET, queryset=Stocks.objects.all())
context = {'stocks_table': table, 'myFilter': myFilter }
return render(request, "home_app/index.html", context)

过滤器.py

import django_filters
from .models import Stocks
class stockFilter(django_filters.FilterSet):
class Meta:
model = Stocks
fields = '__all__'

型号.py

from django.db import models
class Stocks(models.Model):
open = models.IntegerField(
max_length = 128)
high = models.IntegerField(
max_length = 128)
low = models.IntegerField(
max_length = 128)
close = models.IntegerField(
max_length = 128)
volume = models.IntegerField(
max_length = 128)
name = models.CharField(
max_length = 128)

index.html

<form method="GET">
{{ myFilter.form }}
<input type="submit" />
</form>
{% load render_table from django_tables2 %}
{% render_table stocks_table 'django_tables2/bootstrap.html' %}

这是的结果

过滤后。。。

我认为问题在于我的表是用列表而不是查询集填充的。

有没有更好的方法来过滤django-tables2？

非常感谢您的帮助！

我发现发布了一个类似的问题，但它使用了多个模型作为其表

Answer 1

在从mongo获得所需文档后，我创建了一个模型对象Stocks，并将其附加到一个列表中，然后简单地构建(created list(

视图.py

the_rows = col.find({}, {'_id': False})
json_data = list(the_rows)

obj_list = []
for data in json_data:
_open = round(float(data['Open']), 2)
_high = round(float(data['High']), 2)
_low = round(float(data['Low']), 2)
_close = round(float(data['Close']), 2)
obj = Stocks(name=data['Name'], date=data['Date'], open=_open, high=_high, low=_low, close=_close, volume=data['Volume'])
obj_list.append(obj)
Stocks.objects.bulk_create(obj_list)

表格。py基于模型。pyTR

import django_tables2 as tables
from .models import Stocks
class generateTable(tables.Table):
class Meta:
model = Stocks;
template = 'django_tables2/bootstrap.html';

然后，为了创建表和过滤器，我遵循了在中找到的步骤

视图.py

qs = Stocks.objects.all()
myFilter = stockFilter(request.GET, queryset=qs)
table = generateTable(myFilter.qs)
RequestConfig(request, paginate={"per_page": 30}).configure(table)
return render(request, "home_app/index.html", { 'stocks_table': table, 'myFilter': myFilter })

最后是模板index.html

{% block content %}
{% load render_table from django_tables2 %}
<div class="row">
<div class="filter_column">
<form>
{{myFilter.form}}
<input type="submit" />
</form>
</div>
<div class="table_column">
{% render_table stocks_table %}
</div>
</div>
{% endblock %}

结果