+ i6^RIHtRtRtRtRtRtRtR#) )get_connectionc Rp\4pV'g \R4hVP4pVPV4VP 4pVUu.uF pRV^,RV^,RV^,/NK" upV'dVP 4##uupi \ d4p\RT 24.uRp?X'dTP 4##Rp?ii;i X'dTP 4ii;i)z5Obtiene catalogo de controles desde la base de datos.z SELECT CZE_PrjWarWarranty.Item_PrjWar_Warranty, CZE_PrjWarWarranty.description, CZE_PrjWarWarranty.Percentage FROM CZE_PrjWarWarranty 4No se pudo establecer conexión con la base de datosItem_PrjWar_Warranty description Percentagez.[Error inesperado] Error obteniendo breakers: NrConnectionErrorcursorexecutefetchallclose Exceptionprint)queryconnr resultsrowes |C:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\Consultas_SQL\Ventas\VentasEUA\DataMaster\DMPrjWarWarrantySQL.pyget_Catalogo_de_garantiasrs E!"XY Yu//#jqqipbe'QA VYZ[V\]ipq  JJL  r  >qcBC  JJL    JJL sBAB&B<BB C(C7C8CCCC9c\4pVP4pVPRV34VP4pTV'dVP 4## T'dTP 4ii;i)zFSELECT COUNT(*) FROM CZE_PrjWarWarranty WHERE Item_PrjWar_Warranty = ?)rr r fetchoner)itemrr results& r item_existsr%s_  D_bfahi"  JJL 4 JJL s 4AA5chRp\4pV'g \R4hVP4pVPW0W34VP 4X'dVP4R#R# \ dp\ RT 24Rp?L:Rp?ii;i X'dTP4ii;i)z-Inserta un nuevo breaker en la base de datos.zm INSERT INTO CZE_PrjWarWarranty (Item_PrjWar_Warranty, description, Percentage) VALUES (?, ?, ?) rz-[Error inesperado] Error insertando breaker: Nrr r r commitrrrrrrrrr rs&&& rinsert_Catalogo_de_garantiasr!0s E !"XY Yu[=>   JJL  C =aSABBC  JJL *AA00 B;B BBBB1chRp\4pV'g \R4hVP4pVPW1W 34VP 4X'dVP4R#R# \ dp\ RT 24Rp?L:Rp?ii;i X'dTP4ii;i)z)Actualiza un breaker en la base de datos.zn UPDATE CZE_PrjWarWarranty SET description = ?, Percentage = ? WHERE Item_PrjWar_Warranty = ? rz/[Error inesperado] Error actualizando breaker: Nrr s&&& rupdate_Catalogo_de_garantiasr$Es E !"XY YuJ=>   JJL  E ?sCDDE  JJL r"cfRp\4pV'g \R4hVP4pVPW34VP 4X'dVP4R#R# \ dp\ RT 24Rp?L:Rp?ii;i X'dTP4ii;i)u7Elimina un Catálogo de garantías de la base de datos.zK DELETE FROM CZE_PrjWarWarranty WHERE Item_PrjWar_Warranty = ? rz0[Error inesperado] Error eliminando el Control: Nr)rrrr rs& rdelete_Catalogo_de_garantiasr&Zs E !"XY Yug&   JJL  F @DEEF  JJL s*AA// B:B B BBB0c\4pV'g \R4hVP4pVPR4VP 4pV'g.V'dVP 4##VUu.uFpRV^,/NK upV'dVP 4##uupi \ d4p\RT 24.uRp?X'dTP 4##Rp?ii;i X'dTP 4ii;i)rz3SELECT Item_PrjWar_Warranty from CZE_PrjWarWarrantyru?[Error inesperado] Error consultando Catálogo de garantías : Nr )rr rrrs r searchitemsr(ns!"XY YLM//#  JJL  =DDGS'Q0GD  JJL  E  OPQsST  JJL    JJL sNAB,B,3B,7B' B,'B,, C*7C%C*C-%C**C--DN)Consultas_SQL.conexionrrrr!r$r&r(rr,s(2: **(r+