
    وh                         d dl mZmZ d dlmZ d dlmZ d dlmZm	Z	 d dl
Z
 eddg      Zej                  d	       ee      fd
efd       Zy)    )	APIRouterDepends)get_db)Session)SupplierModelSupplier2ModelNz
/suppliers	suppliers)prefixtagsz/old_suppliersdbc                 t   t        j                  ddddt         j                  j                        }|j	                         5 }|j                  d       |j                         }|D ]  }|d   }|d   }t        ||       | j                  t              j                  t        j                  |k(        j                         }|d	k(  r;t        ||
      }| j                  |       | j                          t        d|       t        d|        	 d d d        |j!                          diS # 1 sw Y   xY w)Nzjisparking.comjysparki_adminz
Admin2024$jysparki_jis)hostuserpasswordr   cursorclassz
            SELECT 
               supplier_data.*,
                users.names
            FROM supplier_data LEFT JOIN users ON supplier_data.rut = users.rut
        rutnamesr   )r   supplierzProvedor guardado:zEl proveedor ya existe:data)pymysqlconnectcursors
DictCursorcursorexecutefetchallprintqueryr   filterr   countr   addcommitclose)	r   connr   resultrowr   r   r   new_suppliers	            I/var/www/intrajisbackend.com/public_html/app/backend/routers/suppliers.pyold_dtesr+      s   ??OO..D 
 6&  	 " 	6Ce*CLE#uxx.55m6G6G36NOUUWH1}-"  |$		*C0/5	664 	JJLF96 6s   CD..D7)fastapir   r   app.backend.db.databaser   sqlalchemy.ormr   app.backend.db.modelsr   r   r   r	   getr+        r*   <module>r3      sR    & * " ? 
	
  "6? % % !%r2   