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: 30/05/2025, 07:00:27

Nombre de datou current
('date', 'nombre de datou current')
('2025-05-30 07:00:27', 1276)

Nombre total de photos traitees dans les dernieres 24 heures
('date', 'total de photos traitees')
('2025-05-30 07:00:27', 463288)

Nombre total de photos restant a traiter non commence
('date', 'Nombre total de photos restant a traiter non commence')
('2025-05-30 07:01:34', 76938)

Nombre total de photos restant a traiter
('date', 'Nombre total de photos restant a traiter')
('2025-05-30 07:01:34', 54250)

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-30 07:02:22', 533, 113092, 75741, 37351, 'multi_classification_tapis_dechet', 38.09090909090909, '23315442:aec_metal_:979:1,22806757:aec_metal_:979:1,22792232:aec_metal_:979:1,22740043:aec_metal_:979:0,22711925:aec_metal_:979:1,22636503:aec_metal_:979:0,22597137:aec_metal_:979:0,23429777:aec_metal_:979:1,23438362:arc_en_cie:979:0,23443974:aec_metal_:979:1,23444013:jetson_new:983:1', 11)
('2025-05-30 07:02:22', 4219, 17499, 5810, 11689, 'detection_plaque_valcor_010622', 64.83333333333333, '23315443:plaque_val:1064:0,23320447:plaque_val:1064:0,23361739:plaque_val:1064:0,23397381:plaque_val:1064:0,23430027:plaque_val:1064:0,23444051:plaque_val:1064:0', 6)
('2025-05-30 07:02:22', 3459, 4477, 2320, 2157, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 120.43103448275862, '23157384:JRM_diff_b:979:0,23206173:JRM_diff_b:979:0,23207322:JRM_diff_b:979:0,23208388:JRM_diff_b:979:0,23213206:JRM_diff_b:979:0,23213535:jrm_diff_b:1017:0,23213951:JRM_diff_b:979:0,23217324:JRM_diff_b:979:0,23269764:JRM_diff_b:979:0,23270075:JRM_diff_b:979:0,23270077:JRM_diff_b:979:0,23270079:JRM_diff_b:979:0,23270495:JRM_diff_b:979:0,23270497:JRM_diff_b:979:0,23270788:JRM_diff_b:979:0,23270792:JRM_diff_b:979:0,23271206:JRM_diff_b:979:0,23271559:JRM_diff_b:979:0,23271967:JRM_diff_b:979:0,23272720:JRM_diff_b:979:0,23274323:JRM_diff_b:979:0,23274642:JRM_diff_b:979:0,23275089:JRM_diff_b:979:0,23275526:JRM_diff_b:979:0,23276170:JRM_diff_b:979:0,23277888:JRM_diff_b:979:0,23278903:JRM_diff_b:979:0,23279949:JRM_diff_b:979:0,23279954:JRM_diff_b:979:0,23279957:jrm_diff_b:1017:0,23281171:JRM_diff_b:979:0,23281478:JRM_diff_b:979:0,23289002:arc_en_cie:979:0,23289507:JRM_diff_b:979:0,23289827:JRM_diff_b:979:0,23290111:JRM_diff_b:979:0,23290350:JRM_diff_b:979:0,23290554:JRM_diff_b:979:0,23291104:JRM_diff_b:979:0,23291106', 116)
('2025-05-30 07:02:22', 4433, 2771, 1200, 1571, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 195.89473684210526, '23004700:JRM_diff_b:1053:0,23012282:JRM_diff_b:1053:0,23064248:JRM_diff_b:1053:0,23087224:JRM_diff_b:1053:0,23087342:JRM_diff_b:1053:0,23103831:JRM_diff_b:1053:0,23116388:JRM_diff_b:1053:0,23120591:JRM_diff_b:1053:0,23166364:JRM_diff_b:1053:0,23169752:JRM_diff_b:1053:0,23171827:JRM_diff_b:1053:0,23196715:JRM_diff_b:1053:0,23197257:JRM_diff_b:1053:0,23197259:JRM_diff_b:1053:0,23197262:JRM_diff_b:1053:0,23199899:JRM_diff_b:1053:0,23207880:JRM_diff_b:1053:0,23209248:JRM_diff_b:1053:0,23213343:JRM_diff_b:1053:0,23235550:JRM_diff_b:1053:0,23255795:JRM_diff_b:1053:0,23262463:JRM_diff_b:1053:1,23266176:JRM_diff_b:1053:0,23268156:JRM_diff_b:1053:0,23295591:JRM_diff_b:1053:0,23298687:JRM_diff_b:1053:0,23300546:JRM_diff_b:1053:0,23301330:JRM_diff_b:1053:0,23302234:JRM_diff_b:1053:0,23303128:JRM_diff_b:1053:0,23303130:JRM_diff_b:1053:0,23303769:JRM_diff_b:1053:0,23330944:JRM_diff_b:1053:0,23336567:JRM_diff_b:1053:0,23340391:JRM_diff_b:1053:0,23379394:JRM_diff_b:1053:0,23408777:JRM_diff_b:1053:0,23437546:JRM_diff_b:1053:', 38)
('2025-05-30 07:02:22', 3804, 938, 425, 513, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 123.6, '23231812:pet_clair_:1042:0,23231863:pet_clair_:1042:0,23259325:pet_clair_:1042:0,23261829:pet_clair_:1017:1,23279943:pet_clair_:1017:0,23301441:pet_clair_:979:0,23331057:pet_clair_:1017:0,23331098:pet_clair_:1017:0,23332463:pet_clair_:1042:0,23339069:pet_clair_:1017:0,23358112:pet_clair_:1017:0,23358656:pet_clair_:1042:0,23358692:pet_clair_:1042:0,23366971:pet_clair_:1017:0,23370225:pet_clair_:1017:0', 15)
('2025-05-30 07:02:22', 4892, 8593, 8172, 421, 'multi_classification_tapis_dechet', 15.5, '23436764:sevran_122:1042:0,23443972:angers_mon:1017:0', 2)
('2025-05-30 07:02:22', 3993, 1028, 640, 388, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 72.73076923076923, '23328675:emr_diff_b:1017:0,23331063:emr_diff_b:1017:0,23331092:emr_diff_b:1017:0,23332464:pcnc_diff_:1042:0,23332467:pcnc_diff_:1042:0,23332504:pcnc_diff_:1042:0,23332521:pcnc_diff_:1042:0,23334479:pcnc_diff_:1042:0,23334482:emr_diff_b:1042:0,23339064:emr_diff_b:1017:0,23339072:emr_diff_b:1017:0,23342741:emr_diff_b:1017:0,23344665:emr_diff_b:1017:0,23356352:emr_diff_b:1017:0,23358110:emr_diff_b:1017:1,23358674:pcnc_diff_:1042:0,23358700:pcnc_diff_:1042:0,23358703:pcnc_diff_:1042:1,23360419:pcnc_diff_:1042:0,23368850:pcnc_diff_:1042:0,23372144:emr_diff_b:1017:0,23407898:emr_diff_b:1017:0,23426559:pcnc_diff_:1042:0,23440563:pcnc_diff_:1042:0,23443386:pcnc_diff_:1042:0,23443387:pcnc_diff_:1042:0', 26)
('2025-05-30 07:02:22', 4234, 254, 156, 98, 'refus_rym_velours_valcor', 61.42857142857143, '23356353:truck_diff:991:0,23356357:truck_diff:991:0,23356375:truck_diff:991:0,23370299:truck_diff:991:0,23370303:truck_diff:991:0,23437898:truck_diff:991:1,23437902:truck_diff:991:1', 7)
('2025-05-30 07:02:22', 3991, 97, 76, 21, 'RUBBIA_ELA_131221_add_surclassifier_rapport', 157.0, '23157180:ela_diff_b:1017:0,23261823:ela_diff_b:1017:1,23411038:ela_diff_b:1017:0', 3)
('2025-05-30 07:02:22', 4877, 48, 37, 11, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 40.54545454545455, '23396794:JRM_diff_b:979:0,23396903:JRM_diff_b:979:0,23397108:JRM_diff_b:979:0,23397231:JRM_diff_b:979:0,23397430:JRM_diff_b:979:0,23397595:JRM_diff_b:979:0,23429737:JRM_diff_b:979:0,23429889:JRM_diff_b:979:0,23429954:JRM_diff_b:979:0,23430162:JRM_diff_b:979:0,23446103:JRM_diff_b:979:0', 11)
('2025-05-30 07:02:22', 4310, 8653, 8646, 7, 'classifieur_2camions_valcor_021122_v1', 15.0, '23434681:dechet_val:991:0,23444892:dechet_val:991:0', 2)
('2025-05-30 07:02:22', 3996, 42, 40, 2, 'RUBBIA_Refus_add_surclassifier_rapport', 211.0, '23205408:refus_diff:983:0', 1)
('2025-05-30 07:02:22', 4153, 21, 20, 1, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 35.0, '23422844:flux_dev_d:1017:0', 1)
('2025-05-30 07:02:22', 4748, 20, 20, 0, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 159.0, '23303356:flux_dev_r:979: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-30 07:02:29', 3142, 36, 'STS_refus_Amiens', Decimal('0.0000'), '23444013:jetson_new:983:0', 1)
('2025-05-30 07:02:29', 3459, 3324, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('52.1823'), '23367730:jrm_diff_b:1017:0,23370012:JRM_diff_b:979:0,23370015:JRM_diff_b:979:0,23370018:JRM_diff_b:979:0,23370021:JRM_diff_b:979:0,23370119:jrm_diff_b:1017:0,23370554:JRM_diff_b:979:0,23370558:JRM_diff_b:979:0,23370920:jrm_diff_b:1017:0,23370979:jrm_diff_b:1017:0,23371159:jrm_diff_b:1017:0,23371208:jrm_diff_b:1017:0,23371608:JRM_diff_b:979:0,23371610:JRM_diff_b:979:0,23371612:JRM_diff_b:979:0,23371614:JRM_diff_b:979:0,23371616:JRM_diff_b:979:0,23371618:JRM_diff_b:979:0,23371620:JRM_diff_b:979:0,23371622:JRM_diff_b:979:0,23371625:JRM_diff_b:979:0,23371627:JRM_diff_b:979:0,23371629:JRM_diff_b:979:0,23371655:JRM_diff_b:979:0,23371657:JRM_diff_b:979:0,23371680:JRM_diff_b:979:0,23371697:JRM_diff_b:979:0,23371711:JRM_diff_b:979:0,23371714:JRM_diff_b:979:0,23371715:JRM_diff_b:979:0,23371717:JRM_diff_b:979:0,23372106:jrm_diff_b:1017:0,23372131:jrm_diff_b:1017:0,23372146:jrm_diff_b:1017:0,23372159:jrm_diff_b:1017:0,23372170:jrm_diff_b:1017:0,23373326:JRM_diff_b:979:0,23373327:JRM_diff_b:979:0,23374538:JRM_diff_b:979:0', 127)
('2025-05-30 07:02:29', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('1419.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-30 07:02:29', 3804, 1830, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', Decimal('52.4273'), '23367728:pet_clair_:1017:0,23370137:pet_clair_:1017:0,23370162:pet_clair_:1017:0,23370170:pet_clair_:1017:0,23370215:pet_clair_:1017:0,23370860:pet_clair_:1017:0,23370866:pet_clair_:1017:0,23370908:pet_clair_:1017:0,23370921:pet_clair_:1017:0,23370937:pet_clair_:1017:0,23370986:pet_clair_:1017:0,23371090:pet_clair_:1017:0,23371216:pet_clair_:1017:0,23371481:pet_clair_:1017:0,23372141:pet_clair_:1017:0,23372165:pet_clair_:1017:0,23372169:pet_clair_:1017:0,23375193:pet_clair_:1042:0,23375420:pet_clair_:1017:0,23375428:pet_clair_:1017:0,23379557:pet_clair_:1017:0,23381746:pet_clair_:979:0,23381765:pet_clair_:979:0,23381805:pet_clair_:979:0,23381830:pet_clair_:979:0,23381835:pet_clair_:979:0,23381841:pet_clair_:979:0,23381845:pet_clair_:979:0,23383815:pet_clair_:1017:0,23383826:pet_clair_:1017:0,23384391:pet_clair_:1042:0,23384867:pet_clair_:1017:0,23386643:pet_clair_:1017:0,23388511:pet_clair_:1017:0,23391456:pet_clair_:1017:0,23393128:pet_clair_:1017:0,23393708:pet_clair_:1042:0,23393709:pet_clair_:1042:0,23411', 54)
('2025-05-30 07:02:29', 3991, 295, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('55.4237'), '23370151:ela_diff_b:1017:0,23370154:ela_diff_b:1017:0,23370918:ela_diff_b:1017:0,23371010:ela_diff_b:1017:0,23371488:ela_diff_b:1017:0,23372118:ela_diff_b:1017:0,23381742:ela_diff_b:979:0,23381840:ela_diff_b:979:0,23383817:ela_diff_b:1017:0,23386645:ela_diff_b:1017:0,23412057:ela_diff_b:1042:0,23419023:ela_diff_b:1017:0,23429868:ela_diff_b:1017:0,23443376:ela_diff_b:1042:0', 14)
('2025-05-30 07:02:29', 3992, 141, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('59.9149'), '23370128:aluminium_:1017:0,23370198:aluminium_:1017:0,23370901:aluminium_:1017:0,23371000:aluminium_:1017:0,23372139:aluminium_:1017:0,23376616:aluminium_:1017:0,23381825:aluminium_:1017:0,23408683:aluminium_:1017:0,23419026:aluminium_:1017:0,23424126:aluminium_:1017:0', 10)
('2025-05-30 07:02:29', 3993, 2972, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('48.4041'), '23367706:emr_diff_b:1017:0,23367732:emr_diff_b:1017:0,23368851:pcnc_diff_:1042:0,23370131:emr_diff_b:1017:0,23370140:emr_diff_b:1017:0,23370164:emr_diff_b:1017:0,23370173:emr_diff_b:1017:0,23370212:emr_diff_b:1017:0,23370222:emr_diff_b:1017:0,23370899:emr_diff_b:1017:0,23370907:emr_diff_b:1017:0,23370916:emr_diff_b:1017:0,23370923:emr_diff_b:1017:0,23370934:emr_diff_b:1017:0,23370942:emr_diff_b:1017:0,23370976:emr_diff_b:1017:0,23370989:emr_diff_b:1017:0,23371007:emr_diff_b:1017:0,23371205:emr_diff_b:1017:0,23371213:emr_diff_b:1017:0,23371226:emr_diff_b:1017:0,23371483:emr_diff_b:1017:0,23371489:emr_diff_b:1017:0,23372102:emr_diff_b:1017:0,23372135:emr_diff_b:1017:0,23372157:emr_diff_b:1017:0,23372166:emr_diff_b:1017:0,23372173:emr_diff_b:1017:0,23375191:pcnc_diff_:1042:0,23375419:emr_diff_b:1017:0,23375425:emr_diff_b:1017:0,23376492:pcnc_diff_:1042:0,23376618:emr_diff_b:1017:0,23376849:pcnc_diff_:1042:0,23376850:emr_diff_b:1042:0,23376852:emr_diff_b:1042:0,23376853:emr_diff_b:1042:0,23376854:pcnc_diff_:1042:', 117)
('2025-05-30 07:02:29', 3996, 505, 'RUBBIA_Refus_add_surclassifier_rapport', Decimal('58.5327'), '23366762:refus_diff:983:0,23366765:refus_diff:983:0,23366780:refus_diff:983:0,23366783:refus_diff:983:0,23366788:refus_diff:983:0,23368652:refus_diff:983:0,23368673:refus_diff:983:0,23368674:refus_diff:983:0,23371529:refus_diff:983:0,23371530:refus_diff:983:0,23371533:refus_diff:983:0,23371534:refus_diff:983:0,23371536:refus_diff:983:0,23371537:refus_diff:983:0,23371538:refus_diff:983:0,23373069:refus_diff:983:0,23375004:refus_diff:983:0,23377147:refus_diff:983:0,23377149:refus_diff:983:0,23377754:refus_diff:983:0,23380666:refus_diff:983:0,23391390:refus_diff:983:0,23391393:refus_diff:983:0,23394146:refus_diff:983:0,23397044:refus_diff:983:0,23406447:refus_diff:983:0,23406448:refus_diff:983:0,23406449:refus_diff:983:0,23406450:refus_diff:983:0,23406451:refus_diff:983:0,23406452:refus_diff:983:0,23409788:refus_diff:983:0,23414810:refus_diff:983:0,23418128:refus_diff:983:0,23420469:refus_diff:983:0,23424110:refus_diff:983:0,23424111:refus_diff:983:0,23429772:refus_diff:983:0,23429773:refus_diff:983:0,23436774:r', 44)
('2025-05-30 07:02:29', 4148, 8, 'test_paddle_ocr', Decimal('40.0000'), '23415984:SyctomXV_2:775:0', 1)
('2025-05-30 07:02:29', 4153, 394, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('46.1269'), '23370145:flux_dev_d:1017:0,23370968:flux_dev_d:1017:0,23370971:flux_dev_d:1017:0,23371485:flux_dev_d:1017:0,23371487:flux_dev_d:1017:0,23372164:flux_dev_d:1017:0,23375422:flux_dev_d:1017:0,23381814:flux_dev_d:1017:0,23383822:flux_dev_d:1017:0,23383824:flux_dev_d:1017:0,23384863:flux_dev_d:1017:0,23391458:flux_dev_d:1017:0,23398528:flux_dev_d:1017:0,23411039:flux_dev_d:1017:0,23414781:flux_dev_d:1017:0,23416827:flux_dev_d:1017:0,23419022:flux_dev_d:1017:0,23419029:flux_dev_d:1017:0,23422148:flux_dev_d:1017:0,23425105:flux_dev_d:1017:0,23426540:flux_dev_d:1042:0,23429885:flux_dev_d:1017:0', 22)
('2025-05-30 07:02:29', 4220, 14114, 'split_time_score_plaque_Valcor', Decimal('26.7980'), '23320447:plaque_val:1064:0,23361739:plaque_val:1064:0,23397381:plaque_val:1064:0,23430027:plaque_val:1064:0,23444051:plaque_val:1064:0', 5)
('2025-05-30 07:02:29', 4234, 2513, 'refus_rym_velours_valcor', Decimal('52.3526'), '23370122:truck_diff:991:0,23370125:truck_diff:991:0,23370130:truck_diff:991:0,23370133:truck_diff:991:0,23370136:truck_diff:991:0,23370139:truck_diff:991:0,23370142:truck_diff:991:0,23370146:truck_diff:991:0,23370149:truck_diff:991:0,23370152:truck_diff:991:0,23370155:truck_diff:991:0,23370158:truck_diff:991:0,23370161:truck_diff:991:0,23370165:truck_diff:991:0,23370168:truck_diff:991:0,23370172:truck_diff:991:0,23370175:truck_diff:991:0,23370178:truck_diff:991:0,23370181:truck_diff:991:0,23370196:truck_diff:991:0,23370211:truck_diff:991:0,23370214:truck_diff:991:0,23370218:truck_diff:991:0,23370221:truck_diff:991:0,23370223:truck_diff:991:0,23370226:truck_diff:991:0,23370229:truck_diff:991:0,23370231:truck_diff:991:0,23370232:truck_diff:991:0,23370234:truck_diff:991:0,23370237:truck_diff:991:0,23370239:truck_diff:991:0,23370240:truck_diff:991:0,23370243:truck_diff:991:0,23370245:truck_diff:991:0,23370247:truck_diff:991:0,23370248:truck_diff:991:0,23370250:truck_diff:991:0,23370252:truck_diff:991:0,23370253:t', 373)
('2025-05-30 07:02:29', 4302, 14, 'RUBBIA_JRM_consolidate', Decimal('0.0000'), '23446155:JRM_diff_b:979:0', 1)
('2025-05-30 07:02:29', 4311, 7573, 'sts_dechet_valcor_matching_v2_2022Q3', Decimal('1.0000'), '23434681:dechet_val:991:1', 1)
('2025-05-30 07:02:29', 4433, 331, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('52.4230'), '23369805:JRM_diff_b:1053:0,23379393:JRM_diff_b:1053:0,23380489:JRM_diff_b:1053:0,23414719:JRM_diff_b:1053:0,23415910:JRM_diff_b:1053:0,23437547:JRM_diff_b:1053:0', 6)
('2025-05-30 07:02:29', 4748, 29, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('62.0000'), '23381733:flux_dev_r:979:0,23381809:flux_dev_r:979:0,23381843:flux_dev_r:979:0', 3)