django 多mysql数据库操作_django的多数据库的操作

红太狼 2023-01-12 05:29 166阅读 0赞

1.项目目录

在存在两个app的时候使用两个数据

![58d7aa977fd9929e5b81d731f137a832.png][]

2.model类

app02/models.py

在使用多数据库的时候,我们要到每个表的下面使用\[app\_label=app的名字\],示例如下

class Publish(models.Model):

name=models.CharField(max\_length=32)

email=models.EmailField()

def \_\_str\_\_(self):

return "app02 %s" % self.name

class Meta:

\#app的名字

app\_label = 'app02'

3.settings的写法

DATABASES = \{

'default': \{

'ENGINE': 'django.db.backends.mysql',

'NAME': 'orm', \#\# 数据库名称

'USER': 'root',

'PASSWORD': '123456', \#\# 安装 mysql 数据库时，输入的 root 用户的密码

'HOST': '127.0.0.1',

\},

'mysql02': \{

'ENGINE': 'django.db.backends.mysql',

'NAME': 'orm02', \#\# 数据库名称

'USER': 'root',

'PASSWORD': '123456', \#\# 安装 mysql 数据库时，输入的 root 用户的密码

'HOST': '127.0.0.1',

\},

\# 多数据库连接池

DATABASE\_ROUTERS = \['djangoser.database\_router.DatabaseAppsRouter'\]

\# 配置app与之相对应的连接池

DATABASE\_APPS\_MAPPING = \{

'app01': 'default',

'app02': 'mysql02',

4.在同级目录下添加database\_router.py

from django.conf import settings

DATABASE\_MAPPING = settings.DATABASE\_APPS\_MAPPING

class DatabaseAppsRouter(object):

"""

A router to control all database operations on models for different

databases.

In case an app is not set in settings.DATABASE\_APPS\_MAPPING, the router

will fallback to the \`default\` database.

Settings example:

DATABASE\_APPS\_MAPPING = \{'app1': 'db1', 'app2': 'db2'\}

"""

def db\_for\_read(self, model, \*\*hints):

""""Point all read operations to the specific database."""

if model.\_meta.app\_label in DATABASE\_MAPPING:

return DATABASE\_MAPPING\[model.\_meta.app\_label\]

return None

def db\_for\_write(self, model, \*\*hints):

"""Point all write operations to the specific database."""

if model.\_meta.app\_label in DATABASE\_MAPPING:

return DATABASE\_MAPPING\[model.\_meta.app\_label\]

return None

def allow\_relation(self, obj1, obj2, \*\*hints):

"""Allow any relation between apps that use the same database."""

db\_obj1 = DATABASE\_MAPPING.get(obj1.\_meta.app\_label)

db\_obj2 = DATABASE\_MAPPING.get(obj2.\_meta.app\_label)

if db\_obj1 and db\_obj2:

if db\_obj1 == db\_obj2:

return True

else:

return False

return None

def allow\_syncdb(self, db, model):

"""Make sure that apps only appear in the related database."""

if db in DATABASE\_MAPPING.values():

return DATABASE\_MAPPING.get(model.\_meta.app\_label) == db

elif model.\_meta.app\_label in DATABASE\_MAPPING:

return False

return None

def allow\_migrate(self, db, app\_label, model=None, \*\*hints):

"""

Make sure the auth app only appears in the 'auth\_db'

database.

"""

if db in DATABASE\_MAPPING.values():

return DATABASE\_MAPPING.get(app\_label) == db

elif app\_label in DATABASE\_MAPPING:

return False

return None

\# for Django 1.4 - Django 1.6

def allow\_syncdb(self, db, model):

"""Make sure that apps only appear in the related database."""

if db in DATABASE\_MAPPING.values():

return DATABASE\_MAPPING.get(model.\_meta.app\_label) == db

elif model.\_meta.app\_label in DATABASE\_MAPPING:

return False

return None

\# Django 1.7 - Django 1.11

def allow\_migrate(self, db, app\_label, model\_name=None, \*\*hints):

print(db, app\_label, model\_name, hints)

if db in DATABASE\_MAPPING.values():

return DATABASE\_MAPPING.get(app\_label) == db

elif app\_label in DATABASE\_MAPPING:

return False

return None

5.执行命令

python manage.py makemigrations--database指定要加载那个modles

python manage.py migrate--database=app02\#这样生成的数据库前缀app02\_xxx

[58d7aa977fd9929e5b81d731f137a832.png]: /images/20221119/5bdcf26dc2744c46adb97b951b88b016.png

django 多mysql数据库操作_django的多数据库的操作

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Django--数据库查询操作

相关 django 多mysql数据库操作_django的多数据库的操作

相关 django 多表操作

相关 django 用mysql数据库操作_Django-MySQL数据库使用01

相关 django 多数据库

相关 django 多数据库配置

相关 Django连接操作MySQL数据库

相关 Django连接操作MongoDB数据库

相关 Django之操作数据库

相关 Django+Pycharm简单操作Mysql数据库