i:SSKJr SrSrSrSrSrSrSrg ) )get_connectionc Sn[5nU(d [S5eUR5nURU5 UR 5nUVs/sHoDSUSUSUSUSS.PM snU(aUR 5 $$s snf![ a2n[S U35 /sS nAW(aUR 5 $$S nAff=f!W(aUR 5 ff=f) z,Obtiene los Breakers desde la base de datos.z SELECT CZE_BreakersCatalog.Item_breaker, CZE_BreakersCatalog.description, CZE_BreakersCatalog.price, CZE_BreakersCatalog.type, CZE_BreakersCatalog.TechnicalSheet FROM CZE_BreakersCatalog 4No se pudo establecer conexión con la base de datosr) Item_breaker descriptionpricetypeTechnicalSheetz.[Error inesperado] Error obteniendo breakers: NrConnectionErrorcursorexecutefetchallclose Exceptionprint)queryconnrresultsrowes vC:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\Consultas_SQL\Ventas\VentasEUA\DataMaster\DMbreakersSQL.py get_breakersrs E!"XY Yu//#GNOGN@CQAQY\]^Y_svwxsyzGNO  JJL  O  >qcBC  JJL    JJL sBAB B5BB CC .C/C CCC.c[5nUR5nURSU45 UR5nUU(aUR 5 $$!U(aUR 5 ff=f)Nz?SELECT COUNT(*) FROM CZE_BreakersCatalog WHERE Item_breaker = ?)rrrfetchoner)itemrrresults r item_existsr"$s_  DX[_Zab"  JJL 4 JJL s 4AA3c^Sn[5nU(d [S5eUR5nURXPXX445 UR 5 W(aUR5 gg![ an[ SU35 SnAN6SnAff=f!W(aUR5 ff=f)z-Inserta un nuevo breaker en la base de datos.z INSERT INTO CZE_BreakersCatalog (Item_breaker, description, price, type,TechnicalSheet) VALUES (?, ?, ?, ?,?) rz-[Error inesperado] Error insertando breaker: Nrrrrcommitrrr) r r r r technicalSheetrrrrs rinsert_breakerr'/s E !"XY Yu[MN   JJL  C =aSABBC  JJL *AA-- B7B B BBB,c^Sn[5nU(d [S5eUR5nURXAX#U45 UR 5 W(aUR5 gg![ an[ SU35 SnAN6SnAff=f!W(aUR5 ff=f))Actualiza un breaker en la base de datos.zl UPDATE CZE_BreakersCatalog SET description = ?, price = ?, type = ? WHERE Item_breaker = ? r/[Error inesperado] Error actualizando breaker: Nr$)r r r r rrrrs rupdate_breakerr,Fs E !"XY YuE>?   JJL  E ?sCDDE  JJL r(cZSn[5nU(d [S5eUR5nURX45 UR 5 W(aUR5 gg![ an[ SU35 SnAN6SnAff=f!W(aUR5 ff=f)z'Elimina un breaker de la base de datos.zD DELETE FROM CZE_BreakersCatalog WHERE Item_breaker = ? rz-[Error inesperado] Error eliminando breaker: Nr$)r rrrrs rdelete_breakerr.[s E !"XY Yug&   JJL  C =aSABBC  JJL s*AA++ B 5BBB  BB*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)Nrz