Skip to content

Instantly share code, notes, and snippets.

@djromero
Created March 25, 2017 18:29
Show Gist options
  • Save djromero/4052b714b6aa90bc48d01045ea8b918e to your computer and use it in GitHub Desktop.
Save djromero/4052b714b6aa90bc48d01045ea8b918e to your computer and use it in GitHub Desktop.
Generate a database schema diagram (sqlite) with SchemaCrawler
rm -f database-diagram.pdf
# Use PyCharm CE JDK
JDK="/Applications/PyCharm CE.app/Contents/jdk/Contents/Home/jre/bin/java"
"$JDK" -classpath $(echo ../../_schemacrawler/lib/*.jar | tr ' ' ':') \
schemacrawler.Main \
-server=sqlite \
-database=/Volumes/PRO/c/latenitesoft/socialbotplatform/data/social_bots_deve.db \
-password= \
-infolevel=maximum -command=schema -outputformat=pdf -outputfile=database-diagram.pdf $*
#-infolevel=maximum -command=schema -outputformat=dot -outputfile=database-diagram.dot $*
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment