vim settings #HelloWorld/HelloWorld目錄下

DATABASES = {  'default': {    'ENGINE': 'django.db.backends.mysql', #mysql數據庫中第一個庫test    'NAME': 'test',    'USER': 'root',    'PASSWORD': '123456',    'HOST':'127.0.0.1',    'PORT':'3306',  },  'article': {    'ENGINE': 'django.db.backends.mysql', # mysql數據庫中第二個庫test2    'NAME': 'test2',    'USER': 'root',    'PASSWORD': '123456',    'HOST':'127.0.0.1',    'PORT':'3306',  }}

django-admin.py startapp blog ##HelloWorld/目錄下建立網站app，我建了兩個app（blog和article）

vim settings ##/HelloWorld/HelloWorld目錄下

INSTALLED_APPS = [  'django.contrib.admin',  'django.contrib.auth',  'django.contrib.contenttypes',  'django.contrib.sessions',  'django.contrib.messages',  'django.contrib.staticfiles',  'blog',  'article',]

vim models.py ##blog目錄下

from django.db import models# Create your models here.class Teacher(models.Model):  id = models.IntegerField(primary_key=True)  name = models.CharField(max_length=50)  class Meta:    db_table = 'teacher'#默認庫test中建立名為teacher的表。字段就是id和name

python manage.py migrate ##建立Django系統表，首次運行即可python manage.py makemigrations ##生成遷移計劃，每次加表或字段時都運行生成計劃python manage.py migrate ##同步用戶定義的表

vim models.py #blog目錄下，新建個表測試下，可以在添加或修改刪除幾個字段試試

class Student(models.Model):  id = models.IntegerField(primary_key=True)  name = models.CharField(max_length=50)  student_number = models.CharField(default="",max_length=50)  class Meta:    db_table = 'student'

cd article #進入article目錄vim models.py #article目錄下

from django.db import modelsclass Author(models.Model):  id = models.IntegerField(primary_key=True)  name = models.CharField(max_length=50)  author_ids = models.CharField(max_length=50)  class Meta:    db_table = 'author'    app_label = 'article' ##對應的article這個應用，名字要一致

python manage.py makemigrations article ##生成同步計劃##對article應用執行同步，同步到 article（settings中的配置，對應test2）對應的數據庫中.python migrate article --database article ##執行計劃，必須加--database 指定要同步的庫

cd blog #進入blog目錄下vim models.py ##blog目錄下，在文件中增加一個表，注意后邊app_label

class Group(models.Model):  id = models.IntegerField(primary_key=True)  group_name = models.CharField(max_length=50)  class Meta:    db_table = 'group'    app_label = 'article' ##必須指定這個庫

python manage.py makemigrations article ##生成同步計劃，雖說改的是blogpython migrate article --database article ##執行計劃，雖說改的是blog

vim view.py ##blog目錄下，添加下列代碼

from blog.models import Teacherdef orm_handle_db(request):  test1 = Teacher(id=1,name='runoob',teacher_number='10') ##定義數據  test1.save() ##保存  return render_to_response('orm_handle_db.html')

vim urls.py ##blog目錄下

from django.conf.urls import urlfrom blog import viewsurlpatterns = [  url(r'^hello/$', views.hello),  url(r'^search/$', views.search),  url(r'^post_search/$', views.post_search),  url(r'^search_submit$', views.search_submit),  url(r'^post_search_submit$', views.post_search_submit),  url(r'^db_handle/$', views.db_handle),  url(r'^orm_handle_db/$', views.orm_handle_db), ##這里配置好]

vim orm_handle_db.html ##blog/templates目錄下

vim settings.py ##HelloWorld/HelloWorld目錄下，添加下面兩項

DATABASES_APPS_MAPPING = {  'blog': 'default',  'article': 'article',    }DATABASE_ROUTERS = ['HelloWorld.database_app_router.DatabaseAppsRouter']

vim database_app_router.py ##配置路由 ,HelloWorld/HelloWorld/目錄下。直接粘貼

from django.conf import settingsclass DatabaseAppsRouter(object):def db_for_read(self, model, **hints):app_label = model._meta.app_labelif app_label in settings.DATABASES_APPS_MAPPING:res = settings.DATABASES_APPS_MAPPING[app_label]print(res)return resreturn Nonedef db_for_write(self, model, **hints):app_label = model._meta.app_labelif app_label in settings.DATABASES_APPS_MAPPING:return settings.DATABASES_APPS_MAPPING[app_label]return Nonedef allow_relation(self, obj1, obj2, **hints):db_obj1 = settings.DATABASES_APPS_MAPPING.get(obj1._mata.app_label)db_obj2 = settings.DATABASES_APPS_MAPPING.get(obj2._mata.app_label)if db_obj1 and db_obj2:if db_obj1 == db_obj2:return Trueelse:return Falsereturn Nonedef db_for_migrate(self, db, app_label, model_name=None, **hints):if db in settings.DATABASES_APPS_MAPPING.values():return settings.DATABASES_APPS_MAPPING.get(app_label) == dbelif app_label in settings.DATABASES_APPS_MAPPING:return Falsereturn None

vim views.py #blog目錄下，添加下方代碼

from blog.models import Teacher,Group##這是第8步沒有的def orm_handle_db(request):  test1 = Teacher(id=1,name='runoob',teacher_number='10')  test2 = Group(id=1,group_name='runoob') ##這是第8步沒有的  test1.save()  test2.save()##這是第8步沒有的  return render_to_response('orm_handle_db.html')