如何从模板获取多个值并更新表中的多行? Django的 [英] 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.
template
<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()
这篇关于如何从模板获取多个值并更新表中的多行? Django的的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!