ó
    èÒ–j¨  ã                  óZ   • S r SSKJr  SSKJrJr  SSKJr  SrS	S jr	\
S:X  a  \	" 5         gg)
z�Apply the persistent student document Drive sync queue.

Run from backend/:
  python migrations/apply_student_drive_sync_jobs.py
é    )Úannotations)ÚinspectÚtext)Úenginea¦  
CREATE TABLE IF NOT EXISTS student_drive_sync_jobs (
  id INT NOT NULL AUTO_INCREMENT,
  folder_id INT NOT NULL,
  student_id INT NOT NULL,
  document_id INT NOT NULL,
  file_path VARCHAR(512) NOT NULL,
  mime_type VARCHAR(128) NULL,
  status VARCHAR(24) NOT NULL DEFAULT 'pending',
  attempts INT NOT NULL DEFAULT 0,
  next_attempt_at DATETIME NOT NULL,
  locked_at DATETIME NULL,
  last_error TEXT NULL,
  drive_file_id VARCHAR(255) NULL,
  drive_path VARCHAR(1024) NULL,
  created_at DATETIME NOT NULL,
  updated_at DATETIME NOT NULL,
  completed_at DATETIME NULL,
  PRIMARY KEY (id),
  INDEX ix_student_drive_sync_jobs_folder_id (folder_id),
  INDEX ix_student_drive_sync_jobs_student_id (student_id),
  INDEX ix_student_drive_sync_jobs_status (status),
  INDEX ix_student_drive_sync_jobs_next_attempt_at (next_attempt_at),
  INDEX ix_student_drive_sync_jobs_due (status, next_attempt_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
c                 óP  • [         R                  " 5        n U R                  [        [        5      5        [        S5        S[        [        U 5      R                  5       5      ;   a(  U R                  [        S5      SS05        [        S5        S S S 5        g ! , (       d  f       g = f)Nzok: student_drive_sync_jobsÚalembic_versionz1UPDATE alembic_version SET version_num = :versionÚversionÚ0017_student_drive_sync_jobsz/alembic stamped to 0017_student_drive_sync_jobs)	r   ÚbeginÚexecuter   Ú
CREATE_SQLÚprintÚsetr   Úget_table_names)Úconns    Ú+migrations/apply_student_drive_sync_jobs.pyÚmainr   *   st   € Ü	�ŠŒ˜4Ø�‰”Tœ*Ó%Ô&ÜÐ+Ô,Ø¤¤G¨D£M×$AÑ$AÓ$CÓ DÓDØ�L‰LÜÐHÓIØÐ:Ð;ôô ÐCÔD÷ 
�Žús   –A8BÂ
B%Ú__main__N)ÚreturnÚNone)Ú__doc__Ú
__future__r   Ú
sqlalchemyr   r   Úapp.backend.db.databaser   r   r   Ú__name__© ó    r   Ú<module>r      s6   ðñõ #ç $å *ð€
ô8	Eð ˆzÓÙ…Fð r   