擅长:python、mysql、java
<p>我认为您不应该使用裸SQL查询,而应该尝试使用这样的东西</p>
<pre><code>from django.db import migrations
def combine_names(apps, schema_editor):
# We can't import the Person model directly as it may be a newer
# version than this migration expects. We use the historical version.
Person = apps.get_model('yourappname', 'Person')
for person in Person.objects.all():
person.name = '%s %s' % (person.first_name, person.last_name)
person.save()
class Migration(migrations.Migration):
dependencies = [
('yourappname', '0001_initial'),
]
operations = [
migrations.RunPython(combine_names),
]
</code></pre>
<p>引用:<a href="https://docs.djangoproject.com/en/2.2/topics/migrations/#data-migrations" rel="nofollow noreferrer">https://docs.djangoproject.com/en/2.2/topics/migrations/#data-migrations</a></p>