| | |
| | | ) |
| | | except Exception: |
| | | pass |
| | | try: |
| | | conn.exec_driver_sql( |
| | | "ALTER TABLE app_settings ADD COLUMN grader_can_see_privacy INTEGER NOT NULL DEFAULT 0" |
| | | ) |
| | | except Exception: |
| | | pass |
| | | try: |
| | | conn.exec_driver_sql( |
| | | "ALTER TABLE examination_exam_examinee ADD COLUMN student_no VARCHAR(16)" |
| | | ) |
| | | except Exception: |
| | | pass |
| | | conn.exec_driver_sql( |
| | | "CREATE INDEX IF NOT EXISTS ix_examination_exam_examinee_student_no ON examination_exam_examinee (student_no)" |
| | | ) |
| | | |
| | | from app.database import SessionLocal |
| | | from app.system_settings import get_or_create_settings |