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()
