Django多表操作

from django.db import models



 # Create your models here.

 class UserInfo(models.Model):

     user=models.CharField(max_length=32)

     pawd=models.CharField(max_length=32)

     user_type=models.ForeignKey("UserType")

 class UserType(models.Model):

     caption=models.CharField(max_length=32)

    # querset=models.UserInfo.objects.all()
    # print(querset.query)#sql语句
    # query=models.UserInfo.objects.all().values("user")#得到的是个字典

    # query2=models.UserInfo.objects.all().value_list("user")#得到的是一个元祖

多表操作

models.UserInfo.objects.filter(user_type__caption="普通用户")

models.UserInfo.objects.filter(user_type__s__name="姓名")