src/utils/qa/weeklybld/buildHgCentralSql.csh 1.18

Index: src/utils/qa/weeklybld/buildHgCentralSql.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/weeklybld/buildHgCentralSql.csh,v
retrieving revision 1.17
retrieving revision 1.18
diff -b -B -U 4 -r1.17 -r1.18
--- src/utils/qa/weeklybld/buildHgCentralSql.csh	9 Sep 2009 22:51:30 -0000	1.17
+++ src/utils/qa/weeklybld/buildHgCentralSql.csh	22 Sep 2009 01:53:06 -0000	1.18
@@ -14,11 +14,13 @@
 defaultDb blatServers dbDb dbDbArch gdbPdb liftOverChain clade genomeClade targetDb | \
 sed -e "s/genome-centdb/localhost/" >> /tmp/hgcentraltemp.sql
 
 # get rid of some mysql5 trash in the output we don't want.
+# also need to break data values at rows so the diff and cvs 
+# which are line-oriented work better.
 grep -v "Dump completed on" /tmp/hgcentraltemp.sql | \
 sed -e "s/AUTO_INCREMENT=[0-9]* //" \
- > /tmp/hgcentral.sql
+ | sed -e 's/),(/),\n(/g'  > /tmp/hgcentral.sql
 
 echo
 echo "*** Diffing old new ***"
 diff /usr/local/apache/htdocs/admin/hgcentral.sql /tmp/hgcentral.sql