data_id_pattern = "{:>" + str( int(math.log10(len(prj_records))) + 2) + "s}" current_prj = None for rec in prj_records: data_id, target, prj = rec if data_id in data_ids.keys(): if prj != current_prj: current_prj = prj print( colorize("*** Project '{:s}' ***".format(prj), rgb=Color.FMKINFOGROUP)) format_string = " [DataID " + data_id_pattern + "] --> {:s}" print( colorize(format_string.format('#' + str(data_id), target), rgb=Color.DATAINFO)) if verbose: print( colorize(" |_ status={:d} from {:s}".format( data_ids[data_id][0], data_ids[data_id][1]), rgb=Color.FMKSUBINFO)) else: print( colorize("*** No data has negatively impacted a target ***", rgb=Color.FMKINFO)) fmkdb.stop()
) prj_records = fmkdb.execute_sql_statement( "SELECT PRJ_NAME, DATA_ID, TARGET FROM PROJECT_RECORDS;" ) if fbk_records and prj_records: data_ids = {} for rec in fbk_records: data_ids[rec[0]] = (rec[1], rec[2]) data_id_pattern = "{:>"+str(int(math.log10(len(prj_records)))+2)+"s}" current_prj = None for rec in prj_records: prj, data_id, target = rec if data_id in data_ids.keys(): if prj != current_prj: current_prj = prj print(colorize("*** Project '{:s}' ***".format(prj), rgb=Color.FMKINFOGROUP)) format_string = " [DataID " + data_id_pattern + "] --> {:s}" print(colorize(format_string.format('#'+str(data_id), target), rgb=Color.DATAINFO)) if verbose: print(colorize(" |_ status={:d} from {:s}".format(data_ids[data_id][0], data_ids[data_id][1]), rgb=Color.FMKSUBINFO)) else: print(colorize("*** No data has negatively impacted a target ***", rgb=Color.FMKINFO)) fmkdb.stop()