如何从模板中获取多个值并更新表中的多行?姜戈 [英] How to get multiple values from a template and update multiple rows in a table? Django

问题描述

我对 Django 和 Python 还很陌生.我有一个库存管理网站.我正在尝试更新数据库中的多个值.用户应该能够输入更新的库存值，并且应该更新已提交的每个项目的库存值.页面图片

I'm fairly new to Django and Python. I have a inventory management website. I am trying to update multiple values in a database. User should be able to input updated stock values and it should update each item's stock value which has been submitted. Image of page

我尝试使用item[{{item.id}}]"来创建一个列表，但我不确定如何使用此列表或如何更新多行.我的猜测是我需要从模板中收集所有值和键，并在 POST 中运行一个循环并按 ID 更新相关行.

I tried "item[{{item.id}}]" to create a list but i'm not sure how to use this list or how to update multiple rows. My guess is that I need to gather all the values and keys from the template and in POST run a loop and update the relavant rows by ID.

模板

<form action="" method="post">
  {% csrf_token %}

  {% for item in items %}
    <tr>
      <td>{{item.name}}</td>
      <td>{{item.description}}</td>
      <td>{{item.buyprice}}</td>
      <td>{{item.sellprice}}</td>
      <td><input type="number" value="{{item.instock}}" name="item[{{item.id}}]"></td>
    </tr>
  {% endfor %}
  <tr>
    <td><input type="submit" value="Update"></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
  </tr>
  </tbody>
  </table>
</form>

查看

def stockUpd(request):
    if request.method == 'GET':
        items = Item.objects.filter(user=request.user)
        context = {
        'items':items
        }
        return render(request,'stock/stockupd.html',context);
    #if request.method == 'POST':

推荐答案

做

<input type="number" value="{{item.instock}}" name="item_{{item.id}}">

然后

if request.method == 'POST':
    data = request.POST.dict()
    data.pop('csrfmiddlewaretoken', None)
    for i in data.items():
        obj = Item.objects.get(id=i[0].split("_")[1])
        if not str(obj.instock) == str(i[1]): #here check int or char datatype since 1 not equal "1"
            obj.instock = i[1]
            obj.save()

这篇关于如何从模板中获取多个值并更新表中的多行?姜戈的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！