U h @srddlZddlZddlZddlmZddlmZmZeedZe dd dZ e d dZ e d  d Z e d dZejedeed kred nd e d e de d d ZeZed ededeZeD]\ZZedededqededeZeD] \ZZedededq$ededeZeD]&\ZZedepxddedqdereddZedede Z!edee!feZ"e"r|ede!de"D]Z#ede#dede#d ede#d dd!d"ed#e#d$p@ded%e#d&d'ed(e#d)ed*qnped+e!ed,d-Z$ed.ee$feZ%e%D]<\Z ZZ&e&re&d/ndZ'ed0e ded1e'd2d3qed4ed5e(dZ)ed6e)e)dkr^ed7ed8eD] \ZZed0ededq= %s GROUP BY DATE(timestamp) ORDER BY date DESC iz z activities, z.2fz hoursz 5. Uncategorized Records:z] SELECT COUNT(*) FROM activity_records WHERE category IS NULL OR category = '' z Total uncategorized: z Sample uncategorized apps:a SELECT DISTINCT application_name, COUNT(*) as count FROM activity_records WHERE category IS NULL OR category = '' AND application_name IS NOT NULL GROUP BY application_name ORDER BY count DESC LIMIT 10 )+Zpsycopg2ZjsonosZdotenvrrrgetenvrreplacesplitZ conn_partsZ user_passZhost_dbZ host_portZconnectlenZconnZcursorZcurprintZexecuteZfetchallZ developersZdev_idcountZappsZapp categoriescatZ sample_dev_idZnowdateZtodayZrecordsrecordZweek_agoZ daily_statsZdurationZhoursZfetchoneZuncategorized_countcloserr./debug_activity_records.pys              "