04cadaf097f071cb3fd88866691fb1133b6d4bc5 gperez2 Mon Jun 16 22:47:03 2025 -0700 Commenting out the blatServers filtering to remove domain part due to Hiram updating the blatServers.hgcentral table on hgnfs1 for all host names, refs #35846 diff --git src/utils/qa/check_Tables_Metadata.py src/utils/qa/check_Tables_Metadata.py index 7184aec36d0..63696fbae33 100755 --- src/utils/qa/check_Tables_Metadata.py +++ src/utils/qa/check_Tables_Metadata.py @@ -85,32 +85,34 @@ 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 - if metatable == "blatServers": - data1 = filter_blat_servers(data1) + ## 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)) for line in sorted(only_in_centdb1): print(line)