a Yi~@s>ddlZddlZddlmZeddZddZddZdS) N) load_dotenvc Cs<tjjtddtdtdtdttdddS) NZ MYSQL_HOSTZ localhostZ MYSQL_USERZMYSQL_PASSWORDZMYSQL_DATABASEZ MYSQL_PORTZ3306)hostuserpassworddatabaseport)mysqlZ connectorconnectosgetenvintr r /home/Claro/claro/database.pyconectars rcCs||stddSt}|}|dtdd}dd|D}||||td|jd||dS) Nz$Sin resultados para guardar en MySQLzTRUNCATE TABLE sims_ClarozTabla sims_Claro truncadaz INSERT INTO sims_Claro (fecha, linea, titulo, porcentaje, detalle, restante, total, unidad, renovacion) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s) c SsFg|]>}|d|d|d|d|d|d|d|d|df qS) fechalineatituloporcentaje_usadodetalleusadototalunidad renovacionr .0rr r r !s z$guardar_en_mysql..zMySQL: z registros insertados)printrcursorexecuteZ executemanycommitrowcountclose) resultadosconnrZsqlZ registrosr r rguardar_en_mysqls    r%c Cs|stddSt}|jdd}|jdd}|}ttdd|D}|D]t}td|d|d|f|}||std |d qP|}|d } td |d | | dkrtd| d|d|ftd|jd| |d|f|} || s2td |dqP| d } td| | dkrt|d|ftd|jdn |d|ftd|jd| qP|d|ftd|jd| qP| | | | dS)NzSin resultados para verificarT)Z dictionarycss|]}|dVqdS)rNr rr r r @z.verificar_y_actualizar_sims..z Verificando linea z...z SELECT restante FROM sims_Claro WHERE titulo = 'Llamadas a destinos Claro' AND linea = %s z Linea z no encontrada en sims_Clarorestantez sim_cid=z | restante Claro= z ALERTA Claro: restante=z" <= 10, desactivando campaign 1...z UPDATE campaign_cid_numbers SET active_cid = 0 WHERE sim_cid = %s AND campaign = 1 AND active_cid = 1 z campaign_cid_numbers: z! filas (active_cid=0, campaign=1)u SELECT restante FROM sims_Claro WHERE titulo = 'Llamadas a otras compañías' AND linea = %s z sin datos de otras companiasz restante otras=z UPDATE campaign_cid_numbers SET active_cid = 0 WHERE sim_cid = %s AND campaign = 8 AND active_cid = 1 z! filas (active_cid=0, campaign=8)z UPDATE campaign_cid_numbers SET active_cid = 1 WHERE sim_cid = %s AND campaign = 8 AND active_cid = 0 z! filas (active_cid=1, campaign=8)z UPDATE campaign_cid_numbers SET active_cid = 0 WHERE sim_cid = %s AND campaign = 8 AND active_cid = 1 ) rrrlistsetrZfetchoneZfetchallr!r r") r#r$rZ cursor_otrasZ cursor_updatelineasrZsimZsim_cidr(Z sim_directoZrestante_otrasr r rverificar_y_actualizar_sims6sr       r.)r Zmysql.connectorrdotenvrrr%r.r r r rs   %