!j1UdZddlmZddlZddlmZddlmZddlm Z m Z m Z m Z m Z ddlmZmZmZddlmZd Zd ed <ed d ddddZedddZd9dZd:dZd9dZd;dZGddeZGddeZGdd eZGd!d"eZGd#d$eZ dd5Z%ejLd6ejNZ(d?d7Z)d@d8Z*y)AzVProgramme hierarchy: levels, modules, weeks (intro + 12 weeks), sessions, assessments.) annotationsN)Path)SimpleNamespace)CheckConstraint ForeignKeyIntegerStringUniqueConstraint)Mapped mapped_column relationship)Base)beginnerhb intermediatehiadvancedztuple[str, ...]CSV_LEVEL_SLUGSrrrrrcustom)rrrrrr foundations developmental creativity)rrrctjdd|jj}|s t d|ddS)N\s+_zlevel slug is required@resubstriplower ValueErrorvalue normalizeds C/var/www/html/kelly/kelly-backend/app/programme/models_programme.pynormalize_programme_level_slugr'"s>U[[]%8%8%:;J 122 cr?c|yt|SNstr)slugs r&programme_level_slug_strr/) | t9r(ctjdd|jj}|s t d|ddS)Nrrzmodule kind is requiredrrr#s r&normalize_programme_module_kindr2/s>U[[]%8%8%:;J 233 cr?r(c|yt|Sr*r,)kinds r&programme_module_kind_strr56r0r(ceZdZUdZedZded<eedddZd ed <eed d Z d ed <ee dZ ded<e ddddZ ded<y)ProgrammeLevelprogramme_levelsT primary_key Mapped[int]idrF)uniquenullable Mapped[str]r.r> display_namerdefault sort_orderProgrammeModulelevelall, delete-orphanzProgrammeModule.sort_orderback_populatescascadeorder_byzMapped[list['ProgrammeModule']]modulesN)__name__ __module__ __qualname__ __tablename__r r<__annotations__r r.rBrrEr rMr(r&r7r7<sp&M#5B 5%fRjND+N -fSkE JL+J+GQ?J ?/;';OZv0G ,r(r7c&eZdZUdZedZded<eeddd Zded <ee d d Z d ed<ee dd Z d ed<ee dZ ded<eddZded<eddddZded<ed dd !fZy")#rFprogramme_modulesTr9r;r<zprogramme_levels.idCASCADEondeleteFrAlevel_idrr?r4r@rBrrCrEr7rMrJzMapped['ProgrammeLevel']rG ProgrammeWeekmodulerHzProgrammeWeek.week_indexrIzMapped[list['ProgrammeWeek']]weeksuq_programme_module_level_kindnameN)rNrOrPrQr r<rRrrYr r4rBrrEr rGr]r __table_args__rSr(r&rFrFIs'M#5B 5)*5JU^*_jopHkp%fRj5AD+A -fSkE JL+J+GQ?J ?&23CT]&^E #^+7:NYs,E ('z6@`acNr(rFceZdZUdZedZded<eeddd Zded <ee d Z ded <ee d d Z ded<e ddZded<e ddddZded<ed d deddfZy )!r[programme_weeksTr9r;r<zprogramme_modules.idrVrWFrA module_id week_indexrr? display_labelrFr]rZzMapped['ProgrammeModule']r\ProgrammeSessionweekrHzProgrammeSession.session_numberrIz Mapped[list['ProgrammeSession']]sessionsuq_programme_week_module_indexr_z$week_index >= 0 AND week_index <= 12ck_programme_week_index_rangeN)rNrOrPrQr r<rRrrdrrer rfr r\rir rrarSr(r&r[r[Zs%M#5B 5*:6LW`+alqrI{r+GeDJ D!.vbzE!JM;J(45FW^(_F %_1=$2 2H. l9YZ>EdeNr(r[c*eZdZUdZedZded<eeddd Zded <ee d Z ded <ee d d Z ded<ed Z ded<eddZded<eddddZded<ed d d ed!d" fZy#)$rgprogramme_sessionsTr9r;r<zprogramme_weeks.idrVrWFrAweek_idsession_numberr?titlerCz Mapped[bool] admin_checkedr[rirZzMapped['ProgrammeWeek']rhProgrammeAssessmentsessionrHzProgrammeAssessment.sort_orderrIz#Mapped[list['ProgrammeAssessment']] assessments uq_programme_session_week_numberr_zsession_number >= 1$ck_programme_session_number_positiveN)rNrOrPrQr r<rRrrnrror rqrrr rhrur rrarSr(r&rgrgps(M#5B 5(4HS\)]hmnG[n"/%"HNKH&vc{UCE;C"/">M<>$0Q[$\D !\7C $1 8K4 $4;]^-4Z[Nr(rgceZdZUdZedZded<eeddd Zded <ee d Z ded <ee d d Z ded<e ddZded<ed d dfZy)rsprogramme_assessmentsTr9r;r<zprogramme_sessions.idrVrWFrA session_idrErpr?rqrgrurZzMapped['ProgrammeSession']rt%uq_programme_assessment_session_orderr_N)rNrOrPrQr r<rRrrzrrEr rqr rtr rarSr(r&rsrss}+M#5B 5+J7NYb,cnstJ t+GeDJ D&vc{UCE;C*67IZg*hG 'h&|\HoprNr(rscVttjjdS)z9Project root (directory that contains the `app` package).)r__file__resolveparentsrSr(r& repo_rootrs > ! ! # + +A ..r(z UPP - Assessments - Beginner.csvzUPP - Assessments - HB.csvz$UPP - Assessments - Intermediate.csvzUPP - Assessments - HI.csvz UPP - Assessments - Advanced.csvzdict[str, str]LEVEL_CSV_FILEScddlm}tj|}|syt j }t |ddxsdj}|rNt|j}|jr|j n||z j g}n |dz dz ||dz |dz |dz dz |dz d z g}|D]}||z }|js|cSy) z Locate one UPP CSV on disk. Uses `programme_csv_dir` from settings when set; otherwise tries common locations (repo root, app/, app/all csv/, etc.). r) get_settingsNprogramme_csv_dirr+app programmezall csvall_csv) app.configrrgetrrgetattrr r is_absoluteis_file) r.rfilenamerootrawpbasesbase candidates r&resolve_upp_csv_pathrs (""4(H  ;   D <>#6 = C J J LC   ! dQh5G5G5IJ 5L; &  5L 9  5L9 $ 5L9 $  8O      r(BeginnerzHigher Beginner (HB) IntermediatezHigher Intermediate (HI)AdvancedCustomLEVEL_DISPLAY_DEFAULTScB|j}d|vryd|vryd|vryy)Nrr foundationr)r!)cellcls r&_module_kind_from_cellrs1 Br"r r(z^session\s+(\d+)\s*-?\s*(.*)$cddl}|jdd}t|j|j }g}d}|t |kr(||}|r|dndj }|r t|nd}||dz }B|dz} | t |k\r |S|| } g} tdt | dD]X} | | xsdj } | sn=| j}|d vrn'| jd k(rH| j| Zt | }|dk(r|dz }t|Dcgc] }| |id  }}dg|z}| dz}|t |kr>td ||Ds)|dz }|t |krtd ||Ds)|t |kr||}|r|dndj }|r t|n}|jd k(rnht|D]D}|dz}|t |k\r||xsdj }|s2tj|}|rst|j!d}|j!dxsdj xsd|}|||<||dj#||gd|||d|d<|j}|j%dsd|vr#|j'dddj n|}|jdvr||}|$|s(||d|dj|G|dz }|t |kr|j||f|}|t |kr(|Scc}w)z Parse one UPP assessment CSV into module payloads. Each module payload is a list of week dicts: {"display_label": str, "sessions": {1: {"title": str, "assessments": [str,...]}}, ...}} rNzutf-8replace)encodingerrorsr+)zprogress assessmentgradingz TO COMPLETE)rfric3DK|]}|xsdjyw)r+N)r ).0cs r& z+parse_upp_assessment_csv.. s,U 1ag2__-> s rr}zSession ri)rqrurqz assessment::)NONEr+ru)csv read_textlistreader splitlineslenr rranger!upperappendany _SESSION_REmatchintgroup setdefault startswithsplit)pathrtextrows modules_outrrowc0r4 week_row_idxweek_row week_labelsrlabelll num_weeksi weeks_payload current_sndata_rdrc0bwicolrsmsnrqlows r&parse_upp_assessment_csvrs  >>79> =D  4??,- .D02K A c$i-1gc!f * * ,-/%b)T < FA 1u 3t9 $ B A %!# q#h-+Aa[&B--/EB77{{} -   u %, $ > FA `efo`p$q`p[\{1~SU%V`p $q(,v '9 !s4y ,UV ,U)U aKFs4y ,UV ,U)Us4y fB2a5B--/C-c2>yy{i'I&1f#b'>3 2,,. &&t,RXXa[)BXXa[.B557JXbT?E%'JrN!"%j1<jjl>>-0=@D[DJJsA.q1779dE{{} 4 #BB~%%b)*5b9-HOOPUV-'0 aKFAs4y D D-01 S c$i-V ]%rs7M=c @t|}|yg}tt|D]\}\}}g}t|D]g\}}g} t|dj D])\} } | j | | dt | dd+|j ||d| di|j ||jdd j||d |tj||jdd jd |j|d S) u Full programme tree for one level (levels → modules → weeks → sessions → assessments). Returns None if the CSV file is missing. Nrirqru)rorqrurf)rerfrir )r4rBrEr])r.rB)rG source_csvrM) r enumeratersorteditemsrrrrqrrr`) r.rrM mod_orderr4rr]rerhrirosdatas r& programme_level_payload_from_csvr6s<  %D |G,56Nt6T,U( (D- )- 8 J#%H)/Z0@0F0F0H)I%*8!&w'+E-,@'A*J LL",%)/%: ( !9"  $ S# 6 < < >'   '-V<266tT\\#s=S=Y=Y=[\ ii  r()r$r-returnr-)r. str | Nonerr-)r4rrr-)rr)r.r-rz Path | None)rr-rr)rrrz,list[tuple[ProgrammeModuleKind, list[dict]]])r.r-rz dict | None)+__doc__ __future__rrpathlibrtypesr sqlalchemyrrrr r sqlalchemy.ormr r r app.databaserrrRProgrammeLevelSlugProgrammeModuleKindr'r/r2r5r7rFr[rgrsrrrrrcompile IGNORECASErrrrSr(r&rs0\" !UU>>$XW%     &!  T ddd"D,t. s$ s/ 3 &: &2 #D " $ *bjj92==I Xv-r(