如何在Django中进行多次更新？

Question

我试图通过签入复选框然后按下更新按钮在django中进行多次更新。你知道吗

这是我的视图.py你知道吗

def update_kel_stat(request, id, kelid):
    if request.method == "POST":
        cursor = connection.cursor()
        sql = "UPDATE keluargapeg_dipkeluargapeg SET KelStatApprov='3' WHERE (PegUser = %s AND KelID=%s )" % (id, kelid,)
        cursor.execute(sql)

其中“id”是用户参数，“kelid”是行参数，其中“kelid”成为多个参数。你知道吗

这是我的网址.py你知道吗

url(r'^karyawan/update_status/(?P<id>\d+)/(?P<kelid>\d+)/$', views.pesan_update, name='update_pesan')

你知道吗模板.html，我使用JavaScript加载用于更新的url

    <script>
    function setDeleteAction() {
        if (confirm("Are you sure want to delete these rows?")) {
            document.kel.action = "{% url 'update_pesan' %}";
            document.kel.submit();
        }
    }
</script>

<form method="post" action="" name="kel" enctype="multipart/form-data">
{% for keluarga in kels %}
    <tr id="{{ keluarga.KelID }}">
        <td>
            <a href="#">{{ keluarga.KelNamaLengkap }}</a>
        </td>
        <td>{{ keluarga.KelHubungan }}</td>
        <td class="hidden-480">{{ keluarga.KelTglLahir }}</td>
        <td>{{ keluarga.KelJenisKel }}</td>
        <td class="hidden-480">{{ keluarga.KelIjazahAkhir }}
        </td>
        <td>{{ keluarga.KelPekerjaan }}</td>
        {% if keluarga.KelStatApprov == '1' %}
            <td><span
                    class="label label-sm label-danger">Draft</span>
            </td>
        {% elif keluarga.KelStatApprov == '2' %}
            <td>
                <span class="label label-sm label-warning">Revisi</span>
            </td>
        {% elif keluarga.KelStatApprov == '3' %}
            <td>
                <span class="label label-sm label-success">Setuju</span>
            </td>
        {% endif %}
        <td>{{ keluarga.KelKetRevisi }}</td>
        <td>
            <a href="
                    {{ MEDIA_URL }}{{ keluarga.KelFileUpload }}">{{ keluarga.KelNamaFile }}</a>
        </td>
        <td><input type="checkbox" name="kel[]"
                   value="{{ keluarga.KelID }}"></td>
        <td>
            <div class="hidden-sm hidden-xs action-buttons">
                <a class="green"
                   href="{% url 'edit_keluarga' keluarga.PegUser keluarga.KelID %}">
                    <i class="ace-icon fa fa-pencil bigger-130"></i>
                </a>
                <a class="red" href="#">
                    <i class="ace-icon fa fa-trash-o bigger-130"></i>
                </a>
            </div>
        </td>
    </tr>
{% endfor %}
<tr>
    <td>
        <button type="button" name="btn_delete" id="btn_delete"
                class="btn btn-success"
                onClick="setDeleteAction();">Approve
        </button>
    </td>
</tr>

如何在视图和url中获得多行（如php中的数组）？你知道吗

Answer 1

你在找getlist吗？你知道吗

QueryDict.getlist(key, default=None)
Returns the data with the requested key, as a Python list. Returns an empty list if the key doesn’t exist and no default value was provided. It’s guaranteed to return a list of some sort unless the default value provided is not a list.

request.POST.getlist('kel')