
    .th                     N    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dS )    N   )	db_dbnamedb_userdb_passworddb_hostdb_portc                 Z   |dk    r@t          | dd          5 }|                                cddd           S # 1 swxY w Y   dS t          | d          5 }dt          j        |                                                              d           cddd           S # 1 swxY w Y   dS )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      6/srv/www/htdocs/dashboard-catalog-gnss/utils/common.pyreplace_imager      sA   E)S7333 	t99;;	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 )T"" 	]d\V-=diikk-J-J-Q-QRY-Z-Z\\	] 	] 	] 	] 	] 	] 	] 	] 	] 	] 	] 	] 	] 	] 	] 	] 	] 	]s   :>><B  B$'B$c                    	 t          j        t          t          t          t
          t                    }|                                }|                    |            |	                                }d |j
        D             }t          j        ||          }||r|                                 |r|                                 S S # t           j        $ rP}t          j        d|            Y d }~|r|                                 |r|                                 d S d S d }~ww xY w# |r|                                 |r|                                 w w xY w)N)dbnameuserpasswordhostportc                     g | ]
}|d          S )r    ).0descs     r   
<listcomp>zload_data.<locals>.<listcomp>   s    :::t47:::    )columnsz Error connecting to PostgreSQL: )psycopg2connectr   r   r   r   r   cursorexecutefetchalldescriptionpd	DataFramecloseErrorsterror)query
connectionr'   recordsr$   dfes          r   	load_datar6      s   % 
 
 

 ""$$u//##::v'9:::\'7333
  	LLNNN 		 >   
7A77888ttt 	LLNNN 		 	  	LLNNN 		s*   BC D&D!-D) !D&&D) )/E)r   r%   	streamlitr/   pandasr+   credentialsr   r   r   r   r   r   r6   r   r#   r   <module>r:      s              J J J J J J J J J J J J J J] ] ]    r#   