U h@spddlmZmZddlmZddlmZddlmZddl Z e e Z eZ e deefeddd ZdS) ) APIRouterDepends)Session)text)get_dbNz/api/test/developers-direct)dbc sz|td}g}|D]b}||j|j|j|j|j|jrL|jdddnd|j r^t |j nd|j rpt |j nddq|td }t |||ddWStk r}z&td |t |d d WYSd}~XYnXdS) z,Direct query to developers table for testingzSELECT * FROM developersN z...)id developer_idnameemailactive api_token created_at last_syncz%SELECT COUNT(*) FROM activity_recordsz Direct query to developers table)Zdevelopers_table_count developersZtotal_activities_in_dbmessagez"Error in direct developers query: z Failed to query developers table)errorr)executerappendr r r r r rrstrrscalarlen Exceptionloggerr)rresultrrowactivity_counter;/var/www/html/timesheet/backend/test_developers_endpoint.pyget_developers_direct s2 r!)fastapirrsqlalchemy.ormr sqlalchemyrdatabaserlogging getLogger__name__rroutergetr!rrrr s