U
    h                     @   sp   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	
eZe Zedeefeddd	ZdS )
    )	APIRouterDepends)Session)text)get_dbNz/api/test/developers-direct)dbc                    s   z|  td}g }|D ]b}||j|j|j|j|j|jrL|jdd d nd|j	r^t
|j	nd|jrpt
|jndd q|  td }t|||ddW S  tk
r } z&td	|  t
|d
d W Y S d}~X Y nX dS )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)Zdevelopers_table_count
developersZtotal_activities_in_dbmessagez"Error in direct developers query: z Failed to query developers table)errorr   )Zexecuter   appendr	   r
   r   r   r   r   r   strr   Zscalarlen	Exceptionloggerr   )r   resultr   rowZactivity_counte r   ./test_developers_endpoint.pyget_developers_direct   s2    
r   )Zfastapir   r   Zsqlalchemy.ormr   Z
sqlalchemyr   Zdatabaser   ZloggingZ	getLogger__name__r   Zroutergetr   r   r   r   r   <module>   s   
