- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
下面是我的模型,用于查看错误发生的地方,尤其是 StockQuantity 模型中发生错误的地方,当我尝试过滤或使用 get 检索查询时,它显示的是预期数字但得到了“字符串值”
models.py
# Item
class Item(models.Model):
title = models.CharField(max_length=100)
price = models.FloatField()
discount_price = models.FloatField(blank=True, null=True)
category = models.ForeignKey(
'Category', on_delete=models.CASCADE, null=True)
label = models.CharField(choices=LABEL_CHOICES, max_length=1)
slug = models.SlugField()
description = models.TextField()
# stock_quantity = models.IntegerField(blank=True, null=True)
cover_image = models.ImageField(blank=True, null=True,
upload_to=item_cover_upload_location, default='no-product-image.jpg')
is_footwear = models.BooleanField(default=False)
upload_date = models.DateTimeField(default=timezone.now)
# StockQuantity
class StockQuantity(models.Model):
item = models.ForeignKey('Item', on_delete=models.CASCADE, null=True)
color = models.ForeignKey(
'ItemColor', on_delete=models.CASCADE)
cloth_size = models.ForeignKey(
'ClothSize', on_delete=models.CASCADE, blank=True, null=True)
footwear_size = models.ForeignKey(
'FootwearSize', on_delete=models.CASCADE, blank=True, null=True)
stock_quantity = models.IntegerField(null=True, default=10)
#OrderItem
class OrderItem(models.Model):
user = models.ForeignKey(
settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
item = models.ForeignKey(Item, on_delete=models.CASCADE)
quantity = models.IntegerField(default=1)
footwear_size = models.CharField(max_length=50, null=True)
cloth_size = models.CharField(max_length=50, null=True)
color = models.CharField(max_length=50, null=True)
ordered = models.BooleanField(default=False)
#Order
class Order(models.Model):
user = models.ForeignKey(
settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
ref_code = models.CharField(max_length=20, blank=True, null=True)
items = models.ManyToManyField(OrderItem)
start_date = models.DateTimeField(auto_now_add=True)
ordered_date = models.DateTimeField()
ordered = models.BooleanField(default=False)
shipping_address = models.ForeignKey(
'Address', related_name='shipping_address', on_delete=models.SET_NULL, blank=True, null=True)
billing_address = models.ForeignKey(
'Address', related_name='billing_address', on_delete=models.SET_NULL, blank=True, null=True)
payment = models.ForeignKey(
'Payment', on_delete=models.SET_NULL, blank=True, null=True)
coupon = models.ForeignKey(
'Coupon', on_delete=models.SET_NULL, blank=True, null=True)
being_delivered = models.BooleanField(default=False)
received = models.BooleanField(default=False)
requested_refund = models.BooleanField(default=False)
refund_status = models.BooleanField(default=False)
#Payment
class Payment(models.Model):
user = models.ForeignKey(settings.AUTH_USER_MODEL,
on_delete=models.SET_NULL, blank=True, null=True)
paypal_transaction_id = models.CharField(max_length=50)
amount = models.FloatField()
timestamp = models.DateTimeField(default=timezone.now)
# ItemColor
class ItemColor(models.Model):
item_color = models.CharField(
max_length=25, null=True, blank=True)
item = models.ForeignKey('Item', on_delete=models.CASCADE, null=True)
def __str__(self):
return self.item_color
# ClothSize
class ClothSize(models.Model):
cloth_size = models.CharField(
max_length=25, null=True, blank=True)
item = models.ForeignKey('Item', on_delete=models.CASCADE, null=True)
def __str__(self):
return self.cloth_size
# FootwearSize
class FootwearSize(models.Model):
footwear_size = models.CharField(
max_length=25, null=True, blank=True)
item = models.ForeignKey('Item', on_delete=models.CASCADE, null=True)
以下是我的views.py,特别是引发错误的 View ,我已发表评论以进一步帮助确认错误发生的位置
Views.py
# View where the error occurs
def payment_complete(request):
body = json.loads(request.body)
order = Order.objects.get(
user=request.user, ordered=False, ref_code=body['orderid'])
payment = Payment(
user=request.user,
paypal_transaction_id=body['payid'],
amount=order.get_total()
)
payment.save()
order.ordered = True
order.payment = payment
order.received = True
order.save()
order_items = order.items.all()
order_items.update(ordered=True)
for item in order_items:
if item.item.is_footwear:\
# ERROR OCCURS BELOW ---------
st = StockQuantity.objects.get(
item=item.item, color=item.color, footwear_size=str(item.footwear_size))
else:
# ERROR OCCURS BELOW ---------
st = StockQuantity.objects.get(
item=item.item, color=item.color, cloth_size=str(item.cloth_size))
if st.stock_quantity > 0:
st.stock_quantity -= item.quantity
st.save()
item.save()
item.item.save()
else:
messages.warning("Item out of stock!!")
print("Quantity " + str(st.stock_quantity))
# order_item = OrderItem.objects.get(user=request.user, ordered=True)
messages.success(request, "Order placed successfully!!")
return redirect("/")
追溯和错误
Django version 3.1.1, using settings 'djecommerce.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CTRL-BREAK.
[25/Nov/2020 11:23:42] "GET /product/dummy-item-1/ HTTP/1.1" 200 15564
[25/Nov/2020 11:23:45] "POST /add-to-cart/dummy-item-1 HTTP/1.1" 302 0
[25/Nov/2020 11:23:45] "GET /order-summary/ HTTP/1.1" 200 9206
[25/Nov/2020 11:23:46] "GET /checkout/ HTTP/1.1" 200 37908
Using the defualt shipping address
Using the defualt billing address
[25/Nov/2020 11:23:51] "POST /checkout/ HTTP/1.1" 302 0
[25/Nov/2020 11:23:51] "GET /payment/paypal/ HTTP/1.1" 200 11866
Internal Server Error: /payment-complete/
Traceback (most recent call last):
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\fields\__init__.py", line 1774, in get_prep_value
return int(value)
ValueError: invalid literal for int() with base 10: 'S'
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\core\handlers\exception.py", line 47, in inner
response = get_response(request)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\core\handlers\base.py", line 179, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\core\views.py", line 446, in payment_complete
st = StockQuantity.objects.get(
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\query.py", line 418, in get
clone = self._chain() if self.query.combinator else self.filter(*args, **kwargs)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\query.py", line 942, in filter
return self._filter_or_exclude(False, *args, **kwargs)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\query.py", line 962, in _filter_or_exclude
clone._filter_or_exclude_inplace(negate, *args, **kwargs)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\query.py", line 969, in _filter_or_exclude_inplace
self._query.add_q(Q(*args, **kwargs))
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\sql\query.py", line 1358, in add_q
clause, _ = self._add_q(q_object, self.used_aliases)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\sql\query.py", line 1377, in _add_q
child_clause, needed_inner = self.build_filter(
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\sql\query.py", line 1319, in build_filter
condition = self.build_lookup(lookups, col, value)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\sql\query.py", line 1165, in build_lookup
lookup = lookup_class(lhs, rhs)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\lookups.py", line 24, in __init__
self.rhs = self.get_prep_lookup()
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\fields\related_lookups.py", line 115, in get_prep_lookup
self.rhs = target_field.get_prep_value(self.rhs)
File "C:\Users\halfs\Desktop\DJango\Django-ecommerce\env\lib\site-packages\django\db\models\fields\__init__.py", line 1776, in get_prep_value
raise e.__class__(
ValueError: Field 'id' expected a number but got 'S'.
[25/Nov/2020 11:24:18] "POST /payment-complete/ HTTP/1.1" 500 129792
[25/Nov/2020 11:24:19] "GET / HTTP/1.1" 200 15371
我了解问题是 Django 通过分配 ID 而不是实际值来保存外键,但如果我不知道对象的 ID,我不知道如何过滤对象。谢谢,任何帮助表示赞赏!
最佳答案
查询 ForeignKey 字段时,您“通常”传递模型的一个实例。例如:
# Example models
class AnotherModel(models.Model):
name = models.CharField(...)
class MyModel(models.Model):
another_model = models.ForeignKey(AnotherModel,...)
# Get the instance
another_model_instance = AnotherModel.objects.get(id=1)
# Use the instance in the query
my_model = MyModel.objects.get(another_model=another_model_instance)
但是,您可以使用 __
(双下划线)“跳跃”并查询特定字段。例如:
my_model = MyModel.objects.get(another_model__name='Some name')
在上面的示例中,我们使用 AnotherModel
模型上的 name
字段进行查询。我们可以使用它来修复您 View 中的查询。
# Taken from your payment_complete view
for item in order_items:
if item.item.is_footwear:
st = StockQuantity.objects.get(
item=item.item,
color__item_color=item.color,
footwear_size__footwear_size=str(item.footwear_size)
)
else:
st = StockQuantity.objects.get(
item=item.item,
color__item_color=item.color,
cloth_size__cloth_size=str(item.cloth_size)
)
延伸阅读:https://docs.djangoproject.com/en/3.1/topics/db/queries/ .
关于python - Django ValueError : Field 'id' expected a number but got 'S' ,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/64999216/
就目前而言,这个问题不适合我们的问答形式。我们希望答案得到事实、引用资料或专业知识的支持,但这个问题可能会引发辩论、争论、投票或扩展讨论。如果您觉得这个问题可以改进并可能重新打开,visit the
我是脚本新手。如何编写 Expect 脚本以通过 ssh 连接到设备并提示用户输入密码?我们使用 pin + RSA token 代码作为密码,因此我无法存储密码。 #!/usr/bin/expect
我编写了以下代码并尝试执行它。但我在执行 do {”时遇到“无效的命令名称“do”” 代码: #!/usr/bin/expect set val 0; set input 5; do { pu
我已经查看了 Expect 联机帮助页并用 Google 搜索了它,但我还没有找到 expect 的 -r 是什么。我看到这个选项以前是这样用的 expect -r "\r\n\r\n" 在 expe
我的 shebang 看起来像这样: #!/usr/bin/expect -d 当我从命令行运行脚本时,它会提供我想要的内容。 但是,我通过 crontab 运行这个脚本。是否可以将调试开关保持打开状
我是 Expect 脚本的新手。 我在 Linux 机器上为 ssh 编写了一个 Expect 脚本,在那里我在 ssh 到不同的 Linux 机器时遇到了问题。下面我复制了脚本。 !/usr/loc
Scene 1, Layer 'script', Frame 1, Line 9 1084: Syntax error: expecting identifier before this. Sc
我正在运行调试命令以将命令的输出记录到文件中。我尝试了 log_file 命令,但它没有记录输出。我的代码如下: log_file -a gdb.txt send "~/debugulator.sh
我希望 expect_user 有一个无限的(或非常大的)超时和 expect 的默认超时。有没有办法设置不同的超时?或者我是否只需要在每次更改用途之前手动执行此操作? 最佳答案 expect 和ex
我正在学习 iOS 编程(我来自 Android),我正在寻找更容易获取字符串的方法。有了这个建议,我定义了下一个宏并在一些代码片段中使用它: #define STRING_BASE @"InfoPl
你好我是 rspec 的新手,我想弄清楚将 block 传递给 expect{} 和只使用 expect() 之间的区别 这是一个简单的例子 require "rails_helper" RSpec.
我正在尝试为 React JS 运行单元测试 - 使用 jest/enzyme。 目前测试失败。不太清楚为什么,也许我没有正确调用 expect(wrapper.find)。这是我测试的一部分: F
例如,现在我有一个“root.exp”期望脚本如下: spawn ssh user@ip expect "Password:" send "password" 然后,我要发送到这个ssh服务器的exp
您好,我是 Expect 脚本编写的新手,我一直在尝试使用以下方法将 IP 地址获取到变量中: set timeout -1 spawn $env(SHELL) match_max 100000 se
expect.anything() 不适用于 expect.toBe(),但适用于 expect.toEqual() test("this will pass", () => { expect("
我有一个如下所示的简单脚本,从命令行读取 2 个数字并将它们加在一起: $cat runexp.sh #!/bin/bash echo "read 1st number" read n1 echo "
当 Linux 机器的 $IP 登录后询问密码时,下面的 expect 脚本工作正常 但在某些情况下,某些Linux机器不需要ssh密码(我们可以不用密码登录), 所以我需要更改我的期望脚本以支持没有
我正在尝试使用 expect 远程登录服务器并更改用户密码。该应用程序要求,如果您要更改的密码包含特殊字符,则将其引用。问题是,还需要引用 expect send 语句,当我尝试将两者结合起来时,脚本
下面这个简单的 expect 脚本的目标是获取远程机器上的 hostname 名称 有时期望脚本无法执行到 $IP_ADDRESS 的 ssh(因为远程机器不活动等) 所以在这种情况下,expect
我试图创建一个宏来替换, first: Some(first.as_ref().parse::().expect("Could not parse 'first'")) 我在其他模块(如 Clap w
我是一名优秀的程序员,十分优秀!