1 |
|
|
2 |
test -e ../share/web/static || exit 1 |
dir=../share/web/static |
3 |
|
|
4 |
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 ../share/web/static/spy/{} -desc '<a href\="/">back to SQLSession</a>' |
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 |