c94640c890
Root cause of lost PREP 2016 quiz: deleting a section (e.g. to recreate with different page ranges) cascade-deleted ALL quizzes attached to it, destroying the quiz AND all its questions permanently. Fixes: - Section.quizzes relationship: removed cascade="all, delete-orphan" Deleting a section no longer touches quizzes at all - Quiz.section_id FK: changed to ON DELETE SET NULL, nullable=True If a section is deleted, quizzes keep working (section_id becomes null) - DB migration: drops old FK constraint and recreates with SET NULL Also answers the question about deleting a bank question in a quiz: - quiz_question_links FK has ON DELETE CASCADE — deleting a question silently removes it from all quizzes - This needs a warning UI (not yet implemented — no delete button in bank) Co-Authored-By: Claude Sonnet 4.6 (1M context) <noreply@anthropic.com>
18 lines
694 B
Python
18 lines
694 B
Python
from sqlalchemy import Column, Integer, String, ForeignKey
|
|
from sqlalchemy.orm import relationship
|
|
|
|
from app.database import Base
|
|
|
|
|
|
class Section(Base):
|
|
__tablename__ = "sections"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
document_id = Column(Integer, ForeignKey("pdf_documents.id", ondelete="CASCADE"), nullable=False)
|
|
name = Column(String, nullable=False)
|
|
start_page = Column(Integer, nullable=False)
|
|
end_page = Column(Integer, nullable=False)
|
|
|
|
document = relationship("PDFDocument", back_populates="sections")
|
|
# No cascade delete — deleting a section must NOT destroy quizzes/questions
|
|
quizzes = relationship("Quiz", back_populates="section")
|