Django 中的项目：我无法在终端中创建超级用户来操作 Postgresql 中的数据

Question

我正在用Django做一个项目，试图将数据库从SQLITE更改为Postqresql。当我尝试创建超级用户时，我会收到这个错误。

追溯

File "manage.py", line 22, in <module>
main()
File "manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangocoremanagement__init__.py", line 419, in execute_from_command_line
utility.execute()
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangocoremanagement__init__.py", line 413, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangocoremanagementbase.py", line 354, in run_from_argv
self.execute(*args, **cmd_options)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangocontribauthmanagementcommandscreatesuperuser.py", line 79, in execute
return super().execute(*args, **options)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangocoremanagementbase.py", line 398, in execute
output = self.handle(*args, **options)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangocontribauthmanagementcommandscreatesuperuser.py", line 189, in handle
self.UserModel._default_manager.db_manager(database).create_superuser(**user_data)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangocontribauthmodels.py", line 163, in create_superuser
return self._create_user(username, email, password, **extra_fields)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangocontribauthmodels.py", line 146, in _create_user
user.save(using=self._db)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangocontribauthbase_user.py", line 67, in save
super().save(*args, **kwargs)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangodbmodelsbase.py", line 726, in save
self.save_base(using=using, force_insert=force_insert,
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangodbmodelsbase.py", line 774, in save_base
post_save.send(
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangodispatchdispatcher.py", line 180, in send
return [
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangodispatchdispatcher.py", line 181, in <listcomp>
(receiver, receiver(signal=self, sender=sender, **named))
File "C:UserslDesktopdjango-courseDjango(02-09-21)crm1accountssignals.py", line 7, in customer_profile
group = Group.objects.get(name='customer')
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangodbmodelsmanager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:Userslanaconda3envsmyenvlibsite-packagesdjangodbmodelsquery.py", line 435, in get
raise self.model.DoesNotExist(
django.contrib.auth.models.DoesNotExist: Group matching query does not exist.

设置.py

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql',
'NAME': 'DEMO_TEST',
'USER' : 'postgres',
'HOST': 'localhost',
'PASSWORD':'12345678abcdef',
'PORT': '5432',
}
}

型号.py

from django.db import models
from django.db.models.deletion import SET_NULL
from django.contrib.auth.models import User
class Customer(models.Model):
user = models.OneToOneField(User, null=True, blank=True, on_delete=models.CASCADE)
name = models.CharField(max_length=200, null=True)
phone = models.CharField(max_length=200, null=True)
email = models.CharField(max_length=200, null=True)
profile_pic = models.ImageField(default='profile1.png',null=True, blank=True)
date_created = models.DateTimeField(auto_now_add=True, null=True)

def __str__(self):
return self.name
class Tag(models.Model):
name = models.CharField(max_length=200, null=True)

def __str__(self):
return self.name 
class Product(models.Model):
CATEGORY = (
('Indoor', 'Indoor'),
('Out Door', 'Out Door'),
) 

name = models.CharField(max_length=200, null=True)
prince = models.FloatField(null=True)
category = models.CharField(max_length=200, null=True, choices=CATEGORY)
description = models.CharField(max_length=200, null=True, blank=True)
date_created = models.DateTimeField(auto_now_add=True, null=True)
tags = models.ManyToManyField(Tag)
def __str__(self):
return self.name
class Order(models.Model):
STATUS = (
('Pending', 'Pending'),
('Out for delivery', 'Out for delivery'),
('Delivered', 'Delivered'),
)

customer = models.ForeignKey(Customer, null=True, on_delete=SET_NULL)
product = models.ForeignKey(Product, null=True, on_delete=SET_NULL)
status = models.CharField(max_length=200, null=True, choices=STATUS)
date_created = models.DateTimeField(auto_now_add=True, null=True)
note = models.CharField(max_length=1000, null=True)
def __str__(self):
return self.product.name

当我打开Django服务器时，项目正常工作；问题是当我试图从终端创建超级用户时。我不确定这个问题是来自Postgresql数据库与项目之间的连接，还是Django默认数据库(SQLITE(中创建和加载的模型的迁移问题。我已经尝试使用makemigration和migrate命令再次进行迁移，但在尝试创建超级用户时错误仍然存在。。。一些帮助会很好，非常感谢

Answer 1

您有一个信号处理程序customer_profile，它试图获取一个名为customer的Group。但该组尚未在PostgreSQL数据库中创建。

您可以将Group.objects.get(…)替换为：Group.objects.get_or_create(…):

def customer_profile(sender, instance, created, **kwagrs):
if created:
__, group = Group.objects.get_or_create(name='customer')
instance.groups.add(group)
Customer.objects.create(
user = instance,
name = instance.username
)
print('Profile created.!')