构建大学综合门户与排行系统的实现

from django.db import models

class User(models.Model):

username = models.CharField(max_length=50)

password = models.CharField(max_length=50)

email = models.EmailField()

name = models.CharField(max_length=50)

]]>

class Course(models.Model):

course_name = models.CharField(max_length=100)

course_code = models.CharField(max_length=20)

teacher = models.ForeignKey(User, on_delete=models.CASCADE)

]]>

class Rank(models.Model):

score = models.IntegerField()

user = models.ForeignKey(User, on_delete=models.CASCADE)

course = models.ForeignKey(Course, on_delete=models.CASCADE)

]]>

from django.db.models import F

def get_rank_list(course_id):

ranks = Rank.objects.filter(course_id=course_id).order_by('-score')

return ranks

]]>