xzbautomarkapi/models/marktask.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-

import datetime

from sqlalchemy import Column, Integer, String, DateTime, Float, BOOLEAN, JSON, Enum, TEXT

from db import BaseORMModel
from models.const import TaskTypeEnum


class MarkTask(BaseORMModel):
    """
    阅卷任务
    """

    __tablename__ = "marktasks"

    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(String(20), nullable=False, comment="任务名称")
    year = Column(Integer, nullable=False, comment="年份")
    pid = Column(Integer, default=0, comment="试卷ID")
    pno = Column(String(32), default="", comment="试卷编号")
    pname = Column(String(32), nullable=False, comment="试卷名称")
    pages = Column(Integer, default=100, comment="试卷页数")
    subject = Column(String(32), default="", comment="科目")
    pimgs = Column(String(1000), default="", comment="原始试卷图片URL列表")
    std_points = Column(String(1000), default="", comment="标准坐标点")
    ans_points = Column(String(1000), default="", comment="答题卡坐标点")
    stdans_config = Column(TEXT, default="", comment="答题卡配置")
    score = Column(Integer, default=100, comment="满分")
    school_id = Column(Integer, nullable=False, comment="学校ID")
    school_name = Column(String(32), nullable=False, comment="学校名称")
    grade_id = Column(Integer, nullable=False, comment="年级ID")
    grade_name = Column(String(32), nullable=False, comment="年级名称")
    class_id = Column(Integer, nullable=False, comment="班级ID")
    class_name = Column(String(32), nullable=False, comment="班级名称")
    status = Column(Integer, default=0, comment="状态，0=未开始，1=进行中，2=已完成")
    mtype = Column(String(4), nullable=False, comment="任务类型，work/exam")
    category_id = Column(Integer, nullable=True, comment="分类ID")
    high_score = Column(Float, default=0, comment="最高分")
    low_score = Column(Float, default=0, comment="最低分")
    avg_score = Column(Float, default=0, comment="平均分")
    pass_amount = Column(Integer, default=0, comment="及格人数")
    pass_rate = Column(Float, default=0, comment="及格率")
    marked_amount = Column(Integer, default=0, comment="已批阅数量")
    student_amount = Column(Integer, default=0, comment="参考学生人数")
    uploaded_amount = Column(Integer, default=0, comment="已上传数量")
    error_ratio = Column(Integer, default=0, comment="错题率")
    creator_id = Column(Integer, comment="创建人ID")
    creator_name = Column(String(32), comment="创建人名称")
    created_at = Column(DateTime, default=datetime.datetime.now)
    editor_id = Column(Integer, comment="最后编辑人ID")
    editor_name = Column(String(32), comment="最后编辑人名称")
    updated_at = Column(DateTime, default=datetime.datetime.now, onupdate=datetime.datetime.now)


# 学生阅卷任务表
class StudentMarkTask(BaseORMModel):

    __tablename__ = "student_tasks"

    id = Column(Integer, primary_key=True, autoincrement=True)
    student_id = Column(Integer, nullable=False, comment="学生id")
    student_name = Column(String(32), nullable=False, comment="学生名称")
    student_sno = Column(String(32), nullable=False, comment="学号")
    task_id = Column(Integer, nullable=False, comment="阅卷任务ID")
    mtype = Column(String(4), nullable=False, comment="任务类型，work/exam")
    pid = Column(Integer, default=0, comment="试卷ID")
    pno = Column(String(32), default="", comment="试卷编号")
    pname = Column(String(255), nullable=False, comment="试卷名称")
    pimgs = Column(JSON, default=[], comment="原始试卷图片URL列表")
    question_amount = Column(Integer, default=0, comment="试题数量")
    marked_amount = Column(Integer, default=0, comment="已批阅试题数量")
    is_completed = Column(BOOLEAN(), default=False, comment="是否批阅完成")
    score = Column(Float, default=0, comment="得分")
    rank = Column(Integer, default=0, comment="名次")
    objective_score = Column(Float, default=0, comment="客观题得分")
    subjective_score = Column(Float, default=0, comment="主观题得分")
    status = Column(Integer, default=0, comment="状态，0=待上传，1=上传中,2已上传")
    creator_id = Column(Integer, comment="创建人ID")
    creator_name = Column(String(32), comment="创建人名称")
    created_at = Column(DateTime, default=datetime.datetime.now)
    editor_id = Column(Integer, comment="最后编辑人ID")
    editor_name = Column(String(32), comment="最后编辑人名称")
    updated_at = Column(DateTime, default=datetime.datetime.now, onupdate=datetime.datetime.now)
    school_name = Column(String(32), default="", comment="学校名称")
    grade_name = Column(String(32), default="", comment="年级名称")
    class_name = Column(String(32), default="", comment="班级名称")


# 学生作答表
class StudentAnswer(BaseORMModel):

    __tablename__ = "student_answers"

    id = Column(Integer, primary_key=True, autoincrement=True)
    student_id = Column(Integer, nullable=False, comment="学生ID")
    student_name = Column(String(32), nullable=False, comment="学生名称")
    student_sno = Column(String(32), nullable=False, comment="学号")
    class_id = Column(Integer, nullable=False, comment="班级ID")
    task_id = Column(Integer, nullable=False, comment="阅卷任务ID")
    student_task_id = Column(Integer, nullable=False, comment="学生阅卷任务ID")
    mtype = Column(Enum(TaskTypeEnum), nullable=False, comment="任务类型，work/exam")
    task_name = Column(String(20), nullable=False, comment="任务名称")
    pid = Column(Integer, default=0, comment="试卷ID")
    pno = Column(String(32), default="", comment="试卷编号")
    pname = Column(String(255), nullable=False, comment="试卷名称")
    pimgs = Column(JSON, default="", comment="原始答卷")
    qid = Column(Integer, nullable=False, comment="试题ID")
    qno = Column(String(16), nullable=False, comment="题号")
    sqno = Column(String(16), default="", comment="子题号")
    stem = Column(TEXT, default="", comment="试题题干")
    std_answer = Column(TEXT, nullable=False, default="", comment="学生答案")
    qimg = Column(String(1000), nullable=False, comment="试题图片URL")
    answer = Column(TEXT, nullable=False, default="", comment="学生答案")
    score = Column(Float, default=0, comment="试题分值")
    qtype = Column(String(6), nullable=False, comment="单选题/多选题/判断题/主观题")
    status = Column(BOOLEAN(), default=False, comment="批阅状态")
    incorrect = Column(BOOLEAN(), default=False, comment="是否错题")
    marked_img = Column(String(1000), default="", comment="批阅后的试题图片URL")
    marked_score = Column(Float, default=0, comment="批阅得分")
    creator_id = Column(Integer, nullable=False, comment="创建人ID")
    creator_name = Column(String(32), nullable=False, comment="创建人名称")
    created_at = Column(DateTime, default=datetime.datetime.now)
    editor_id = Column(Integer, nullable=False, comment="最后编辑人ID")
    editor_name = Column(String(32), nullable=False, comment="最后编辑人名称")
    updated_at = Column(DateTime, default=datetime.datetime.now, onupdate=datetime.datetime.now)
    school_name = Column(String(32), default="", comment="学校名称")
    grade_name = Column(String(32), default="", comment="年级名称")
    class_name = Column(String(32), default="", comment="班级名称")