
    ^_f                     L    d dl Z d dlZd dlZd dlZddlmZmZm	Z	m
Z
mZ d Zd Zy)    N   )	db_dbnamedb_userdb_passworddb_hostdb_portc                 "   |dk(  r(t        | dd      5 }|j                         cddd       S t        | d      5 }dt        j                  |j                               j	                  d       cddd       S # 1 sw Y   yxY w# 1 sw Y   yxY w)z7Read and convert image files to base64-encoded strings.svgrzutf-8)encodingNrbzdata:image/jpeg;base64,)openreadbase64	b64encodedecode)	file_path	file_typefiles      J/Users/putuwistika/Documents/TRILAK/dashboard-catalog-gnss/utils/common.pyreplace_imager      s    E)S73 	t99;	 	 )T" 	]d,V-=-=diik-J-Q-QRY-Z,[\	] 	]	 		] 	]s   A95B9BBc                    	 t        j                  t        t        t        t
        t              }|j                         }|j                  |        |j                         }|j                  D cg c]  }|d   	 }}t        j                  ||      }||r|j                          |r|j                          S S c c}w # t         j                  $ rG}t        j                   d|        Y d }~r|j                          r|j                          y y d }~ww xY w# r|j                          r|j                          w w xY w)N)dbnameuserpasswordhostportr   )columnsz Error connecting to PostgreSQL: )psycopg2connectr   r   r   r   r   cursorexecutefetchalldescriptionpd	DataFramecloseErrorsterror)query
connectionr!   recordsdescr   dfes           r   	load_datar1      s   %% 

 ""$u//#'-'9'9:t47::\\'73
 LLN  ; >> 
3A378LLN  LLN s<   A-C  /B;;C  ;C   DD+D DD 'E)r   r   	streamlitr)   pandasr%   credentialsr   r   r   r   r   r   r1        r   <module>r7      s"        J J]r6   