Django rest framework uses a custom user table

Article Directory


Django default user table auth_usercontains id, password, last_login, is_superuser, username, last_name, email, is_staff, is_active, date_joined, first_name field. When these basic fields are not enough, expanding fields on this basic table is a good choice. This article introduces the functional design of interface access control using custom user tables on DRF (Django Rest Framework).

1. Django project and application creation

Install the necessary modules first

pip install django
pip install djangorestframework

Create project folders, projects, and applications

E:\SweetYaya> mkdir MyProj01
E:\SweetYaya> cd MyProj01
E:\SweetYaya\MyProj01> django-admin startproject MyProj01 .
E:\SweetYaya\MyProj01> django-admin startapp MyApp

Synchronize the database

E:\SweetYaya\MyProj01> python migrate
Operations to perform:
  Apply all migrations: admin, auth, contenttypes, sessions
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying auth.0001_initial... OK
  Applying admin.0001_initial... OK
  Applying admin.0002_logentry_remove_auto_add... OK
  Applying sessions.0001_initial... OK

Test access after executing the following command

E:\SweetYaya\MyProj01>python runserver
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
June 07, 2021 - 21:16:57
Django version 3.2.4, using settings 'MyProj01.settings'
Starting development server at
Quit the server with CTRL-BREAK.

2. Customize the User table

Open the MyApp/models.pyfile, create inherits from AbstractUserthe UserProfileclass, add to it nameand mobilefield, it is our custom user table.

from django.db import models
from django.contrib.auth.models import AbstractUser

class UserProfile(AbstractUser):
    name = models.CharField(max_length=30, null=True, blank=True, verbose_name="姓名")
    mobile = models.CharField(max_length=11, verbose_name="电话")

    class Meta:
        verbose_name = "用户"
        verbose_name_plural = "用户"

        def __str__(self):

3. Serialization and routing

We directly MyProj01/url.pydefine the sequence of the method and route configuration

from django.urls import path, include
from MyApp.models import UserProfile
from rest_framework import routers, serializers, viewsets

# Serializers define the API representation.
class UserSerializer(serializers.HyperlinkedModelSerializer):
    class Meta:
        model = UserProfile
        fields = ['url', 'username', 'name', 'mobile', 'email', 'is_staff']

# ViewSets define the view behavior.
class UserViewSet(viewsets.ModelViewSet):
    queryset = UserProfile.objects.all()
    serializer_class = UserSerializer

# Routers provide an easy way of automatically determining the URL conf.
router = routers.DefaultRouter()
router.register('users', UserViewSet)

# Wire up our API using automatic URL routing.
# Additionally, we include login URLs for the browsable API.
urlpatterns = [
    path('', include(router.urls)),
    path('api-auth/', include('rest_framework.urls', namespace='rest_framework'))

3. DRF configuration

Find it MyProj01/, do the following configuration

  1. Join the application created above and rest_framework
  1. Add global authentication settings
  1. Modify the default user table, so far settings.pyall done!
AUTH_USER_MODEL = 'MyApp.UserProfile'

4. Synchronize the database

Execute makemigrationsthe command

E:\SweetYaya\MyProj01> python makemigrations
Migrations for 'MyApp':
    - Create model UserProfile

Execute migratecommands there are mistakes

E:\SweetYaya\MyProj01> python migrate
Traceback (most recent call last):
  File "", line 22, in <module>
  File "", line 18, in main
  File "D:\Program Files\Python36\lib\site-packages\django\core\management\", line 419, in execute_from_command_line
  File "D:\Program Files\Python36\lib\site-packages\django\core\management\", line 413, in execute
  File "D:\Program Files\Python36\lib\site-packages\django\core\management\", line 354, in run_from_argv
    self.execute(*args, **cmd_options)
  File "D:\Program Files\Python36\lib\site-packages\django\core\management\", line 398, in execute
    output = self.handle(*args, **options)
  File "D:\Program Files\Python36\lib\site-packages\django\core\management\", line 89, in wrapped
    res = handle_func(*args, **kwargs)
  File "D:\Program Files\Python36\lib\site-packages\django\core\management\commands\", line 95, in handle
  File "D:\Program Files\Python36\lib\site-packages\django\db\migrations\", line 310, in check_consistent_history
django.db.migrations.exceptions.InconsistentMigrationHistory: Migration admin.0001_initial is applied before its dependency MyApp.0001_initial on database 'default'.


  • first makemigrations
  • Open, comment out INSTALL_APPS
  • Open, comment out admin in urlpatterns
  • And then migratenot being given a
  • Finally, just pay attention to restoring the content of the comment.
E:\SweetYaya\MyProj01> python migrate
Operations to perform:
  Apply all migrations: MyApp, admin, auth, contenttypes, sessions
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying contenttypes.0002_remove_content_type_name... OK
  Applying admin.0003_logentry_add_action_flag_choices... OK
  Applying sessions.0001_initial... OK

5. Testing

Excuting an order

E:\SweetYaya\MyProj01>python runserver

Access results are as follows, indicating a successful configuration at this time, but yet do not have access to log in users.

Insert picture description here

6. Register users from the command line

enter Python Shell

E:\SweetYaya\MyProj01> python shell
Python 3.6.6 (v3.6.6:4cf1f54eb7, Jun 27 2018, 03:37:03) [MSC v.1900 64 bit (AMD64)]
Type 'copyright', 'credits' or 'license' for more information
IPython 6.5.0 -- An enhanced Interactive Python. Type '?' for help.

Type the following code

In [1]: from MyApp.models import UserProfile

In [2]: from django.contrib.auth.hashers import make_password

In [3]: ist = UserProfile(username='guest01',password=make_password('123456'))

In [4]:

In [5]: ist = UserProfile(username='guest02',password=make_password('123456'))

In [6]:

Then in the database to view the MyApp_userprofiletable found in more than two records, add successful, continue to access, user password is visible below. Finished test.

Insert picture description here



The peach blossom fairy grows peach trees and picks peach blossoms for wine