i.SSKJr SrSrSrSrSrg))get_connectioncSn[5nU(d [S5eUR5nURU5 UR 5nUVs/sHoDSUSUSUSS.PM snU(aUR 5 $$s snf![ a2n[SU35 /sS nAW(aUR 5 $$S nAff=f!W(aUR 5 ff=f) z,Obtiene los Breakers desde la base de datos.z SELECT CZE_BreakersOptions.Item_breaker_options, CZE_BreakersOptions.description, CZE_BreakersOptions.price, CZE_BreakersOptions.TechnicalSheet FROM CZE_BreakersOptions 4No se pudo establecer conexión con la base de datosr)Item_breaker_options descriptionpriceTechnicalSheetz.[Error inesperado] Error obteniendo breakers: NrConnectionErrorcursorexecutefetchallclose Exceptionprint)queryconnrresultsrowes }C:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\Consultas_SQL\Ventas\VentasEUA\DataMaster\DMbreakersOptionsSQL.pyget_BreakersOptionsrs E!"XY Yu//#FGFwzQAQTUVQWknopkqrFG  JJL  G  >qcBC  JJL    JJL sBABB 1B B C C*C +CC  CC*c[5nUR5nURSU45 UR5nUU(aUR 5 $$!U(aUR 5 ff=f)NzGSELECT COUNT(*) FROM CZE_BreakersOptions WHERE Item_breaker_options = ?)rrrfetchoner)itemrrresults r item_existsr #s_  D`cgbij"  JJL 4 JJL s 4AA3c\Sn[5nU(d [S5eUR5nURX!U45 UR 5 W(aUR5 gg![ an[ SU35 SnAN6SnAff=f!W(aUR5 ff=f))Actualiza un breaker en la base de datos.zZ UPDATE CZE_BreakersOptions SET price = ? WHERE Item_breaker_options = ? rz/[Error inesperado] Error actualizando breaker: Nrrrrcommitrrr)rr rrrrs rupdate_BreakersOptionsr%/s E !"XY Yudm,   JJL  E ?sCDDE  JJL *AA,, B6B B BBB+c[5nU(d [S5eUR5nURS5 UR 5nU(d/U(aUR 5 $$UVs/sH o3SUSS.PM snU(aUR 5 $$s snf![ a2n[SU35 /sSnAW(aUR 5 $$SnAff=f!W(aUR 5 ff=f)NrzDSELECT Item_breaker_options,TechnicalSheet from CZE_BreakersOptions rr)r r uN[Error inesperado] Error eliminando Catálogo de opciones de interruptores : r )rrrrrs r searchitemsr(Es!"XY Y]^//#  JJL  W^^V]sQ3q6JV]^  JJL  _  ^_`^abc  JJL    JJL sHAB(0B(4B#B(#B(( C$2CC$C'C$$C''Dc\Sn[5nU(d [S5eUR5nURX!U45 UR 5 W(aUR5 gg![ an[ SU35 SnAN6SnAff=f!W(aUR5 ff=f)r"zb UPDATE CZE_BreakersOptions SET TechnicalSheet = ? WHERE Item_breaker_options = ? ruM[Error inesperado] Error actualizando Catálogo de opciones de interruptores Nr#)rr rrrrs r%update_BreakersOptions_TechnicalSheetr*Xs E !"XY Yud34   JJL  c ]^_]`abbc  JJL r&N)Consultas_SQL.conexionrrr r%r(r*rr.s# 2: ,&r-