8b749d55d00445992c65433f2029caf0789bc4c6
dschmelt
  Tue Dec 3 10:13:13 2019 -0800
Adding a few scripts to tracked Dirs #24290

diff --git src/utils/qa/sqlPublicEuroCompare src/utils/qa/sqlPublicEuroCompare
new file mode 100755
index 0000000..48069e1
--- /dev/null
+++ src/utils/qa/sqlPublicEuroCompare
@@ -0,0 +1,29 @@
+# Check for sql database numbers being equal
+
+euroDb="`mysql --user=genome --host=genome-euro-mysql.soe.ucsc.edu -Ne "show databases" | wc -l`"
+rrDb="`mysql --user=genome --host=mysqlrr.soe.ucsc.edu -Ne "show databases" | wc -l`"
+# Option to include a diff statement here 
+if [ $euroDb = $rrDb ]
+ then
+   echo "Same number of databases, $euroDb = $rrDb"
+ else
+   echo "Different number of databases, $euroDb in Euro versus $rrDb in RR"
+fi
+
+# Check update times
+# Unfortunately, it would be table specific and so I chose not to do that
+# #hgsql -e "show table status like 'gap'\G" galGal6
+
+# Check table number in hg19, hg38, mm10
+for db in hg19 hg38 mm10;
+do
+   euroTbls="`mysql --user=genome --host=genome-euro-mysql.soe.ucsc.edu -Ne 'show tables' $db | wc -l`"
+   rrTbls="`mysql --user=genome --host=mysqlrr.soe.ucsc.edu -Ne 'show tables' $db | wc -l`"
+   #  Option to include a diff statement here
+   if [[ "$euroTbls" = "$rrTbls" ]];
+    then
+      echo "Same number of tables in $db, $euroTbls = $rrTbls"
+    else
+      echo "Different number of tables in $db, $euroTbls in Euro versus $rrTbls in RR"
+   fi
+done;