
    i|                         S SK r S SKrS SKJr  S SKJrJrJrJr  S SKJ	r	J
r
  S SKJr  \R                  " S5      rS\\\      4S jrg)	    N)datetime)DictListOptionalUnion)
ProductivoENVIRONMENT)get_connectionclientes_score_sqlreturnc                     Sn Sn [        5       nU(       d  [        S5      eU   UR                  5       nUR                  U 5        UR                   Vs/ s H  o3S   PM	     nnUR                  5       nU(       a  / nU HW  n[        [        XG5      5      nS H)  n	X;   d  M
  X   (       d  M  X   R                  5       X'   M+     UR                  U5        MY     [        R                  S[        U5       S35        UsSSS5        U(       a   UR                  5         $ $ [        R                  S	5         SSS5        U(       a   UR                  5         ggs  snf ! [         a    [        R                  S5         $ f = f! [         a    [        R                  S5         gf = f! , (       d  f       O= f! [         R"                   a3  n
S
[%        U
5       3n[        R'                  U5        [        U5      eSn
A
f[         a3  n
S[%        U
5       3n[        R'                  U5        [        U5      eSn
A
f[         a3  n
S[%        U
5       3n[        R'                  U5        [        U5      eSn
A
ff = f U(       a7   UR                  5         g! [         a    [        R                  S5         gf = fg! U(       a7   UR                  5         f ! [         a    [        R                  S5         f f = ff = f)z4
Buscar los registros de score en la base de datos.
u6  
        SELECT 
            Score.[OrderNum&Line] AS ordernumandline,
            Score.OrderNum, Score.Capacidad,
            Score.Voltaje, Score.Tipo, 
            Score.Caseta, Score.JobNum2,
            Score.FechaProducción,
            Score.FechaMat, Score.AvanceDeSurtimiento,
            Score.AvisoDeTerminacion, Score.MaterialFaltante,
            Score.PartNum_M, Score.Description_M,
            Score.RefCategory_M, 
            Score.NoSerie_M, Score.Faltante_M,
            Score.En_PO_Altern_M, Score.Estatus_M,
            Score.Fecha_Llegada_M, Score.PartNum_G,
            Score.Description_G, 
            Score.NoSerie_G,
            Score.Faltante_G, Score.En_PO_Altern_G,
            Score.Estatus_G, Score.Fecha_Llegada_G
        FROM 
            Score 
        WHERE
            Score.OrderNum IN (
            '126309', '126308', '126307', '126306', '126305', '126304', '126303', '126302', '126301', '126300',
            '126299', '126298', '126297', '126296', '126295', '126294', '126293', '126292', '126291', '126290',
            '126289', '126288', '126287', '126286', '126285', '126284', '126283', '126282', '126281', '126280',
            '126279', '126278', '126277', '126276', '126275', '126274', '126273', '126272', '126271', '126270',
            '126269', '126268', '126267', '126266', '126265', '126264', '126263', '126262', '126261', '126260',
            '126259', '126258', '126257', '126256', '126255', '126254', '126253', '126252', '126251', '126250',
            '126249', '126248', '126247', '126246', '126245', '126244'
        )
        Nu4   No se pudo establecer conexión con la base de datosr   )	CreatedAt	UpdatedAtzSe encontraron z registros de scoreu#   Error al cerrar la conexión ala BDz-No se encontraron registros en la tabla Scorez-Error de base de datos al buscar los scores: u)   Error de conexión al buscar los scores: z'Error inesperado al buscar los scores: )r
   ConnectionErrorcursorexecutedescriptionfetchalldictzip	isoformatappendloggerinfolenclose	ExceptionwarningpyodbcErrorstrerror)queryconnr   columncolumnsrowsresultsrowresult
date_fielde	error_msgs               ڂC:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\Consultas_SQL\Clientes\NetworkEnvironment\ScoreNetworkEnvironmentQL.pybuscar_score_viewr/      s   E@ D7F!"XYY[[]FNN5! 06/A/AB/AVay/AGB ??$DC!#g"34F 'A
%/F4F4F171C1M1M1OF. 'A NN6*   oc'l^;NOP/ TZ F

 ' NO7 Z F

 Q CV  FDEF9 FDEFa T8 << #CCF8L	Y	"" #?AxH	Y	"" #=c!fXF	Y	""#M Z F

 FDEF 4F

 FDEF s   F8 0F'E"<F'"F'-AF'=	F8 E F'6F8 F F'E?>E?F$#F$'
F51F8 4J8 5F8 8I5.G::I5.H55I5.I00I55J8 J J43J48K8KK8K41K83K44K8)r   loggingr   typingr   r   r   r   configr   r	   Consultas_SQL.conexionr
   	getLoggerr   r/        r.   <module>r7      sH       . . * 1 
		/	0]F8DJ/ ]Fr6   