bb113eaa1fe0e8b96299c8e670b03c2180af94d6 gperez2 Wed Jun 18 16:40:15 2025 -0700 Code review edits, refs #35927 diff --git src/utils/qa/check_Tables_Metadata.py src/utils/qa/check_Tables_Metadata.py index 63696fbae33..9b9e3667b37 100755 --- src/utils/qa/check_Tables_Metadata.py +++ src/utils/qa/check_Tables_Metadata.py @@ -85,32 +85,32 @@ for db in db_list: for metatable in metatables: # Construct different SQL queries depending on the metatable type if metatable == "liftOverChain": query = "SELECT * FROM {} WHERE fromDb = '{}' OR toDb = '{}'".format(metatable, db, db) elif metatable == "blatServers": query = "SELECT * FROM {} WHERE db = '{}'".format(metatable, db) else: query = "SELECT * FROM {} WHERE name = '{}'".format(metatable, db) # Gets and sort data from both databases data1 = get_data(host1, query, centdb1) data2 = get_data(host2, query, centdb2) # Apply filtering to blatServers to remove domain part - ## Commenting out these lines due to Hiram updating the blatServers.hgcentral table on - ## hgnfs1 for all host names + '''Commenting out these lines due to Hiram updating the blatServers.hgcentral table on + hgnfs1 for all host names''' #if metatable == "blatServers": #data1 = filter_blat_servers(data1) # Convert lists to sets for comparison set1 = set(data1) set2 = set(data2) # Identify unique entries in each database only_in_centdb1 = set1 - set2 only_in_centdb2 = set2 - set1 # Print differences if any unique entries exist if only_in_centdb1: print("Discrepancies between hgw1 and beta metadata tables for Database: {}".format(db)) print("{} entries only in {}:".format(metatable, centdb1))