系统:Windows 7 语言版本:Anaconda3-4.3.0.1-Windows-x86_64 编辑器:pycharm-community-2016.3.2
Part 1:功能描述
Part 2:数据库设计
Part 3:models
from django.db import models
class Constants(models.Model):
class_name = models.CharField(blank=True, null=True, max_length=10, verbose_name='班级')
student_name = models.CharField(blank=True, null=True, max_length=10, verbose_name='学生姓名')
exam_info = models.CharField(blank=True, null=True, max_length=20, verbose_name='模拟考信息')
course_name = models.CharField(blank=True, null=True, max_length=20, verbose_name='科目')
class Meta:
db_table = 'grades_constants'
verbose_name = "常数项"
verbose_name_plural = verbose_name
class StudentGrades(models.Model):
class_name = models.CharField(blank=True, null=True, max_length=10, verbose_name='班级')
student_name = models.CharField(null=False, default='', max_length=10, verbose_name='学生姓名')
exam_info = models.CharField(blank=True, null=True, max_length=20, verbose_name='模拟考信息')
course_name = models.CharField(blank=True, null=True, max_length=20, verbose_name='科目')
grades = models.FloatField(blank=False, null=False, default=0.0, verbose_name="学习成绩")
class Meta:
unique_together = ('class_name', 'student_name', 'exam_info', 'course_name')
db_table = 'grades_record'
verbose_name = "学习成绩记录"
verbose_name_plural = verbose_name
代码截图
models.py:写创建数据库对应代码的位置
Part 4:ORM介绍
Object-relational mapper
的方法,将传统对数据库操作的sql语句改为对类的操作db_table
unique_together('class_name', 'student_name', 'exam_info', 'course_name')
,不同记录不能有完全相同的以上4个字段makemigrations
migrate
以上为本次的学习内容,下回见