当前位置:Gxlcms > 数据库问题 > django 10.5 sqlite3迁移到mysql

django 10.5 sqlite3迁移到mysql

时间:2021-07-01 10:21:17 帮助过:22人阅读

python ./manage.py syncdb --database slave

 

变更为:
python manage.py migrate --run-syncdb --database slave

  

 

原文:
from django.contrib.contenttypes.models import ContentType

def run():

    def do(Table):
        if Table is not None:
            table_objects = Table.objects.all()
            for i in table_objects:
                i.save(using=slave)

    ContentType.objects.using(slave).all().delete()

    for i in ContentType.objects.all():
        do(i.model_class())
变更为
# -*- coding:utf-8 -*-
from __future__ import unicode_literals

from django.contrib.contenttypes.models import ContentType

def
run(): failed_list = [] def do(table): if table is not None: try: table_objects = table.objects.all() for i in table_objects: i.save(using=slave) except: failed_list.append(table) ContentType.objects.using(slave).all().delete() for i in ContentType.objects.all(): do(i.model_class()) while failed_list: table = failed_list.pop(0) do(table)

 

 

 

django 10.5 sqlite3迁移到mysql

标签:pytho   als   save   cts   types   base   sla   app   tle   

人气教程排行