U ZhV@sRdZddlmZddlZddlmZmZddlmZee Z GdddeZ dS)zN Fixed Developer Discovery that includes developers from the developers table )DeveloperDiscoveryN)datetimetimezone)textcs8eZdZdZddZd eeeeedfdd ZZS) FixedDeveloperDiscoveryzAExtended DeveloperDiscovery that also checks the developers tablec Cs|js gSz@td}|j|}g}|D]}d}d}z8td}|j|d|ji}|rn|jpfd}|j}Wn:tk r} zt d|j d| W5d} ~ XYnX| |jpd|j |j d d |j |jpd|j d |d |r| n|jr|j nd|d d|j|jr"|j nddddq*tdt|d|WStk r} ztd| gWYSd} ~ XYnXdS)z(Get developers from the developers tableaQ SELECT id, developer_id, name, email, active, api_token, created_at, last_sync FROM developers WHERE active = true rNa SELECT COUNT(*) as count, MAX(timestamp) as last_activity FROM activity_records WHERE developer_id = :dev_id dev_idzError counting activities for z: Zdev_unknownizRegistered developer (z activities)Zdevelopers_table registeredzN/A)idnamehostporthostname device_id description last_seenactivity_countsourcestatusemail created_atversion bucket_countzFound z developers in developers tablez)Error discovering from developers table: ) db_sessionrexecute developer_idfetchonecount last_activity Exceptionloggerwarningr appendr isoformatrrinfolenerror) selfqueryresult developersrowrrZ count_queryZ count_resulter-cszBFixedDeveloperDiscovery.discover_all_developers..r rrrz3Total developers after including developers table: ) superdiscover_all_developersr r$r/r" enumerategetr%) r'r0r1r2r3all_developersZ table_devsZ existing_idsr6iexisting __class__r-r.r9Ws"     z/FixedDeveloperDiscovery.discover_all_developers)FTTT) __name__ __module__ __qualname____doc__r/boollistr9 __classcell__r-r-r?r.r sGr) rDdeveloper_discoveryrloggingrr sqlalchemyr getLoggerrAr rr-r-r-r.s