i4SSKJr SrSrSrSrSrSrg) )get_connectioncSn[5nU(d [S5eUR5nURU5 UR 5nUVs/sHoDSUSUSS.PM snU(aUR 5 $$s snf![ a2n[SU35 /sSnAW(aUR 5 $$SnAff=f!W(aUR 5 ff=f) 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 datosr)Item_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//#jqqipbeQAVYZ[V\]ipq  JJL  r  >qcBC  JJL    JJL sBAB B-B B C C&C 'C C  C C&c[5nUR5nURSU45 UR5nUU(aUR 5 $$!U(aUR 5 ff=f)NzFSELECT COUNT(*) FROM CZE_PrjWarWarranty WHERE Item_PrjWar_Warranty = ?)rr rfetchoner)itemrr results r item_existsr%s_  D_bfahi"  JJL 4 JJL s 4AA3c\Sn[5nU(d [S5eUR5nURX0X45 UR 5 W(aUR5 gg![ an[ SU35 SnAN6SnAff=f!W(aUR5 ff=f)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 rcommitrrrrr r rrr rs rinsert_Catalogo_de_garantiasr#0s E !"XY Yu[=>   JJL  C =aSABBC  JJL *AA,, B6B B BBB+c\Sn[5nU(d [S5eUR5nURX1X 45 UR 5 W(aUR5 gg![ an[ SU35 SnAN6SnAff=f!W(aUR5 ff=f)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: Nr r"s rupdate_Catalogo_de_garantiasr&Es E !"XY YuJ=>   JJL  E ?sCDDE  JJL r$cZSn[5nU(d [S5eUR5nURX45 UR 5 W(aUR5 gg![ an[ SU35 SnAN6SnAff=f!W(aUR5 ff=f)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 5BBB  BB*c[5nU(d [S5eUR5nURS5 UR 5nU(d/U(aUR 5 $$UVs/sH nSUS0PM snU(aUR 5 $$s snf![ a2n[SU35 /sSnAW(aUR 5 $$SnAff=f!W(aUR 5 ff=f)Nrz3SELECT Item_PrjWar_Warranty from CZE_PrjWarWarrantyrru?[Error inesperado] Error consultando Catálogo de garantías : r )rr rrrs r searchitemsr*ns!"XY YLM//#  JJL  =DDGS'Q0GD  JJL  E  OPQsST  JJL    JJL sHAB%0B%4B B% B%% C!/C>C!?C$C!!C$$C>N)Consultas_SQL.conexionrrrr#r&r(r*rr.s(2: **(r-