本文介绍django-import-export在关联外键时,导出可以导出可读字样(而非关联id),导入通过可读字眼进行导入(而非关联id)
模型设计如下:
# models.py
from django.db import models
# Create your models here.
class User(models.Model):
gender_by_choice = (
('male', '男'),
('female', '女'),
)
username = models.CharField(max_length=10, unique=True, verbose_name='姓名')
age = models.IntegerField(verbose_name='年龄')
gender = models.CharField(max_length=6, choices=gender_by_choice, verbose_name='性别')
nickname = models.CharField(max_length=10, verbose_name='昵称')
def __str__(self):
return self.username
class Meta:
verbose_name = '用户'
verbose_name_plural = '用户'
class Book(models.Model):
owner = models.ForeignKey(User, null=True, blank=True, on_delete=models.SET_NULL, verbose_name='归属者')
name = models.CharField(max_length=64, verbose_name='书名')
def __str__<