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) z5Obtiene catalogo de controles desde la base de datos.a SELECT CZE_ControllerCatalog.Item_controller, CZE_ControllerCatalog.description, CZE_ControllerCatalog.price, CZE_ControllerCatalog.BrandID, CZE_ControllerCatalog.TechnicalSheet FROM CZE_ControllerCatalog 4No se pudo establecer conexión con la base de datosr)Item_controller descriptionpriceBrandIDTechnicalSheetu<[Error inesperado] Error obteniendo Catálogo de controles: NrConnectionErrorcursorexecutefetchallclose Exceptionprint)queryconnrresultsrowes C:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\Consultas_SQL\Ventas\VentasEUA\DataMaster\DMControllerCatalogSQL.pyget_Catalogo_de_controlesrs E!"XY Yu//#MTUMTFIF3q6CPQF_bcd_ey|}~yAMTU  JJL  U  LQCPQ  JJL    JJL sBAB B5BB CC .C/C CCC.c[5nUR5nURSU45 UR5nUU(aUR 5 $$!U(aUR 5 ff=f)NzDSELECT COUNT(*) FROM CZE_ControllerCatalog WHERE Item_controller = ?)rrrfetchoner)itemrrresults r item_existsr"'s_  D]`d_fg"  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_ControllerCatalog (Item_controller, description, price, BrandID, TechnicalSheet) VALUES (?, ?, ?, ?, ?) rz-[Error inesperado] Error insertando breaker: Nrrrrcommitrrr) r r r typetechnicalSheetrrrrs rinsert_Catalogo_de_controlesr(2s E !"XY Yu[NO   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)z)Actualiza un breaker en la base de datos.zt UPDATE CZE_ControllerCatalog SET description = ?, price = ?, BrandID = ? WHERE Item_controller = ? ru?[Error inesperado] Error actualizando Catálogo de controles : Nr$)r r r r&rrrrs rupdate_Catalogo_de_controlesr+Gs E !"XY YuE>?   JJL  U OPQsSTTU  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.zI DELETE FROM CZE_ControllerCatalog WHERE Item_controller = ? rz0[Error inesperado] Error eliminando el Control: Nr$)r rrrrs rdelete_Catalogo_de_controlesr-\s E !"XY Yug&   JJL  F @DEEF  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)NrzASELECT Item_controller, TechnicalSheet from CZE_ControllerCatalogrr)r ru>[Error inesperado] Error consultando Catálogo de controles : r)rrrrrs r searchitemsr/ps!"XY YZ[//#  JJL  RYYQX#Fc!fEQXY  JJL  Z  NqcRS  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)u>Actualiza la ficha técnica de un breaker en la base de datos.z_ UPDATE CZE_ControllerCatalog SET TechnicalSheet = ? WHERE Item_controller = ? ru6[Error inesperado] Error actualizando ficha técnica: Nr$)r rrrrrs r+update_Catalogo_de_controles_TechnicalSheetr1s E !"XY Yut45   JJL  L FqcJKKL  JJL s*AA,, B6B B BBB+N) Consultas_SQL.conexionrrr"r(r+r-r/r1rr5s-2> **(&r4