trunk/schemaSpy/update.sh


dir=../share/web/static

test -e $dir || exit 1

test -d $dir/spy || mkdir $dir/spy

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
2	dir=../share/web/static
3
4	test -e $dir \|\| exit 1
5
6	test -d $dir/spy \|\| mkdir $dir/spy
7
8	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>'
9
10	# remove extra links to sourcefourge.net which seem to confuse my students :-)
11	perl -p -i -n -e 's/<(a\|li\|td\|tr\|span).+sourceforge.net.+\1>//ig' $dir/spy//.html $dir/spy///*.html
12	perl -p -i -n -e 's/Please.+this project//i' $dir/spy//.html $dir/spy///*.html