[sql]mysql管理手头手册,多对多sql逻辑

国家--城市例子

class Country(models.Model):
name = models.CharField(max_length=30) def __str__(self):
return self.name class City(models.Model):
country = models.ForeignKey(Country, on_delete=models.CASCADE)
name = models.CharField(max_length=30) def __str__(self):
return self.name

子表创建数据

City.objects.create(name='xian', country_id=1)
City.objects.create(name='xian', country_instance)

从主表取出子表的数据

1.view中取出

c = Country.objects.get(id=1)
print(c.city_set.all())

跟related_name有关系: https://www.cnblogs.com/iiiiiher/p/9542094.html

2.模板中取出

https://docs.djangoproject.com/zh-hans/2.1/intro/tutorial03/

<h1>{{ question.question_text }}</h1>
<ul>
{% for choice in question.choice_set.all %}
<li>{{ choice.choice_text }}</li>
{% endfor %}
</ul>

从次表取出主表的字段

方法1:
City.objects.values('name','country__name') 也可以这样
BlogArticles.objects.get(id=1).author.username
方法2:
class BlogArticles(models.Model):
title = models.CharField(max_length=300)
body = models.TextField()
publish = models.DateTimeField(default=timezone.now)
author = models.ForeignKey(User, on_delete=models.CASCADE, related_name='blog_posts') 前端:
<small>{{ article.author.username }}</small>
04-30 00:04