8554403a3f057a38f35d763783f95ee64b247b80 galt Tue Jun 14 12:32:30 2016 -0700 adding a way to run these diff --git src/hg/geoIp/load-tables src/hg/geoIp/load-tables new file mode 100755 index 0000000..0c1d97a --- /dev/null +++ src/hg/geoIp/load-tables @@ -0,0 +1,11 @@ +#!/bin/tcsh +# we want to use autoSql to make the .sql +# which is handy for initializing empty tables +# but we do not need the .c and .h files at this time. +foreach f ( *.as ) + echo $f + #hgsql hgFixed -e "drop table $f:r" + hgsql hgFixed < $f:r.sql + hgsql hgFixed -e "load data local infile '$f:r.tab' into table $f:r" + hgsql hgFixed -e "select count(*) from $f:r" +end