一,model.py 格式
#房产信息表
class EsHouse(models.Model):
community_code = models.ForeignKey('EsCommunity',models.CASCADE, db_column='community_code',null=True,help_text="所属小区编号")
code = models.CharField(unique=True, max_length=50,help_text='房产编号')
name = models.CharField(max_length=255,help_text='房产名称')
rooms = models.IntegerField(help_text='房间数')
unit = models.CharField(max_length=50,help_text='单元信息')
floor = models.IntegerField(help_text='楼层信息')
desc = models.CharField(max_length=255, blank=True, null=True,help_text='房产描述')
enter_time = models.PositiveIntegerField(blank=True, null=True,help_text='入住时间')
class Meta:
managed = True
db_table = 'es_house'
verbose_name = '房产信息表'
verbose_name_plural = verbose_name
ordering = ('-enter_time',)
unique_together = (('community_code','building_code','m_id','unit','floor'),)
def __str__(self):
return f'EsHouse {self.code}
#小区信息表
class EsCommunity(models.Model):
code = models.CharField(unique=True, max_length=50,help_text='小区编号',primary_key = True)
name = models.CharField(max_length=255,help_text='小区名称')
二,ORM操作
1,Join语句
#根据外键连表(LEFT JOIN)查询
querySet = EsHouse.objects.filter(community_code__name ='小区名字').values('id','community_code__name')
#SQL :SELECt `es_house`.`id`, `es_community`.`name` FROM `es_house` LEFT OUTER JOIN `es_community` ON (`es_house`.`community_code` = `es_community`.`code`) ORDER BY `es_house`.`enter_time` DESC;
#如果不加上null=True的话执行的sql是inner join的方式,当mysql上又设置了外键可为空,导致正式使用的时候那些外键为空的没有查询到.



