Alnoda workspaces

Added by: bluxmit
Apr 23, 2023

Version

~> SchemaSpy

Description

Database documentation built easy

Install (execute in workspace terminal)

wrk install schemaspy==6.1.0

Remarks and hints

schemaspy -h myhost -p 5432 -d mydb -u abc -o /home/schemaspy

Scripts

# Istall script

sudo apt-get -y update 
sudo apt-get install -y openjdk-8-jre
sudo apt-get install -y graphviz

cd /tmp 
mkdir /home/abc/apps/schemaspy/
cd /home/abc/apps/schemaspy 
wget https://github.com/schemaspy/schemaspy/releases/download/v6.1.0/schemaspy-6.1.0.jar 
wget https://jdbc.postgresql.org/download/postgresql-42.3.1.jar

cat >/home/abc/apps/schemaspy/schemaspy.sh <<EOL
#!/bin/bash
while getopts h:p:d:u:P:o: flag
do
    case "${flag}" in
        h) host=${OPTARG};;
p) port=${OPTARG};;
    d) database=${OPTARG};;
u) user=${OPTARG};;
P) password=${OPTARG};;
        o) output_dir=${OPTARG};;
    esac
done
if [ -z "${host}" ]; then host="localhost"; fi 
if [ -z "${port}" ]; then port="5432"; fi 
if [ -z "${output_dir}" ]; then output_dir="/home/project"; fi 
 
schemacmd="java -jar /home/abc/apps/schemaspy/schemaspy.jar -t pgsql -dp /home/abc/apps/schemaspy/postgresql-42.3.1.jar -host \"${host}\" -port ${port} -db \"${database}\" -u \"${user}\" -o \"${output_dir}\""

if [ "${password}" ]; then 
   schemacmd="${schemacmd} -p ${password}" 
fi 
eval $schemacmd
EOL

chmod +x /home/abc/apps/schemaspy/schemaspy.sh 
ln -s /home/abc/apps/schemaspy/schemaspy.sh /home/abc/bin/schemaspy

# Start script

alnoda-workspace

no compatibility requirements

~> App

~> SchemaSpy

Description

Tags

Links

Install (execute in workspace terminal)

Remarks and hints

Scripts

!= Workspace compatibility

alnoda-workspace

!= App compatibility