trunk/schemaSpy/update.sh


dir=../share/web/static

test -e $dir || exit 1

cat dbs.txt | xargs -i java -jar schemaSpy_3.1.1.jar -cp /usr/share/java/postgresql.jar -t pgsql -host localhost -u dpavlin -db {} -s public -o $dir/spy/{} -desc '<a href\="/">back to SQLSession</a>'

# remove extra links to sourcefourge.net which seem to confuse my students :-)
perl -p -i -n -e 's/<(a|li|td|tr|span).+sourceforge.net.+\1>//ig' $dir/spy/*/*.html $dir/spy/*/*/*.html
perl -p -i -n -e 's/Please.+this project//i' $dir/spy/*/*.html $dir/spy/*/*/*.html
1	dpavlin	42
2	dpavlin	43	dir=../share/web/static
3	dpavlin	42
4	dpavlin	43	test -e $dir \|\| exit 1
5
6			cat dbs.txt \| xargs -i java -jar schemaSpy_3.1.1.jar -cp /usr/share/java/postgresql.jar -t pgsql -host localhost -u dpavlin -db {} -s public -o $dir/spy/{} -desc '<a href\="/">back to SQLSession</a>'
7
8			# remove extra links to sourcefourge.net which seem to confuse my students :-)
9			perl -p -i -n -e 's/<(a\|li\|td\|tr\|span).+sourceforge.net.+\1>//ig' $dir/spy//.html $dir/spy///*.html
10			perl -p -i -n -e 's/Please.+this project//i' $dir/spy//.html $dir/spy///*.html