iSSKJrJr SSKJr SSKr\"5rSrSr"SS\5r \RS5S 5r \RS 5S \ 4S j5r \RS 5S \ S\ 4Sj5rg))FastAPI HTTPException) BaseModelNzDriver={ODBC Driver 18 for SQL Server};Server=192.168.1.13;Database=Home;UID=unabomber;PWD=n116533891W2k;Encrypt=yes;TrustServerCertificate=yes;c4[R"[SS9$)NF) autocommit)pyodbcconnectCONN_STR/var/www/html/main.pyget_connrs >>(u 55r c:\rSrSr%\\S'\\\S'\\S'Srg) MarkRequest keepFileId deleteFileIdstoDeleter N) __name__ __module__ __qualname____firstlineno__int__annotations__listbool__static_attributes__r r r rrsO9Nr rz //dup-groupsc [5nUR5nURS5 UR5n/nSnUHmn[ UR 5n[ UR 5nUS- U-nUR[U5[UR5UUUS.5 US- nMo UUR5 $!UR5 f=f)z Returns groups that have duplicates. Assumes your 'files' table has: id, path, sizeBytes (or size), hash, todelete, MTimeUtc, LastSeenUtc Adjust column names as needed. aH SELECT FullHash, sizeBytes = MAX(sizeBytes), fileCount = COUNT(*) FROM files WHERE FullHash IS NOT NULL GROUP BY FullHash, sizeBytes HAVING COUNT(*) > 1 ORDER BY (COUNT(*) - 1) * MAX(sizeBytes) DESC )groupIdFullHash sizeBytes fileCount wastedBytes) rcursorexecutefetchallrr"r#appendstrr!close) conncurrowsoutgroup_idr size_bytes file_countwasteds r list_dup_groupsr4s :D kkm  ||~AQ[[)JQ[[)J 1n 2F JJx= O''%   MH  s B)CCz//dup-groups/{group_id}r/c  [U5nUS:a [5e[5nUR 5nUR SU5 UR 5nU(d [SSS9eURn[UR5nUR SXV5 /nUR5H{nUR[UR5[UR5[UR5URUR[!UR"5S .5 M} [U5[U5UUS .UR%5 $![a [SSS9ef=f!UR%5 f=f) z Since our simple list endpoint invents groupId values, we re-derive by rank. For production: store groups in a table with a stable groupId. r*group_id must be a positive integer string status_codedetailag WITH dup AS ( SELECT FullHash, sizeBytes, fileCount = COUNT(*), wastedBytes = (COUNT(*) - 1) * MAX(sizeBytes), rn = ROW_NUMBER() OVER ( ORDER BY (COUNT(*) - 1) * MAX(sizeBytes) DESC ) FROM files WHERE FullHash IS NOT NULL GROUP BY FullHash, sizeBytes HAVING COUNT(*) > 1 ) SELECT FullHash, sizeBytes FROM dup WHERE rn = ? Group not foundz SELECT FileId, path, sizeBytes, MTimeUtc, LastSeenUtc, todelete FROM files WHERE FullHash = ? AND sizeBytes = ? ORDER BY path )FileIdpathr"MTimeUtc LastSeenUtctodelete)r r!r"files)r ValueErrorrrr%r&fetchoner!r"r'r(r=r)r>r?r@rrAr*) r/idxr+r,gthe_hashr1rBr0s r get_grouprHCs\b(m 7,   :D9kkm  $% ( LLNC8IJ J::%     #A LLahh-AFF  -JJ }} ,   3xH #   { b4`aabz sEDE1E.1Fz//dup-groups/{group_id}/markreqcURUR;a [SSS9eUR(d [SSS9e[U5nUS:a [ 5e[ 5nUR 5nURSU5 UR5nU(d [SS S9eURn[UR5nS RS UR55nS US 3n UR(aSOSXg/UR-n URX5 UR5 SUR0UR5 $![a [SSS9ef=f!UR5 f=f)zU Sets todelete bit for req.deleteFileIds. Safety: ensure keepFileId is not included. r6z%keepFileId cannot be in deleteFileIdsr8zNo deleteFileIds suppliedrr7a WITH dup AS ( SELECT FullHash, sizeBytes, rn = ROW_NUMBER() OVER ( ORDER BY (COUNT(*) - 1) * MAX(sizeBytes) DESC ) FROM files WHERE FullHash IS NOT NULL GROUP BY FullHash, sizeBytes HAVING COUNT(*) > 1 ) SELECT FullHash, sizeBytes FROM dup WHERE rn = ? r;r<,c3&# UHnSv M g7f)?Nr ).0_s r mark_group..s?->->sz UPDATE files SET todelete = ? WHERE FullHash = ? AND sizeBytes = ? AND FileId IN (z ) rupdated)rrrrrCrr%r&rDr!r"joinrcommitrowcountr*) r/rIrEr+r,rFrGr1 placeholderssqlparamss r mark_grouprYsn  ~~***4[\\   4OPPb(m 7,   :D+kkm  ! $ LLNC8IJ J::% xx?S->->?? +^,  ||!HACDUDUU C  3<<( _ b4`aab^ sE(CE/E,/F)fastapirrpydanticrrappr rrgetr4r)rHpostrYr r r r_s*  i& 6) ''R "#GG$GR ()??;?*?r