Django tables2：表恢复到以前的值

tktrz96b  于 2023-11-20  发布在  Go
关注(0)|答案(1)|浏览(98)

我有一个视图，我显示2个表，我有一个表单来创建一个新的过滤器在我的模板。使用我的代码，我希望过滤器表更新，并保持这种方式。
然而，在创建一个新的过滤器后，它会显示在表中，但如果我刷新页面或创建一个新的过滤器，它会恢复到“原始”表，即如果我有1个过滤器，我创建了一个，但我刷新页面或创建一个新的过滤器后，显示的表将只显示一个过滤器。
以更具体的方式说明：

original: [<trend_monitoring.tables.ReportTable object at 0x7f01e4d3b700>, <trend_monitoring.tables.FilterTable object at 0x7f01e4d3bc70>]
[<trend_monitoring.tables.ReportTable object at 0x7f01e4d3b700>, <trend_monitoring.tables.FilterTable object at 0x7f01e4d3bc70>]
172.19.0.3 - - [10/Nov/2023:10:33:00 +0000] "POST /trendyqc/dashboard/ HTTP/1.0" 302 0 "http://localhost:8000/trendyqc/dashboard/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 OPR/106.0.0.0 (Edition developer)"
original: [<trend_monitoring.tables.ReportTable object at 0x7f01e4d45670>, <trend_monitoring.tables.FilterTable object at 0x7f01e4d45bb0>]
[<trend_monitoring.tables.ReportTable object at 0x7f01e4d45670>, <trend_monitoring.tables.FilterTable object at 0x7f01e4d45bb0>]
172.19.0.3 - - [10/Nov/2023:10:33:01 +0000] "GET /trendyqc/dashboard/ HTTP/1.0" 200 233735 "http://localhost:8000/trendyqc/dashboard/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 OPR/106.0.0.0 (Edition developer)"
original: [<trend_monitoring.tables.ReportTable object at 0x7f01e4d3b700>, <trend_monitoring.tables.FilterTable object at 0x7f01e4d3bc70>]
[<trend_monitoring.tables.ReportTable object at 0x7f01e4d3b700>, <trend_monitoring.tables.FilterTable object at 0x7f01e4d3bc70>]
172.19.0.3 - - [10/Nov/2023:10:33:26 +0000] "GET /trendyqc/dashboard/ HTTP/1.0" 200 232980 "http://localhost:8000/trendyqc/dashboard/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 OPR/106.0.0.0 (Edition developer)"

字符串
刷新后，RAM地址回到原来的值。我觉得有一些网络开发巫毒正在进行，但我不知道是怎么回事。
谢谢你的帮助。
以下是我的观点：

class Dashboard(MultiTableMixin, TemplateView):
    template_name = "dashboard.html"
    report_sample_data = Report_Sample.objects.all()
    tables = [
        ReportTable(Report.objects.all()),
        FilterTable(Filter.objects.all())
    ]
    model = Report

    table_pagination = {
        "per_page": 10
    }

    def _get_context_data_dashboard(self):
        """ Get the basic data that needs to be displayed in the dashboard page

        Returns:
            dict: Dict of report and assay data to be passed to the dashboard
        """

        # object list needs to be defined for SingleTableViews but i have no
        # need for it
        # get the default context data (the one i need is one called table)
        context = self.get_context_data(object_list="")
        print(f"original: {context['tables']}")

        # get all the assays and sort them
        assays = sorted({
            assay
            for assay in self.report_sample_data.values_list(
                "assay", flat=True)
        })
        sequencer_ids = sorted({
            sequencer_id
            for sequencer_id in self.model.objects.all().values_list(
                "sequencer_id", flat=True)
        })
        project_names = sorted(
            project_name
            for project_name in self.model.objects.all().values_list(
                "project_name", flat=True)
        )

        context["project_names"] = project_names
        context["assays"] = assays
        context["sequencer_ids"] = sequencer_ids
        plotable_metrics = {
            **self._get_plotable_metrics(bam_qc),
            **self._get_plotable_metrics(fastq_qc),
            **self._get_plotable_metrics(vcf_qc)
        }
        context["metrics"] = dict(sorted(plotable_metrics.items()))
        return context

    def _get_plotable_metrics(self, module) -> dict:
        """ Gather all the plotable metrics by model in a dict

        Args:
            module (module): Module containing the definition of models

        Returns:
            dict: Dict with the name of the model as key and the name of the
            field as value
        """

        plotable_metrics = {}

        # loop through the modules' classes and get their name and object into
        # a dict
        module_dict = dict(
            [
                (name, cls)
                for name, cls in module.__dict__.items()
                if isinstance(cls, type)
            ]
        )

        for model_name, model in module_dict.items():
            plotable_metrics.setdefault(model_name, [])

            for field in model._meta.fields:
                # get the type of the field
                field_type = field.get_internal_type()

                # only get fields with those type for plotability
                if field_type in ["FloatField", "IntegerField"]:
                    plotable_metrics[model_name].append(field.name)

            plotable_metrics[model_name].sort()

        return plotable_metrics

    def get(self, request):
        """ Handle GET request

        Args:
            request (?): HTML request coming in

        Returns:
            ?: Render Django thingy?
        """

        context = self._get_context_data_dashboard()
        print(context["tables"])
        request.session.pop("form", None)
        return render(request, self.template_name, context)

    def post(self, request):
        """ Handle POST request

        Args:
            request (?): HTML request coming in

        Returns:
            ?: Render Django thingy? | Redirect thingy towards the Plot view
        """

        context = self._get_context_data_dashboard()
        print(context["tables"])
        form = FilterForm(request.POST)
        request.session.pop("form", None)

        # button in the filter table has been clicked
        if "filter_use" in request.POST:
            # get the filter id from the button value
            filter_id = request.POST["filter_use"]
            # get the filter obj in the database
            filter_obj = Filter.objects.get(id=filter_id)
            # deserialize the filter content for use in the Plot page
            request.session["form"] = json.loads(filter_obj.content)
            return redirect("Plot")

        # call the clean function and see if the form data is valid
        if form.is_valid():
            if "plot" in request.POST:
                # save the cleaned data in the session so that it gets passed to
                # the Plot view
                request.session["form"] = form.cleaned_data
                return redirect("Plot")

            elif "save_filter" in request.POST:
                filter_name = request.POST["save_filter"]

                # the default value that the prompt return is Save filter i.e.
                # if nothing was inputted the value is Save filter
                if filter_name != "Save filter":
                    msg, msg_status = import_filter(
                        filter_name, form.cleaned_data
                    )
                    messages.add_message(request, msg_status, f"{msg}")

                return redirect("Dashboard")

        else:
            # add the errors for displaying in the dashboard template
            for error_field in form.errors:
                if isinstance(form.errors[error_field], list):
                    for error in form.errors[error_field]:
                        messages.add_message(
                            request, messages.ERROR,
                            f"{error_field}: {error}"
                        )
                else:
                    messages.add_message(
                            request, messages.ERROR,
                            f"{error_field}: {''.join(form.errors[error])}"
                        )

        return render(request, self.template_name, context)

型
下面是我的模板：

{% extends "base.html" %}

{% load static %}
{% load render_table from django_tables2 %}

{% block dashboard %}

<div style="width:90%; margin: auto; padding: 10px;">
<p>There are <b>{{ project_names|length }}</b> projects currently in TrendyQC.</p>
</div>

<div style="width:90%; margin: auto; padding: 10px;">
    {% render_table tables.0 %}
</div>

{% if user.is_authenticated %}

<br>

<form action="{% url 'Dashboard' %}" method="post" id="filter_use"> {% csrf_token %}
    <div style="width:90%; margin: auto; padding: 10px;">
        {% render_table tables.1 %}
    </div>
</form>

{% endif %}

<br>

<form action="{% url 'Dashboard' %}" method="post" id="filter_form"> {% csrf_token %}
    <!-- Div for 3 inner divs that will occupy the page horizontally -->
    <div class="filter" style="width:90%; margin: auto; padding: 10px; ">
        <!-- 1st inner div: filter for obtaining a subset of runs -->
        <div class="filter-column" style="display: inline-block; *display: inline; zoom: 1; vertical-align: top; width:40%">
            <h5>Subset selection (select at least one)</h5>
            <div>
                <ul>
                    <select class="multiselect" name="assay_select" multiple title="Choose an assay">
                        {% for assay in assays %}
                            <option value="{{ assay }}">{{ assay }}</option>
                        {% endfor %}
                    </select>
                </ul>
                <ul>
                    <select class="multiselect" name="run_select" multiple title="Choose a run">
                        {% for project_name in project_names %}
                            <option value="{{ project_name }}">{{ project_name }}</option>
                        {% endfor %}
                    </select>
                </ul>
                <ul>
                    <select class="multiselect" name="sequencer_select" multiple title="Choose a sequencer id">
                        {% for sequencer_id in sequencer_ids %}
                            <option value="{{ sequencer_id }}">{{ sequencer_id }}</option>
                        {% endfor %}
                    </select>
                </ul>
                <ul>
                    <input type="date" name="date_start"> - <input type="date" name="date_end">
                </ul>
            </div>
        </div>

        <!-- 2nd inner div: Metrics for x-axis -->
        <div class="filter-column" style="display: inline-block; *display: inline; zoom: 1; vertical-align: top; width:40%">
            <h5>X axis - Metrics</h5>
            <select class="multiselect" name="metrics_x" disabled title="Choose a metric">
                {% for model, fields in metrics.items %}
                    <optgroup label={{ model }}>
                        {% for field in fields %}
                            <option data-subtext="{{ model }}" data-tokens="{{ model }} {{ field }}" value="{{ model }}|{{ field }}">{{ field }}</option>
                        {% endfor %}
                    </optgroup>
                {% endfor %}
            </select>
        </div>

        <!-- 3rd inner div: Metrics for y-axis -->
        <div class="filter-column" style="display: inline-block; *display: inline; zoom: 1; vertical-align: top; width:18%">
            <h5>Y axis - Metrics</h5>
            <select class="multiselect" name="metrics_y" title="Choose a metric">
                {% for model, fields in metrics.items %}
                    <optgroup label={{ model }}>
                        {% for field in fields %}
                            <option data-subtext="{{ model }}" data-tokens="{{ model }} {{ field }}" value="{{ model }}|{{ field }}">{{ field }}</option>
                        {% endfor %}
                    </optgroup>
                {% endfor %}
            </select>
        </div>
    </div>

    <br>

    <div style="display: inline-block; *display: inline; zoom: 1; vertical-align: top; padding-left:5%">
        <input class="btn btn-info" type="submit" name="plot" value="Plot">
        <input class="btn btn-info" type="submit" value="Save filter" name="save_filter" id="save_filter" onclick="saveFilter();"/>
    </div>
</form>

<script>
$(function () {
    $(".multiselect").selectpicker({
        liveSearch: true
    });
});

function saveFilter() {
    var filter_name = prompt("Name your filter:", "");
    if (!filter_name) return;
    $("#save_filter").val(filter_name);
    $("#filter_form").submit();
}

// if a button is clicked i.e. the buttons in the filter table submit the filter use form
$("button").click(function() {
    $("#filter_use").submit();
});
</script>

{% endblock %}

型

django

1条答案

按热度按时间
f2uvfpb9

f2uvfpb91#

看起来在类的__init__中的Django查询在获得新的GET请求时没有刷新表的值。
在我的自定义_get_context_data函数中移动这个查询似乎可以使刷新工作：

class Dashboard(MultiTableMixin, TemplateView):
    template_name = "dashboard.html"
    report_sample_data = Report_Sample.objects.all()
    tables = [
        ReportTable(Report.objects.all())
    ]
    model = Report

    table_pagination = {
        "per_page": 10
    }

    def _get_context_data(self):
        """ Get the basic data that needs to be displayed in the dashboard page

        Returns:
            dict: Dict of report and assay data to be passed to the dashboard
        """

        # get the default context data (the one key i need is one called tables)
        context = super().get_context_data()

        context["tables"].append(FilterTable(Filter.objects.all()))

字符串

赞(0）分享  回复(0）举报  2023-11-20
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com