U h @sddlZddlZddZdZeegZediZeD].ZedekrRgeed<eedeq6e D]<\Z Z ede e D] Z ede d d e d qqndS) Nc Cs2g}dddddg}t|D]\}}}dd|D|dd<|D]}|d rBtj||}zt|d d d } | } W5QRX|D]z} t| | tj tj B} | D]Z} | d|  d d}| d }||d}|||tjd|| |dqqWqBtk r(}zW5d}~XYqBXqBq|S)z6Search for SQL queries or ORM patterns in Python filesz\.filter.*active.*==.*[Tt]ruez\.outerjoin.*activity_countzcoalesce.*activity_countzdevelopers.*LEFT OUTER JOINz subquery\(\)cSsg|]}|dkr|qS))venv __pycache__z.git).0drr./find_query_source.py sz&search_for_queries..Nz.pyrzutf-8)encoding )filelinepatterncontent)oswalkendswithpathjoinopenreadrefinditer IGNORECASE MULTILINEstartcountsplitstripappendreplacesep Exception)Z directorypatternsresultsZsearch_patternsrootdirsfilesrZ file_pathfrrmatchesmatchZline_numlinesZ line_contenterrrsearch_for_queriess<  r/z"E:\timesheet\timesheet_new\backendz1=== Files with potential problematic queries === rz File: z Line rz: r) rrr/Z backend_dirr&printZ files_foundresultr!itemsrr+r,rrrrs-