Django 2.2:将用户模型分解为两种不同的模型?

2024-10-03 11:24:28 发布

您现在位置:Python中文网/ 问答频道 /正文

我使用内置的Django管理员,我有两种类型的用户,需要使用不同的URL调用这两种用户,即http://127.0.0.1:8000/admin/staff&http://127.0.0.1:8000/admin/customer需要将用户模型分解为两个独立的模型Staff&CustomerStaff模型将用于管理员用户&Customer模型将用于前端用户

注意:我将db表名保持为默认的auth_userauth_group…等

我已经在project中创建了名为users的应用程序

到目前为止,我尝试了以下几点:

型号.py

from django.contrib.auth.models import (
    AbstractUser, Permission, Group, GroupManager)
from django.db import models
from django.utils.translation import gettext_lazy as _

class Staff(AbstractUser):

    class Meta(AbstractUser.Meta):
        swappable = 'AUTH_USER_MODEL'
        verbose_name = _('staff')
        verbose_name_plural = _('staffs')
        db_table = 'auth_user'


class Customer(AbstractUser):

    class Meta(AbstractUser.Meta):
        swappable = 'AUTH_USER_MODEL'
        verbose_name = _('customer')
        verbose_name_plural = _('customers')
        db_table = 'auth_user'

admin.py

from django.contrib import admin
from django.contrib.auth.models import Group, User, Permission
from django.contrib.auth.admin import GroupAdmin, UserAdmin
from django.utils.translation import ugettext_lazy as _
from django import forms
from django.forms import ModelForm, Select
from users.models import Staff, Customer


class MyGroupAdminForm(forms.ModelForm):

    class Meta:
        model = Group
        fields = ('name', 'permissions')

    permissions = forms.ModelMultipleChoiceField(
        Permission.objects.exclude(content_type__app_label__in=[
                                   'auth', 'admin', 'sessions', 'users', 'contenttypes']),
        widget=admin.widgets.FilteredSelectMultiple(_('permissions'), False))


class MyUserAdminForm(forms.ModelForm):
    model = User
    groups = forms.ModelChoiceField(Group.objects, label='Role')

    class Meta:
        model = User
        fields = '__all__'


class CustomUserAdmin(UserAdmin):
    form = MyUserAdminForm
    fieldsets = (
        (None, {'fields': ('username', 'password')}),
        (_('Personal info'), {'fields': ('first_name', 'last_name', 'email')}),
        (_('Permissions'), {'fields': ('is_active', 'is_staff', 'is_superuser',
                                       'groups',)}),
        (_('Important dates'), {'fields': ('last_login', 'date_joined')}),
    )


class CustomGroupAdmin(GroupAdmin):
    form = MyGroupAdminForm

# admin.site.unregister(User)
admin.site.unregister(Group)


# admin.site.register(User, CustomUserAdmin)
# admin.site.register(Group, CustomGroupAdmin)

admin.site.register(Staff, CustomUserAdmin)
admin.site.register(Group, CustomGroupAdmin)

设置.py

AUTH_USER_MODEL = "users.Staff"

现在,当我尝试更改任何staff用户时,我遇到以下错误:

OperationalError at /admin/users/staff/1/change/
(1054, "Unknown column 'auth_user_groups.staff_id' in 'where clause'")
Request Method: GET
Request URL:    http://127.0.0.1:8000/admin/users/staff/1/change/
Django Version: 2.2.8
Exception Type: OperationalError
Exception Value:    
(1054, "Unknown column 'auth_user_groups.staff_id' in 'where clause'")
Exception Location: C:\Users\kalim.ullah\Envs\Cert\lib\site-packages\MySQLdb\connections.py in query, line 239
Python Executable:  C:\Users\kalim.ullah\Envs\Cert\Scripts\python.exe
Python Version: 3.8.0
Python Path:    
['D:\\projects\\certdashboard',
 'C:\\Users\\kalim.ullah\\Envs\\Cert\\Scripts\\python38.zip',
 'C:\\Users\\kalim.ullah\\Envs\\Cert\\DLLs',
 'C:\\Users\\kalim.ullah\\Envs\\Cert\\lib',
 'C:\\Users\\kalim.ullah\\Envs\\Cert\\Scripts',
 'c:\\users\\kalim.ullah\\appdata\\local\\programs\\python\\python38\\Lib',
 'c:\\users\\kalim.ullah\\appdata\\local\\programs\\python\\python38\\DLLs',
 'C:\\Users\\kalim.ullah\\Envs\\Cert',
 'C:\\Users\\kalim.ullah\\Envs\\Cert\\lib\\site-packages']
Server time:    Fri, 10 Jan 2020 13:00:41 +0000

请指导我做这件事的正确方法

谢谢


Tags: djangofromimportauthcertadmingroupsite