
    Ji                         d dl mZmZ d dlmZ d dlmZ d dlmZ d dl	Z	 e	j                  e      Z e       Zej                  d       ee      fdefd       Zy)	    )	APIRouterDepends)Session)text)get_dbNz/api/test/developers-directdbc                   K   	 | j                  t        d            }g }|D ]  }|j                  |j                  |j                  |j
                  |j                  |j                  |j                  r|j                  dd dz   nd|j                  rt        |j                        nd|j                  rt        |j                        ndd        | j                  t        d            j                         }t        |      ||ddS # t        $ r0}t        j!                  d	|        t        |      d
dcY d}~S d}~ww xY ww)z,Direct query to developers table for testingzSELECT * FROM developersN
   z...)iddeveloper_idnameemailactive	api_token
created_at	last_syncz%SELECT COUNT(*) FROM activity_recordsz Direct query to developers table)developers_table_count
developerstotal_activities_in_dbmessagez"Error in direct developers query: z Failed to query developers table)errorr   )executer   appendr   r   r   r   r   r   r   strr   scalarlen	Exceptionloggerr   )r   resultr   rowactivity_countes         >E:\timesheet\timesheet_new\backend\test_developers_endpoint.pyget_developers_directr$      s     
D!;<=
Cff # 0 0**;>==S]]3B/%7d58^^c#..136==S/d	 	  D)P$QRYY[ '**o$&49	
 	
  
9!=>V9
 	

s5   EDD 
E	E%D?9E:E?EE)fastapir   r   sqlalchemy.ormr   
sqlalchemyr   databaser   logging	getLogger__name__r   routergetr$        r#   <module>r0      sW    & "   			8	$	)*.5fo "
G "
 +"
r/   