+ jHjQa0t$Rt^RIHt^RIt^RIt^RIt^RIt^RIt^RI t ^RI H t H t ^RI Ht^RIHtHtHt^RIHtHtHt^RIHtRR ltR t]P8!R 4t]P8!R 4t]!4t R ]!R&Rkt"Rlt#Rt$Rt%RRlt&RRlt'RRlt(RRlt)RmRRllt*]PVRmR R!ll4t,] !R"R#44t-] !R$R%44t.R&R'lt/R(R)lt0R*R+lt1R,R-/R.R/llt2R0RR1RRRRRRRRRRRR2R-/R3R4llt3R,R-/R5R6llt4R7R8lt5R9RRRRRRRRR/R:R;llt6R<R=lt7R>RR?R-/R@RAllt8RBRClt9RDRElt:RFRGlt;RHRIltRNROlt?RPRQlt@RRRSltARTRUltBRVRWltCRXRYltDRZR-/R[R\lltER]R/R^R_lltFR`R-R]R/RaRblltGRcRdltHR,R-/ReRflltIRgRh/RiRjlltJR#)nzPer-profile first-class Project store. The schema is small and additive: column additions go through ``add_column_if_missing`` so opening an old DB is always safe. ) annotationsN) dataclassfield)Path)IterableListOptional)add_column_if_missingopen_db write_txnget_hermes_homecV^8dQhRR/#)returnr)formats";/home/ubuntu/.hermes/hermes-agent/hermes_cli/projects_db.py __annotate__rs--$-c$\4R, #)z@The per-profile projects DB path (``$HERMES_HOME/projects.db``). projects.dbr rrrprojects_db_pathrs  } ,,ra CREATE TABLE IF NOT EXISTS projects ( id TEXT PRIMARY KEY, slug TEXT NOT NULL UNIQUE, name TEXT NOT NULL, description TEXT, icon TEXT, color TEXT, board_slug TEXT, primary_path TEXT, created_at INTEGER NOT NULL, archived INTEGER NOT NULL DEFAULT 0 ); CREATE TABLE IF NOT EXISTS project_folders ( project_id TEXT NOT NULL REFERENCES projects(id) ON DELETE CASCADE, path TEXT NOT NULL, label TEXT, is_primary INTEGER NOT NULL DEFAULT 0, added_at INTEGER NOT NULL, PRIMARY KEY (project_id, path) ); CREATE INDEX IF NOT EXISTS idx_project_folders_path ON project_folders(path); CREATE TABLE IF NOT EXISTS project_meta ( key TEXT PRIMARY KEY, value TEXT ); -- Git repos found by scanning the filesystem (desktop "repo-first" discovery). -- Cached here so the overview is instant after the first scan instead of -- re-walking the disk every time the Projects view opens. CREATE TABLE IF NOT EXISTS discovered_repos ( root TEXT PRIMARY KEY, label TEXT, last_seen INTEGER NOT NULL ); z^[a-z0-9][a-z0-9\-_]{0,63}$z [^a-z0-9._-]+zset[str]_INITIALIZED_PATHS board_slug primary_pathiconcolor description active_idrepo_discovery_policyc V^8dQhRRRR/#)rnamestrrr)rs"rrrTs++3+3+rc\P!RR\T;'gR4P4P 44PR4pVR,PR4;'gR#)z8Derive a slug candidate from a human name (best-effort).z [^a-z0-9]+--_:N@Nproject)resubr#striplower)r"ss& r_slugifyr/TsV }c3tzzr?#8#8#:#@#@#BCII$OA S6<<  * **rc V^8dQhRRRR/#)rslug Optional[str]rr)rs"rrrZs     =  rcVe(\V4P4P4MRpV'gR#\P V4'g\ RV: R24hV#)z>Lowercase + strip a slug; validate; return ``None`` for empty.Nr&zinvalid project slug zc: must be 1-64 chars, lowercase alphanumerics / hyphens / underscores, not starting with '-' or '_')r#r,r-_SLUG_REmatch ValueError)r1r.s& rnormalize_slugr7Zs\%)%5D !2A  >>!  #D8,   HrcV^8dQhRR/#)rrintr)rs"rrrhscrc>\\P!44#N)r9timerrr_nowr=hs tyy{ rc V^8dQhRRRR/#rpathr#rr)rs"rrrls  # # rc\PP\PP\ V4P 444pVP R4;'gT#)zEAbsolute, user-expanded, separator-normalized path (no trailing sep)./\)osr@abspath expanduserr#r,rstrip)r@ps& r_normalize_pathrHlsD **3t9??+<=>A 88E?  arc V^8dQhRRRR/#)rdb_pathOptional[Path]rsqlite3.Connectionr)rs"rrrrs\\^\/A\rcaVeTM \4p\VP44oRV3Rllp\VRRVR7#)zOpen (and initialize if needed) the per-profile projects DB. WAL with DELETE fallback for network filesystems (``hermes_state`` helper). Schema init is idempotent (``CREATE TABLE IF NOT EXISTS`` + additive migrations) and cached per-path per-process. c V^8dQhRRRR/#)rconnrLrNoner)rs"rrconnect..__annotate__{s)),))rc<S\9dR#VP\4VPR4Uu0uF qR,kK pp\FpW29gK \ VRW3 R24K \P S4R#uupi)NzPRAGMA table_info(projects)r"projectsz TEXT)r executescript SCHEMA_SQLexecute_OPTIONAL_PROJECT_COLUMNS_add_column_if_missingadd)rOrowcolscolresolveds& r _initializeconnect.._initialize{sx ) )  :&'+||4Q'RS'RF 'RS,C&tZUmL- x( TsBrT)db_label foreign_keys initialize)rr#resolver )rJr@r^r]s& @rconnectrdrsB )7/?/AD4<<>"H)) 4-d{ [[rcV^8dQhRR/#)rrJrKr)rs"rrrs^rc #t"\VR7pVx\P!\4;_uu_4VP 4RRR4R# +'giR#;i \P!\4;_uu_4TP 4RRR4i +'gii;i;i5i)zOpen a projects DB connection and close it on exit (sqlite3's own context manager only commits/rollbacks, so long-lived gateway/dashboard processes would leak fds otherwise).)rJN)rd contextlibsuppress Exceptionclose)rJrOs& rconnect_closingrksk 7 #D   + + JJL, + + +Z  + + JJL, + + +sJ B8A%"B8A B8 A"  B8%#B5B"  B5" B2 -B55B8cX]tRt^t$R]R&RtR]R&RtR]R&^tR ]R &R R ltR t R#) ProjectFolderr#r@Nr2labelFbool is_primaryr9added_atcV^8dQhRR/#rrdictr)rs"rrProjectFolder.__annotate__sxxxrc xRVPRVPR\VP4RVP/#)r@rnrprq)r@rnrorprq)selfs&rto_dictProjectFolder.to_dicts2 7DJJ d4??F[]gimivivwwrr) __name__ __module__ __qualname____firstlineno____annotations__rnrprqrx__static_attributes__rrrrmrms1 IE=JHcxxrrmc]tRt^t$R]R&R]R&R]R&R]R&RtR]R &RtR]R &RtR]R &RtR]R &Rt R]R &Rt R]R&] !] R7t R]R&RRltRtR#)Projectr#idr1r"r9 created_atNr2rrrrrFroarchived)default_factoryzlist[ProjectFolder]folderscV^8dQhRR/#rsr)rs"rrProject.__annotate__sEEErc  .RO\OUu/uFq\W4bK pp/VCR\VP4RVPRVP Uu.uFq3P 4NK up/C#uupiuupi)rrrr)rr1r")_OPTIONAL_ROW_FIELDSgetattrrorrrrx)rwkdfs& rrxProject.to_dicts*WBV*W X*WQ *W XE!EZdmm!4lDOOU^vzwCwCaDwCqrajajalwCaDE E YaDs A3A8r)rzr{r|r}r~rrrrrrrlistrrxrrrrrrsn G I IO!%K%D-E= $J $"&L-&Hd#(#>G >EErrc$V^8dQhRRRRRR/#)rrOrLrZz sqlite3.Rowrrr)rs"rrrs"  *   rcVP4pVPRVR,34P4p\R RVR,RVR,RVR,RVR,RRV9d\ VR,4MRRVUu.uF6p\ VR ,VR ,\ VR ,4VR ,4NK8 up/\ Uu/uFqUV9gK WQV,bK upB#uupiuupi)z9Materialize a ``projects`` row together with its folders.zySELECT path, label, is_primary, added_at FROM project_folders WHERE project_id = ? ORDER BY is_primary DESC, added_at ASCrr1r"rrFrr@rnrprqr)keysrVfetchallrrormr)rOrZrrrrs&& r _load_projectrs 88:Dll D T hj    t9 v; -0[ EHEV *4*<c*o&% fmmel`aqy!G*d1\?6KQz][elm 3 @24i91!f92 @  n @s H Q Q S _ Q,2asG ,-44T:qWD Krc V^8dQhRRRR/#r?r)rs"rrrs33C3C3rcR\PP\V44#)zGComparison key for primary-path dedup (absolute + case/sep-normalized).)rCr@normcaserH)r@s&r_primary_path_keyrs 77  OD1 22rinclude_archivedFc(V^8dQhRRRRRRRR/# rrOrLr@r#rrorOptional[Project]r)rs"rrrs+  1  SW du rcR\V4pV'd \WR7MRFpVP;'gM\RVP4VP'dVP^,P MR4pV'gKm\V4V8XgKVu# R#)zThe first (oldest) project whose primary path matches ``path`` (separator/case normalized so equivalent Windows spellings don't slip past the dedup check), else None.)rc3`"TF$qP'gKVPxK& R#5ir;)rpr@).0rs& r 'find_by_primary_path..s :\\\VQVV\s..Nr)r list_projectsrnextrr@)rOr@rkeyprojprimarys&&$ rfind_by_primary_pathrs D !CJM dFSUU##  t :T\\ :TXT`T`T`DLLO.s%Z1TAXYaa1Ts  Nz#folder already belongs to project 'z' (z/); switch to it instead of creating a duplicatezINSERT INTO projects (id, slug, name, description, icon, color, board_slug, primary_path, created_at, archived) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 0)zbINSERT INTO project_folders (project_id, path, label, is_primary, added_at) VALUES (?, ?, ?, ?, ?))r#r,r6r7r/secrets token_hexr=rrtfromkeysmaprHinsertrr1rr rVr executemany)rOr"r1rrrrrrrslug_candidatepidnow folder_pathsrexistingr@s&$$$$$$$$$ rcreate_projectrs tzzr? "D 9::-1^D)x~N ""1% %C &C %Z_gmmQS1T%ZZ[L/;ol+G7.Aw'<q/6=FZ#D2`dH1(--HKK=Q; ;   4  4 ,t4d+5^J '4 O  pMY Z\Tc4DGOqC @\ Z   J [  JsAG"G ;G G G" c$V^8dQhRRRRRR/#)rrOrLrrorz list[Project]r)rs"rrrs(JJ*JJR_JrcRV'dRMR,R,pVPV4P4Uu.uFp\W4NK up#uupi)zSELECT * FROM projectsr&z WHERE archived = 0z ORDER BY created_at ASC)rVrr)rOrsqlrs&$ rrrsI ",O=rcVPRV34P4;'g9VPR\V4P434P4pVfR#\ W4#)z,Look up a project by id first, then by slug.z#SELECT * FROM projects WHERE id = ?z%SELECT * FROM projects WHERE slug = ?N)rVrr#r-r)rOrrZs&& r get_projectrsm :ZMJSSU h h <<?#j/BWBWBYA[ \ e e g;4.&s:6ic1auD\6szUPDATE projects SET z WHERE id = ?)r#r,r6r7join_execute_rowcount) rOrr"rrrrr\givenstoredfieldssetsrs &&$$$$$ rupdate_projectrs*  4y => >3=3C3C3E3E^J/2 T =+"KfVZ\h\hdhMi e]]d +lJHZHZVZ-[8 8 !3V V8    99:6: :D T%9$}#M^dOe^dYZRSPTPT^dOeishtOt uxy yyPfs C9C9D c$V^8dQhRRRRRR/#)rrOrLrr#rr9r)rs"rrr*s".SSrc\V4;_uu_4VPW4pRRR4VP# +'giXP#;i)zIRun one write statement in its own txn and return the affected row count.N)r rVrowcount)rOrparamscurs&&& rrr*s: 4ll3'  <<  <<s : A rnrpc 0V^8dQhRRRRRRRRRR R R/#) rrOrLrr#r@rnr2rprorr)rs"rrr1s='S}quCFrc \V4pV'g \R4h\W4f\RV 24h\V4;_uu_4VP RWV\ 434VeVP RW1V34V'g$VP RV34P 4f \WV4RRR4V# +'giT#;i)z7Add a folder to a project. Returns the normalized path.zfolder path must not be emptyNzno such project: zlINSERT OR IGNORE INTO project_folders (project_id, path, label, is_primary, added_at) VALUES (?, ?, ?, 0, ?)zFUPDATE project_folders SET label = ? WHERE project_id = ? AND path = ?zESELECT 1 FROM project_folders WHERE project_id = ? AND is_primary = 1)rHr6rr rVr=r_set_primary_locked)rOrr@rnrpnorms&&&$$ r add_folderr1s 4 D 8994$,,ZL9:: 4 z udf -    LLadiw{c| }  SV`Ub (* $ 7  K  Ks =C /C C c(V^8dQhRRRRRRRR/#rrOrLrr#r@rror)rs"rrrGs)*34rc\V4p\V4;_uu_4VPRW34P4pVPRW34pVeoVR,'d`VPRV34P4pV'd$VR,'d\ WVR,4MVPRV34RRR4XP ^8# +'giL;i)zCRemove a folder from a project. Repoints primary if it was primary.zHSELECT is_primary FROM project_folders WHERE project_id = ? AND path = ?z=DELETE FROM project_folders WHERE project_id = ? AND path = ?NrpzSSELECT path FROM project_folders WHERE project_id = ? ORDER BY added_at ASC LIMIT 1r@z4UPDATE projects SET primary_path = NULL WHERE id = ?)rHr rVrrr)rOrr@r was_primaryrnxts&&& r remove_folderrGs 4 D 4ll VYcXj (* llZ]g\no  "{<'@'@,,ehrgthj s6{{#Dc&kB SV`Ubc  <UPDATE project_folders SET is_primary = 0 WHERE project_id = ?zKUPDATE project_folders SET is_primary = 1 WHERE project_id = ? AND path = ?z1UPDATE projects SET primary_path = ? WHERE id = ?NrV)rOrr@s&&&rrrZs:LLQT^S`aLL^ak`rsLLDtFXYrc(V^8dQhRRRRRRRR/#rr)rs"rrras)(crc\V4p\V4;_uu_4VPRW34P4f RRR4R#\ WV4RRR4R# +'giR#;i)z?SELECT 1 FROM project_folders WHERE project_id = ? AND path = ?NFT)rHr rVrr)rOrr@rs&&& r set_primaryrasd 4 D 4 <<Y\f[m n w w y B  Dd3    s%A$ A$$ A5 c$V^8dQhRRRRRR/#rrOrLrr#rror)rs"rrrj'gg,g#g$grc$\VRV34^8#)z-UPDATE projects SET archived = 1 WHERE id = ?rrOrs&&rarchive_projectrj T#RU_Ta bef ffrc$V^8dQhRRRRRR/#rr)rs"rrrnrrc$\VRV34^8#)z-UPDATE projects SET archived = 0 WHERE id = ?rrs&&rrestore_projectrnrrc$V^8dQhRRRRRR/#rr)rs"rrrrs'[[+[[[rc$\VRV34^8#)z0Hard-delete a project and its folders (cascade).z!DELETE FROM projects WHERE id = ?rrs&&rdelete_projectrrs T#F VYZ ZZrc(V^8dQhRRRRRRRR/#)rrOrLrr#valuerrPr)rs"rrrys)0s34rc,VPRW34R#)z=Upsert a project_meta row (caller already holds a write txn).ziINSERT INTO project_meta (key, value) VALUES (?, ?) ON CONFLICT(key) DO UPDATE SET value = excluded.valueNr)rOrrs&&&r_upsert_meta_lockedrysLLs rc$V^8dQhRRRRRR/#)rrOrLrr#rr2r)rs"rrrs"))&)S)])rcjVPRV34P4pV'd VR,#R#)z,SELECT value FROM project_meta WHERE key = ?rN)rVr)rOrrZs&& r _get_metars/ ,,Ev N W W YC3w<(D(rc$V^8dQhRRRRRR/#)rrOrLrr2rrPr)rs"rrrs'DD'D]DtDrc\V4;_uu_4VfVPR\34M\V\V4RRR4R# +'giR#;i)z9Set (or clear, when ``None``) the active project pointer.Nz&DELETE FROM project_meta WHERE key = ?)r rV_ACTIVE_META_KEYrrs&&r set_activers= 4   LLADTCV W &6 C s .A  A c V^8dQhRRRR/#rrOrLrr2r)rs"rrrs--*-}-rc"\V\4#r;)rrrOs&r get_active_idr s T+ ,,rc V^8dQhRRRR/#rr)rs"rrrs77#57-7rc"\V\4#r;)r_DISCOVERY_POLICY_META_KEYr s&rget_discovery_policy_keyrs T5 66rc(V^8dQhRRRRRRRR/#) rrOrLclearro policy_keyr2rrPr)rs"rrrs0JJ0JJ=J]aJrcfV'dVPR4Ve\V\V4R#R#)zaOptionally wipe the scan cache, then record the policy key when given (caller holds a write txn).DELETE FROM discovered_reposN)rVrr)rOrrs&&&r_clear_repos_lockedrs*  34D" C jn { rc\V4pW18XdR#VRJ;'gV'*p\V4;_uu_4\WV4RRR4V# +'giT#;i)zClear cached scan rows when their discovery policy changes; pre-policy rows are retained only for the backward-compatible default policy. Returns whether rows were cleared.FN)rr r)rOrrcurrentcleareds&&$ r!reconcile_discovered_repos_policyrsW't,GT!==)=%=G 4D:6  N  Ns A A" rc$V^8dQhRRRRRR/#)rrOrLrr2rrPr)rs"rrrs#44!34M4]a4rc\V4;_uu_4\VRV4RRR4R# +'giR#;i)TN)r r)rOrs&$rclear_discovered_reposrs# 4D$ 3 s, = replacec ,V^8dQhRRRRRRRRR R /#) rrOrLreposz#Iterable[tuple[str, Optional[str]]]rrorr2rr9r)rs"rrrs6 %HVZ rc\4pRV4UUu.uFDwrVV'gKYV;'g*\PPV4;'gTV3NKF ppp\ V4;_uu_4V'dVP R4V'dVP RV4\VRV4RRR4\V4#uuppi +'giL!;i)zPersist scanned ``(root, label)`` repo roots (normalized; label falls back to basename) and return the row count. ``replace`` = authoritative fresh scan: stale rows are deleted first so old eval/worktree noise doesn't live forever.c3@"TFwr\V4V3xK R#5ir;)rH)rrootrns& rr*record_discovered_repos..sTe{t_T2E:esrzINSERT INTO discovered_repos (root, label, last_seen) VALUES (?, ?, ?) ON CONFLICT(root) DO UPDATE SET label = excluded.label, last_seen = excluded.last_seenFN) r=rCr@basenamer rVrrr)rOr!rrrrrnrowss&&$$ rrecord_discovered_reposr(s &CUeT TKDX\ =66((.66$<T   4  LL7 8    i  D%4  t9  s' C C &C  C 7!CC C! c V^8dQhRRRR/#)rrOrLrz list[dict]r)rs"rrrsEE 2EzErc|VPR4P4Uu.uFp\V4NK up#uupi)z;All cached discovered repo roots, most-recently-seen first.zKSELECT root, label, last_seen FROM discovered_repos ORDER BY last_seen DESC)rVrrt)rOrs& rlist_discovered_reposr+sN!\\*wxBBD EDDGD EE Es9c(V^8dQhRRRRRRRR/#rr)rs"rrrs0ee-eSete`qerca\T;'gR4P4'gR#\V4oRpV'g VR, pRV3RllpVPV4P 4Uu.uFqT!VR,4'gKVNK ppV'd \ V\ VRR 7R ,4#R#uupi) zReturn the project owning ``path``: a folder owns it when equal or an ancestor, and the longest folder wins so nested projects resolve to the innermost one.r&NznSELECT pf.project_id AS pid, pf.path AS folder FROM project_folders pf JOIN projects p ON p.id = pf.project_idz WHERE p.archived = 0c V^8dQhRRRR/#)rfolderr#rror)rs"rr&project_for_path..__annotate__seeSeTerc<VPR4pSV8H;'gGSPV\P,4;'gSPVR,4#)rB/)rF startswithrCsep)r/stemtargets& rownsproject_for_path..ownssQ}}U#dd6#4#4TBFF]#CddvGXGXY]`cYcGddrr/c&\VR,4#)r/)r)rs&r"project_for_path..s s1X;7Gr)rr)r#r,rHrVrrmax)rOr@rrr7rZownersr6s&&$ @rproject_for_pathr>s tzzr? " " T "F zC  &&ee"\\#.779 Q9cT#h-=Pcc9F QTZ;tS-GHO Pd`ddRs 5CCtitler&c(V^8dQhRRRRRRRR/#)rr)rtask_idr#r?rr)rs"rrrs(00W0s0c030rcTVP;'g\VP4 RV 2pV'da\P R\ V4P 4P44P R4R,P R4MRpV'dV RV 2#T#)zDeterministic ``/[-]`` branch name for a project-linked kanban task (stable and human-meaningful, replacing the random ``wt/`` fallback).r2r%:N(Nr&)r1r/r"_BRANCH_SAFE_REr+r#r,r-)r)rAr?basetslugs&&$ rbranch_name_forrGsll44hw||4 5Qwi @D_dO  SZ%5%5%7%=%=%? @ F Fs KC P V VWZ [jlE %dV1UG /4/r)rrrr)rrrrrr;)K__conditional_annotations____doc__ __future__rrgrCr*rsqlite3r< dataclassesrrpathlibrtypingrrrhermes_cli.sqlite_utilr rXr r hermes_constantsr rrUcompiler4rDsetrr~rWrrrr/r7r=rHrdcontextmanagerrkrmrrrrrrrrrrrrrrrrrrrrr rrrrr(r+r>rG)rHs@rrTsZ #  (++ff,- ' V ::4 5**-."uH$LU4+   \,  xx x EE E$ 3 Z_ $BF$ko$"&$EI$ae$ $>B$af$NJJ =zHLzkozz7;zY]z2_cx},&Zgg[) D-7J qv 4TX4 ]b $2E eV[e$0B00r