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 Zdev_idzError counting activities for z: Zdev_unknownizRegistered developer (z activities)Zdevelopers_tableZ registeredzN/A)idnameZhostZportZhostnameZ device_id descriptionZ last_seenactivity_countsourcestatusemail created_atversionZ bucket_countzFound z developers in developers tablez)Error discovering from developers table: )Z db_sessionrZexecuteZ developer_idZfetchonecount last_activity ExceptionloggerZwarningr appendrZ isoformatrrinfolenerror) selfZqueryresultZ developersrowr rZ count_queryZ count_resulter./fixed_developer_discovery.pydiscover_from_developers_tablesT     *   z6FixedDeveloperDiscovery.discover_from_developers_tableFT) scan_network scan_local scan_databaseinclude_developers_tablereturnc st|||}|rtd|}dd|D}|D]~}|d|krT||q8t|D]X\} } | d|dkr\| ds|d| d<|dd| ddkr|d| d<q8q\q8tdt||S) z1Extended discovery that includes developers tablez/Discovering developers from developers table...cSsh|] }|dqS)rr).0devrrr cszBFixedDeveloperDiscovery.discover_all_developers..rrr rz3Total developers after including developers table: ) superdiscover_all_developersrrrr enumerategetr) rr r!r"r#Zall_developersZ table_devsZ existing_idsr&iexisting __class__rrr)Ws"     z/FixedDeveloperDiscovery.discover_all_developers)FTTT) __name__ __module__ __qualname____doc__rboollistr) __classcell__rrr.rr sGr) r3Zdeveloper_discoveryrZloggingrrZ sqlalchemyrZ getLoggerr0rrrrrrs