python /home/admin/mtr/script_for_cron.py -j default -m 30 -a 'python3 ~/workarea/git/Velours/python/mtr/sql_queries.py -j status ' -s monitor_queries -M 0 -S 0 -U 120,120,120
 import MySQLdb succeeded 
Now: 18/05/2025, 00:01:26

Nombre de datou current
('date', 'nombre de datou current')
('2025-05-18 00:01:26', 602)

Nombre total de photos traitees dans les dernieres 24 heures
('date', 'total de photos traitees')
('2025-05-18 00:01:26', 251051)

Nombre total de photos restant a traiter non commence
('date', 'Nombre total de photos restant a traiter non commence')
('2025-05-18 00:03:13', 93650)

Nombre total de photos restant a traiter
('date', 'Nombre total de photos restant a traiter')
('2025-05-18 00:03:13', 8082)

Reste a faire par datou id
('date', 'datou_id', 'total_a_traiter', 'total_traite', 'restant_a_traite', 'datou_nom', 'temps moyens passe des datous a traiter (heures)', 'list_port_ids_mtr_user_ids')
('2025-05-18 00:04:13', 4219, 4632, 1935, 2697, 'detection_plaque_valcor_010622', 78.5, '22946849:plaque_val:1064:0,22991983:plaque_val:1064:0', 2)
('2025-05-18 00:04:13', 4310, 44971, 42456, 2515, 'classifieur_2camions_valcor_021122_v1', 124.0, '22855226:dechet_val:991:0,22866163:dechet_val:991:0,22869338:dechet_val:991:0,22906008:dechet_val:991:0,22945684:dechet_val:991:0,23043211:dechet_val:991:0', 6)
('2025-05-18 00:04:13', 4892, 13776, 12859, 917, 'multi_classification_tapis_dechet', 44.5, '23034666:angers_mon:1017:0,23049137:sevran_122:1042:0', 2)
('2025-05-18 00:04:13', 4234, 818, 402, 416, 'refus_rym_velours_valcor', 34.666666666666664, '23004716:truck_diff:991:0,23065692:truck_diff:991:0,23065694:truck_diff:991:1,23065699:truck_diff:991:0,23071817:truck_diff:991:0,23071890:truck_diff:991:0,23073202:truck_diff:991:0,23073209:truck_diff:991:1,23077627:truck_diff:991:0', 9)
('2025-05-18 00:04:13', 3459, 1493, 1100, 393, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 54.63265306122449, '22886792:jrm_diff_b:1017:0,22889072:JRM_diff_b:979:0,22894226:JRM_diff_b:979:0,22915102:jrm_diff_b:1042:0,22923045:JRM_diff_b:979:0,22955402:JRM_diff_b:979:0,22955444:JRM_diff_b:979:0,22955733:jrm_diff_b:1017:0,22967636:JRM_diff_b:979:0,22969172:JRM_diff_b:979:0,22988986:jrm_diff_b:1042:0,22989016:jrm_diff_b:1042:0,23003826:jrm_diff_b:1017:0,23010986:jrm_diff_b:1017:0,23012442:jrm_diff_b:1017:0,23021844:jrm_diff_b:1042:0,23021873:jrm_diff_b:1042:0,23027510:JRM_diff_b:979:0,23027530:JRM_diff_b:979:0,23027551:JRM_diff_b:979:0,23027553:JRM_diff_b:979:0,23027556:JRM_diff_b:979:0,23027557:JRM_diff_b:979:0,23030032:JRM_diff_b:979:0,23030048:JRM_diff_b:979:0,23031327:JRM_diff_b:979:0,23052744:jrm_diff_b:1017:0,23055009:JRM_diff_b:979:0,23055011:JRM_diff_b:979:0,23055016:JRM_diff_b:979:0,23055018:JRM_diff_b:979:0,23055020:JRM_diff_b:979:0,23055022:JRM_diff_b:979:0,23056933:JRM_diff_b:979:0,23056935:JRM_diff_b:979:0,23056937:JRM_diff_b:979:0,23057979:JRM_diff_b:979:0,23057981:JRM_diff_b:979:0,23062706:JRM_diff_b:979:0', 49)
('2025-05-18 00:04:13', 4433, 404, 150, 254, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 56.8, '22967391:JRM_diff_b:1053:0,23004700:JRM_diff_b:1053:0,23012282:JRM_diff_b:1053:0,23012284:JRM_diff_b:1053:0,23070248:JRM_diff_b:1053:0', 5)
('2025-05-18 00:04:13', 3804, 438, 225, 213, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 45.285714285714285, '23012449:pet_clair_:1017:0,23021841:pet_clair_:1042:0,23025692:pet_clair_:1017:0,23035125:pet_clair_:1042:0,23052752:pet_clair_:1017:0,23056328:pet_clair_:1017:0,23062408:pet_clair_:1017:0', 7)
('2025-05-18 00:04:13', 3993, 654, 460, 194, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 45.46666666666667, '22988942:pcnc_diff_:1042:0,22989030:pcnc_diff_:1042:0,23021846:emr_diff_b:1042:0,23021847:pcnc_diff_:1042:0,23035121:pcnc_diff_:1042:0,23035122:pcnc_diff_:1042:0,23035132:pcnc_diff_:1042:0,23035142:pcnc_diff_:1042:0,23052742:emr_diff_b:1017:0,23052748:emr_diff_b:1017:0,23055816:pcnc_diff_:1042:0,23056314:emr_diff_b:1017:0,23062407:emr_diff_b:1017:0,23063139:pcnc_diff_:1042:0,23071979:emr_diff_b:1017:0', 15)
('2025-05-18 00:04:13', 4877, 208, 62, 146, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 39.0, '23034441:JRM_diff_b:979:0,22970336:JRM_diff_b:979:0,23004292:JRM_diff_b:979:0,23021706:JRM_diff_b:979:0', 4)
('2025-05-18 00:04:13', 3996, 455, 320, 135, 'RUBBIA_Refus_add_surclassifier_rapport', 39.625, '23024221:refus_diff:983:0,23034808:refus_diff:983:0,23051560:refus_diff:983:0,23052806:refus_diff:983:0,23052807:refus_diff:983:0,23056886:refus_diff:983:0,23072040:refus_diff:983:0,23072043:refus_diff:983:1', 8)
('2025-05-18 00:04:13', 4153, 233, 140, 93, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 33.142857142857146, '23063140:flux_dev_d:1042:0,22997190:flux_dev_d:1017:0,23003835:flux_dev_d:1017:0,23000838:flux_dev_d:1017:0,23052746:flux_dev_d:1017:0,23058882:flux_dev_d:1017:0,23062409:flux_dev_d:1017:0', 7)
('2025-05-18 00:04:13', 533, 17400, 17348, 52, 'multi_classification_tapis_dechet', 62.5, '22899559:aec_metal_:979:0,22962323:jetson_tes:979:0,23084261:aec_metal_:979:0,23084284:jetson_new:983:0', 4)
('2025-05-18 00:04:13', 4926, 128, 80, 48, 'RUBBIA_fluxdev_angers_280325', 39.75, '23024270:flux_dev_d:1017:0,23056323:flux_dev_d:1017:0,23058882:flux_dev_d:1017:0,23062409:flux_dev_d:1017:0', 4)
('2025-05-18 00:04:13', 3991, 34, 20, 14, 'RUBBIA_ELA_131221_add_surclassifier_rapport', 37.0, '23056326:ela_diff_b:1017:0', 1)
('2025-05-18 00:04:13', 4322, 23, 20, 3, 'RUBBIA_filmPE_151122', 28.0, '23079411:film_pedb_:1017:0', 1)
('2025-05-18 00:04:13', 4748, 23, 20, 3, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 48.0, '23034672:flux_dev_r:979:0', 1)
('2025-05-18 00:04:13', 3995, 21, 20, 1, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', 33.0, '23052719:pehd_pp_di:1017:0', 1)

Reste a faire par datou id non traite
('date', 'datou_id', 'total_a_traiter', 'datou_nom', 'temps moyens passe des datous a traiter (heures)', 'list_port_ids_mtr_user_ids', 'nb_port')
('2025-05-18 00:04:21', 370, 25, 'proportion_papier_qualite_dechets_tri', Decimal('5.6000'), '13545772:papier_dif:739:0,13545779:papier_dif:739:0,13545783:papier_dif:739:0,13545787:papier_dif:739:0', 4)
('2025-05-18 00:04:21', 533, 18, 'multi_classification_tapis_dechet', Decimal('0.0000'), '23093869:aec_metal_:979:0', 1)
('2025-05-18 00:04:21', 3142, 1124, 'STS_refus_Amiens', Decimal('0.0000'), '23084284:jetson_new:983:0', 1)
('2025-05-18 00:04:21', 3385, 782, 'split_time_score_JRM_Arc_En_Ciel_peu_dense', Decimal('0.0000'), '23086561:arc_en_cie:979:0', 1)
('2025-05-18 00:04:21', 3459, 1186, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('17.5514'), '23073354:jrm_diff_b:1017:0,23074306:JRM_diff_b:979:0,23075513:jrm_diff_b:1017:0,23077270:jrm_diff_b:1042:0,23077275:jrm_diff_b:1042:0,23077279:jrm_diff_b:1042:0,23079432:jrm_diff_b:1017:0,23080595:JRM_diff_b:979:0,23080598:JRM_diff_b:979:0,23080600:JRM_diff_b:979:0,23080708:JRM_diff_b:979:0,23080716:JRM_diff_b:979:0,23080729:JRM_diff_b:979:0,23080730:JRM_diff_b:979:0,23080731:JRM_diff_b:979:0,23081203:JRM_diff_b:979:0,23081489:JRM_diff_b:979:0,23082890:jrm_diff_b:1042:0,23082941:JRM_diff_b:979:0,23084349:jrm_diff_b:1042:0,23087498:JRM_diff_b:979:0,23087500:JRM_diff_b:979:0,23087501:JRM_diff_b:979:0,23088011:JRM_diff_b:979:0,23088013:JRM_diff_b:979:0,23088015:JRM_diff_b:979:0,23088017:JRM_diff_b:979:0,23088020:JRM_diff_b:979:0,23088022:JRM_diff_b:979:0,23088024:JRM_diff_b:979:0,23088026:JRM_diff_b:979:0,23088282:JRM_diff_b:979:0,23088283:JRM_diff_b:979:0,23088602:JRM_diff_b:979:0,23088819:JRM_diff_b:979:0,23088821:JRM_diff_b:979:0,23089905:JRM_diff_b:979:0,23089907:JRM_diff_b:979:0,23089909:JRM_diff_b:979:0,23', 49)
('2025-05-18 00:04:21', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('1124.0000'), '4453926:jrm_diff_b:739:0,4652336:jrm_diff_b:739:0,4756245:jrm_diff_b:739:0,4938484:jrm_diff_b:739:0,4938485:jrm_diff_b:739:0,4938486:jrm_diff_b:739:0,4938487:jrm_diff_b:739:0,4938488:jrm_diff_b:739:0', 8)
('2025-05-18 00:04:21', 3804, 376, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', Decimal('24.2606'), '23073350:pet_clair_:1017:0,23075514:pet_clair_:1017:0,23077254:pet_clair_:1042:0,23079397:pet_clair_:1017:0,23079425:pet_clair_:1017:0,23080631:pet_clair_:1017:0,23080633:pet_clair_:1017:0,23082838:pet_clair_:1017:0,23082888:pet_clair_:1042:0,23086572:pet_clair_:979:0,23086580:pet_clair_:979:0,23086584:pet_clair_:979:0,23087198:pet_clair_:979:0,23087920:pet_clair_:979:0,23087938:pet_clair_:979:0,23087944:pet_clair_:979:0,23092229:pet_clair_:979:0', 17)
('2025-05-18 00:04:21', 3991, 73, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('23.9589'), '23077282:ela_diff_b:1042:0,23080635:ela_diff_b:1017:0,23086576:ela_diff_b:979:0,23087916:ela_diff_b:979:0', 4)
('2025-05-18 00:04:21', 3992, 17, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('16.9412'), '23073876:aluminium_:979:0,23087200:aluminium_:979:0,23087936:aluminium_:979:0,23090272:aluminium_:979:0', 4)
('2025-05-18 00:04:21', 3993, 709, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('24.8575'), '23073356:emr_diff_b:1017:0,23075516:emr_diff_b:1017:0,23077256:pcnc_diff_:1042:0,23077258:pcnc_diff_:1042:0,23077265:pcnc_diff_:1042:0,23077267:emr_diff_b:1042:0,23077268:pcnc_diff_:1042:0,23077271:pcnc_diff_:1042:0,23077273:pcnc_diff_:1042:0,23077276:pcnc_diff_:1042:0,23077281:pcnc_diff_:1042:0,23079395:emr_diff_b:1017:0,23079430:emr_diff_b:1017:0,23079434:emr_diff_b:1017:0,23082840:emr_diff_b:1017:0,23082885:pcnc_diff_:1042:0,23082886:pcnc_diff_:1042:0,23082896:pcnc_diff_:1042:0,23082898:pcnc_diff_:1042:0,23082901:pcnc_diff_:1042:0,23084345:pcnc_diff_:1042:0,23084346:pcnc_diff_:1042:0,23084347:emr_diff_b:1042:0,23086573:emr_diff_b:979:0,23086579:emr_diff_b:979:0,23086583:emr_diff_b:979:0,23087197:emr_diff_b:979:0,23087201:emr_diff_b:979:0,23087915:emr_diff_b:979:0,23087917:gros_carto:979:0,23087923:emr_diff_b:979:0,23087929:emr_diff_b:979:0,23087932:emr_diff_b:979:0,23087935:emr_diff_b:979:0,23092789:emr_diff_b:979:0', 35)
('2025-05-18 00:04:21', 3994, 9, 'RUBBIA_proportion_papier_add_surclassifier_rapport', Decimal('26.0000'), '23082893:pcm_diff_b:1042:0', 1)
('2025-05-18 00:04:21', 3995, 102, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', Decimal('13.9706'), '23086574:pehd_pp_di:979:0,23086581:pehd_pp_di:979:0,23086586:pehd_pp_di:979:0,23087919:pehd_pp_di:979:0,23087921:pehd_pp_di:979:0,23087931:pehd_pp_di:979:0,23087942:pehd_pp_di:979:0,23090324:pehd_pp_di:979:0', 8)
('2025-05-18 00:04:21', 3996, 1331, 'RUBBIA_Refus_add_surclassifier_rapport', Decimal('14.5071'), '23074782:refus_diff:983:0,23074784:refus_diff:983:0,23080649:refus_diff:983:0,23080650:refus_diff:983:0,23083526:refus_diff:983:0,23084285:refus_diff:983:0,23086463:refus_diff:983:0,23086607:refus_diff:983:0,23086610:refus_diff:983:0,23086612:refus_diff:983:0,23086614:refus_diff:983:0,23086615:refus_diff:983:0,23087148:refus_diff:983:0,23087407:refus_diff:983:0,23087747:refus_diff:983:0,23087748:refus_diff:983:0,23088271:refus_diff:983:0,23088564:refus_diff:983:0,23089895:refus_diff:983:0,23089896:refus_diff:983:0,23090130:refus_diff:983:0,23090474:refus_diff:983:0,23091762:refus_diff:983:0,23091763:refus_diff:983:0,23091764:refus_diff:983:0,23091947:refus_diff:983:0,23092325:refus_diff:983:0,23092775:refus_diff:983:0,23093459:refus_diff:983:0,23093460:refus_diff:983:0', 30)
('2025-05-18 00:04:21', 4153, 17, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('28.0000'), '23079398:flux_dev_d:1017:0,23079429:flux_dev_d:1017:0,23080632:flux_dev_d:1017:0', 3)
('2025-05-18 00:04:21', 4219, 779, 'detection_plaque_valcor_010622', Decimal('23.0000'), '23084592:plaque_val:1064:0', 1)
('2025-05-18 00:04:21', 4220, 6260, 'split_time_score_plaque_Valcor', Decimal('13.6460'), '22991983:plaque_val:1064:0,23035025:plaque_val:1064:0,23084592:plaque_val:1064:0', 3)
('2025-05-18 00:04:21', 4234, 864, 'refus_rym_velours_valcor', Decimal('24.2940'), '23073211:truck_diff:991:0,23076669:truck_diff:991:0,23076670:truck_diff:991:0,23076672:truck_diff:991:0,23076673:truck_diff:991:0,23076675:truck_diff:991:0,23076685:truck_diff:991:0,23076695:truck_diff:991:0,23076697:truck_diff:991:0,23076698:truck_diff:991:0,23076713:truck_diff:991:0,23076719:truck_diff:991:0,23076720:truck_diff:991:0,23076721:truck_diff:991:0,23082660:truck_diff:991:0,23082661:truck_diff:991:0,23082663:truck_diff:991:0,23082664:truck_diff:991:0,23082666:truck_diff:991:0,23082667:truck_diff:991:0,23082668:truck_diff:991:0,23082670:truck_diff:991:0,23082671:truck_diff:991:0,23082673:truck_diff:991:0,23082674:truck_diff:991:0,23082676:truck_diff:991:0,23082677:truck_diff:991:0,23082678:truck_diff:991:0,23082680:truck_diff:991:0,23082681:truck_diff:991:0,23082683:truck_diff:991:0,23082684:truck_diff:991:0,23082686:truck_diff:991:0,23082687:truck_diff:991:0,23082688:truck_diff:991:0,23082690:truck_diff:991:0,23082691:truck_diff:991:0,23082693:truck_diff:991:0,23082694:truck_diff:991:0,23082696:t', 194)
('2025-05-18 00:04:21', 4310, 7224, 'classifieur_2camions_valcor_021122_v1', Decimal('20.0000'), '23085962:dechet_val:991:0', 1)
('2025-05-18 00:04:21', 4322, 317, 'RUBBIA_filmPE_151122', Decimal('18.3817'), '23082883:film_pedb_:1042:0,23082892:film_pedb_:1042:0,23082903:film_pedb_:1042:0,23084348:film_pedb_:1042:0,23086570:film_pedb_:979:0,23086575:film_pedb_:979:0,23086577:film_pedb_:979:0,23086582:film_pedb_:979:0,23087203:film_pedb_:979:0,23087914:film_pedb_:979:0,23087925:film_pedb_:979:0,23092289:film_pedb_:979:0', 12)
('2025-05-18 00:04:21', 4433, 226, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('15.0000'), '23087224:JRM_diff_b:1053:0,23087234:JRM_diff_b:1053:0,23087278:JRM_diff_b:1053:0,23087342:JRM_diff_b:1053:0', 4)
('2025-05-18 00:04:21', 4748, 96, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('13.5833'), '23086571:flux_dev_r:979:0,23086578:flux_dev_r:979:0,23086585:flux_dev_r:979:0,23087199:flux_dev_r:979:0,23087918:flux_dev_r:979:0,23087922:flux_dev_r:979:0,23087940:flux_dev_r:979:0,23090413:flux_dev_r:979:0', 8)
('2025-05-18 00:04:21', 4849, 80, 'split_time_score_SCCU_6', Decimal('3.0000'), '23084692:SCCU_17052:1103:0', 1)
('2025-05-18 00:04:21', 4850, 64, 'split_time_score_SCCU_7', Decimal('3.0000'), '23084693:SCCU_17052:1103:0', 1)
('2025-05-18 00:04:21', 4851, 56, 'split_time_score_SCCU_8', Decimal('3.0000'), '23084694:SCCU_17052:1103:0', 1)
('2025-05-18 00:04:21', 4877, 45, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('19.2000'), '23059524:JRM_diff_b:979:0,23084200:JRM_diff_b:979:0,23084202:JRM_diff_b:979:0,23084203:JRM_diff_b:979:0,23084204:JRM_diff_b:979:0', 5)
('2025-05-18 00:04:21', 4878, 4263, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('16.7408'), '23034647:arc_en_cie:979:0,23084262:arc_en_cie:979:0', 2)
('2025-05-18 00:04:21', 4887, 1193, 'split_time_score_Sevran_test', Decimal('1.0000'), '23085257:sevran_122:1042:0', 1)
('2025-05-18 00:04:21', 4892, 1293, 'multi_classification_tapis_dechet', Decimal('22.0773'), '23084507:angers_mon:1017:0,23085257:sevran_122:1042:0', 2)
('2025-05-18 00:04:21', 4916, 53586, 'split_time_score_Acier_Arc_En_Ciel', Decimal('13.4390'), '22806757:aec_metal_:979:0,22848639:aec_metal_:979:0,22866006:aec_metal_:979:0,22867180:aec_metal_:979:0,22986467:aec_metal_:979:0,23034673:aec_metal_:979:0,23084261:aec_metal_:979:0', 7)
('2025-05-18 00:04:21', 4934, 4263, 'split_time_score_JRM_Arc_En_Ciel_test_load_1hour', Decimal('23.6341'), '23034647:arc_en_cie:979:0,23084262:arc_en_cie:979:0', 2)

Nombre de photos d'entrees traites par datou dans les dernieres 24 heures pour les traitement (datou_current) en cours
('date', 'datou_id', 'Nombre de photos traitees', 'datou_nom')
('2025-05-18 00:04:21', 3459, 5460, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-05-18 00:04:21', 533, 21800, 'multi_classification_tapis_dechet')
('2025-05-18 00:04:21', 4433, 540, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-05-18 00:04:21', 4877, 480, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-05-18 00:04:21', 3993, 2400, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-05-18 00:04:21', 4153, 1120, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-05-18 00:04:21', 4234, 711, 'refus_rym_velours_valcor')
('2025-05-18 00:04:21', 3804, 800, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-05-18 00:04:21', 4748, 160, 'RUBBIA_PET_Fonce_add_surclassifier