django开发系列：ORM查询练习

django开发系列：ORM查询练习

models(创建表)：

from django.db import models

class Grade(models.Model):
    """年级表"""
    gname=models.CharField(max_length=32)


class Classes(models.Model):
    """班级表"""
    caption=models.CharField(max_length=32)
    grade=models.ForeignKey("Grade", on_delete=models.CASCADE)
    teach_cls = models.ManyToManyField('Teacher')


class Teacher(models.Model):
    """老师表"""
    tname=models.CharField(max_length=32)


class Course(models.Model):
    """课程表"""
    cname=models.CharField(max_length=32)
    teacher=models.OneToOneField("Teacher", on_delete=models.CASCADE)


class Student(models.Model):
    """学生表"""
    sname = models.CharField(max_length=32)
    gender = models.CharField(max_length=10)
    classes = models.ForeignKey("Classes",on_delete=models.CASCADE)


class Score(models.Model):
    """成绩表"""
    student = models.ForeignKey("Student",on_delete=models.CASCADE)
    course = models.ForeignKey("Course",on_delete=models.CASCADE)
    score=models.IntegerField()

插入数据:

def