
    v(f                     6    d dl Z d dlmZ d dlZd dlZd dlZd Zy)    N)
connect_dbc                     K   	 t                d {   } | j                         }|j                  d       |j                         }d|iS 7 9# t        $ r}t        d|        Y d }~yd }~ww xY ww)NzSELECT * FROM file_list	employeeszError saving file: F)r   cursorexecutefetchallfetchkeyslistjsondumpspd	DataFrameto_json	Exceptionprint)	connr   resultrecordscolumn_namescolumn_names_listresponse_contentcustomize_dataes	            Mc:\Users\Admin\OneDrive - OMSOFTWARE\Python\NoticeGen\operations\file_data.pyfileListr      sm     \!01"V$$	 "&  #A3'(s>   A1A A8A 
A1A 	A.A)$A1)A..A1)osmodels.connectr   pandasr   asyncior   r        r   <module>r#      s    	 %   r"   