0890e2c3c68649027aa95195fe82ca2e1101e82e kent Sun Sep 15 11:42:11 2019 -0700 Adding -uncsv as an option. Actually it used to be the default so I had to throw it on in the test set. The csv/array vs. normal commas in free text are a weak point of the system. Between that and the SQL you can't escape escaping it seems! diff --git src/hg/sqlUpdateRelated/tests/doTest.csh src/hg/sqlUpdateRelated/tests/doTest.csh index 7051258..fced604 100755 --- src/hg/sqlUpdateRelated/tests/doTest.csh +++ src/hg/sqlUpdateRelated/tests/doTest.csh @@ -1,8 +1,8 @@ #!/bin/tcsh -efx set db = kentXDjTstWhyYDropMe hgsqladmin --force drop $db hgsqladmin create $db hgsql $db < inDb.sql -sqlUpdateRelated $db hcat_contributor.tsv hcat_lab.tsv hcat_publication.tsv hcat_organ.tsv hcat_organpart.tsv hcat_assaytype.tsv hcat_disease.tsv hcat_project.tsv +sqlUpdateRelated -uncsv $db hcat_contributor.tsv hcat_lab.tsv hcat_publication.tsv hcat_organ.tsv hcat_organpart.tsv hcat_assaytype.tsv hcat_disease.tsv hcat_project.tsv hgsqldump $db | grep -v "Dump completed" >outDb.sql diff expectedDb.sql outDb.sql