编程错误在 /admin/order/order/ 关系"order_order"不存在 第 1 行：选择 COUNT(*) 作为"order_order"中的"__count"

Question

我正在与django rest framework合作，我有一个名为订单的应用程序。我想改变我的订单逻辑，我改变了订单应用程序的模型。但是当我想在管理面板中打开order和order_item模型时，我有这个错误:

ProgrammingError at /admin/order/order/
relation "order_order" does not exist
LINE 1: SELECT COUNT(*) AS "__count" FROM "order_order"

并且当我运行migrate命令时，它不能很好地迁移并且不能在数据库中创建order和OrderItem表。我正在使用postgres数据库。这是我的代码:

模型:

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)
# products = models.ManyToManyField(OrderItem)
created_date = models.DateTimeField(auto_now_add=True)
ordered_date = models.DateTimeField()
ordered = models.BooleanField(default=False)
def __str__(self):
return self.user.full_name
def total_price(self):
total = 0
for order_item in self.products.all():
total += order_item.get_final_price()
return total

class OrderItem(models.Model):
user = models.ForeignKey(settings.AUTH_USER_MODEL,
on_delete=models.CASCADE)
order = models.ForeignKey(Order, on_delete=models.CASCADE, related_name='products')
ordered = models.BooleanField(default=False)
product = models.ForeignKey(Product, on_delete=models.CASCADE)
quantity = models.PositiveSmallIntegerField(default=1)
def __str__(self):
return f"{self.quantity} of {self.product.name}"
def get_total_item_price(self):
return self.quantity * self.product.price
def get_total_discount_item_price(self):
return self.quantity * self.product.discount
def get_amount_saved(self):
return self.get_total_item_price() - self.get_total_discount_item_price()
def get_final_price(self):
if self.product.discount:
return self.get_total_discount_item_price()
return self.get_total_item_price()

管理:

class OrderAdmin(admin.ModelAdmin):
list_display = ['user',
'ordered',
'ordered_date',
'created_date',
'total_price'
]
list_display_links = ['user', ]
list_filter = ['ordered', ]
search_fields = [
'user',
'ref_code'
]

admin.site.register(Order, OrderAdmin)
admin.site.register(OrderItem)

序列化器:

class OrderItemSerializer(serializers.ModelSerializer):
product = serializers.SerializerMethodField()
final_price = serializers.SerializerMethodField()
class Meta:
model = OrderItem
fields = (
'id',
'product',
'quantity',
'final_price'
)
def get_product(self, obj):
return ProductSerializer(obj.product).data
def get_final_price(self, obj):
return obj.get_final_price()

class OrderSerializer(serializers.ModelSerializer):
order_items = serializers.SerializerMethodField()
total = serializers.SerializerMethodField()
class Meta:
model = Order
fields = (
'id',
'order_items',
'total',
)
def get_order_items(self, obj):
return OrderItemSerializer(obj.products.all(), many=True).data
def get_total(self, obj):
return obj.total_price()

Answer 1

想评论一下，但是你试过使用python manage.py migrate yourapp --fake吗?

这是我从哪里得到的

Answer 2

我正在使用容器平台，并在docker平台上使用posgres。在posgres容器中，我使用了网络和存储。因为我在存储中有一个运行的容器，它是保存的数据，我不能通过删除pgadmin中的db或重新启动容器或通过迁移更改db来更改它们。我移走了我的容器，制作了新的容器。这样问题就解决了。