django不用在数据库中创建新的user表而使用它的后台管理功能

在一个项目中经常要对远端的一个数据库中的数据做修改，每次都写sql感觉很麻烦，就想到能不能直接利用django的后台管理功能呢，当然是可以的，但是要登录django的后台使用它的管理功能必须在对应的数据库创建django后台管理需要的user和Log相关的表，而这个又是不可能的，那能不能不创建user表而仅仅是使用它的后台管理功能呢，答案是可以的

django后台登录需要输入用户名、密码，用户登录验证的backend默认是django.contrib.auth.backends，而它采用的是数据库表的验证，为了不创建新表，我们需要修改登录验证的backends，

修改的方法很简单，在setting.py中添加配置

AUTHENTICATION_BACKENDS = ["houtai.extend.auth.backends.SimpleBackend"]#用户验证的Backend

然后要实现SimpleBackend，验证后需要返回一个User对象，所以还需要实现一个SingleUser类

from __future__ import unicode_literals
from houtai.extend.auth.user import SingleUser

class SimpleBackend(object):
    """
    Authenticates against settings.AUTH_USER_MODEL.
    """

    def authenticate(self, username=None, password=None):
        cur_user = SingleUser()
        if cur_user.validate(username,password):
            return cur_user
        
    def get_user(self, user_id):
        return SingleUser()

from houtai.extend.common import Singleton
class SingleUser(Singleton):
    username = "admin"
    password = "111111"
    is_active = 1
    is_staff =1
    is_superuser =1
    pk = '123456'
       
    def validate(self,username,password):
        if username and password:
            if username == self.username and password == self.password:
                return True
        return False
    def save(self,update_fields=['last_login']):
        return
    def has_module_perms(self, app_label):
        """
        Returns True if the user has any permissions in the given app label.
        Uses pretty much the same logic as has_perm, above.
        """
        # Active superusers have all permissions.
        if self.is_active and self.is_superuser:
            return True
        return False
    def has_perm(self, perm, obj=None):
        return True

有了上面的backends就能够用admin:111111登录到后台，单很快就会出现下面这个错误：

"Table 'test.django_content_type' doesn't exist"

这时候需要做下面三件事才能搞定：

1、修改admin后台首页的模板：

在url.py中添加admin.site.index_template = 'houtai/index.html'

index.html

{% extends "admin/base_site.html" %}
{% load i18n admin_static %}

{% block extrastyle %}{{ block.super }}<link rel="stylesheet" type="text/css" href="{% static "admin/css/dashboard.css" %}" />{% endblock %}

{% block coltype %}colMS{% endblock %}

{% block bodyclass %}dashboard{% endblock %}

{% block breadcrumbs %}{% endblock %}

{% block content %}
<div id="content-main">

{% if app_list %}
    {% for app in app_list %}
        <div class="app-{{ app.app_label }} module">
        <table>
        <caption>
            <a href="{{ app.app_url }}" class="section" title="{% blocktrans with name=app.name %}Models in the {{ name }} application{% endblocktrans %}">
                {% blocktrans with name=app.name %}{{ name }}{% endblocktrans %}
            </a>
        </caption>
        {% for model in app.models %}
            <tr class="model-{{ model.object_name|lower }}">
            {% if model.admin_url %}
                <th scope="row"><a href="{{ model.admin_url }}">{{ model.name }}</a></th>
            {% else %}
                <th scope="row">{{ model.name }}</th>
            {% endif %}

            {% if model.add_url %}
                <td><a href="{{ model.add_url }}" class="addlink">{% trans 'Add' %}</a></td>
            {% else %}
                <td> </td>
            {% endif %}

            {% if model.admin_url %}
                <td><a href="{{ model.admin_url }}" class="changelink">{% trans 'Change' %}</a></td>
            {% else %}
                <td> </td>
            {% endif %}
            </tr>
        {% endfor %}
        </table>
        </div>
    {% endfor %}
{% else %}
    <p>{% trans "You don't have permission to edit anything." %}</p>
{% endif %}
</div>
{% endblock %}

2、修改django.contrib.admin.options.py

修改：

action_list = LogEntry.objects.filter(
                object_id=unquote(object_id),
                content_type__id__exact=ContentType.objects.get_for_model(model).id
            ).select_related().order_by('action_time')

为：

if settings.LOGGING != None:
            action_list = LogEntry.objects.filter(
                object_id=unquote(object_id),
                content_type__id__exact=ContentType.objects.get_for_model(model).id
            ).select_related().order_by('action_time')

修改：

from django.contrib.admin.models import LogEntry, ADDITION
            LogEntry.objects.log_action(
                user_id=request.user.pk,
                content_type_id=ContentType.objects.get_for_model(object).pk,
                object_id=object.pk,
                object_repr=force_text(object),
                action_flag=ADDITION
            )

为：

if settings.LOGGING != None:
            from django.contrib.admin.models import LogEntry, ADDITION
            LogEntry.objects.log_action(
                user_id=request.user.pk,
                content_type_id=ContentType.objects.get_for_model(object).pk,
                object_id=object.pk,
                object_repr=force_text(object),
                action_flag=ADDITION
            )

修改：

from django.contrib.admin.models import LogEntry, CHANGE
            LogEntry.objects.log_action(
                user_id=request.user.pk,
                content_type_id=ContentType.objects.get_for_model(object).pk,
                object_id=object.pk,
                object_repr=force_text(object),
                action_flag=CHANGE,
                change_message=message
            )

为：

if settings.LOGGING != None:
            from django.contrib.admin.models import LogEntry, CHANGE
            LogEntry.objects.log_action(
                user_id=request.user.pk,
                content_type_id=ContentType.objects.get_for_model(object).pk,
                object_id=object.pk,
                object_repr=force_text(object),
                action_flag=CHANGE,
                change_message=message
            )

修改：

from django.contrib.admin.models import LogEntry, DELETION
            LogEntry.objects.log_action(
                user_id=request.user.pk,
                content_type_id=ContentType.objects.get_for_model(self.model).pk,
                object_id=object.pk,
                object_repr=object_repr,
                action_flag=DELETION
            )

为：

if settings.LOGGING != None:
            from django.contrib.admin.models import LogEntry, DELETION
            LogEntry.objects.log_action(
                user_id=request.user.pk,
                content_type_id=ContentType.objects.get_for_model(self.model).pk,
                object_id=object.pk,
                object_repr=object_repr,
                action_flag=DELETION
            )

3、在setting.py中设置Loging为None

LOGGING  = None#关闭后台日志记录功能

至此就可以用admin:111111登录后台管理远程的数据库了